Stack Overflow
Stack Overflow

Questions tagged [google-appsheet]

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

44 questions
2
votes
2 answers

appsheet prevent duplicate entries

I would like to know how I can prevent a duplicate entry (based on my own client/project definition of what that means-below), in an AppSheet mobile app connected to Google Sheets. AppSheet talks alot about UNIQUEID() which they also encourage using…
ipisors
  • 21
  • 1
  • 4
1
vote
1 answer

Count how many instances the value in a column appears in that column

I need to create a virtual column in APPSHEET that will return a count of how many times the value in [ptnum] appears in the data table column [ptnum]. I want it to return the number as value in the virtual column. I need an APP…
randy dickinson
  • 81
  • 8
1
vote
1 answer

Appsheet - special character inside columns' titles but not true

I'm receiving the following message: Table name 'IINR(finishes)' uses special characters that are used in expressions and formulas. Consider renaming the table to remove these special characters. But I checked and there are no special characters…
Teo
  • 3,143
  • 2
  • 29
  • 59
1
vote
1 answer

AppScript - AppSheet API Post Issues

I'm attempting to send a row to an appsheet app with their provided API. I have it all set up in app script and I'm getting a code 200 (success) but it's not adding the data to the spreadsheet. Am I doing something wrong? function testingAPI(){ …
Bl0nde Yetti
  • 11
  • 2
0
votes
0 answers

Can I have a default value of enum in an AppSheet table?

I have a table which I use as a CMS to generate my templated documents. I have a column with ENUM values in it and I'd like to have a default value to be preset in the template. Can I do this in AppSheet?
Dvdgld
  • 1,984
  • 2
  • 15
  • 41
0
votes
0 answers

Integrating AppSheet, PostgreSQL, and MinIO S3 Server for Photo Storage

I am developing a student management system using AppSheet and PostgreSQL. In my PostgreSQL "students" table, there's a "photo" column that should store photos in our MinIO S3 server. However, when a photo is uploaded via AppSheet, it gets stored in…
Islom Ilkhomov
  • 1
0
votes
0 answers

using appsheet getting error " "COMPUTED_VALUE""

I do have this formula ={"R Per Maand";ARRAYFORMULA(IF(LEN(B2:B),I2:I*GOOGLEFINANCE("CURRENCY:USDZAR"),))} that when running from google sheet is working, but when I run it from appSheet app, it gives error ="COMPUTED_VALUE" with this "Array result…
Odiez Bez
  • 11
  • 2
0
votes
0 answers

I entered this formula and my app goes blank

Any(IFS(Sales log[Item Code/Description]=Product List[Product Description],(Select(Product List[CFN],[_THISROW].[Item Code/Description]=[Product Description])),Sales Log[Item Code/Description]=Product list[CFN],(Select(Product…
Enna Nadanthaalum
  • 17
  • 4
0
votes
0 answers

Appsheet Build - my push notifications working in apk but not working in aab

My application build seems to get push notifications when downloaded from APK on android. The AAB bundle that was on the same email app sheet sent with links, is the one uploaded onto play store. The play store downloaded app from android is not…
Sarah Lyons
  • 1
0
votes
1 answer

Appsheet how do I check if the value can be divided by 30?

I am trying to check the time of duration must be 30 minute per unit. My data are like this "MINUTE([time])" which return a number. Any idea how I can achieve this? I tried to validate like this "([_THISROW] % 30) = 0" but error return:…
polohi
  • 1
  • 1
0
votes
1 answer

How can I have a Timestamp created in a column when the state of a field in another column is set to a specific status?

How can I have a Timestamp created in a column when the state of a field in another column is set to a specific status?, ie. "In-Progress"? I have a column for "Status", there are buttons to press when the job is "in progress" and "completed". I…
David Young
  • 1
0
votes
0 answers

Possible for Apps Script to extract the "Before" value of edited cells in specified column?

I created an AppSheet app that uses a Google Sheet as its' backend database. When adding new rows through the app, most fields contain text input, except columns E and F, in which users capture images with their mobile device's camera (The photos…
Lindsey
  • 1
0
votes
0 answers

Creating a Google doc from Appsheet

Can you create a Google doc from Appsheet dynamically ? It allows you to create a pdf file on a Google drive but not a Google doc . Opening the pdf as a Google doc leads to having two files (pdf and doc) and not what we need.So, can we create a doc…
DVader
  • 15
  • 1
  • 6
0
votes
1 answer

Is it possible to dynamically change the number of decimal places in appsheet's same column?

In the google app_sheet(these formulas similar to the excel formulas, therefore if you know the solution with the excel, please let me know) I need to set a the column for dynamically change decimal places. as a example when a calculated value comes…
Nira Mosh
  • 11
  • 4
0
votes
0 answers

How to disable the app close confirmation dialog in Google AppSheet App?

I created my first my Google AppSheet App in Google sheets. It is super easy to display my data in app form. Editing and delete a row is also easy, simply selecting required check boxes. Except one thing. When I close the app, it shows a…
Sun Bathu
  • 1
  • 1
1
2 3