About perissf

perissf · 06-08-2021

Hi there, I have a list expression, containing SELECT with an inner IN() on another SELECT. This expression works in Test but fails during an Action to “Add a new row to another table using values from this row”. The goal of the Action is to copy the...

perissf · 03-25-2021

Well, don’t be fooled by the post title I know that the ANY expression returns an arbitrary value of the given list, and an arbitrary item cannot be predicted, but what I need is to fill the columns of a new record when creating an action of type “Da...

perissf · 03-09-2021

Recently I came across a thread related to checking USEREMAIL() against a list of email records, and it was mentioned that the check may fail due to difference between uppercase and lowercase characters. Has anybody dealt with this issue before? Is t...

perissf · 02-25-2021

Hi there, I have some problems in invoking the API to add a record to the table User Settings in my App (this is not the built-in User Settings table, instead it has been created by me). I am getting a 404 error resource not found. Note that the App,...

perissf · 02-17-2021

In a multi-language website, I want to embed in an iframe of my web page the same-language version of my App. Since the suggested (and simpler) way to make an App multi-language is through User Settings, I believe that in order to accomplish this bas...

perissf · 07-05-2021

Clarence_Chin: The expression wrong? No idea what’s wrong with your formula, please try to simplify it until you find out the issue there.

perissf · 06-18-2021

Ok Let’s start from scratch. I want to represent a situation with some persons who are assigned some tasks. The same person can have many tasks, and the same task can be assigned to many persons. I have a person and 2 tasks. These 2 tasks are assigne...

perissf · 06-18-2021

Steve: Please describe in plain language what you think this expression is doing Yes, I want to copy parent record together with child records. But the situation is slightly different from the one referenced in this post, because the relationship bet...

perissf · 06-18-2021

@Adam or somebody else of AppSheet team, have you had the chance to have a look at this issue?

perissf · 06-09-2021

The two things are unrelated: slices don’t have the possiblity to be sorted. Sorting is related to displaying data, and you can sort the same data differently, depending on the view you are displaying. However your screenshot seems to show a choice l...

My Stats

lqi's Bio

Badges perissf Earned

Recent Activity

List expression works in Test but fails in Action

Is the result of ANY expression predictable?

Case-sensitive check of USEREMAIL() against list

JavaScript API Call not working

Embed in iframe my App in a language

Re: Inventory tracking various locations

Re: List expression works in Test but fails in Action

Re: List expression works in Test but fails in Action

Re: List expression works in Test but fails in Action

Re: Question about sorting a slice

perissf's Ideas (1)