About AI-FL

AI-FL · 08-19-2023

Hi there. I have a Parts Master table and Parts Used table. Part Used column named "Part Number" is a Ref type pointing back to Parts Master. This is awesome because users can click the "New" button when on Parts Used Form to search for a part to add...

AI-FL · 06-30-2023

Looking for guidance as I'm new to calling scripts in AppSheet. I have an Apps Script that creates a POST request with a required JSON array. I would like to know if Appsheet can create the array variable using a loop on my returned list (below) OR i...

AI-FL · 06-05-2023

This may not be REF_ROWS at all but here goes. I have an inline Ref table (Parts) displayed on the Details page of my Job table records. I have an AppScript that I am posting payload to Quickbooks and I would like to pass this Ref table to a variable...

AI-FL · 05-19-2023

I have an Estimate table that includes a Ref column for Job ID (key) from Jobs table. To add a new record to the Estimate table, I have an action button on the Job Detail page to open Estimate form. When I save the form, a new record is added to the ...

AI-FL · 07-19-2022

I have Parts Needed and Parts Master sheets. I would like to autofill some fields based on either of two inputs in form for Parts Needed. Below formulas work fine independently but adding both I get circular error. I understand why the error is occur...

AI-FL · 07-09-2023

The bot is working now to create the JSON file. Thanks for this. One last question...you mention folderid. Are you using a Google drive folder by chance to house the JSON files? I'm getting stuck on having to point to the JSON file (8a453bd1.JSON) in...

AI-FL · 07-04-2023

Thanks @scott192 . I'm going to give this a try. Definitely looks like it will solve my loop-thru-list problem.

AI-FL · 07-02-2023

The script will take the array as a parameter and pass to the POST call. For example: var response = UrlFetchApp.fetch(url, { method: 'POST', muteHttpExceptions : true, payload: JSON.stringify(arrayVariablefromAppSheet), headers: { Authorization: 'Be...

AI-FL · 07-01-2023

The purpose is to create the array and pass to my Apps Script function via Appsheet Process.

AI-FL · 06-30-2023

I found the issue. I needed to return a list, but not of the key column. I am using SELECT now and getting the expected list of values.Thanks.

My Stats

adimoravineni's Bio

Badges AI-FL Earned

Recent Activity

Part of referenced table checkbox will not stay selected

Create Array for Function parameter

REF_ROWS output to variable

Populate Ref column on Add

Autofill Initial Value circular error

Re: Create Array for Function parameter

Re: Create Array for Function parameter

Re: Create Array for Function parameter

Re: Create Array for Function parameter

Re: REF_ROWS output to variable