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

[Tammi_Canelli]

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]

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]

The name field is ref but not the ID field.

Would the formula go in the ID field?