AppSheet Training Resources & Useful Links

[Jake_Naude]

AppSheet is a “no code” platform which makes app building a relatively quick and easy thing… once you have your head around a few basics.

If you’re like me you’ll probably dive right in and start building without reading this stuff and end up wasting a great deal of time going in circles. Trust me, if you can manage it, take a couple of days to go through this stuff first. The time you loose up-front will easily be made up later…

Not exhaustive and in no particular order, here are a few links I found useful:

The first 5 links are lifted straight out of AppSheet’s initial welcome message:

.
1. AppSheet: The Official AppSheet 101 Course

Udemy

Free Google AppSheet Tutorial - Create Business Applications with AppSheet

A Basic Guide to Build Data Driven Mobile Apps & Web-Apps in Minutes - Free Course

.
2. AppSheet: App Design 101 Guide

help.appsheet.com

App Design 101

How to think about building your app

.
3. AppSheet: Essential Starter Articles

help.appsheet.com

DATA | AppSheet Help Center

How to model the data in your apps.

.
4. AppSheet: YouTube Channel

YouTube

AppSheet

The no-code development platform for building powerful mobile & web-applications. Visit us at https://www.appsheet.com/ to learn more.

.
5. AppSheet: Community
https://community.appsheet.com/
This has to be my top resource! I rate the AppSheet Community Forum very highly and could not have built my app without the help of the very talented people that hang out here and give so freely (and patiently) of their knowledge and time!

.
6. AppSheet: Learn How To Use AppSheet

.
7. AppSheet: Documentation

help.appsheet.com

AppSheet Help Center

Quality documentation. Well written and consistent. Easy-to-reach and easy enough for even me to understand.

.
8. AppSheet: Sample Apps
https://www.appsheet.com/SampleApps
Giving users access to Free Sample Apps that demonstrate functionality and learning principles was an inspired idea. I continue to learn a great deal here. Another very useful resource.

.
9. AppSheet: Office Hours
These webinars share intermediate/advanced tips & tricks for using AppSheet, introduce new features, and take live Q&A from app creators.

.
After I bumped my head enough times on my new app I stopped and went through the links above and found I needed a little more. Here’s where I found some extra stuff which I found very helpful!

.
QREW Tools Chrome Extension from @Stefan_Quartemont at QREW
This is the most useful tool in my toolbox! A free visual aid to building expressions and has tons more: Links, Docs, Snippets, Schema and Views!

chrome.google.com

AppSheet Toolbox

Build Better AppSheet Apps

.
QREW Technologies: YouTube Channel

YouTube

AppSheet Training

Helping you unlock the full power of AppSheet! We replace time-wasting processes with flexible digital tools to achieve your goals and save money, and this channel is one of the ways that we are trying to help people do just that! This channel is...

.
AppSheet Proficiency Course (recorded instructor-led sessions) from AppSheetTraining.com

AppSheet Training

AppSheet Essentials | AppSheet Training

Join us for this two-day, 8-hour Essentials Bootcamp as we design an Invoice App from start-to-finish. This bootcamp will meet two-days in a row 4-hours each. This course includes: - A complete walkthrough of the Appsheet Development Process - Live...

.
AppSheet Proficiency Path (excellent on-demand video content) from AppSheetTraining.com

AppSheet Training

On Demand AppSheet Training Video Courses - AppSheet Training

Watch our OnDemand AppSheet Training courses anytime! Our guided paths will take your AppSheet Skills to the next level. Level up your AppSheet skills and upgrade your career.

.
In-App Resource Guides from @MultiTech_Visions

Introducing A New Resource: In-App Guides Tips & Tricks 💡

Hey everyone. Over the past few months I’ve been working on building a system to deliver a new type of resource for the community, one that would give people step-by-step guides on how to implement specific functionalities in their apps. Things like: How to delete child records with parent records How to use Gravatars Quickly implementing an avatar builder How to turn on/off quick edits using actions and more… What sets these resources apart is the fact that they are presented directly insi…

.
Excellent Subscription Service Patreon also from @MultiTech_Visions
https://www.patreon.com/home

.
AppSheet Training Resources for Spanish Speakers

@Guillermo from TailorSheet.com is offering AppSheet training in Spanish

@Guillermo says: “I have created a website, a youtube channel and a new course in Spanish for those who want to learn AppSheet but don’t speak English well enough…”

Website: https://www.tailorsheet.com/
Youtube: https://www.youtube.com/channel/UCYZcmaI_gqDfYI84ONSMUVA/
Course from Zero to Expert: https://www.tailorsheet.com/de-cero-a-experto.

.
…and a few docs and posts from the community that I found particularly helpful…

.
@Steve

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW() MINROW() REF_ROWS() SELECT() What is a Key? Adding & updating rows Is this a new row?/Does this row already exist? What is the previous value of this column? Excel alternatives How do I do COUNTIF() or COUNTIFS()? How do I do SUMIF() or SUMIFS()? How do I do VLOOKUP()? Last row of the spreadsheet How do I get the last row of the spreadsheet? How do I get a column value from…

.
@Peter

XY Column Type Tips & Tricks 💡

If you want to customize the base layer of your map view, consider ‘XY’ column types. When the column type is marked as ‘XY’ you’ll see the option in your column definition to link to a hosted image (that will serve as your map base layer). [image] After including a link to the map image, you’ll be able to add points to that image, just like you’d add lat/long points on a map. Your XY coordinates will be percentages across the height/width of the background image (50,50 will be the center). […

.
@Itay_Golan

XY view all pins in map Questions

Is it possible to add an action that shows all the related pins in the related location? [image] like this view Thanks in advance

.

@Suvrutt_Gurjar

Dashboarding Options With Card Views Tips & Tricks 💡

Just thought of posting use of card views to make useful dashboard reports. There are some challenges, but these are because of extending use of card views for dashboard purpose. The card views in themselves work nicely. Kudos to @morgan and AppSheet team for these versatile card views. So I created a test app based on some test data. The below screenshot shows the card view in desktop mode from that test app. [Dashboard with Card Views] Following services I used while creating teh test a…

.
@GreenFlux

IMAGE EDITING! Rotate, Crop, Resize, Mirror, Etc- Using FileStack & URL Parameters Tips & Tricks 💡

Disclaimer: Free signup at https://www.filestack.com/ is required in order for each developer to have their own API key and track usage. The free version offers up to 1000 ‘transformations’ a month. I have no affiliation with Filestack and do not stand to gain from users signing up. I was going to post as a sample app but I don’t want the usage counting against the limit on my free account. www.filestack.com Web-service that supports file editing and conversion for photos, vid…

.
@Amit_Jain

Copy data From above Row Questions

What will be formula to IF column X Contains Value Yes then copy Data from above Row

.
@Jerome_Canete

Show_If Conditions Questions

HI Appsheet, a beginner here. I’m having trouble with the show_if function not fully working. I have column A with enumlist with list for example “one”, “two”, “three”, “four”, “five”, “six”, & “none”. Now i want column B to show only if 1 or any 2 or more of the choices in column A are selected except the choice “none”. I did this condition but seems not working right: CONTAINS([A],ANY({one,two,three,four,five,six,})) Thanks in advance for any help.

.
@Peter

Loading Screen Animations Tips & Tricks 💡

In the UX > Brand section of the editor, the loading screen of each can be customized so that whenever the app is manually synced, users see an image or animation while waiting for fresh data to load. Check out some of the animation ideas below for getting started customizing your loading screens (copy the image link into the ‘Launch Image’ field of your app brand settings)

.
@Peter

Interactive Dashboard Tips & Tricks 💡

When building Dashboards, make sure you try enabling ‘Interactive’ mode - if your views are built from similar or related tables, they will dynamically change as items are selected. [Interactive%20Dashboard] Here’s another example of a calendar of events that is related to 3 other tables: Staff Members, Inspection Points & Facilities. [Interactive%20Dashboard_Calendar] Recent dashboard updates now allow end app users to customize the layout of the dashboard they’re using to best fit the sc…

.

New Action: Add a Row to a table Announcements

We just added an initial version of a new action ‘Data: add a new row to another table using values from this row’ Please try it and give us feedback. Documentation, etc coming later this week. The brief version is here: let’s consider an example with Orders and OrderDetails as two related tables in an app. Add an action ‘CreateChildRow’ to the Orders table that will add a row to the OrderDetails table. You can specify expressions to assign to each column of this row. For example: Order = [O…

.

help.appsheet.com

List Expressions

List expressions use and/or produce lists of values.

[MultiTech]

What comprehensive list! Nice one!

[Lucinda_Mason]

I agree that it’s hard to find all the helpful info. Your list is a great place to start. I also found watching old office hours to be helpful.

Thanks for putting this resource together.

[Jake_Naude]

Lucinda_Mason:

I also found watching old office hours to be helpful.

Hi @Lucinda_Mason… Good spot… List updated to include Office Hours… Thanks…

[Guillermo]

Great work @Jake_Naude.
I have created a website, a youtube channel and a new course in spanish for those who want to learn apsheet but doesnt speak english well enough.
here below the links to complete your list! Thanks a lot for your work

Website: https://www.tailorsheet.com/
Youtube channel with free course: https://www.youtube.com/channel/UCYZcmaI_gqDfYI84ONSMUVA/
Course from Zero to Expert: https://www.tailorsheet.com/de-cero-a-experto

[MultiTech]

---

@Guillermo wrote:

I have created a website, a youtube channel and a new course in spanish for those who want to learn apsheet but doesnt speak english well enough.

---

Excellent resource! @Guillermo Nice one!

[Jake_Naude]

Guillermo:

I have created a website, a youtube channel and a new course in spanish for those who want to learn apsheet but doesnt speak english well enough.

Hi @Guillermo,

I don’t speak Spanish but I did take a look at the English version of your site and it looks like some great content that you’ve clearly put a great deal of thought into. I’ve updated the post and included your links. Good luck with your training…

[Guillermo]

Thank you so much @Jake_Naude!

[Suvrutt_Gurjar]

Hi @Guillermo,

I believe you may wish to post your information in the post thread below as well.

Non-English AppSheet Content Resources

Hi All, Trying something a little different today. I know for many of you, English is not your first language and it had provided some difficulty when you first learned the platform. Because of this, many of you have created or found additional resources in alternate languages to either learn the platform or share information with other users in your region. If you are someone that has created a resource site for learning AppSheet in a language other than English, I would highly encourage you t…

[Guillermo]

Yes! Thanks a lot @Suvrutt_Gurjar. Ihave just updated the information of my course on the post you have mentioned! Thanks for your help!

[jcadence]

Hi @Jake_Naude Great list! One additional resource we recommend starting with is our “Learn how to use AppSheet” guide. it contains many of the resources you referenced plus a few additional. It’s available in both our support documentation and on the Creator Community. Hope this helps!

Learn how to use AppSheet Resources

Whether you’re new to AppSheet and just getting started or want to learn how to improve your existing applications, figuring out what to do next can be a bit daunting. I’ve put together a quick guide to help get you over the, “what do I do next” hurdle in case you find yourself in need of a little inspiration. AppSheet Academy For new app creators or those looking to brush up on fundamentals, our free one hour course guides you through the fundamentals of becoming a successful app creator. Hos…

[Jake_Naude]

JCadence:

“Learn how to use AppSheet” guide.

Hi Jennifer,

Thanks for that… I’ve slipped it in at #6… Cheers…

[Jake_Naude]

Here’s a clever (and free) new AppSheet learning resource from @Stefan_Quartemont and the QREW Team at https://appsheettraining.com/

Learn AppSheet Faster for Free - AppSheet IQ™ Tips & Tricks 💡

I’m so excited to announce the release of our newest product to enhance your AppSheet experience: AppSheet IQ™! AppSheet is crazy powerful and can build almost anything. But it can be hard to get a grasp on which of the hundreds of features and concepts are right for you to learn… After years of helping people learn AppSheet, we’ve narrowed in on common topics and metrics that get people building the apps they want, fast! AppSheet IQ™ has a library of topics, features, and concepts that it i…

[Eloy_Paredes_He]

Great list!! Thanks for sharing!