Getting the name from =GetFieldSelections(<TableName>.ID)

[#1]

Hi, I have a straight table and some text boxes outside of it, where I want the text boxes to display the name of the client when the name OR ID is selected. I know how to get it if its the name using: =GetFieldSelections(<TableName>.Name) , but I want this textbox to display the name if even the ID is selected (<TableName>.ID). Anyone have any ideas?

Thanks!

[Gysbert_Wassenaar · Accepted solution]

Try =only(<TableName>.Name)

[giakoum]

if(getselectedcount(id) >0 or getselectedcount(name) >0 , GetFieldSelections(<TableName>.Name))

or similar

[#4]

Hi David,

can maybe just use only for this.

=Only(Name)

Once you limit down to a single name or ID, the name will display for you

hope that helps

Joe

[#5]

wow super easy many thanks!

[jagan]

Hi,

Also you can use

MaxString(Name) Or MinString(Name), if you select a value you will get the selected value otherwise it will give the max string name.

By using this you always get the answer, whether you selected or not.

Hope this helps you.

Regards,

Jagan.