Assuming your form isn’t too complicated, you can redo that with a custom form, writing the inputs into user-specific columns, checks for the condition and write the correct “Name” to the destination sheet using an add row action.
Assuming your form isn’t too complicated, you can redo that with a custom form, writing the inputs into user-specific columns, checks for the condition and write the correct “Name” to the destination sheet using an add row action.