Barcode Scan with date time entry

data
(Michael Serafini) #1

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

(Levent Kulacoglu) #2

@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())
(Steve Coile) #3

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 Serafini) #4

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

1 Like
(Michael Serafini) #5

Steve

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

Michael

1 Like