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
0
votes
0 answers

AppSheet database as a datasource for a Google Sheets Pivot Table

We have a postgresql database view that we want to access in order to provide a datasource for a Google Sheets pivot table. Sheets does not provide a way to access PostgreSQL (even via Apps Script as the JDBC connector doesn't work with pgSQL) but…
Martyn
  • 55
  • 6
0
votes
1 answer

Appsheet : open a form and insert the name of company in a field

I'm starting with appssheet. I have a table "Company" and "Actions" From Company form, I want to open a form in "Action table" (it's ok) But I want to fill the company name in the field "Company" in the form. To avoid searching the company in the…
lolodeville
  • 1
0
votes
1 answer

I can't get this script to replace the values that are inside of the table

I have a script that I would like to use to replace values in agoogle doc template with values from a google sheet, The script is recognising the varibles and can use them to create unique file names based on the info in the google sheet but it…
BikeX Winchester
  • 3
  • 1
0
votes
2 answers

Automatic Lookup Across Tables in AppSheet

Hi I'm having a problem with looking up data on another table with AppSheet Basically, when I scan in a barcode, I want the product name to lookup such that in SQL SELECT productName FROM productLookupTable WHERE productLookupTable.barcode ==…
chi11ax
  • 541
  • 1
  • 6
  • 17
0
votes
0 answers

Apps Script OnChange not firing when spreadsheet is edited from elsewhere

So I have a very simple Apps script code that has OnChange trigger, and it fires whenever I edit the spreadsheet, then sends a post request to another server. It works perfectly when I add or remove a row from the spreadsheet, but if the spreadsheet…
Ahmed Sameh
  • 1
  • 2
0
votes
0 answers

Race condition in Google Appsheet when updating row after created

It seems I'm experiencing a race condition in Google Appsheet: I've configured a Behavior in my form view: Once the form is saved -> run 'Data: set the values of some columns in this row' (edit one of the fields). Looking in the chrome developer…
user574157
  • 11
  • 2
0
votes
0 answers

Triple dependent dropdown in appsheet from google sheet with formula

How can i create triple dependent dropdown in appsheet from google sheet with formula step by step procedure. I am beginner in this, i just created a triple dependant drop down by watching youtube but the 3rd drop down are not dependant 1st coulmn.…
Abhijith Mulik
  • 3
  • 2
0
votes
1 answer

How to retrieve specific value from LIST using SELECT

I keep retrieving the entire LIST of Customer's Total Amount instead of the Specific Customer. I have tried using SELECT according to their Order ID to filter out other Customer. However, the result is still the whole list. My code here I have tried…
gphilosophy
  • 1
  • 2
0
votes
0 answers

How can I use Webhook to Edit the sheet while using Security Filter in appsheet.?

Hi i have create a POS system in appsheet. And for that I have create a webhook which deduct the Available Stocks and put the value of new available stock in Available stocks but now when I used Security filter it is not editing that Stocks can…
Shubham Singh
  • 15
  • 5
0
votes
0 answers

Converting an API connected database into a dynamic input app

I have connected my google sheets to an API from which is returns certain parameters when i enter a certain tickr. I am wondering how to go about converting this into an app, whereby the users can enter a tickr of their choice and it dynamically…
TV98
  • 1
  • 3
0
votes
2 answers

AppSheet + Spreadsheet: AppSheet won't display formulaically generated image

I am stuck on this problem and request your guidance. Appreciate it in advance! I am trying to display QR code images on the Appsheet. The images need to come from spreadsheet where they are stored in a column named QR code. The QR codes are unique…
Guss
  • 1
  • 3
0
votes
0 answers

APPSHEET formula to be editable

I want to put a formula where if the conditions are not met, it becomes editable so that the user writes the answer. I put the following example: I would like to put in the EDITABLE part IFS( (WEEKDAY(TODAY()) = 1), "Sunday", (WEEKDAY(TODAY()) =…
Johan
  • 109
  • 5
0
votes
0 answers

White Label Native apps for Android made by AppSheet

I'm trying to find people who made apps with AppSheet, and posted their apps in the PlayStore. Can they tell me experience about it, names from apps posted on PlayStore to download and try it, see how they works? Thanks
Tomás Cerbero
  • 3
  • 1
0
votes
1 answer

AppSheet: I need FILTER the data and show each user the rows that contains his NAME

I have this Users Sheet and the login process is working perfectly (if the user Email is contained in the Users list then the data will showup). Now i need to show the user the data that contains his name only (Filter), from where i can do that ?…
Mo396
  • 39
  • 1
  • 6
0
votes
0 answers

I want my app to show me Only the users i created + show each user his data

i want my app to show data only to those who are listed in my Users sheet list (check the image '2'), then i want it to show only the rows that contain the name of that user. i tries this but seems that my logique is wrong ! Any Help :) Thanks in…
Mo396
  • 39
  • 1
  • 6
1
2
3