About James_Burns

James_Burns · 11-14-2023

I'm sure I'm missing something simple but when I create a new form view for a table that new form becomes the default form the app opens for the system add and edit actions. I have an Accounts_Payable table and the system generated an Accounts_Payabl...

James_Burns · 10-30-2023

I have two tables, one called Accounts_Paid and another called Accounts_Payable. A field in Accounts_Paid is Accounts_Payable_IDs which is an EnumList type with base type of Ref to the Accounts_Payable table.On the Accounts_Payable table the Vendor f...

James_Burns · 12-13-2022

I was struggling recently to name a bot I created in the "improved" editor. It defaulted to "New Bot" as usual but when I selected it there was no apparent field for bot name as there is with, for instance, actions or slices. Eventually I realized th...

James_Burns · 07-17-2022

I hope someone can help!I have a table, 'Sales', that contains a "Sales ID" as the key column. I have another table, 'SalesItems', that contains "SalesItems ID" as the key column. There is also a "Sales ID" column that is set to 'Ref' with the source...

James_Burns · 03-18-2022

Does anyone else experience an almost invisible status bar when accessing one of their apps via the AppSheet app on iPhone (see image below)? This occurs whether the app is using custom colors or any of the default colors. So far I've experienced it ...

Re: Remember a user preference · 11-14-2023

Apologies, the ORDERBY has to return a list of row keys so you could adjusted your SELECT to pull the row key and then include that result in another select. Alternatively you could leverage your MAXROW version with something like: ANY(SELECT(Treats[...

Re: Remember a user preference · 11-14-2023

Try INDEX(ORDERBY(SELECT(Treats[Treat],[User email]=[_THISROW].[User email],TRUE), [Timestamp],TRUE),1)

Re: Remember a user preference · 11-14-2023

You could skip the user table altogether and simply have the form on the treats table set up so that the initial value for each field is the last value the user entered. Add a timestamp field and then a SELECT() and ORDERBY() to get the last record f...

James_Burns · 11-08-2023

I responded to your other post which I assume addresses the same issue. But I believe you want to substitute "Add," in your url for "Action?".

James_Burns · 11-08-2023

I don't think you should have "Add" in there. It should be "Action" and then you specify the action in the payload.This has worked for me (invoked from Google Apps Script so adjust accordingly): The url like: 'https://api.appsheet.com/api/v2/apps/' +...

My Stats

James_Burns's Bio

Badges James_Burns Earned

Recent Activity

Default Form View Override

Initial Value Issue in New Desktop Design

Naming a Bot (or other elements) in New "Improved" Editor

Related Records Not Showing in Workflow/Bot Document

iPhone status bar almost invisible while using AppSheet app.

Re: Remember a user preference

Re: Remember a user preference

Re: Remember a user preference

Re: API connection syntax

Re: Invalid REST API invoke URL