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

Question

Question

Hide a row in a table based on the value in one of the columns?

asked on April 14, 2020

I know there has to be a way to do this with Javascript but I can't do it myself, hoping someone here can help me out... I have a table in a form for our supply chain department to do inventory. The form uses a lookup to list items we should have by location and the desired par level. The form then subtracts the actual number on hand (entered by the person filling out the form) from the par level to indicate the number that need to be ordered or restocked. I then have a second form that is sent to the manager that I would like to only have the rows of items that need to be restocked (i.e. the # to restock field greater than 0).


Thank you!

0 0

Answer

SELECTED ANSWER
replied on April 14, 2020

Hi Shawn,

You can use field rules and hide every column when the number column equals 0. When the condition is a table's column, the field rules for the table's other columns will only show/hide those on the same row.

1 0
replied on April 14, 2020

Thank you Jim, that worked perfectly (and I can use that same logic to do some other fun things with my tables, which I wouldn't have even bothered with if it I had to deal with JS lol). Great idea!

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.