Fisrt off, I have spent several hours searching and trying different answers but nothing seems to work for this seemingly simple request.
I have two form fields, one is a date field (mm/dd/yyyy) the user will select the date for, and the other is a calculated date field that needs to add 14 days (same format) to the date the user selects.
There have been some very complicated formulas I have tried and some very simple ones (Datefield1+14). I would think this could be done as a "Simplified Field Notation", however I cannot seem to find the formula to accomplish this...
Copy link to clipboard
As "Custom calculation script" of field where you select date use this.
var date = util.scand("mm/dd/yyyy", event.value);
if(event.value == "")
this.getField("Text1").value = "";
this.getField("Text1").value = util.printd("mm/dd/yyyy", date);}
Change "Text1" to the name of the field where you want to add +14.
Just 2 cents on the above answer, I would use a "custom validation script", my reason for this is that a custom validation script is only called when the field changes, whereas a custom calculation script is called when any field changes and in this instance we only need the script to run when the actual value of field changes.
I tried it as both custom validation and custom calculation and it does nothing...
Annnnd I know why... I was putting it in the field that I want to be automatically updated and pointing it to the field the user enters, not the other way around. This works! Thank you!