👋 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
Convert a date to a Month/year
I am storing a date DD/MM/YYYY but I would like to store this in another field as MM/YYYY so I can group/count...
Limit number of entries in a table for each date - HELP
Hi Team, I want to limit the number of entries in a table to ‘n’ number of entries FOR EACH DATE FROM CURRENT ...
Item ID interpreted as number in scientific e notation
Hello friends, i’ve had some weird occurences using unique_id(), generally when it generates an all-numbers co...
INPUT() with Date
Dear, I need help with INPUT() I try to create an action to let user update certain column, I found that, if t...
Problem with Bot Email
Dear, I am facing an issue with email automation which will be trigger if a column’s value is changed. Firstly...
Data Change on updateed column
Hi, I have an email that is sent when a[Send Stock Email] Column is updated to “True” by an action button. The...
Help - e-mail body / related detail order
Hello ! I created an application to take orders by phone. In the confirmation email, in the order summary tabl...
Count values in two columns
I have 2 enum columns in the same row. Both can have the value “A” or “B” or “C”. In a VC I want to count how ...
New Bug Encountered:Text disappears when clicking on inline view
I have inline view shown below which converts the address column into text, however when you click the view bu...
What does the "no response" mean?
Hello AppSheet team members, Could you please tell me what does the “no response” mean as shown in the red fra...
How to Show a more than one Column with Enum
Hello, I have a question about displaying columns based on enums. I want to be able to select a value and then...
Suggested value depending on previous data
How to get only the previous data in an enum list. This formula in suggested values does not do it: sort(SELEC...
Automation not working as expected
Good day. I have a problem with an automation not performing as expected. I have an orders table with a [code]...
Search inside a reference nested table
Hi, Is there a way for the search field to also find values that appear in the nested tables on the opening pa...
How do I display the parent record and only limited child records
Nov '21 - My parent record is Quotes (list of part numbers that need to have price quotes from various shops)....
Yesterday database
I want that my yesterday’s data next day should not be visible to anyone inside Appsheet. It’s possible or not...
How can i make a daily cash out for a store?
I’ve been working on a cash register app, and everything well but when making the daily cash out i have no ide...
Create multiple rows in other table Based on a change in the current table
Hello guys I have a problem and I searched for it a lot but couldn’t find a solution I have 4 table first tabl...
Caledar view UX Behavior
Hi, I have created a Calendar view that by default looks per month, and when I click on the calendar event, it...
Getting Authentication Error in Appsheet
Hi All, Can someone please help me debug this error we are getting when trying to access the app. Thanks, Mayu...
Help with bot please
I have two bots. The first bot copies a record from table “Job_List” to table “Jobs_Completed” once the record...
Can I limit what data shows per the user email - linked to a customer table?
I want my app to open the same for everyone. I want each customer/client to see the exact same layout and view...
Bots: branch on a condition
Hi, Maybe it is a novice question but I cant find out how to do it: I want a bot to do an action based on the ...
Image URL from Jotform not displaying
I’m using Jotform as a way for users to submit data to my app. As part of the Jotform submission, a user can t...
Issue with UX view not showing the same slices as per "view data" output
Hi guys. What might I be doing wrong if my slice “view data” table is showing the correct items as per my cond...
Mentioning specific users in slack webhook
Hi there, I have a slack webhook setup right now that, when triggered, it posts to a channel. My action is mor...
Map Pins XY
How do I edit my map pin with a description? And also, how do I get the pins to stay in place? I keep dropping...
XY base image/map
Hi, I have a map that is available as a google map (please see link below) . It is available publically as I e...
Image on XY column type not showing
Hey there! I already looked for information about the background image for WY column and It has worked for me…...
New Bug Encountered: Dropdown format rule
I have a drop down list which I need to highlight any properties which have been accessed 2 or more times, I h...
