-
You should be able to just copy and paste your existing rule and modify as needed.
-
Can you add a few additional formatting rules for your additional users?
-
The format of that value will depend on the environment the form is in. Put a calculated value on the form with the userName() function and open the published form (i.e. if this is a browser form, you need to publish and open in the browser). That will show you the correct value. It may also be the field I bound the section to - I used the ID ...
-
Sure. Put it in a section and hide the section unless the username matches the users you want. I'm attaching your form with a sample of this.
-
As we discovered in email, your rules were correct. The issue was with existing data - those due dates needed to be updated. You did that by toggling the location field for the TCS items so the due date was set correctly.
-
The rules get added to Location and to CPR Completed. Both of these fields could change and impact the result of the calculation. The rules then set the CPR Due Date field. I know you've checked that field no longer has a default, but maybe just verify that once more - you should be able to right click the field in the Fields task pane and ...
-
You should be able to use validation formulas for your two fields - I've attached a simple sample form for you. For the attachment field - this is a list form, so it can have only one attachment field. That should be repeating, however - I think generally you can attach multiple files.
-
Hmmm. So this is a list form? You've removed the default value from Due Date? You may need to double check your list and make sure that field doesn't have a value. You can also attach your form in a reply under the Options tab and I'll take a quick look and see if I can see what might be wrong. :)
-
I would not use a default value for CPR Due Date. I would instead use rules. I would put the same rules on CPR Completed and on the Location field. The rules would have conditions. If the Location = A or B, and CPR Completed is not blank, set Due Date to CPR Completed + 2 years. If the location is not equal to A and not equal to B, and CPR ...
-
Sounds like you got this sorted, but let me know if you still need help!