MENU

Fun & Interesting

Looping in AppSheet | The most comprehensive tutorial

Full Of Sheets 13,066 1 year ago
Video Not Working? Fix It Now

AppSheet Looping allows you to simulate the for() and forEach() loop functions in javascript. As a response to the request of @martinnjeri6997 ,this allows you to do something repeatedly until a certain condition is met. In this video, we will demonstrate and fully explain how Looping in Appsheet works and how it is implemented in your AppSheet apps. There are a lot of use cases for looping. In this video, we will select multiple months from a dropdown, and create individual entries per month to another table. We did it by utilizing the following: ● Ref columns ● Group actions ● List comparisons ● INDEX() expression Get the AppSheet Best P4actices eBook: https://bit.ly/4bh3JSp Use Coupon Code: imsofullofsheets (Thanks for your suppport. ?) This video is a response to a question by @martinnjeri6997 in our video https://youtu.be/fFxGRbktA0U?si=m1UA7ytGsbP_H0lr Building from this app, watch this next: https://youtu.be/VH7MQnhIrVg?si=RbIpbzYn5l55taQ1 _______________________ Recommended Related Videos: AppSheet Best Practices https://youtu.be/nuBAOEPIMo8?si=fKLbKd7LJKkxt2er 5 Ways to Create Dropdowns https://youtu.be/I0TwK5rODaI?si=7WV9UWziV9FRi6Or ================================ Video Chapters 00:00 What is Looping? 00:26 Member Shoutout 01:06 Sample use-case 03:05 Setting up a Looper helper table 06:23 Linking Looper table to Main table using Ref columns 10:17 Looping Step 1: Create action to add records to Main table 13:30 Preparing the EnumList Iteration 14:55 Illustration of Lists Comparison 17:50 Looping Step 2: Create an Action Group 19:02 Looping Step 3: Create a Repeat action to restsrt the Action Group 21:01 Understanding how the iterations work in the background 22:11 Setting up the condition to stop the loop 24:20 Setting up the loop trigger 27:24 Recommended next steps 27:46 Other possibilities of using Looping 28:29 "3-Steps to Loop" review ================================ #appsheet #fullofsheets #looping #loops #buildingwithappsheet #appsheetforbeginners

Comment