I would like to set-up an email data collection to gather volunteer hours from our volunteers. Is there a way to auto-populate a field if I use the HTML format. Each volunteer has a Contact ID, but they don't know what it is. Can just replying to the email populate that field since their email address is linked to their Contact ID?
Email Data Collection - Can I autopopulate a field based on the email address?
Collapse
X
-
I have two volunteer tables. One is tblVolunteer and the other is tblHours. tblVolunteer includes the following fields [ContactID] and [email]. tblHours includes multiple entries for each ContactID that includes their task and the number of hours with the following fields [ContactID], [Task], [Hours]. The ContactID is a concatenated field - a combination of their last name and first, but the volunteer doesn't know what it is and I don't want them to have to enter it on the form (too much room for errors). Since their email address is linked to their ContactID, and the email form is obviously being sent to their email, I wonder if there is a way to autopopulate the ContactID field in the tblHours when they respond to the email. In essence I need to capture their ContactID information in the response without them having to manually enter it. Any suggestions?Comment
Comment