I have a form where we want members of our team to be assigned mentors and be able to update them as needed. I’ve created two datasets. One dataset with all the available mentors with bios, etc. The second dataset is of everyone and their assigned mentor.
The form has a dropdown for every mentee linked to the “mentee dataset”, a text field linked to their current mentor, and a dropdown that is able to update the “current mentor” that pull the mentor names from the “mentors dataset.”
The issue I’m having is when a new mentor is selected the Text Field that’s linked to the “Current Mentor” gets updated as selections are made in the dropdown to update that field. If would be nice if the field was only updated upon submission of the form.
(Working in the Wix editor)
I’ve scoured the forums and looked through the api for something to fix this but everything I’ve tried hasn’t worked.