InfoPath Dev

Hello, I have problem that came out of nowhere. I have published many InfoPath forms to Sharepoint pages in our company and they have been working perfectly. But couple of days ago when adding another form to the pages I see that suddenly it prompts again with security notice. Okei, I could get rid of that just by clicking "Trust all ...

Hi, Yes secondary data source is only for guiding user who is filling the form, nothing is actually saved to main connection. I circled around this problem with OnLoad function in SQL code, probably best way to handle it without web services.

Hello, I use SQL code to fill in secondary connection fields. I get the values and I submit the form via Email. When receiver opens the form, they can see but empty fields. Where have these values from secondary connection disappeared? Do these secondary connections refresh automatically at some point? What is the best practice to get values ...

Hi, I have two simple questions 1) Does InfoPath2007 have inbuilt function that it removes blank spaces from the end of the value? (e.g "FI " converts automatically to "FI") 2) If so, can I somehow circle around this automation? I have a dropdown list that gets value "FI " from the database (secondary connection). ...

Hello, I have button that sets value for two fields, submits data to database and as a mail attachment and then closes the form. But I don't understand why it starts up all the rules in the form fields? This leads to field values changing and sections closing etc... Is it normal feature that pressing button activates all the rules in the ...

Thanks ErnestoM, your guess was correct and form was easy to fix. Many thanks!

I have a database-form with InfoPath 2007. Completing the form requires input from two persons, so the process is following:  1) Person A fills in a request and submits data to database and as a mail attachment to person B  2) Person B opens the form from office outlook and approves it by clicking "Approve" ...

Hi, Let's say I have database table with fields Personnel number (primary key), Person name and Person birthdate I'm using rules to get person name displayed on custom field. Why I cannot get any value when filtering with birthdate, only with Personnel number? Can I retrieve data only using primary key fields?

Hi and thanks for your answer, Basically the problem is that I publish my form to Sharepoint, and users can "save as..." that file to their desktop. Then they can open it anytime they want and will use old version unless there are some kind of check each time they open the form. I'm not sure if OnVersionUprage is correct one ...

Hi, I have published my form to Sharepoint but users are capable of saving form to their desktop and send it from there. This creates problems with version updates to the form. I've seen it possible for the form (when opened locally) to check automatically whether it is the latest version. But I cannot find or figure out that functionality ...