I have a form that members will fill out with volunteer hours worked and I am trying to make it easier and faster for them by having the initial input fields auto-fill with their details (Full Name, Email, and Membership #) as soon as they access the form. Besides the Private Members Database created automatically with login, I have a separate more robust membership roster with all of their details. I am still fairly new to coding so I am learning as I go.
I was able to successfully add the code seen below (the portion above the blue line) that pulled their email address (which will be the same in both databases) since they are logged in and then had it auto-fill their email in the specific email input line. The trouble I am having how is having the code use the login email to return results from the bigger database to fill in the Full Name and Membership # fields. I tried a couple different things I found including the code from the Vorbly site however I could not get any of those to return any results.
Then I tried a different approach where I created another dataset on the page linked to the bigger database and then linked it to both the Full Name and Membership ID Input boxes. The idea was to have the login email filter out the dataset to show the values from the respective fields in the inboxes and then I would have a setfieldvalue command connected to the submit button to add those details along with the other manual input worked hour info to the form submission database.
The code below the blue line is what I tried to use last however I still could not get it to filter the dataset to return the correct values. Any suggestions or help would be appreciated. Thank you!