I have a form that we use to onboard new users. In the form, we would fill out information such as: contact name, position, department, manager, etc. Now, I want to use this same form and create a logic that would go something like this: Is the user "Current" or "New"?. So then the form displays certain fields depending on the answer. I tried this in the form and worked as expected.
However, it created a new row (a new submission), and I realized that I'm not really changing the logic in the sheets, just in the forms. What I'm trying to do is that when a current user either moves to a different department or gets a promotion, I wanted to use the forms to make these updates on current users (current information in the sheets). Are there any solutions to this rather than making these changes manually?