Is there a way to get a name field to auto po...

(Tammi Canelli) #1

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?

(Aleksi Alkio) #2

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)

(Tammi Canelli) #3

The name field is ref but not the ID field.

Would the formula go in the ID field?