Display formula with two criteria fails

In a list box I want to control display of buttons based on two criteria:

  1. The value of a field in the current list row
  2. The number of possible states from a rowlink in a box elsewhere on the screen

Either criteria by itself seems to work, but I can't combine them.

I can control visibility based on the current row: =thisrow()[stepMask]>=1 evaluates to TRUE, button is visible.

I can control visibility based on the rowlink: =rows($[listrow][States])>1 evaluates to TRUE, button is visible.

If I combine them, the button will not be visible: =rows($[listrow][States])>1 and thisrow()[stepMask]>=1

Putting terms in parentheses and/or inside an IF statement does not help. Clicking of the formula displays a warning: 'Formula contains missing or incompatible arguments', though neither half of the combined formula has a problem.

Any suggestions?

=And(a, b)

Returns true if only a and b each return true. Honeycode uses functions for and/or.

2 Likes

Thanks. I was misled by the syntax for filters and findrow().

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.