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

Question

Question

Hide a Row populated by a lookup rule

Forms
Updated two days ago
asked two days ago

How can I hide a row populated by a lookup rule, below is an example. when i get a value showing 0.000 shares, i would like the whole row hidden. when i use field rules the data is hidden but the row itself is still visible. Any help would be appreciated.

 

0 0

Replies

replied two days ago

You can set this up by using a "Where" clause in your lookup rule, something like this:

Then it will only pull data where the selected value is not 0.

0 0
replied two days ago

is that available on self hosted? i don't see that being a option for me. I'm on forms 12

 

0 0
replied two days ago

Sorry, to clarify - This option would be found where you originally set up your lookup query, not where you apply the rule to your form. 

Hopefully that helps!

0 0
replied two days ago

If a manual selection is not needed in the table based on results, then I would suggest controlling it from SQL with a WHERE clause that excludes values you don't want populated in your table.

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

Sign in to reply to this post.

Details
Related Posts
Loading ...