Barcode Scan with date time entry

[Michael_Serafin]

Hello

Is there are method when performing a barcode scan to automatically add the current date/time to the same field? We are prototyping a solution for cancer patients attending a summer camp. We need to track medicine checked in and out of the facility.

Michael

[LeventK · Accepted solution]

@Michael_Serafini
Yes it’s possible. You have 2 options:
1.) You can use a Change Timestamp type column and bind it to the track the change of your Scannable column
2.) You can use a Datetime type column and set an AppFormula:

IFS(ISNOTBLANK([ScannableColumn]),NOW())

[Michael_Serafin]

Thank you Levent. Option 1 is exactly what I was seeking.

[Steve]

LeventK:

2.) You can use a Datetime type column and set an AppFormula:

Note that if you use an app formula, the timestamp column’s value will update any time the row is updated whether the barcode column value changed or not. Levent’s option #1 is the better approach if you anticipate any other column value for the row ever changing.

[Michael_Serafin]

Steve

Thank you for the feedback. Indeed recommendation 1 from Levent is exactly what I was seeking.

Michael