👋 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
Rename folder
Hi team!My app creates a new folder when a new sale is done (an automation that creates a dummy pdf with route...
How to select only month and year
I want to use a Date field, but when opening the calendar it only allows the month and year to be selected, wi...
Add a Google Doc to AppSheet and Open Google Doc in Chrome
Hi,i've 2 questions about working with Google Docs file:1 - I add an existing google doc to AppSheet and i see...
Valid If - NOT - OR
I am trying to check if some items are chosen from an EnumList and make the choices valid if.....So invalid if...
import data from google search to excel / sheets
helloIm currently doing a reaserch of certian websites results deu to different keywords, infavor to do so i n...
Content vanishing
Hi everyone,I am having a weird situation on a view. There is one specific column on which when I enter data t...
Virtual column returns only zeros
Hi everyoneI know that this has been answered left and right and I do have tried all that I could find, but de...
Setting initial value for a Ref column from another table
Hi,I am getting this error while trying setting initial value for a Ref column on my AppSheet form."The expres...
Enum List- Changing order of custom answers
Is it possible to re-order or allow users to reorder their custom answers in an Enum List? By default, the cus...
SUM BASED ON ENUM OR ENUMLIST
SUM(SELECT(ABSEN[DAY OFF],[ID TEACHER]=[_THISROW].[ID TEACHER]))) Hi there,Pless help me, how to SUM "day off"...
Copy cell to another table
Hello all. I need to copy in the Table1[Customer number] the row number of row in Table2 which contains the sa...
New AppSheet data limits published on or about 14-MAR-2024
https://support.google.com/appsheet/answer/12653576?hl=enThe preview limit of 10,000 rows for all accounts has...
avoid formula field in virtual columns that is manadatory and use only show_if field
Hello!I need some fields, yes/no type, and if the user click "yes", another field will be shown. But My table ...
How to create multiple scan with multiple quantity
Hi guys, I am designing an inventory management through appsheet. I need to outbound multiple products for an ...
Fields unique to each user
Hello everyone,This is my first AppSheet app. I was not able to find any answers for my question so hence why ...
Start the GPS selector with coordinates
In my Car Meetings App, people can select an exact GPS location.For instance, they want to select the middle o...
Count and Sum
Table ID CUTI 1 ☝️Table CUTI 2 ☝️Pless help me to make a count & sum formula, I want to find the amount of tea...
"My Appsheet databases have disappeared
This morning, my application suddenly stopped working and displayed a message stating that it was impossible t...
copy table
Hello everyone, is it possible to copy from one table to another with its children? example appointment to sal...
booking the appointment for service from google calendar
Hi guys,Is there a way to make this possible?I would like to pull data from my google calendar to a table with...
App doesn't work if we change the OAuth Client ID
Hi community,I had generated an client ID using my personal google account to code the google login in my app,...
Convert text to number?
How do you convert a text field to a number so you can do calculations on it? I’ve had to use ANY and SELECT t...
automatic pdf creation and view
Hi all. I'm currently working on a project that requires the creation of a pdf file after every register in th...
How to use EnumList to create a list of email address (in one column)?
I am creating a Bot. I want to include a list of comma separated email address (user defined) in the CC: field...
datetime local incompatable
So i have my spreadsheet set as locale AUstraliaI can confirm this setting in the table settings of AppSheet, ...
data back up
Does anyone know, if we were to somehow accidentally lose or delete our app sheet app. Would I still have acce...
Format rules
Hello lads I have a sheet where I keep the course deadlines with 2 dates in the "Training date" column and the...
About the export this view to a CSV file action
This text has been translated from Japanese into English using a translation tool.Please excuse any reading di...
Linking Columns/sheets
HI all.I'm currently working on a app for logging transportation data with trucks.I'll share the idea where i ...
