Best way to know if information is up-to-date

(0) Share

Report

Posted on by GVF

Hello,

I'm looking for ideas on how to make it possible for any user to get a sense of whether the info displayed on a form is likely to be up-to-date.

Considering that the field "Last modified" is automatically updated even if a user has merely changed a typo in one of the form's fields but has not really reviewed and updated substantial info, I was considering making the whole thing something more "deliberate".

Would it be possible to add a button or checkbox, which users could click on after properly reviewing the available info, and have this fill a date/time field immediately next to this button/checkbox?

Does this make sense? Are there better ways to achieve this? Am I complicating thing unnecessarily?

Thanks!

I have the same question (0)

All responses (7)

Answers (4)

Verified answer

Linn Zaw Win 3,407 on at

Like (2)

Report

I have never seen such a requirement in any of my projects though. We had a similar requirement but it is more like recording the approval date/time of the record.

Back to your requirement, it is possible to create another date/time field "Reviewed On" and add a checkbox "Reviewed" next to it. After properly reviewing the available info, the user can check the "Reviewed" checkbox which will auto-populate the "Reviewed On" with current date/time. And auto-uncheck the "Reviewed" onSave of the record to allow the user to check again. All of this can be done with simple JavaScript.

Was this reply helpful? Yes No
Verified answer

LuHao 40,892 on at

Like (2)

Report

Hi GVF,

Agree with Linn.

Here are steps.

1) New a two option field and a date and time field.

2) Add these two fields on the form.

Set date and time field to read-only.

If you need each form to have its own checkbox field and date field, then new multiple two option fields and date fields, add each field to the corresponding form.

3) New a workflow.

Record fields change.

Check condition.

Update record, use Execution Time(Process) to update the date and time field.

Activate the workflow.

In this way, when user check the two option field, the date and time field will change to the current time.

Was this reply helpful? Yes No
GVF 10 on at

Like (0)

Report

Hi Hao!

Thanks a lot for this! It's exactly what I had in mind and the step-by-step explanation is really helpful.

Still, I can't figure out why but I'm stuck in the last step/screenshot.

I understand that I must click on the "Review Time" field in order to be able to set the Process/Execution Time options on the right-hand panel, right?

The thing is, unlike yours, my field appears as a date one I can't click on (see below -sorry it's not in English).

Any idea what it is I'm doing wrong?

Thanks a lot!

Was this reply helpful? Yes No
Verified answer

LuHao 40,892 on at

Like (2)

Report

Hi GVF,

This field is locked in your workflow.

Set it as not read-only in the form, and then try to update it in the workflow, see it it is unlocked.

Was this reply helpful? Yes No
GVF 10 on at

Like (0)

Report

Thanks Hao! It was indeed that. All solved now.

One final detail, if I may: to make it work more as a "button", would it be possible to add a step making the checkbox go back to "No"?

Like that, when updating the record again in the future, users wouldn't need to get it from Yes to No and to Yes again, for the system to register the new date.

Thanks a lot in advance!

Was this reply helpful? Yes No
Verified answer

Linn Zaw Win 3,407 on at

Like (1)

Report

Yes, that is possible. In the workflow that updates the date/time, set the value of Two Options field to No as well.

If the Two Options field is being shown as a checkbox, change it back to two radio button on the form, configure the workflow and set the value to No, then, change the control back to a checkbox on the form.

Was this reply helpful? Yes No
GVF 10 on at

Like (0)

Report

Thanks a lot, Linn!

Was this reply helpful? Yes No