Empowering citizen developers since 2015

There are many instances where you'll want to push data from a user into the cloud ASAP. To make this happen, there's a little bit of code you can throw onto the end of your deeplink formulas. THE MAGIC CODE: &"&at="&(NOW()+1) Forcing a sync is a great way to ensure that data from your users always get to the cloud; you can avoid data loss, errors, and having to use recovery mode simply by adding this step into the data collection process. Limitations |----------------------------- - You can only use this method with the following DeepLink formulas: -- LinkToRow() -- LinkToView() -- LinkToApp() ----------------------------------------------------------------------------------------------------------- Previous Build Video |----------------------------- - This video shows how to take an app I built in a previous video, and upgrade it to include this "force sync" type of functionality. - See the original app build (Part 1) here: https://youtu.be/ozpdxbmvOZ0 App Starting Point |----------------------------- - You can see the original app here: https://www.appsheet.com/samples/How-to-add-items-to-an-order-in-an-alternative-way?appGuidString=841d28bb-32de-461a-bc63-649cb6b71446 App Finishing Point |----------------------------- - You can see the resulting app here: https://www.appsheet.com/templates/This-app-demonstrates-how-to-force-a-sync-using-Actions?appGuidString=aa672bdd-afd5-4846-bd1b-c7c63d2ff500 Table of Contents |--------------------------------------------------------------------------- 0:00 - Intro 0:46 - General Idea Overview 1:38 - STEP 1 - making the group action 2:56 - Force Sync 3:38 - STEP 2 - where to take the user 4:25 - STEP 3 - make the DeepLink action 5:16 - STEP 4 - adding the (force sync) code 6:04 - STEP 5 - completing the stack 6:41 - Testing things out (and a little psychology) ----------------------------------------------------------------------------------------------------------------------- ///////////////////////////////////////////////////////////////////////////// /// SUPPORT THE CHANNEL ///////////////////////////////////////////////////////////////////////////// // // Schedule a 1-on-1 // https://calendly.com/multitechvisions/1-on-1 // // Patreon // https://www.Patreon.com/MultiTech // // Merch // https://multitech-merch.creator-spring.com/ // ///////////////////////////////////////////////////////////////////////// For more information about MultiTech Visions, visit www.MultiTechVisions.com #CitizenDeveloper #AppSheet

A short video explaining how looping with Actions works in AppSheet in under 2 minutes. I have a sample app that demonstrates one way of accomplishing looping with actions, you can find it here: https://www.appsheet.com/samples/How-to-loop-through-a-list-and-create-child-records-for-each-item-in-that-list?appGuidString=87db6a15-2904-41c6-b6a9-dbf999af71bd FYI: the method shown in this video differs from that inside the sample app. - In the app, instead of relying on the calculations for what's left to be done inside the actions, instead I build them out in virtual columns. I suggest that method, mainly due to some "in the weeds" technical details dealing with the type of the data - which can sometimes get lost when only doing the calculations inside the action. ---------------------------------------------------------------------------------------------- BECOME a Patreon SUPPORTER https://www.Patreon.com/MultiTech - AppSheet Template Tables - Pro Tips - Advanced In-App Guides - iota ---------------------------------------------------------------------------------------------- https://www.renderforest.com/signup?afil_link=781426bd6bcf49c574a2a11e50cbf4fa --For quick/easy/awesome videos --App promo videos, product videos, commercials, etc. --and it helps support the channel! (If you use the link above, I get a small commission of your first purchase.) ---------------------------------------------------------------------------------------------- For more information about MultiTech Visions, visit www.MultiTechVisions.com #CitizenDeveloper #AppSheet ****************************Music Credits ******************* Bossa De Link by The OneUps https://open.spotify.com/artist/4kvAB828lg5b3M8aelIAQp/discography

Answer to the following AppSheet Community Question: https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Most-efficient-way-to-move-rows-from-preview-table-to-permanent/m-p/427016#M169271 - How can I efficiently move records from one table to another; copying data from one into another, then deleting the original records. - There's TONS of good information and learned lessons in this post, I highly suggest you take the time to check it out if you're working on implementing data importing into your app. This video largely centers around describing the difference between client-side vs. server-side in AppSheet; as well as the benefits of including a parent level over your Import_Preview table. -----| Table of Contents |----- 0:00 - Intro 1:30 - Client-Side action execution 3:33 - Server-Side action execution 6:40 - Data-Import Scenario Overview 8:29 - Import_Preview Parent Table 10:01 - Benefits of the parent level 11:42 - DATA SUBSET of error records 14:31 - Ending ----------------------------------------------------------------------------------------------------------------------- ///////////////////////////////////////////////////////////////////////////// /// SUPPORT THE CHANNEL ///////////////////////////////////////////////////////////////////////////// // // Schedule a 1-on-1 // https://calendly.com/multitechvisions/1-on-1 // // Patreon // https://www.Patreon.com/MultiTech // // 15% off @ https://www.AppSheetTraining.com // Code: MULTITECH-15 // // Tip Jar // https://www.MultiTechVisions.com/Tips // // ///////////////////////////////////////////////////////////////////////// For more information about MultiTech Visions, visit https://www.MultiTechVisions.com #CitizenDeveloper #AppSheet #Patreon