Email Data Collection - Can I autopopulate a field based on the email address?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • mvlt
    New Member
    • Apr 2007
    • 6

    Email Data Collection - Can I autopopulate a field based on the email address?

    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?
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Sorry but I am not clear from your question exactly what you are asking. Can you please provide more detailed information about what you are trying to do.

    Comment

    • mvlt
      New Member
      • Apr 2007
      • 6

      #3
      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

      Working...