Guide on How To Create a Community Post

Dear valuable members and users,

For a long time I’m seeing a lot of multiple and concurrent posts, posts like novels seeming to aim the Pulitzer Price, exactly the same questions by the same user but paraphrased/re-phrased etc. Being a dedicated community member and an AppSheet developer who is reading around 2.5K posts per day, I urged myself to tip on some good advice and best practice BEFORE posting something in the community:


#1 - APPSHEET DOCUMENTATION


AppSheet has a very good help documentation vested to the users and the community. Kudos to @Steve, these pages are very well documented and updated time to time. Please search and read those docs well, experiment the expressions and techniques described within, make your hands dirty, pour some sweat first before posting anything.


#2 - APPSHEET SAMPLE APPS


AppSheet has a very resourcefull SAMPLE APPS page. You can check this page out to see provided a similar app fits your requirements. If one of them deems fit, than it’s a very good opportunity to copy that app and develop your own onto it rather than starting from scratch.


#3 - HOW TO BUILD AN APP


AppSheet offers very good resources to learn how to build an app with AppSheet. I may humbly advise to start with these and then come-up with questions.

You can also check Udemy for free course as well


#4 - USE K.I.S.S. AT ALL TIMES


There is absolutely no need to create a post like a novel bespangled with over 10-15 images etc. Believe me neither Google nor AppSheet will nomenee you for the Pulitzer price. There are very talented and experienced developers and community members who can catch what you are talking about even from a single screenshot. Use K.I.S.S. technique at all times and try to explain the major problem without bunch of irrelevant details.

Bear in mind that, no one in the community has the ability to foresee the future nor we have the magic sphere to see what you have built, your sheet structure, your table schema etc. Provided you are asking something technical, try to support the question with 1 or 2 screenshots.


#5 - AVOID CREATING CONSEQUENT AND/OR CONCURRENT POSTS


I notice consequent and concurrent posts on the same issue repeatedly. When you post a question, please be patient to receive a reply for it. Provided your question is not replied somehow, there might be several reasons for that. Re-posting the same questions with the same header or just with switching words again’n’again does not guarantee that you will be receiving faster replies at all. Besides no any one is urged to reply your post. If someone knows a solution, or wants to reply, he and she ultimately will. No worries; creating a reply under your original/initial post will already be noticed in the dashboard. Please save your time and save ours as well!


#6 - SEARCH THE COMMUNITY POSTS


AppSheet Community is one of the largest knowledgebase you can find regarding AppSheet developement. Please get a habit of using the magnifying glass on upper right corner and search for possible posts, solutions, tips&tricks etc. regarding your problem before posting yours. Please also pay attention that, even when you are creating a new post, on the preview pane right hand side, the discource offers you possible posts where your typed content is matching. So use it!!


#7 - DISTINGUISH APPSHEET SUPPORT FROM PRO-BONO


I got a severe feedback from a member, telling that “he is paying AppSheet to get this support”. Please distinguish the services between Official AppSheet Technical Support whom can always be reached via support@appsheet.com and Pro-bono Community Services. We are all here on voluntary basis, our acts are totally pro-bono, we are not paid at all by AppSheet. We are all here because we love to share and help people, that’s all. So please do not treat any one in the community that he/she is obliged to help. Bear in mind that no one in the community is your child to be yelled at when someone is not giving what you asked or required. Please be gentle, kind and nice!

Thanks for reading and consideration.

28 Likes
How to add an “ADD” button in form
Features which are supported by appsheet
Retrieving long text from a table
Import Product list in csv format to appsheet
Users Permission
Multiple filters in a view
Convert Date and Time to DateTime (Timestamp)
Automated, regular movement of old data from Google sheet to a more permanent cloud database?
Show Enum Values if value of another column is true
Between in two dates
Count automatically decreased
How to create an invoice table properly?
Deployment procedure
Edit related record
Tabular form to insert data
Formulario
Grouping/filtering for inventory management
Can you apply a behavior to select spacific group of rows from the Data, when clicked?
I need to build an app to track daily activity in one category for multiple users
Any way to sort the drop down data
Required IF is false but cant make the column Blank
How to change graphic info at Spec tab command?
How to acomulate data from the actual table
Reference problem
I cannot get a good expression to Create a report that will show this in an email. I want all on one report - NOT 8 reports/emails
Get automatically the % of absenteeism
UX View - Display Name Formula Needed
How to access information from another table
DateTime column limitation
How to make in one register many rows?
Connecting Chart view values with another table/chart view
Dependent list
Quizz Refresh
Map management
Checkout list with barcode scanner
Select all feature in table view
Set Auto Value
Create workflow template for entire table
Ranking Table
Form default values based on filtering
Adding to another Table from another table
Television
Affichage de vue
Big thank you for Column Ordering in Forms!
How to import my template from Figma
Predictive model: no Output?
Reference id
Ref Causing "This Entry Is Invalid" with no explanation
Choose entry to link data
Apps Testing is locked
Calculating the percentage of completion
Build a league table for sport
Referencing 1 coloum for 1 datasheet form 2 different datasheets
Purge the Data
Save an email attachment to a "related Documents" table within the app
Sharing amounts by ratio
Dependent Drop-down in Nested Form
Brand New to Appsheet - Udemy Coupon Code to learn
Select Function Issue
Common Data so filled in Form A should Auto-Fill when completing Form B (where Forms A & B are interlinked via a Virtual Column)
Dependent Dropdown Question
Analysis Of Sync Time
Error unable to add/delete/update
Sumif Total sale In Date range
Finishing Database App
Send order and details as attachment in email
How do I make a filter with two columns?
Link Google Calendar with calendar appsheet
Creating a unique staff number
Using Barcode
Sharing account with another developer in co
Wrong percent display card
Add value to today
New Bug Encountered: missing localization for Add action in related rows
Return Value of Lookup Without Match
Hiding Views From Users
Split gallery over multiple pages
Help! How can I create a view of matching records?
Junior Football Team manager looking for help creating app that records player performance
Have trouble to copy SAMPLE APP Order Capture How-to
Audit data changes
Dashboard with date filter (Choosing) updating the others view present in it
Reference Date to a UX Calendar
Inventory management using different barcodes
20 + 1 evry 365 days but stop at 25
Alternative Order Capturing
User role customization
Define send Email
Currency issue
How are users added to an app
Is my account enterprise plus
Book a workstation in an office on a specific date
Count unique?
Set specific range for chart (col series)
Function to count cummulative data
Need advice, sample apps, community isolation use in the situation of covid 19
Disable "Add" but enable edit if row is already filled with entry data
LOOKUP from several columns
Selecting an Enum in a column deletes another column Enum entry
App Template to get started
Show_If expressions to limit "New" Button in child records(virtual colum)
How to calculate Time Difference between two rows
I am struggling!
Update Accounts Table based on Sales and Payments
Inventory App
Lookup based on multiple selection enumlist column
Scanning in Data
Selecting specific dates from the Beginning of the month
I want to add expression till today in slice
Delineate between questionnaires as in the Deck View Type
Dependent dropdowns question
Create daily water consumption dashboard
Data synchronization problem in the app
I am a newbie to AppSheets
Print form screen data
Document Parsing
two tabs filter
Changing Date format
Creating slice for every month data
Need assistance with adding editable lines
Creation of stock and inventory management application
Error with "Start" Expression
Multi-page form saving 1st page
Set Date limit
Mark attendance
Help with limiting entries
View not sorting dates at all
Show all rows based on customers
Unable to fetch app definition. The app's access token needs to be updated

I see this a lot, as well. It’s a small percentage of users, but it’s still very discouraging to those of us who volunteer our time here to help others for free.

@LeventK, you’re one of the top contributors to this forum. The vast majority of us all appreciate what you and others bring to the community. Keep up the great work, my friend!

17 Likes

Thanks @LeventK, great guide. Something like that has been on my mind to make for a long time now!

8 Likes

@LeventK
Thank you for this post. Been thinking the same.

6 Likes

Excellent guidance from a senior guide in the community @LeventK.

My humble suggestions below:

Over the years the AppSheet team and community members have created some excellent reference material. I believe many interesting solutions and excellent help articles and sample apps are available.

Whenever a new member joins the community, we anyway get a notification from the community platform. While responding to the first few posts of a new member, we, who have been around in the community for some time can share this @LeventK’s post and a few similar theme posts referred below. I believe it will help the new community member in faster onboarding of his AppSheet journey and community participation.

https://www.appsheet.com/Support
Search by a keyword such as say 'actions", “references”, “table view” and one will get many relevant help articles and sample apps.

If a new member posts in non -English language.

15 Likes

@Suvrutt_Gurjar
Thanks for this valuable contribution and support my friend, appreciated.

4 Likes

Just in case new app makers haven’t noticed one of the easiest places to search when working in the editor and emulator is the little search box bottom left.

8 Likes

@LeventK Thank you so much for putting this together. It would have been so helpful to me at the beginning of my AppSheet journey. I hope it has been marked to stay at the top of the Tips&Tricks section.

3 Likes

Don’t know how to post in this forum.

Anyway, I’m a noob and planning my first app.

The following how to help needed.

How to generate a running serial number for each row in a form.
How to display this number back to the user once they submit.
Allow update by fetching data only for the given serial number.

Thanks.

AnanthaPad

1 Like

Shoutout to @Marc_Dillon & @Steve. They’ve been a huge help while I sit over here banging my head against the wall. :grin:

5 Likes

Hi @LeventK

I allow to make a humble contribution to this thread, on suggestion from @Suvrutt_Gurjar.
You may want to integrate it in your first post ?
It’s more a how-to-do than a how-to-think-and-behave though.

For people who are willing to share expressions, indicate the tip to enclose their expressions with that:


and indent as well.

So, for short comparison, this:
IF(AND(condition1,condition2), resultTrue, resultFalse)
would become:

IF(
  AND(
    condition1,
    condition2
  ), 
  resultTrue, 
  resultFalse
)

Thank you for consideration, and many thanks to the community !

4 Likes