👋 Hey There, Introduce Yourselves!
Hey there, Rod here on the Community Team. We're excited to see so many new faces in the AppSheet Community! W...
AppSheet Q&A
Have questions about using AppSheet? Need help with your app? This is where you can ask questions and find answers from a global community of your peers, app creators, and platform experts. Reference help documentation here.
Forum Posts
User Generated Key for Parent-Child Relations
HiBackgroundWe are currently usingGoogle Sheet to create Job orders line by line manually.Job IDs are generate...
Ask for appsheet
Hi Google,I knew Appsheet was bought by you. Please, do please to change domain from appsheet.com to appsheet....
Show "Add" if ID is not already in table
I have two tables linked together by unique ID numbers in an ID column in both tables. One is a top level "Emp...
Unique function behavior in automations
It would be helpful if the AppSheet Help Center included a clear, consolidated reference regarding which funct...
Error:Unable to obtain access token lock for user
Our application shows the following error:Error:Unable to obtain access token lock for user '100015'/For what ...
Copying row and getting the reference rows (Appointments and Images)
Hi,I have a scheduling app where I have appointments that have a referenced table for images. I want to be abl...
Auto populate table based on other table
HelloI have a table 1 with column A,B,Cis it possible to auto fill table 2 with value from Table 1 A,B when ev...
Showing ref_rows as a column other than the ID
I have 2 ref tables [client event] and [event detail], one [event detail] can have many [client events]. The a...
Sync after saving a form
I want the app to sync after saving one particular form.is this possible?I found this post, but I didn't under...
ORDERBY on SELECT in suggested values
I have a SELECT in suggested values, which works:SELECT(Wood chop orders for App SQL version.csv[Moulding Code...
BOTS condition based on a limit in VC
Hello,i'm using a bot that advice the manager if the VC [Limite_spesa] is exceeded (overbudget). Now, i'm sett...
Generating and Sending Report via Email
I'm currently making an inventory application, wherein we have the list of products, add stock, withdraw stock...
formula problem I want to calculate monthly balance and per model.
hello everyoneI need to make a Scap app to scale.But the app has many sheets, in Excel, there are many sheets....
How to have default system actions only displaying in tables but not "inline tables"
Somehow I have ended up with the default system actions (+) Add displaying in both the table view and also in ...
Google Calendar API Request Error
I have a table using the Google Calendar connection. It is used to send invitations when the user submits a fo...
How do I can show only MONTH value using Text Formula
Anyone can help me, please?This formula didn't work, I wanna show MONTH value from Column Value Reference [DAT...
Pre-select Enum value
Hi[OrderType] is Text column type.[Options] is Enum column type.[Options] - Suggested Value formula is SomeTab...
Bug when trying to access columns from ref row
Hi I am trying to access a column from ref rows column but it doesn't work. It's suggesting me the column name...
Appsheet prototype users limit
Hi guys!Is there any clear and firm answer that the 10 users we can have on prototype app is based on account ...
CSV Import Process
Hi all, was looking some help understanding how the CSV importing process works on the app. I have a process w...
Dynamic email not giving me access to my own app
I have setup a simple dynamic email, i am using a gmail client, with a (free) @gmail.com email address, i own ...
New feature: Trigger other bots
“We released in preview a new advanced feature that supports data changes happening in one Bot can trigger oth...
AppSheet and Google forms
Hi,I recent met a problem about how to build an AppSheet by using google forms that 1 person needs to several ...
Substituting line breaks in email template
In the app, if I was wanting to display a list of items, each item on it’s own line, I would do the little tri...
Relationship Demo
I wondered if anyone had or knew of a simple demo of how to relate different gsheets. Like what Id to use etc....
How to generate random unique id
Hi friends , HOW TO GENERATE RANDOMomly UNIQUEID with only 5 caracters instead of 8 caracteres given by defaul...
Hide detail view from clicking a column in a chart from a dashboard?
Hello,I have a dashboard view with three charts. When a user touches or (clicks) the columns in the charts the...
Form View link for specific record in the email
Hello Reader ,I want to give a link in the email which will open the specific record's form view the app the l...
Error only on mobile and tablet view, works normally on browser view
Hi there,I've encountered this problem twice now.In the middle of my work, I saved it then the mobile view and...
Open google sheet file
Hi, I am trying to open a google sheet file from an action button. This file is a kind of reporting format. Th...
