-
Thanks for the advice, I think that's where I might end up.
-
All,
I've connected an infopath form to an MS sql db.
On my Inforpath (2010) form I have a field called SearchName with a button underneath the field which queries the data from the SQL db.
On my form I have a repeating table which only shows data when the SearchName field is equal to a field on the repeating table.
How can I use a bit ...
-
I've got lost in all the As and Bs.
So if I get it
Drop Down A opens Optional A
Drop Down B opens Optional B
On optional B, rule if Drop Down Value doesn't equal B, hide control.
You'll need a rule on each optional section. If you get one working you should be able to copy the rule and change the fields as required.
-
You'll need a button to query the external Sharepoint list, which you already have.
You need a formatting rule on your repeating table section so that if your 'search query box' "is not equal" to a field in repeating table, hide control
You'll need to playing around with the rule to fit your search criteria etc.
-
On your optional section use a formatting rule. Where the value, not the display value of the drop down list doesn't equal X hide your optional section.
-
http://www.infopathdev.com/forums/p/23994/83185.aspx#83185
-
My initial reaction is break it down into smaller chunks and use multiple views.
Can you at least get your form to connect to the SharePoint (SP) list? and set fields from SP to fields on an infopath form/table. Don't worry about marrying them up just yet. Can you at least pull some SP data into an infopath form.
Can you get to that ...
-
Are they hyper-linked images? Do they images still exist?
-
What will you be sending out? A web based infopath form or a word doc?
Signatures - use insert picture. People use to do that on word docs.
Look into view and form status. You could make something read only.
-
You would add a second getuserprofile data connection and use that.