I would like existing users to fill out a form when they apply to be a contributor, but the details they provide in the form should also update columns within their User Profile.
I’ve tried using the Set Column Action, but it appears that the form entries just creates a brand new Row vs Updating an existing row. The only Row Options I have in the Set Column is “This Item” and “-”. The Sheet the Form is referencing is Users, which has Row Owners.
Any help would be much appreciated! The only workaround I found was to use a Google Form that Looks up and Updates and existing Row. I the form submission could go to a different GS and use a Zap to update the User sheet. Seems a little messy though.