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
.
2. AppSheet: App Design 101 Guide
.
3. AppSheet: Essential Starter Articles
.
4. AppSheet: YouTube Channel
.
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
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!
.
QREW Technologies: YouTube Channel
.
AppSheet Proficiency Course (recorded instructor-led sessions) from AppSheetTraining.com
.
AppSheet Proficiency Path (excellent on-demand video content) from AppSheetTraining.com
.
In-App Resource Guides from @MultiTech_Visions
[Introducing A New Resource: In-App Guides](https://community.appsheet.com/t/introducing-a-new-resource-in-app-guides/21928) 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()](https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-and-select/24216) 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](https://community.appsheet.com/t/xy-column-type/8314) 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](https://community.appsheet.com/t/xy-view-all-pins-in-map/14200) 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
.
[Dashboarding Options With Card Views](https://community.appsheet.com/t/dashboarding-options-with-card-views/27015) 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…
[IMAGE EDITING! Rotate, Crop, Resize, Mirror, Etc- Using FileStack & URL Parameters](https://community.appsheet.com/t/image-editing-rotate-crop-resize-mirror-etc-using-filestack-url-parameters/25983) 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…
[Copy data From above Row](https://community.appsheet.com/t/copy-data-from-above-row/8841) Questions
What will be formula to IF column X Contains Value Yes then copy Data from above Row
.
@Jerome_Canete
[Show_If Conditions](https://community.appsheet.com/t/show-if-conditions/26754) 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](https://community.appsheet.com/t/loading-screen-animations/10985) 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](https://community.appsheet.com/t/interactive-dashboard/189) 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](https://community.appsheet.com/t/new-action-add-a-row-to-a-table/13232) 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…
.