Hi all, I am having a related but different issue with Airtable Automations, and would welcome any thoughts on whether user error or bug! Hopefully I am sufficiently on topic here and not too verbose…
I am using the “create record” automation to create a new record in a “timesheet” table, based on moving the status of a job in a “jobs” table. I also write the Record_ID of the new timesheet record in a field of the “jobs” table (single line text). So far so good!
The trouble starts when I want to then use an automation to “update record” (the one I just created).
The “action” of the “update record” automation connects to the timesheets table. It pulls through the Record_ID of the relevant timesheet record, the one that I have saved in the “jobs” table from the first automation (see above). The problem is that the Record_ID field appears to the automation to be blank even though I can see it in the table.
If I manually type the Record_ID text in the automation this works.
So it seems to be that the first automation creates a field Record_ID entry that is visible to the eye but not the automation.
I tried passing the Record_ID via a second formula field, and it didn’t work. I tried ignoring the test result and just running and it didn’t work.
Any thoughts / advice appreciated!
If it helps the usecase is that I want to create a timesheet entry when dragging a “job” into a kanban category “timer”, and record the time at which this is done. Then when the job is dragged out of the “timer” category, the same timesheet record is updated with the end time. One minus the other = duration. As I am on the free version at the moment Apps are not available.