Browser Forms

Re: make field visible depending on value in drop-down list in repeating table

clubo — Fri, 13 Nov 2009 12:24:30 GMT

Hi Qazi,

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.

Re: make field visible depending on value in drop-down list in repeating table

Qazi Anis — Fri, 13 Nov 2009 05:33:17 GMT

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.

Re: make field visible depending on value in drop-down list in repeating table

Qazi Anis — Fri, 13 Nov 2009 05:30:24 GMT

your formid field is causing all the problems

Re: make field visible depending on value in drop-down list in repeating table

clubo — Thu, 12 Nov 2009 14:33:15 GMT

Hi Qazi,

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.

pci_test_v0.1.xsn

Re: make field visible depending on value in drop-down list in repeating table

Qazi Anis — Thu, 12 Nov 2009 13:25:45 GMT

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

Re: make field visible depending on value in drop-down list in repeating table

clubo — Thu, 12 Nov 2009 12:58:03 GMT

Hi Qazi,

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.

Re: make field visible depending on value in drop-down list in repeating table

clubo — Thu, 12 Nov 2009 09:45:30 GMT

Hi Qazi,

Execellent job, worked like a charm.

Thank you :)

Re: make field visible depending on value in drop-down list in repeating table

clubo — Thu, 12 Nov 2009 09:20:05 GMT

Hi Qazi,

I will try this and report back. Thanks for the quick reply.

Re: make field visible depending on value in drop-down list in repeating table

Qazi Anis — Thu, 12 Nov 2009 06:22:51 GMT

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

make field visible depending on value in drop-down list in repeating table

clubo — Wed, 11 Nov 2009 15:46:30 GMT

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?