I’m new to Appsheet.
I’m making an attendance log.
I want to be able to lookup an employee by their name but have the data reference their Employee Number. This way if someone changes their name, I can just change the Employee name list rather than going into the data log and change every instance.
If I’m doing this in google sheets I’d have a drop down of employee names with a vlookup next to it to find the employee number, and then do a query on the data based on the employee number.
I’m assuming/hoping there is a way to easily do this in Appsheet.
Thanks in advance.