Hi All,
I have a form with a repeating table containing a number of fields one of which is a drop-down list box. Based on the value in the drop-down a hidden field becomes visible. I have a rule in conditional formatting that displays the hidden field when the drop down contains the text string "Other". However this only works if you choose Other as the first record in the repeating table. If you choose one of the other text values in the drop down first and then add a new row and select Other in the second drop down the hidden field wont display. I would like to know if its possible to reference a hidden field in code and make it visible?
hi,
create a new text field and in its default value use fuction
eval(eval(repeatinggroup,'Concat(my:fieldname,";")'),"..")
based on the value of this new text field(if it contains "others") hide/unhide your field
Hi Qazi,
I will try this and report back. Thanks for the quick reply.
Execellent job, worked like a charm.
Thank you :)
I think I may have jumped the gun, while it works fine on preview, once I published the form to Form Services on SharePoint, the form cannot be submitted. I get an error telling me there is required fields that need to be filled in. Which is odd because I have no required fields in the form yet. Any ideas would be welcome.
look into the data sources and check if any of the data fields are having a red * suffixed. Also might be you have some data validations set on.
attach the template so that we can have a look at it
I checked the form and cannot see any validations on unless I'm going blind. All my datafields seem fine too. I've added a link to the form template below.
your formid field is causing all the problems
change the data type of formid field to string and let me know if this gets resolved. i could not test the form properly as i dont have any access to your network.
Thanks again it was the formid field. What I don't understand is the form was submitting fine before I added the eval function to the repeatingHelper field which has nothing to do with the formid field. Anyway thanks for all your help.