Oct 31, 2024 12:40 PM
Hi,
I want to create a new record and link it with the right assets.
Creating the record goes wel, but linking the assets won't work.
I get this error. I am a bit new to airtable, maybe it is a beginner mistake.
Thanks in advance.
Greetings,
Robin
const inputData = input.config();
const { txt_name, txt_files } = inputData;
// Specify the tables
let postsTable = base.getTable('Social media posts');
let assetsTable = base.getTable('Assets');
// Create a new record in the 'Social media posts' table and capture the ID
let newRecordId = await postsTable.createRecordAsync({
'Naam': txt_name,
});
// Update the record in 'Assets' where the ID matches txt_files, setting "Social media posts" field to the new record ID
await assetsTable.updateRecordAsync(txt_files, {
'Social media posts': [{ id: newRecordId }],
});
Solved! Go to Solution.
Oct 31, 2024 07:14 PM
Could I check that you've set your input variable for the linked record to display as "ID"?
The linked records value is also an array, so you'd need to do `txt_files[0]` in your updateRecordAsync
Nov 01, 2024 01:37 AM
Thanks! Also just realized that your screenshot actually includes that detail, sorry about missing that
Did the array thing work?
Oct 31, 2024 07:14 PM
Could I check that you've set your input variable for the linked record to display as "ID"?
The linked records value is also an array, so you'd need to do `txt_files[0]` in your updateRecordAsync
Nov 01, 2024 12:52 AM
@TheTimeSavingCo
Yes, it is...
Nov 01, 2024 01:37 AM
Thanks! Also just realized that your screenshot actually includes that detail, sorry about missing that
Did the array thing work?