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.
- 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}
