Hi, gurus.
I have a timesheet data in Airtable that I want to sync to another Airtable base using Make.
As a sample, here is a timesheet record from the source base, with a Shift Sync value of OVERTIME, that I would want to sync to the destination base.
The Shift Sync value will be used to determine and link a Shift record (from Shifts table in the destination base) when the new record is created. Here are the Shifts records in the destination base.
In Make, I query all Shifts records first and eventually assign the Record IDs as variables.
When creating the new record in the destination table, I tried to use an IF statement to link the correct Shift Record ID depending on the value of Shift Sync, but I get an empty value.
Can you help on how to make this work?
Thank you!
