
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 26, 2021 02:22 PM
I’m trying to use airtable to manage data for a large research study, so automation is key here. I set up an automation so that when I enter a participants data into our “Screening” table, it automatically created a record in the “Master” sheet AND links to their record in the screening table.
Here is what the “create record” automation looked like when it was working:
It was working fine and dandy until today, I tried to enter a new participant and it stopped automatically linking to their record in the screening table. And now looks like this:
Does anyone have any advice on why this would be happening? I haven’t touched this automation or anything related to it since it ran fine a week ago.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 26, 2021 04:45 PM
- Your first screenshot shows values for
{Longitudinal ID}
as “0001” and “0002” but in both automation screenshots the values being inserted into that field are Airtable record IDs. Is that on purpose? - What are the settings for the Update Record step?
- Are there any steps that occur before the Update Record step?
- What are the field permissions for
{Screener Card Link}
set to?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 27, 2021 09:55 AM
- I need to have a longitudinal ID and I figured the easiest way to do this would be to change the automatically generated airtable record ID to the longitudinal ID that I want… I changed the airtable record ID myself on purpose but that may be messing up my automation?
- I don’t have an update record step, just “when a record is created in “Screening” create a record in “Master”” Here’s a full screenshot of the automation:
- Field permissions are editors and up for
{screener card link}
