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 …

Yep exact, that’s what I’ve done and it works like a charm. Many thanks @Ajay for this confirmation :+1:t2:

Hi @ChristopheHK do you happen to have an example of the json you’re using to get this to work? Have you been able to send date/time data successfully?

It’s a normal json, but if you want to set ONLY ONE parameter of an array, you have to hardcode the [ and ] . You can send date, with format = Zulu timestamp (default timestamp for adalo)

[Snímka obrazovky 2020-11-16 o 20.15.54] Does not work

[Snímka obrazovky 2020-11-16 o 20.19.17]

You can use Custom Action in Adalo to update in AirTable field with multiple relations ( for example guests and tags, many to many relation ) When you try to send Update Tag from Adalo to AirTable your JSON look like this: { fields: { guests_uuid: { 0: "[recpGIq2zW32QfeLt, recc9ADs3UBnh1Zeo]" …

i could’t find in Adalo any options to get Array or ValueList of related ids to create a valid json for custom action ( also in AirTable no formula like ArrayToJson, FilterValues or some CustomFunctions, but you can try this way: Add value in AirTable you can make formula field A to collect relate…

now, i think that better to use some backend to data processing ( parsing json, working with array and etc )

[image] geullaideo: ‘"’& SUBSTITUTE( ARRAYJOIN( tags_uuid ), “,”,“","” I cannot get a formula like this one to work in my Airtable. It says invalid formula. Assuming I need to change tags_uuid, but to what?

Airtable linked records can be sent throught the api?

Get Help

AndreasAyoCruz November 16, 2020, 7:20pm 15

How did you solve it?

Add an Entry in an "Many to Many" Airtable List withour rewriting the field

Topic		Replies	Views
Set relationship while creating records in airtable External Collections, Custom Actions & Collections	6	1887	June 21, 2022
Is there any tutorial on creating linked records in Airtable? External Collections, Custom Actions & Collections	6	2277	June 27, 2021
Airtable, Create record, Link to screen - empty data Get Help	1	2126	January 18, 2021
Add an Entry in an "Many to Many" Airtable List withour rewriting the field Database	1	1056	March 15, 2021
Updating Airtable record with linked field Get Help	8	1561	July 29, 2020

Airtable linked records can be sent throught the api?

Related topics