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

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?

0 2 301
2 REPLIES 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)

The name field is ref but not the ID field.

Would the formula go in the ID field?

Top Labels in this Space