About Peter_Kalu

Peter_Kalu · 03-14-2024

Hello,I have this policy in place that checks and only permits app deployment for id's in [Owner Id] list. This worked flawlessly, until recently. Without any change, I noticed that anyone in my organization can now deploy an app. Was there a platfor...

Peter_Kalu · 08-01-2023

Hello all,I have a special situation where date columns on Appsheet are not parsed properly on SQL database. So, I'm forced to change the column to TEXT in Appsheet. However, I need to enforce validation on the column to only accept this format dd/mm...

Peter_Kalu · 04-21-2023

Hello!I implemented a solution where an action initiated from a child table deletes related rows in a parent table before finally deleting the child record. However, this action only seems to delete parent records I created, even though there are rel...

Peter_Kalu · 02-14-2022

Was there a new update to limit nested IFS() expression? I used the expression in a virtual column to perform sums based on multiple criteria. This worked without issue for over a year, then suddenly I now get this error:"Your expression uses more le...

Peter_Kalu · 04-03-2021

Hello! I’m trying to run an action from a scheduled report at a specific time; however, the action is not kicking in. No email, just need to change data. The called action changes the status column from “New” to “Complete”. I’m not sure what I’m not ...

Peter_Kalu

Nobody has had this issue before?

Peter_Kalu · 08-03-2023

You can add the second data source as a new table, and then connect it to a different view. Users get to use the view of their choice.Step 1: Click on Data > New Table (select "Gestionale 2022" sheet)Step 2: Click on UX > New View > Create a new view...

Peter_Kalu · 08-03-2023

Since the default date format for Appsheet is mm/dd/yyyy, I went with this valid_if expression insteadAND(COUNT( SPLIT( TRIM([_THIS]), "/"))=3,ISNOTBLANK(DATE(TRIM([_THIS]))))

Peter_Kalu · 08-02-2023

Thanks for the pointers and sample expression, Marc. I changed the mysql column text, but for consistency and sorting purposes I want to enforce dd/mm/yyyy format.

Peter_Kalu · 08-02-2023

We're using Apigee as an intermediary to avoid exposing IP addresses; so that means the Appsheet payload has to be evaluated before reaching MySQL backend.Appsheet sends datetime fields as such: YYYY-MM-DDThh:mm:ss.000Z. That format is not recognized...

My Stats

Peter_Kalu's Bio

Badges Peter_Kalu Earned

Recent Activity

Team Policy: Restrict who can deploy apps (Not working)

Valid if on date text

Actions to Delete Multiple Rows - Buggy?

Limit on Nested IFS() Expression

Calling an action with Scheduled Report

Re: Team Policy: Restrict who can deploy apps (Not working)

Re: Allow Users to Select Another Google Sheets File as Data Source

Re: Valid if on date text

Re: Valid if on date text

Re: Valid if on date text