Hello,
I am planning on using appsheet with an Airtable database, most probably used by the procurement team at my workplace.
I am looking for successful use cases to see what can be done.
I am fairly new to the world of nocode and would appreciate the help and guidance.
Cordially,
Laure
Solved! Go to Solution.
The child table needs to have a Ref column where you select the parent based on the key/label column. That will generate a virtual list column in your parent table that shows all your child's for example when you open the parent record's detail view.
Yes that's correct, unfortunately.
It works like...
LOOKUP([_THISROW].[Column],SearchTable,SearchColumn,ResultColumn)
If you are in TableA and a column contains "Laure" and you want to find that user from the Users table, and then read this user's email address, you will write it like..
LOOKUP[_THISROW].[Name],Users,Name,Email)
User | Count |
---|---|
17 | |
9 | |
6 | |
5 | |
5 |