Using Automation to (Mass Update Values) from One Table to Another | AppSheet Explained

If you've implemented a blueprint table (where you use one table as a "template" and another as the place where you're copying data to), AND you've been using that system for awhile...
- What happens when you make a major change to the blueprint table?
- How can I get all the derivative records (the copies) to update with the newest values?

More discussion here: https://www.googlecloudcommunity.com/...

-------------------------------------------------------------------------------------------------

The solution takes four parts:
- Part 1) Create a [Data Set] action
- Create the action, on the table that needs updating, to actually make the update

- Part 2) Create a [Ref Update] action
- Create a mass update action, that runs the above action on all the records that need updating

- Part 3) Create a Scheduled Bot
- Create a scheduled bot to run the mass update action
- None of the actual scheduling details, nor the actual names, matter much - you can largely skip these

- Part 4) Run the bot
- Run your scheduled bot

CLEAN-UP
- Keep the bot you made, you might need to use it again; just disable it, so it doesn't run on the schedule - which you didn't set! (^_^)


Table of Contents |----------------------------------------------------------------------------------------
0:00 Overview
0:51 (ACTION) Set | Column_Value
2:11 Adding data to the source table
3:45 (ACTION) Ref Update | All Table_Rows
5:14 Overview of the process
6:17 (AUTOMATION) Making the Scheduled bot
7:28 Running the mass update

-----------------------------------------------------------------------------------------------------------------------

/////////////////////////////////////////////////////////////////////////////
/// SUPPORT THE CHANNEL
/////////////////////////////////////////////////////////////////////////////

🔹 Answer Portal by MultiTech Visions
- Resources & Tools: Access a rich library of guides, tutorials, and sample apps.
- Priority Support: Upgrade your subscription for personalized support.
- Ask Questions: Have a query? Submit your questions and get answers from experts.

https://www.multitechvisions.com/answers

Merch Store
Show your support with our branded apparel and accessories.

https://multitech-merch.creator-sprin...

/////////////////////////////////////////////////////////////////////////////

For more in-depth information about MultiTech Visions, visit www.MultiTechVisions.com

#CitizenDeveloper #AppSheet