I am trying to create an application in which users make a request of their supervisor and the supervisor approves or denies the request. I created a sheet with "employee name" as a contact list and "supervisor name" as a contact list. When I fill out the form and enter names in those fields, SS doesn't pick up that they are licensed users, it just puts names in the field even though it is a contact list type.
As a result, the workflow doesn't go because the contact information is not available in the sheet.
I don't want to have to pre-populate the "employee" field contact list with EVERY employee in the company. I thought I could have them enter their email address in a field but there is no way to use that field in a workflow.
What is the solution?
Thanks!