👋 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
Question- Using AND & OR in an expression
I have this expression on a format rule ** it applies the rule when the following applies: AND(CONTEXT(“View”)...
Creating opening screen of available forms
I want to emulate Sample Custom App Launcher but instead of launching/opening other apps, I want to display th...
Virtual column
I want create virtual column in my form. I have to make entry in virtual column.It's possible?
Action: add a new row to another table with the same values
Hiwhen i use the action "add a new row to another table", if in the destination table there is already a row w...
Compares 2 list with and give a third value
Hello,I have 3 tables:Table 1 is a list of companies, with ID and CompanyName (other columns are irrelevant)Ta...
Synching problem
My app needs to collect data offline as well as online, since it has to work in some factory locations where t...
Re: double byte vs single byte characters
I found out that while "ＴＨＩＳ" and "THIS" are considered to be identical,"コレ" and "ｺﾚ" are considered as differ...
how can i directly open "edit-form" when clicking on a row in table-view? (not "quick-edit")
in table-view when clicking on row, first you get "detail view" after this you can click "edit" and then you g...
WEEKNUM comparing CONCATENATEd date
Hi, I am having trouble getting a WEEKNUM expression to recognise a date value...My formula for the date value...
Cannot get a confirmation pop-up action to work.
Hello!I have the following one table and that is all.DateIncomeExpenseThere is a 'Transaction entry' view of f...
Potential bug: ref rows appear in editor but not in app
I have been exploring how i want to manage the files uploaded through the app, i think i have settled on a sol...
Getting calculated virtual fields to update data in table periodically
Hello! Have a little issue that I cannot seem to figure out. I have a table with some records of employee wage...
Incrementing counter
I've been scratching my head trying to solve what sounds simple - having a visible counter field that incremen...
How to update Due date?
I set Due date for each project with the formula belowIF(HOUR(DATE([End]) - TODAY())/24 <= 0, 0, HOUR(DATE([En...
Mobile app doesn’t work
Hello ios and android mobile app from doesn’t work no more. I used to used it on a daily basis and right now i...
[URGENT] - Help with App Sync.
Hi Guys, I need a urgent help, very important. One of my app recently had a insert field problem, and the user...
Missing signature images
Hi I have a table where we require the user to do 3 signatures in sequence before clicking save. All 3 have li...
Virtual column formula works; same app formula in regular column does not
Hi there, I have a table with a virtual column that flags rows I want to delete later with a formula: OR((and(...
Format rules, color
Hello everyone, I just wanted to know if you can help me with this formula, sometimes I need to put NO and mak...
Error: Data table 'Accessories' is not accessible due to: The service is currently unavailable..
Unable to fetch app definition.Error: Data table 'Accessories' is not accessible due to: The service is curren...
Write decimal numbers with 2 digits after the coma
Hello a new doubt, how can I write decimal numbers with 2 digits after the comaI have to write decimal numbers...
Appsheet App will not save
My appsheet app will not save. Interestingly if I open the same app in browser view it will save. Please see t...
Allow inputting of a date range instead of a single date?
So I have a table (Match Log) that is a log of matches. Right now I have a question for the Date. What I need ...
Displaying an image in google sheets
Hello I am struggling with the equation that displays images captured in an app in a google sheet. can anyone ...
double byte vs single byte characters
Do double byte, single byte characters matter when using Google Sheets as your source?I'm creating an app for ...
Yes/No where no opens long text for more info
for Yes/no columm, if no was selected, how would I have that open a long text box for user input? I have a sec...
If statement query
Hi, I have a number field Count that wants to increment only if a record is freshly added and not if that reco...
Inventory app
I am new to Google sheets and App sheets and I am lost. I need a basic inventory app, We have a shop and 2 van...
Select a list of dates to exclude from future bookings.
Good Evening I am trying to implement my holiday table into a formula to ensure that future visits cannot be b...
