Excuse me, I’m a beginner!
I created a “ref” between two sheets, I’m trying to understand in the database file (on GoogleDrive) how to display the “label” value (ex. Machine name) and not the ID that Appsheet automatically generates (ex. 48d677b5) is doable ?
If so, how?
thank you all
With a Ref column, say its point to tableA. In the App the user will choose from the column in tableA chosen as the LABEL column, but in the spreadsheet you’ll see the data for the KEY column. Hope this helps.
1 Like
Thank you very much for your help, so you confirm that it is not possible to see the text reference in the calculation file using a “ref?”
Not sure what you mean
1 Like
What you want is not possible; a column of type Ref will always store the key column value of the referenced row and never the label column value (unless the key and label columns are the same). You could consider adding a column to receive the referenced row’s label column value ad giving this new column an App formula expression that dereferences the Ref column’s value to get the label value.
1 Like