Using Automation to (Mass Update Values) from One Table to Another | AppSheet Explained
8.4 هزار بار بازدید -
2 سال پیش
-
If you've implemented a blueprint
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: www.googlecloudcommunity.com/gc/Tips-Tricks/Using-…
-------------------------------------------------------------------------------------------------
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.
www.multitechvisions.com/answers
Merch Store
Show your support with our branded apparel and accessories.
multitech-merch.creator-sprin...
/////////////////////////////////////////////////////////////////////////////
For more in-depth information about MultiTech Visions, visit www.MultiTechVisions.com
#CitizenDeveloper #AppSheet
2 سال پیش
در تاریخ 1401/07/12 منتشر شده
است.
8,445
بـار بازدید شده