Question

Calculations in Forms Table

Forms Laserfiche

Updated March 8, 2019

asked on March 8, 2019

Hello,

I've got a table which I'm hoping to populate a hidden field (to be used in a look up for some eventualities) depending on the answer in a drop down earlier in the row. The drop down is a Yes/No and the idea is to fill the hidden field with the work Critical or Non-Critical. As it stands I've got the following in the calculation section of the hidden field:

=IF(INDEX(Engineering_Drawing.Critical,ROW()) = "Yes", INDEX(Engineering_Drawing.Drawing_Style,ROW()) = "Critical", INDEX(Engineering_Drawing.Drawing_Style,ROW()) = "Non-Critical")

However it's stating that this contains circular logic, as far as I can tell it's sound in that if the row reads yes, it should fill the second row with Critical, and if not with Non-Critical. Anyone know where it's falling over? Maybe I can't use direct comparison in the if statement?

0 0

Answer

SELECTED ANSWER

replied on March 8, 2019 • Show version history

Which variable is using the function? If you're results should be a static value of Critical or Non-Critical, then you don't need the INDEX in the True/False values.

For example,

=IF(INDEX(Engineering_Drawing.Critical,ROW()) = "Yes","Critical","Non-Critical")

The way you have it now, it is checking the values of the Drawing_Style column after it determines the result of the IF condition and returning a true/false.

If the Drawing_Style column is where you have this function, then it is a circular reference because it is checking its own value.

3 0

Replies

replied on March 8, 2019

I will serenade you with "You can be my hero, Jason".

Makes perfect sense and works, not sure why my mind was throwing more index() in there.

Thank you,

0 0

You are not allowed to follow up in this post.

Question

Question

Calculations in Forms Table

Answer

Replies

Sign in to reply to this post.