Use for questions about about the programming aspects of Google AppSheet like using expressions
Use for question about programming aspects of creating applications in Google AppSheet
Related tags
Questions tagged [google-appsheet]
44 questions
0
votes
1 answer
On Google AppSheet, why the result of LOOKUP isn't what it supposed to be?
For example, I have this simple table on sheet "Login Account":
User ID
Email
A001
john.doe@gmail.com
B001
test@example.com
And then on AppSheet, I'm using Data --> User Settings to set up a simple login form. I can set up a field…
Chen Li Yong
- 5,459
- 8
- 58
- 124
0
votes
1 answer
How have an Android NFC service listening my app?
I have an app built in AppSheet (Google's codeless app building solution). My app can't use my device NFC (Android Smartphone), but it can work with webhooks. I'm trying to figure out if there is a way to have a service running and listening on my…
Thiago Martins
- 3
- 3
0
votes
1 answer
APPSHEET move entire data to first row when data is updated/added
In my google sheet, I created a script that everytime a new data added or edited it will automically move it to the first row in my google sheet. What I want is when everytime I update a data or add a new data using the Appsheet, it will also…
0
votes
1 answer
Appsheet use image url as image from second table
I am trying to use the url for the image reference on my app sheet using Virtual Column but the problem is it wont detect as Image but instead as List
by the way, image links are listed on the Sheet2
0
votes
1 answer
AppSheet: adding new data populates a ' in the cell
This is happening on several sheets and I'm not sure what would cause it (and I can't find anything online about it).
What in AppSheet would cause the cells of new data to populate a ' at the beginning of the cell's value?
Apalila
- 53
- 6
0
votes
2 answers
Conditionally set text in Google AppSheet
I am evaluating Google AppSheet. I have a Google Sheet with the following structure:
| items |
| date | time | category | name |
|------------|------|----------|------------------|
| …
Dev
- 921
- 4
- 14
- 31
0
votes
2 answers
Apps Script to record copy-paste and programmatic changes through AppSheet in Google Sheets
I have a Master sheet where my team and I make changes at least twice a day. The changes are recorded in the changelog sheet.
The changelog sheet currently only records onEdit events, i.e., hand edits. The problem is most of the changes are made…
kiran kumar
- 1
- 1
0
votes
0 answers
Collecting telemetry data from AppSheet
I'm looking to build a new app for in-house users (employees) and want to try out AppSheet. However, I really want to collect telemetry (usage) data so I know who is using what, when, etc.
I don't see any information about this, even after searching…
John
- 1,124
- 1
- 11
- 27
0
votes
1 answer
Convert onEdit script to manually running script
The script has the purpose of writing the datetimestamp to a specific cell the moment when a cell in column 4 has the text Assign.
I have a script that theoretical works but I'm getting my data from Appsheet. The problem with this is that Appsheet…
AndroidzZ
- 21
- 4
0
votes
1 answer
Google Scripts onEdit not recognising data being edited on a sheet during a sync from a mobile device
I have a Google sheet that is updated by a mobile app created on AppSheet.
I have a column of data that I need to keep a history of so wrote a script to copy the column to a fblank column in another sheet.
function readdailyChecks() {
var…
-1
votes
1 answer
How to show a question in a form based on selected answer for previous dropdown-menu-question (enum list)
I'm making a form in AppSheet that will be filled out by the user of the app. I have a table with questions for the columns. Question 1 contains an EnumList of answers, so the user can select multiple answers. What I want to do is display question 2…
Nick
- 15
- 6
-1
votes
1 answer
Create table with text entries in Appsheet?
I am making an app with appsheet in which user is asked to measure some values and enter numbers in a table, can i create this table in Appsheet?
-2
votes
1 answer
What is the most efficient way to import event details from Google Calendar to Google Sheets? (Google Apps Script)
I am working on a script to save Google Calendar events to a Google Sheets file. There were many other posts on the subject, but I needed a single row per event with the guest list split into multiple columns based on criteria and I was unable to…
Benjamin
- 3
- 2
-2
votes
1 answer
Multiple Restricted Words
In Appsheet's DATA VALIDITY (Valid If) expression, is there a way to put a restriction on multiple words (needle) from a row (haystack) that is of type "text"? I know the following works:
NOT(CONTAINS([Comment],"value"))
However, is there an…
dreamerdan
- 43
- 7