Action Filter Condition based on Ref List Column Type

AppSheet AppSheet Q&A
, ,
1

I have a column that references another table, each row shows as ColumnName(0) . I need to create a an action that runs only if the count is 0 and not 1 per row.

I tired this COUNT(SELECT(DA_RAW[PID#],ISBLANK([PID#])))=0

though it doesn’t give an error, it makes the action not available in any view.

2

You may want to further elaborate the table names( parent and child tables) and relevant columns and whether you action is on parent or child table.

The community could then help you better.

1 Like
3

I think I’ve worked it out. With this:

SELECT(DA_RAW[PID#],ISBLANK([PID#])

you’re asking it to make a list of blank cells. So next when you do

COUNT(…)

the answer will always be zero because its counting cells with data in them and not blank cells. To fix this simply change this

SELECT(DA_RAW[PID#],ISBLANK([PID#]))

to the Key column for this table, since that will always have data in it. The contents of a cell doesn’t matter to COUNT(), just whether its got data or not.

Simon@1minManager.com

1 Like