Hi @Dan_Irwin!
I am actually doing this myself. I also, set up drop down menus in my Google sheets. It’s really quite helpful.
The best way that I found to do bulk updating, especially if there are a lot of records, is try using Integronat. It’s quite simple and easy, especially if it’s a simple scenario.
I would recommend Integromat, at this time, over Make (same company, just updated version).
There are still some bugs that need to be resolved in Make.
Mary
Hi @Dan_Irwin!
I am actually doing this myself. I also, set up drop down menus in my Google sheets. It’s really quite helpful.
The best way that I found to do bulk updating, especially if there are a lot of records, is try using Integronat. It’s quite simple and easy, especially if it’s a simple scenario.
I would recommend Integromat, at this time, over Make (same company, just updated version).
There are still some bugs that need to be resolved in Make.
Mary
Thanks! That worked like a gem
Question for the future: Is way in Integromat to append information to the cell rather than overwrite it?
The easiest way to do this is to use Airtable’s Batch Update app:
Thanks! That worked like a gem
Question for the future: Is way in Integromat to append information to the cell rather than overwrite it?
Hi @Dan_Irwin!
I am glad it worked!
Interns of your most recent question, you could try using one of the functions in Airtable—Upsert. I have not used it before, in Integromat, so I don’t have any working knowledge.
I would do some research and see what you can find out and perhaps use a sandbox in Airtable, for test trials.
Mary
The easiest way to do this is to use Airtable’s Batch Update app:
Hi @ScottWorld!
Great to know!!
Thanks for telling us!
I did not even know about this app!
Mary
Hi @Dan_Irwin!
I am glad it worked!
Interns of your most recent question, you could try using one of the functions in Airtable—Upsert. I have not used it before, in Integromat, so I don’t have any working knowledge.
I would do some research and see what you can find out and perhaps use a sandbox in Airtable, for test trials.
Mary
@M_k
Yes, the upsert function is a fantastic time-saving module that Integromat (aka Make.com) created specifically for Airtable.
It updates an existing record if the record exists. Otherwise, it creates a new record. It is a great way to save time, save operations, and takes the burden off your own shoulders from creating this sort of complicated logic in your scenario.
You can read more about it here: Airtable