Hi All, I'm new on using Airtable Automations and have been trying to sync content with a Google Spreadsheets file.
Once using the "When record update" trigger type, I've observed that each "enter" command made by the user when typing on a specific cell/field in Airtable creates a new row in the GSheet tab.
My question is: how to assure that the GSheets will reflect and store only the final status, i.e., the most up-to-date content in Airtable?
Rks in advance for your thoughts!
Sync with Google Spreadsheets (Update) creating multiple rows
+3
+35You would need to create either a checkbox field or a single-select field for the user to select when they are done editing the entire record in Airtable, and then you would trigger the automation off of that field.
I discuss this more in this thread.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+3Hi ScottWorld, tks for your attention.
I've tried to insert a "timestamp" field in Airtable to capture the most recent update and, once returned in GSheets, I could consider the "query" or "unique" function to deduplicate the similar records - however, I can see that the records are returning in some cases the same timestamp...
That happens mostly when the user is editing in Airtable a "multiple choice" field type, where predefined options are populated and then one or more option can be selected. It seems that for each selected option the Airtable Automation is triggering an update...
Tks All for any thoughts!
+17Hi Leone!
If you're going to use Airtable Automations for this, +1 to ScottWorld's suggestion around using a checkbox or single select that determines if the user is "editing" or not and only sends updates once editing is complete.
Alternatively, I might suggest reaching for a dedicated tool for this like Whalesync (my product).
The Airtable x Google Sheets 2-way sync which will just handle all the logic for you out-of-the-box: https://www.whalesync.com/connect/airtable-google-sheets
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.