You are viewing limited content. For full access, please sign in.

Question

Question

Forms Field Rule to Hide Table when Empty

Forms
Updated April 12, 2023
asked on April 11, 2023

Is it possible to hide a table when it is empty (has no rows) with field rules or should it be done with script?

I tried a field rule to show if one of the table's variables is not blank, but it shows even when there are no rows.

If I force the table to have at least 1 row it works, but all my tables end up with an additional blank row.

I simply want to show the table if it has rows, or given the terminology available to me, if any field is not blank.

0 0

Answer

SELECTED ANSWER
replied on April 11, 2023

The way I've done this in the past is I create an extra Column (which I hide) called ROWID. In the Field I put the formula =ROW(). Then I create a Number field outside the Table call NumRows with the formula =MAX(Table.ROWID). It will always show the number of Rows in the Table in the field. I would then use a field Rule to Show Table when NumRow is greater than 0.

Hope this helps

2 0
replied on April 12, 2023

Thank you, this worked. I already had a total field for the table so I went with that one and based it off the total being 0. It was a little strange because that was also one of the fields I was hiding but it seems as long as I save the data it works.

0 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...