I have an app that is to be used by two groups. The first group would enter a question to be asked and submit the form, saving it to a SharePoint list, sending an automatic email to the second group of people. The second group would access the entry, enter the edit mode and provide their response.
I am wanting the default date for the response (second group) to automatically default to the date they enter edit mode to respond, but I want that date to stay the same even if the user needs to edit the response a day (or more) later. Example: I edit the form with my response today (4/26/2023), but if I need to add additional notes to the entry tomorrow, I still want the original default date of 4/26/2023 to remain the same.
Obviously, the typical default formula of If(EditForm1.Mode=FormMode.Edit,Today(),Parent.Default) doesn't work as each time one enters the edit mode, the default date would update.
Is there a different formula to use to accomplish this?
Thanks!
