-
Hi - welcome to the forum!
The built-in InfoPath functions should allow you to do math calculations. For example, if you're displaying totals, you'd do a simple sum(field1, field2) or even field1 + field2. It get can complicated depending on what you're trying to achieve.Here's an article describing the functions along ...
-
Sorry Yes 2 one to make it hidden if blank and the second addDays(Requestdate, 1)
-
I may not have been clear. Where is the rule that sets the Due Date field? Does the Due Date field itself have any rules on it?
-
Yes the rule I have set up for that is to take today's date add 1 day--this is populated into 2 area's one being a field that funnels into a Access Database, and another that populates a field in the subject of the email when the form is submitted. Basically it is generating a project due date.
The form is a project request ...
-
So i would set up the form to have a submitted value, set the "form load" option to change views based on this value.
Once the first person complete and submits the form the next person who opens gets the second view.
Couple of things
You may want to have different buttons for navigation depending on user
so if the lm wants to ...
-
Here's a mapping with some manual mods that I think will be right for your form and what you are trying to do - you can always import it into the mapping tool so you can see the difference.
-
Updated mapping file
-
Thank you - I have corrected the Id field I think, but I haven't been able to sort the relative mapping.
-
Hi,
I have a repeating table which is bond to a repeating group from a Sql Server database table. I'm using the InfoPath form to enter data into the database. I would like to be able to be able to change the value of a specific cell depending on an over maximum total value I'm accumulating. Is this possible without coding?
Any help ...
-
There are some problems with your mapping. You have a repeating group for your submit - >my:myFields/my:Project/my:Overtime/my:OvertimeDetails/my:OvertimeAuthHours/my:OvertimeDetail/ - but then you have absolute XPaths to your fields. They need to be relative to the repeating group instead.
The field you have indicated for the ID is outside of ...