Helping People
Reshape
How They Work
With Data

 

ABOUT

2017_whole_logo.png

When it comes to AppSheet...

MultiTech Visions has been at the vanguard of app-design and innovation since the beginning

Starting in 2016, MultiTech Visions has been assisting companies of all shapes and sizes to reshape how they work with their data. 

 

By utilizing the AppSheet platform, we help implement mobile-first strategies; revolutionizing how small businesses track their data, how research institutions conduct studies, how doctors communicate with front-line healthcare workers, and more...

Editing with Headphones

Patreon Support

My goal is to make THE WORLD🌎
(aka YOU) my client.

One of the largest pains I have is that I build amazing software with the AppSheet platform - but I can't share it because it belongs to a client.

If the WORLD was my client, then I could share it with the🌎!

Screenshot%202021-02-28%20101319_edited.
 
 

AppSheet Explained, Deep Dives, Sample App Build Videos, and more

How to Force a Sync  ||  AppSheet Explained
09:03

How to Force a Sync || AppSheet Explained

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
Looping with Actions (in Under 2 Minutes)
02:53

Looping with Actions (in Under 2 Minutes)

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
Discussion about Importing Data into your AppSheet App
15:41

Discussion about Importing Data into your AppSheet App

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