# Set relationship while creating records in airtable

**URL:** <https://forum.adalo.com/t/set-relationship-while-creating-records-in-airtable/7885>\
**Category:** External Collections, Custom Actions & Collections\
**Created:** [January 13, 2021, 2:17pm UTC](https://forum.adalo.com/t/set-relationship-while-creating-records-in-airtable/7885 "2021-01-13T14:17:55Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Deepakjain](https://avatars.discourse-cdn.com/v4/letter/d/cab0a1/32.png) [@Deepakjain](https://forum.adalo.com/u/Deepakjain)\
**Post date:** [January 13, 2021, 2:17pm UTC](https://forum.adalo.com/t/set-relationship-while-creating-records-in-airtable/7885/1 "2021-01-13T14:17:55Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![bhanu](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bhanu/32/6859_2.png) [@bhanu](https://forum.adalo.com/u/bhanu)\
**Post date:** [January 13, 2021, 2:25pm UTC](https://forum.adalo.com/t/set-relationship-while-creating-records-in-airtable/7885/2 "2021-01-13T14:25:13Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Deepakjain](https://avatars.discourse-cdn.com/v4/letter/d/cab0a1/32.png) [@Deepakjain](https://forum.adalo.com/u/Deepakjain)\
**Post date:** [January 16, 2021, 7:23am UTC](https://forum.adalo.com/t/set-relationship-while-creating-records-in-airtable/7885/3 "2021-01-16T07:23:54Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![bhanu](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/bhanu/32/6859_2.png) [@bhanu](https://forum.adalo.com/u/bhanu)\
**Post date:** [January 16, 2021, 7:41am UTC](https://forum.adalo.com/t/set-relationship-while-creating-records-in-airtable/7885/4 "2021-01-16T07:41:19Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![mbl79](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/mbl79/32/6013_2.png) [@mbl79](https://forum.adalo.com/u/mbl79)\
**Post date:** [January 25, 2021, 7:29pm UTC](https://forum.adalo.com/t/set-relationship-while-creating-records-in-airtable/7885/5 "2021-01-25T19:29:24Z")

</div>

@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](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/d/da0e634b467e9f964d3cf6d7f16a53e55ae02ebc.png)

The only time I am able to update the table of service requests is when I run the response test!

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/d/dd3e96ccd735204d8ea9d49e3b697ea8781d0bea.png)

Can you explain to me how I need to change things in order to make this work? I do not understand.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/2X/6/606308fce259215de2fe843ae470794089d7bbf3.png)

---

<div class="post-metadata">

**Author:** ![geullaideo](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/geullaideo/32/5106_2.png) [@geullaideo](https://forum.adalo.com/u/geullaideo)\
**Post date:** [January 25, 2021, 7:35pm UTC](https://forum.adalo.com/t/set-relationship-while-creating-records-in-airtable/7885/6 "2021-01-25T19:35:10Z")

</div>

> [@Airtable linked records can be sent throught the api?](https://forum.adalo.com/t/airtable-linked-records-can-be-sent-throught-the-api/1247):
>
> 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]

---

<div class="post-metadata">

**Author:** ![brenou](https://avatars.discourse-cdn.com/v4/letter/b/e47c2d/32.png) [@brenou](https://forum.adalo.com/u/brenou)\
**Post date:** [June 21, 2022, 10:22pm UTC](https://forum.adalo.com/t/set-relationship-while-creating-records-in-airtable/7885/7 "2022-06-21T22:22:34Z")

</div>

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](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/e/0/e07278fc8cc29c9b158c8ca7da3d0bfb3ba1a56b.png)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/d/8/d87603ac5cdb72b140bab0be74013b8b273da848.png)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/9/7/9785cec19a8d54ccedae462e5d8523e84dc11e5e.png)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/2/9/29614d96b79575f0448c2fc21499e4d8573089ac.png)
