Using appsheet as a front end to Airtable database

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 Solved
0 13 1,170
3 ACCEPTED SOLUTIONS

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.

View solution in original post

Yes that's correct, unfortunately.

View solution in original post

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)

View solution in original post

13 REPLIES 13
Top Labels in this Space