I’m trying to create an automation that finds Coaching IDs in one table and then links them all together in a “Master” sheet. Basically, every time a coaching session happens for a participant, I want all of their data linked so I can see everything ...
I had an automation that when I created a new record of a participant’s information into a time point of our survey (ex. baseline, 3 month, 6 month, etc.) that it would find records with the same participant ID and link them together.
I have separate...
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 l...
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...
It may actually be the initial “when a record is created” step that isn’t working. I’ve continued messing around with the automation and got it to work one time of previously entered data but when I enter a new participant is when the automation fail...
