Question

Different value for table rows

Forms Forms Layout Designer

Updated September 2

asked on September 2

We have flex spending accounts for our employees (FSA), that employees can put money into for medical expenses. We have one for just the employee and one for employees with dependents. If the employee is electing just for themselves the annual amount they can contribute is different than if they are electing for dependents also. I would like to do this in a table and have row 2 of the table have a maximum different than row one's maximum.

Any ideas on making the Max. Election Annually different for each row?

I'm in forms 11.

0 0

Replies

replied on September 2

Currently, I ended up doing two different tables. Each selected/shown by a radio button.

1 0

replied on September 2

You could have a formula on that field that pulls in a value based on the option selected. This assumes you have a radio button outside of your table:

=IF(my_radio_button = "Employee Only", "$5,000", IF(my_radio_button = "Include Dependents", "$10,000", ""))

That example includes nested IF statements. You could simplify the formula with just an if then else, like this:

=IF(my_radio_button = "Employee Only", $5,000", "$10,000")

I hope that helps!

0 0

replied on September 2 • Show version history

If you put a hidden field as a column of your table you can setup field rules to validate against that field.

"Validate FSA Election Table > Max Election Annually, as field with value less than or equal to FSA Election Table > Hidden Max Election. Always

This field rule enforces validation based on each row independently.

0 0

You are not allowed to follow up in this post.

Question

Question

Different value for table rows

Replies

Sign in to reply to this post.