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

No. I am talking about using the <><> ito be used for LongText columns in Detail View.Not related to PDF/HTML Templates at all.

JPAlpano

Is there anyway to make use the <> <> expressions to loop through a [Related Items] column?(like rendering each item in a table cell or a <UL><LI>?</LI></UL>

JPAlpano

This is the correct solution. So, Encrafted, Make sure you add it in a virtual column formula and appsheet should automatically assign it as a List type column.

JPAlpano

You said that both workers table and attendance table are child tables?What is the parent? I am assuming that the structure is like thisParent Table- Workers Table- Attendance TableSo that means, that both Child tables have a Ref column pointing to t...

JPAlpano

It seems that your IFS() statement only has two conditions:Either > 0, or 0. I would recommend to just try doing a simple IF().IF( [DateEntry1]>0, "Frag.= "&[DateEntry1], "")

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: Can't figure out how to make a list of things that reference the current thing

Re: Update a parent value from a child table

Re: IFS retuns "False" instead of value

JPAlpano's Ideas (7)