👋 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
Change One or More Data Values in Current Table
Something very simple, but can’t seem to get to work. The app is a shopping list. I only have one table and tw...
Create a form to select rows between 2 dates
Hi, I would like to create an form page in my app that alows user to select “From Date” to “To Date” and find ...
Error in SELECT function
Hi, everyone. I have no idea where my error is in this formula, i need to count the amount of people that need...
Detail View Always Takes me to the Same Record
Hello, I have a Students1 table. From that table, I created several slices. Every student has an advisor, and ...
Using AND , OR in same expression
I am having a problem trying to filter a view by 2 expressions. This is the formula I am trying to use but not...
Query about data to be selected
Dear Sirs: We want to select all the data in a field that is of the date and time type, how can we do so that ...
IFS() dont work
Hi I’m trying to use this formula IFS( [_THISROW].[COMPANY]=LOOKUP([_THISROW].[COMPANY],“Pontos de venda”,“COM...
Update another table
I have an app for inventory management and I have a form with many fields one of them is available serial numb...
Displaying Duration as a chart
Hi all, So I have a Virtual Column that calculates the duration between 2 DateTime Columns, basically [endtime...
Top select orderby
I’m using this expression to find the Top 4 rows of the Overstock table to show in another table. TOP( SELECT(...
Add multiple rows in other table
Hello guys I have 3 table First table : Tasks columns: Task id: Text UNIQUEID() (key) Task kind : Enum Task Da...
Menu desplegable a partir de otra tabla
Buenos dias comunidad! Mi consulta es respecto a que tengo dos tablas (A y B), donde la primera (A) tengo a lo...
Looking for some input from the more experienced guys
Hi all, Looking at this video for Google Sheets: I tried to figure out a way to do the same in AppSheet. The w...
Finding sample app for Copy wholly row to another table for log
Hi everyone. I’m finding sample app with above subject. but I didn’t found from anywhere. so please teach me t...
In a form, how to set conditions on drop down menu options?
I am developing an inventory management app. I created a form for recording inventory in/out activities. After...
How to add the sum of related transactions?
I am developing an inventory management app, which wants to show what items are put in each and every location...
Behavior > Confirmation > Require Password
Hello, Is it possible to have the confirmation prompt for a global password rather than just a Yes/No? Thanks
How to sort a Ref to a Slice?
I have a list of jobs in a Google Sheet that is used by two apps as a Ref for a drop-down list of options. Eac...
Android delay with camera
Hi, I’m building an app that needs to scan use the camera to scan QR codes. The little icon to search using th...
Max Rows or Emails per Bot run = 1000
Just doing a test on a table with 5500 rows and about 3500 email addresses. The Bot is set to create a record ...
New Bug Encountered:CSV export action returns blank CSV when table filtered using search bar
What that topic says - I am exporting from a ‘order’ table itself, not a slice, with all columns visible in th...
Link to Android whitelabel app
Hello, Is there a way to create an URL that links directly to a whitelabel app on an Android phone? Thans in a...
API > Reading Records from a Table
Hello All, I am trying to get a list of column values from my table via a API call. For testing purposes the t...
Appspot URI showing up in image path
The following path is showing up in image filenames since Sep 28. I have added ellipsis to shorten it. gs://ap...
Most Efficient Expression for a LEFT + FIND on a CONTEXT("View")
Hi guys, hope everyone is having a good day / evening. My question is whether the following expression is the ...
Group by time template
Hi, I have already read some previous questions in the community, but I can’t find a solution. I have a “reser...
Show a view depending on NOW()
Hello! Using Google Calendar data (containing “Start” and “End” columns), I want to show a view according to w...
Error Message 11-15-2021
I am getting the following error on Sync. Is this a bug? Error: “System.AggregateException: One or more errors...
How to borrow N units from one table row to another
Dear Community Member, I am creating an Inventory Management App. I have independent inventory holder entries ...
Can't get in-line drowpdown from within Form
I’m trying to replicate the sample app (Order Capture How-to) and struggling with this item (no 7). I’ve follo...
