New to this community, so please bear with me.
How do I auto populate a secondary field based upon the text inputted? I have employee IDs that are a mix of text/interger (P356) with the employees full name (Oscar Sepulveda III) in the choices list. I want the survey to auto populate the Full_Name based upon the entry within Employee_ID. In excel I would use an array formula, yet again I am new to Survey123 and trying to figure this out.
|dateTime||Date_Time||Date and Time Form Completed|
|text||Employee_ID||Employee ID Number|
|text||Full_Name||First and Last Name|