Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Upload gsheet tables with relationships already established

Topic Labels: Base design
892 1
cancel
Showing results for 
Search instead for 
Did you mean: 
himg1509
5 - Automation Enthusiast
5 - Automation Enthusiast

I have 3 tables in a gsheet - Meals, Dishes and Ingredients with a one to many parent-child relationship through IDs - meal ID, dish ID and ingredient ID.

Is it possible to upload this data along with the relationships or I need to establish the relationships in airtable again manually?

If it is possible, kindly also explain how?

Thanks a lot. Grateful to the community.

heman
1 Reply 1
Dan_Montoya
Community Manager
Community Manager

Assuming this is a one time load the following process should work for you. 

  • load your sheet and tabs 
  • in meals find your dishes field and change it to a linked record lining to the dishes tables
  • repeat for dishes and ingredients