69 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
30
views
Appsheet lookup changes behavior after 5 seconds
I have a field I would like to have pre-filled with an initial value based on the previously filled value. It works if open the form again to fill it within 5 seconds. After that, it is blank. What ...
0
votes
1
answer
48
views
AppSheet Image column: Suggested values hide upload button
I’m using AppSheet and I found a problem with Image-type columns when using Suggested values.
My goal is to show suggested images (previously uploaded for the same product), but also allow the user to ...
0
votes
0
answers
71
views
I can't add a custom duration time to an calendar event in appsheet (+ google calendar)
I'm trying to make a custom amount of time for the duration of an event in my calendar view, this view is associated to a google calendar and when the event is created then is automatically added an ...
-4
votes
1
answer
210
views
Appsheet Bot Webhook cannot get JSON response from Google App Script Web app
Since Google Appsheet Bot Webhook cannot handle nested arrays of complex types JSON response from the Plate Recognizer API, I built a simple Google App Script as a proxy to simplify the API response ...
0
votes
1
answer
196
views
Getting an error of There is already a row with the key: ' ' with UNIQUEID() set in keys in AppSheet
I have a simple Tools inventory app. The error occurs when I try to transfer a tool to from one person to another person with an action button. If i do it without the action button, i do not get an ...
0
votes
1
answer
126
views
How can I improve efficiency of a Google Apps Script (fetch request to Salesforce, write data to Google sheet)
I have an AppSheet app that uses a Google sheet as the data source for its tables, although the underlying data source for the Google sheet is Salesforce. The Salesforce sObject is huge (660+ columns, ...
0
votes
0
answers
40
views
Google Appsheet - Update Record when add New Record en other table
I have three tables in my application called ASSETS, ASSETS_GROUP_MOVS, and ASSETS_GROUP_MOVS_LINES.
The ASSETS_GROUP_MOVS and ASSETS_GROUP_MOVS_LINES tables function as master/detail tables through ...
0
votes
1
answer
98
views
Bot Automation Parallel Execution
I've created a bot that triggers whenever a table is updated. Since multiple users can update the table simultaneously, will the bot trigger in parallel for each update (i.e., one execution per update)...
1
vote
1
answer
478
views
In AppSheet, how do I get an initial value as the latest value previously entered for this particular Product?
In AppSheet, I have a table called Scans and columns called "Product" and "Expiration". I would like to populate an initial value for the most recent entry for Expiration based on ...
0
votes
1
answer
743
views
AppSheet Create and Show PDF file
In my AppSheet app I make pdf file by automation bot, It works perfectly I created file and I got path (like Folder path and file ptefix) this path I use in "File" row of my relative data ...
1
vote
0
answers
96
views
One to One Relationship In AppSheet
How can I create a 1 to 1 relationship in appsheet?
Let's say there are 2 tables called Pen(Id, Color, Price), Clip(Pen, Color). A Pen can have only one clip and vice versa.
0
votes
1
answer
154
views
How to open multiple URLs in Appsheet
My scenario is I'm working on an Application which has a list of URLs in a table in appsheet, we are showing them as a table view. I'm trying to add a functionality for selecting multiple rows in that ...
0
votes
1
answer
119
views
How do I get an appsheet calendar reference to read dates in 2025?
I have the following appsheet reference between a list of events and a calendar.
SELECT(Calendar[Var],CONTAINS([Location],[_THISROW].[Key]))
This grabs all the data up to Dec. 31 2024 but stops at 1/1/...
0
votes
1
answer
49
views
Concat 2-3 columns in Google Database
I'm using Google App Sheet.
How can I join columns using this concat or textjoin expression under "Name" Column?
Not using Spreadsheet, I'm using database.
Not able to find the solution. I ...
0
votes
1
answer
134
views
Google AppSheet: Handling API Errors and Providing Real-Time User Feedback
I'm currently working on an AppSheet app that submits data via a form to a Google Sheet.
It's set up in the way AppSheet appears to have intended: the data source is Google Sheets with specific ...