Jump to content

logistics

Members
  • Content Count

    18
  • Joined

  • Last visited

  • Days Won

    3

Reputation Activity

  1. Like
    logistics got a reaction from ghorbanpour in Access field from a different table in a submission form   
    Hello,
     
    I have a submission form that requests users to select a value in a drop-down.
    I would like to use the selected value to look up an email address, based on this value, in a different table, and populate a virtual field with that email address.
    I would then like to use the value in that virtual field to send a submission notification.
     
    How can I achieve this? I cannot see how to load a parameter from another table based on the value of a field.
    Any help would be much appreciated.
     
    Thanks,
    Julien
  2. Like
    logistics reacted to Mathilda in Automated emails when specific data field is updated   
    Hi Julien,
    Yes, it's possible. You may trigger changing a field and when field is changed, insert email address into virtual field.  Then using virtual field in Email field for your acknowledgement email. Since I don't know type of your datapage, I created code for details datapage.
    Insert script in the footer of your datapage:
    <SCRIPT LANGUAGE="JavaScript"> function insert() { var x= document.getElementById("EditRecordEmail").value; document.getElementById("cbParamVirtual1").value = x; } document.getElementById("EditRecordField1").onchange=insert; </SCRIPT> Insert your fieldname which you would like to trigger instead of Field1
    Also I assume that you have email field on your datapage, so you need to insert your field name instead on Email in my code.
    This way an email will be sent only if you changed value in specified field
    Hope that helps
×
×
  • Create New...