How do we lookup an item in a table

  • Profile Image
    bookbyowner
    Asked on September 03, 2017 at 03:33 PM

    We have 500 items (houses) with a unique ID#  (like BC101)

    I'd like to enter that id# on form and retrieve the description of the item and an email address that we'd like to send the completed for to. 

     

    Enter ID#:  BC101

    Name:  BaseCamp 101      

    email to info@abc.com

     

     

  • Profile Image
    Mike_G
    Answered on September 03, 2017 at 04:00 PM

    The closest possible way for you to achieve your requirements with our forms is with the help of the Spreadsheet to Form widget. — How-to-Use-the-Spreadsheet-to-Form-Widget

    To send the completed form data to the email address generated in the email address field retrieve from your spreadsheet, setup an email autoresponder on the form and have the email address field as the recipient of the autoresponder — Setting-up-an-Autoresponder-Email

    If you have other questions or concerns regarding this, please feel free to contact us again anytime.