There is an ‘employee’ spreadsheet with columns such as Employee Name, Employee ID and others.
I have marked Employee ID as the key column and employee name as the label column.
The dropdowns involving employees show their names, as they are supposed to (as name column is chosen as label). But when the entries are recorded in the spreadsheet, the Key column values, i.e. the employee ID are recorded rather than the name column.
This is posing problems in the whole mechanism of the app.
So is there a way to do what I want, i.e. having the Name values (label column values) in the entries rather than the ID values (key column values)? Or do I have to work with whatever is going on now?