👋 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
Limit on Nested IFS() Expression
Was there a new update to limit nested IFS() expression? I used the expression in a virtual column to perform ...
Dereferences don't update on edit?
Hello folks. Question; Do deferences only only when adding a new row? I have reference and deferences sep for ...
Key Values with Manually Added Rows
Hello,I am trying to set up my app and am struggling with a key setup. I have a spreadsheet with existing data...
Function to randomly order items in a list
Dear Community:Is there an AppSheet function to randomly order items in a list?Thanks in advance
Automation – duplicating a row does not work when spreadsheet has over 1,000 rows
I have been run into a problem with my app.I have a scheduled daily bot set up for certain rows that duplicate...
AppSheet insists on generating virtual column after deletion of these
So, I have a few tables that each contain a reference to a central table. Naturally, AppSheet then generates a...
Total points for individual user from multiple weeks
Hi all, I am trying to create a slice within a table that will total/sum all points for each user from across ...
The percentage results revert to 0 after a few seconds.
I'm trying to calculate a percentage of conformity, and this is the formula in a virtual column:SUM(LIST(IF([1...
save uploaded file on google drive
Hi all,using AppSheet, I need to upload file and store it on google drive. The problem is, I need to store the...
oData v4 DELETE request came as GET
Hello everybody,I'm trying to build odata v4 rest api that will connect appsheet to MongoDB, but I ran into a ...
Strange behavior when uploading documents
I am observing a strange behavior in document loading that happens to me in several applications. Normally in ...
Use return values from webhooks conversion error
Hi AppSheet Community,Im encountering an issue with a webhook data action in my AppSheet app. When I trigger a...
Strange naming of documents
Good morning to the community.My application allows to upload pdf documents to the “documents” field.The gener...
Concerns about Using an AppSheet Application for 400 Users
We are currently subscribed to Google Workspace, and our organization has 400 accounts. As a result, all emplo...
Recovery JSON file not created.
We have performed a system reset on the software (as advised on previous threads) as there were 180 pending sy...
Using "Is part of" to join Table 2 to Table1 and select data from already saved data in Table 2
Hello!I have 2 tables, T1= "Details of Inspection" and T2 ="Issues". Table 2 is "Part of" T1, I referenced the...
"the scan result didnt match any known entries"
hello all,I have a question regarding a kind of QR Code that creates issue when re-scanning.when i scanning i ...
Problemas con TEXT()
Cómo puedo escapar el texto? En Español escribimos martes, 22 de agosto de 2024, si utilizo TEXT, no encuentro...
Appsheet tasks to appscript - issue with parameters not passed
Hello, I am creating an automation in appsheet that is calling appscript to create a new google task when a ne...
Comportamiento extraño con SORT()
Tengo esta expresión:UNIQUE(LIST(IF(CONTAINS([Dia], "Domingo"), 1, 0),IF(CONTAINS([Dia], "Lunes"), 2, 0),IF(CO...
MAX is not working as intended
Hi,I'm trying to find MAX value from the PID column where the first 6 digits of the PID match with the Start D...
Why doesn't a Google Calendar show up in the "Choose a Sheet/Table" selection in AppSheet?
Hey everyone,I created a calendar called "example" in Google Calendar.I connected my account as a "new data so...
Delete Button in ref in Untertabelle
Hallo, ich habe eine Untertabelle (ref) (18_0...) in einer Haupttabelle (10_GefB)Wenn hier einen neuen Datensa...
CSV Import
Hello communityThe problem I have is that I get this error when I import my csv file to appsheetthis is the er...
[BUG] Not updating a column when action button is pressed.
On my app we have a table that refers to all quotations we made for our costumers and there is a button called...
Security Filters in Latest Version Affecting Stable Version
Curious if anyone else is experiencing a similar issue.Recently, I started working on developing some addition...
Backfill values for a new field
Hi ! I have a form appsheet built & I have submissions in there already with (Y/N) answers. I added 2 new fiel...
Format Rule Disappears When I Save in Editor
I am trying to create a format rule that puts a red exclamation point in front of the facility name if the "Da...
Link to Dashboard View (LinkToRow) from Email not working
Is there a way to open a dashboard view to a specific record from a link?Current situation:I am using the foll...
QR code printed on invoice linked to that invoice
Hello friendsI want to get a QR code printed on the invoice PDF so that when it is scanned by the customer it ...
