I have a status field (dropdown) with 7 total options. And 2 date fields (date picker).
2 of the options are Started and Completed. And the Date fields are Started Date and Completed Date.
If the User selects Started/Completed from the dropdown, I would like the corresponding date fields to auto-fill to TODAY.
Seems like you could create a workflow that runs on item change that checks the value of the dropdown. It value=started or completed just add a "set field value" action to update the started date or completed date. Just check the "Use date when action is executed" box.
Do you want this to happen live, in the form or do you want a workflow to edit the date after submission? One concern if you have it edit live in the form, suppose you are well into the process and someone accidentally selects Start and over writes the start date then says oops, and selects the correct status, yet does not notice the date change. You may want to consider this in you solution.
you will have to add there a check for two specific choice values.
I also have this same need, and I would like it to happen immediately on the form before the user saves the form - which would allow the user to change the date if they need to. (I know I could develop a workflow for this, but I worry about long term use and possibly clogging up the server with workflows when it might be cleaner/more efficient if it's immediately done in the form.)
I have a form with a task status field and a Start Date and a Completed Date field. When anyone changes the status to "In Progress" I would like the Start Date to auto populate with Today's date, similarly, I would like it to auto populate the Completed Date field if anyone changes the status to Completed.
I don't know how to write or configure formulas on my own yet, but I'm thinking this formula should include an element that says something to the effect of If Task Status equals In Progress then Today's date in Start Date field If it was currently blank - but don't do anything if it already has a date (and another one just like that for the Completed status.)
Would that be complicated? Or should I just use the workflow?
Now i need to try and find a solution for the responsive forms.
Please let me know if anyone finds a solutions :'(