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

MultiTech Visions
MultiTech Visions
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 بـار بازدید شده
... بیشتر