Question

Field rules not hiding subsequent field based on table entry

Forms Version 9

Updated February 23, 2016

asked on February 19, 2016

I am trying to combine all of our different departments' time sheets into one form. Based on the department radial you select at the very top of the form, your corresponding time detail section table will appear towards the bottom of the form. Thing is, I only want the "Other Explanation" field to show if someone selects "Other" anywhere on their daily detail from the drop-down list options on the table. I've tried setting up my field rules by saying:

Show "Other Explanation" when Any "Saturday," "Sunday," "Monday," "Tuesday," "Wednesday," "Thursday," "Friday" (for each department) is "Other."

I've tried making separate field rules for each individual day for each department. I've tried lumping together departments one week at a time. I've tried lumping ALL of the days together for every department all together. I've tried doing it the opposite way by saying Hide it unless any selection is Other. I've tried bumping the field rules up and down through the listed order from 1 all the way to the bottom of the field rule list. I can't make it work. Thoughts?

Notes: The version I am using is 9.2.1.1069, and I know absolutely no JavaScript or CSS.

0 0

Replies

replied on February 19, 2016

Hi Allison,

Fields inside a collection/table cannot be used as conditions for actions outside that collection/table. If there were multiple rows in the table, then it is possible that there might be more than one value for say, "Friday". In that case, there would be no unique condition to trigger the field rule.

If you do not expect more than one row for this table on submission, then instead of using a table to format the fields, you could instead have seven individual drop-down fields for each day of the week, outside of any collections or tables.

If on the other hand there might be more than one row on submission and you'd want the "Other Explanation" line to show if any of the fields in any row is "Other", then that would likely have to be handled using custom JavaScript.

Hope this helps point in the right direction, and we can help on Answers if you have any CSS or JavaScript questions.

0 0

replied on February 23, 2016

Ok, that answers my question, thank you! Yes, we did design the form so that you can have more than one row for a day, because we might work in more than one category/project type. Thank you! I'll see what I can figure out.

0 0

You are not allowed to follow up in this post.

Question

Question

Field rules not hiding subsequent field based on table entry

Replies

Sign in to reply to this post.