-
Repeating fields are not a best practice because they are
hard to map to separate database rows and can cause form logic to fail when accessing fields after the repeating one.
I recommend creating a group called Roles with another repeating group underneath it called Role and a field called Name inside of that.
Then, you ...
-
InfoPath dates are formatted differently from SharePoint column dates, and now() returns a date and a time, not just a date.
The format you should be using is 2013-04-21T09:19:30 where the date is before the T and the time is after.
This will allow you to use the string functions to compare whether one date is greater than another.
Please ...
-
Hi Pete_Murphy,
If you are using the InfoPath browser form, it will default to the server time zone.
If you are using the InfoPath filler, it will default to the time zone of the user's machine where the form is being filled out.
Assuming the browser (since the filler solves your problem by design), the key question is how do you get the ...
-
Hi Excellerant,
Well, the default way of attaching the XML should be sufficient. Your email VBA code that triggers will have to open the XML and query it, but you'd have to do a very similar thing if the email body was XML. So, I don't think you gain anything by switching the XML from the attachment to the email body. We've done ...
-
Hi Dom80,
Instead of using the default submit functionality, add a button with a rule that submits, sets the value of your dropdown field, and then submits again.
That ought to do it.
-
Hi Kei and welcome to the forum,
We have an InfoPath Master class that we conduct which includes a module on best practices.
To answer your specific requirements, you'll want to use a workflow with an Impersonation Step to remove permissions on submitted forms and add back permissions for submitter, approval chain and admin staff.
Add ...
-
Create an XML Template part and include it in your form.
Or, create a dropdown without any values first and copy that.
-
Yes, you can do this but it's a bit complex since you have to manually update the form contents. I wouldn't bother because there are a lot of references. The simple way is when you originally created the form the dialog asked you if you wanted to include other schemas - that was the time to say yes and specify them. After creating the form ...
-
Well, why not just display some red text in the form? That's a lot simpler than this convoluted approach just to show a popup dialog. You can even have them click an "OK" to enable the control. Use conditional formatting and hide-show to make it dynamic. No need for popups.
-
Thanks for sharing! That's a good technique. Or, you could put the formulas on a debug view as plain text. :)