i have an interface that displays a grid of data returned from a DB. One of the columns has a numerical ID column. Rather than show the id, i would like to show it's associated value which is in a different lookup table.
The interface has two main ruleslocal!xxx: gets the table datalocal!yyy: gets the lookup data.The lookup data is returned as :
[lookupId:123,value:Toys]; [lookupId:456,value:Games]In my grid field, i set the column as a text field with the following as value:
index(local!xxx,wherecontains(fv!item.id,local!yyy),{})However im' getting the message can only act on data of the same type (Text, Any Type)I've tried to enclose in touniformstring, but it has no effect. ps. whats with the tags ? i had to write this out 3 times before i reliased not to click on the tags function)
Discussion posts and replies are publicly visible
Hi Paul - Can you please try replacing index(local!xxx,wherecontains(fv!item.id,local!yyy),{}) with index(local!xxx,wherecontains(fv!item.id,apply(touniformstring(_),{local!yyy})),{}) and check if it works.
still the same i'm afraid.