Using appsheet as a front end to Airtable database

[Laure998]

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

[AleksiAlkio · Accepted 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.

[AleksiAlkio · Accepted solution]

Yes that's correct, unfortunately.

[AleksiAlkio]

Do you have any thoughts what would you like to know?

[RedVox]

AirTable has similar capabilities to AppSheet and there is no native connector between them.  You could use Zapier or unito or a number of other 3rd party tools as a go-between.  But it will get costly & add some complexity. 

You might want to explore Airtable and see if you can use it to accomplish whatever you hope to build.  Or, alternatively, explore the work your other department has done in Airtable and consider replicating that work in AppSheet.  

[AleksiAlkio]

What do mean by "no native connector between them"?

[RedVox]

Oh wow, I never noticed that before.  I guess I was thinking about credential suppliers.  Good to know.  Thanks!

[AleksiAlkio]

You're welcome 🙂

[Laure998]

Thank you for your inputs.
@AleksiAlkio I started to connect Airtable to Appsheet and I do not understand how to set up in the appsheet tables the linked tables column I have in Airtable.

I can't seem to wrap my head around it.

Your help would be much appreciated.

[AleksiAlkio · Accepted 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.

[Laure998]

Thank you so much @AleksiAlkio for your prompt reply. It helps a lot.

I have another question related to the formula type columns in Airtable.

Can you confirm that Appsheet is not able to extract the formulas in Airtable when the tables are imported ?

Once again thank you.
From what I see, I will have to manually recreate the formulas in the appsheet tables. It is time consuming and prone to errors. 

[AleksiAlkio · Accepted solution]

Yes that's correct, unfortunately.

[Laure998]

Thank you.

Last question and I will not bother you anymore.

Do you know, by any chance, how to set up in appsheet a lookup column from Airtable?

I see there is a LOOKUP function in Appsheet but I don't understand how to use it.

[AleksiAlkio · Accepted solution]

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)

[Laure998]

Thank you @AleksiAlkio, it is very clear.

[AleksiAlkio]

You're welcome!