How do I set up the relationship between 2 tables in an external database like Airtable? I need to move my entire database to airtable since it’s difficult to view entire data in one-go in Adalo. Any suggestions are welcome.

Not sure if I clearly understand your problem, but if you’re talking about linked records in Airtable and sending data from Adalo to be able to send linked record information, this is doable. You need to use custom actions and use “typecast”=true in your json. Your Airtable API documentation has the details on how to send the typecast parameter. Look for a table with linked records and check the Create records writeup.

Thanks a lot for the reply @bhanu. But what should I send in the body that creates relationship (eg. id/name of that record) 2. How? It does not show me anywhere to send that data (as it uses to show me while dealing with Adalo database like current table1, current table2 and assign that as a whole to add that as relationship) Please help

@Deepakjain can you share screenshots of what you’re trying to do to help me visualise your issue at hand please?

@bhanu Now I am struggling with this as well. I have one Airtable database with pieces of equipment, and would like to connect service/repair requests to those pieces of equipment via the app. I was able to create a custom action using the JSON: [image] The only time I am able to update the table of service requests is when I run the response test! [image] Can you explain to me how I need to change things in order to make this work? I do not understand. [image]

[image] Airtable linked records can be sent throught the api? Get Help I have 2 tables in airtable 1 is an Item and the other one is the invoice. This is my item linked field in airtable in the invoice table [image] I want to add the item to my invoice. but when I click on create it won’t send it via the API… However, I can send it to my table by using a text field in airtable. Anyone had the same issue? [image]

Hello, Hello, I am using Airtable external tables with relationships. I’m trying to create a record with a bound field with a custom action. I followed the explanations. The test is ok but in preview, it does not work. I don’t understand. Thanks for your help. I attached the screenshots [image] [image] [image] [image]

Set relationship while creating records in airtable

Get Help External Collections, Custom Actions & Collections

geullaideo January 25, 2021, 7:35pm 6

Topic		Replies	Views
Airtable linked records can be sent throught the api? Get Help	33	7367	July 21, 2022
Is there any tutorial on creating linked records in Airtable? External Collections, Custom Actions & Collections	6	2329	June 27, 2021
Sending "Current Data" with Custom Actions External Collections, Custom Actions & Collections	4	859	April 12, 2021
Airtable, Create record, Link to screen - empty data Get Help	1	2151	January 18, 2021
Relationships & Airtable Collections Get Help	1	666	April 16, 2020

Set relationship while creating records in airtable

Related topics