My goal is:
- When a new item is created, the Report Submitted Date text field is blank. But today's date is entered when the Report Submitted combo box is flipped to Yes (and blanked when No or no selection is made).
- When an existing item is viewed or edited, the Report Submitted Date is set to the existing value. But today's date is entered when the Report Submitted combo box is flipped to Yes (and the existing value is shown when No or no selection is made).
However when I open an existing item, the date is updated to Today (sometimes it is OK when I view the first item, but not subsequent items). I want it to be initially set to the existing date value. I tried setting the global variable ReportSubmittedDate to Blank() on OnHidden, OnVisible, OnNew, OnEdit, OnView...but the same behavior persists.
For the Report Submitted combo box, OnChange is set to:
If(
Self.Selected.Value = "Yes",
Set(
ReportSubmittedDate,
Today()
),
Set(
ReportSubmittedDate,
Blank()
);
);
For Report Submitted text box, DefaultDate is set to:
Coalesce(
ReportSubmittedDate,
Parent.Default
)
