Condition on behavior

[ATR]

I’m trying to create an action that is only avaible when a row from a child table is not empty. My parent table is “NotasData” and it’s child table “CobrançaData”. So when the row “Valor Pagamento” is empty the user should not be able to do the action. I used this formula bellow and it didn’t work:

ISNOTBLANK([Related CobrançaDatas].[Valor Pagamento])

[Steve]

Try:

ISNOTBLANK([Related CobrançaDatas][Valor Pagamento] - LIST(""))

[ATR]

The formula is okay but is not returning what i expected as in the image bellow the row that contains NFse 814 value at “Notas” Column should not return Y since the column “Valor Pagamento” at his child table is empty (I’ve already checked). I also tried a FILTER() formula but it didn’t work too

[Steve]

In the child table, highlight the Valor Pagamento cell of the specific row and press the Delete key to ensure the cell contains absolutely nothing.

[ATR]

Oh i see, but will the app recognize this changes on Spreadsheet? Or do i need to rebuild the table?

[Steve]

Data changes in the spreadsheet will be seen when the app syncs.

[ATR]

Still returning Yes to all data

[Steve]

Please post a screenshot of the action configuration, and a screenshot of the complete condition expression.

[ATR]

I’ve added a AND condition to also check if the payment has been already confirmed.

[Steve]

Why is this here?

[ATR]

I understood that i had to insert the list inside the isnotblank(). So i had to do exactly the way you wrote, hadn’t i?

[Steve]

ATR:

So i had to do exactly the way you wrote, hadn’t i?

Yes, please: exactly as I provided.

[ATR]

It’s close to what i wanted, i’ll show the view to explain better:

1. When both tables have the confirmation it turns green at the related table (ref rows) and at the parent table and the user wont be able to do the action.

2. Also he wont be able to do the action until all values from Related CobrançaDatas - “Valor Pagamento” Column are not empty (being empty means red dot on related Cobrança view). At the image bellow he is able to do it but is not what i expected.

As you can see the #1 condition is working, but #2 is not working properly

Srry to bother again