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