Is there a way to get a name field to auto populate based on a barcode scan?
I have a form that starts with an employee ID field that is scannable and I’d like the name field to auto populate with the employee’s name.
Would this be a formula in appsheet or my original smartsheet?
If your field type is not ref, you could read the value with an app formula (or initial value) like LOOKUP([_THISROW].[EMPLOYEE ID],SourceTableName,Employee ID,Name)
The name field is ref but not the ID field.
Would the formula go in the ID field?
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |