About JPAlpano

JPAlpano · 01-10-2024

Hi Team,I need help with using [_ROWNUMBER] in an Initial Value expression.It works fine when adding new rows through a Form via "Add" action button.My Problem is when I create records from another table.To explain, this is my setup.MY TABLESFrom Tab...

JPAlpano · 01-17-2023

Hi I am having a bit of trouble with a switch formula.I have a previous Enum column called [CHANNEL].The choices are: Key Accounts, SME, Others.The next column is a text field with suggested values based on the selection from [CHANNEL].What I want is...

JPAlpano · 08-23-2022

(*NOTE: Only applicable for Google users (GSheet/GDrive))As you all know, when a file column is used in your apps and your users upload a file, Appsheet does not retain the same filename as the user uploaded it.The default filename saved to Google Dr...

JPAlpano · 08-18-2022

Hope we can have an additional sub-Header columns that will be located right below the Header columns in both Mobile views and Desktop Views.In mobile View, this will appear just as another section below headers.In Desktop View, this can utilize the ...

JPAlpano · 08-15-2022

I have the following setup:Table 1 : Action A: Update Table2 Column 3Action A setup:Do this: Data: execute an action on a set of rowsReference table: Table 2Referenced Rows: FILTER("Table 2", AND([Column 1]=[_THISROW].[Column 1], [Column 2]=[_THISROW...

JPAlpano · 07-28-2024

No. It really. I haven't found a way to iterate through [Related Records][Column Name] to display them as individual bullets in an unordered list (<OL><LI></LI></OL>).

JPAlpano · 07-28-2024

You have to turn on the toggle for Preview Features in Settings > General.

JPAlpano · 07-28-2024

Good post, but stressful in the eyes. May I request you uodate your post and divide them into paragraphs? Each sections are appearing as of the whole post is one long paragraph.

JPAlpano · 07-28-2024

Yes it is. Kinda funny that I am told to turn off Core Security to make this work.They need to whitelist Google Form and Events Add-On for GSheets as an internal connection.Why would we want to turn off Core Security settings to use this? We need the...

JPAlpano · 07-28-2024

I have the same issue and is escalated already through AppSheet support. They will have to fix this using an enhancement release.If my guess is right, you are using a Core Plan with the Core Security Settinfs turned on in the Google Admin console. Th...

My Stats

JPAlpano's Bio

Badges JPAlpano Earned

Recent Activity

[_ROWNUMBER] not showing in INITIAL VALUE when entry is added via Automation Bot

SELECT from different tables based on previous column

How to control or rename uploaded files in a [file] column

Detail View > Sub-Header columns

Run Action on a set of rows - Form Saved vs Automation bot

Re: Rich Text Formatting - in Preview Program

Re: Rich Text Formatting - in Preview Program

Re: Appsheet Work Standard Protocol

Re: Google Forms Integration is Now Generally Available!

Re: Appsheet Form Submission Bot not triggering

JPAlpano's Ideas (7)