Hi I have a bit of an issue that I am struggling to solve myself.
I have a worksheet with that gets updates via data shuttle with a list of employees nominated for a performance award. I want to collect feedback from their respective unit managers on specific criteria. The feedback is a numeric rating that answers specific questions. For example, "On a scale of 1-5 how would you rate {{employee name}}'s ability to resolve a customer complaint?" or "On a scale of 1-5 how would you rate {{employee's name}} ability to navigate a work conflict?" I need to ask each manager 4-5 questions for each of their employees.
The dilemma that I face is that if I use the "request update" feature, the fields have to be column names, and column names are not long enough to be these questions. If instead, I set up an automation to email a form, there is no way to prepopulate the form with the employee's name, so it just creates a new row instead of populating the existing one.
Is there a workaround that I am just not seeing?