I just found out this wonderful appsheet program and I've been playing around with this.
Is it possible to link between tables without using reference key? Can it link using text. For example, if I like to have one table to link to another table using the "item" field.
The reason I'm asking is, I will be using both appsheet and google sheet to look at the data. If I use the "ref" type for the field then when I generate a new entry it would show the unique ID of the reference in google sheet, which is not very useable data, since I need to look at the actual name of the "item" field.
I hope this make sense.
LinkedIn
Twitter
