Is it possible to get Auto Response with excel?

  • Profile Image
    cmueller1233
    Asked on March 28, 2018 at 05:14 AM

    Is this (https://www.jotform.com/answers/1114733-Auto-response-a-code-from-excel) still not possible ? Or is there a solution for having an out response form with a code from excel table one row by one row by now?

  • Profile Image
    Victoria_K
    Answered on March 28, 2018 at 09:18 AM

    Unfortunately, there is no possible options to get pieces of information from excel documents for the purpose you described. But, I can suggest creating a Smart Form with the conditional logic set up. 

    Smart-Forms-Using-Conditional-Logic

    If you could clarify the idea you are trying to implement, we could search for possible workarounds to get this ready.

  • Profile Image
    cmueller1233
    Answered on March 28, 2018 at 11:29 AM

    I would like to have Form through which users can receive Codes, with whom they can get free samples of a Product. After they have entered their email and some other Information. Users should get a Response with one unique Code from a list. There should only be one Code per email-address/user. After all Codes have been used the Form should no longer be available.



  • Profile Image
    Kiran
    Answered on March 28, 2018 at 12:47 PM

    In order to get a unique code for each user, you may consider using Unique ID widget on the form. Please refer to the guide below that can help you with setting up unique ID field on the form.

    https://www.jotform.com/help/79-How-to-Add-Custom-Unique-IDs-to-your-Form-Submissions

    Since you want to generate one ID for email address, you may set the email address as the unique question so that the form cannot be submitted again using the same email address. Also, you may limit the number of submissions on the form from the form settings.

    Hope this information helps! Please get back to us if you need any further assistance. We will be happy to help. 

  • Profile Image
    cmueller1233
    Answered on March 29, 2018 at 02:44 AM

    The Codes to redeem a free Sample only consist of letters and would need to be stored and accessed by the form somehow. Is that possible? Im afraid unique ID's would not do.

  • Profile Image
    Kiran
    Answered on March 29, 2018 at 07:06 AM

    The unique ID widget generates the number only after submitting the number and only alphabets is not possible with Unique ID widget. You may take a look at Random Value 
    Generator widget that allows to generate a value with only alphabets and check uniqueness.

    Let us know if that works. 


  • Profile Image
    cmueller1233
    Answered on March 29, 2018 at 09:43 AM

    The codes are predetermined, there not to be random.

  • Profile Image
    Kiran
    Answered on March 29, 2018 at 11:27 AM

    Unfortunately, generating continuous alphabet series is not available at this moment. Do you have the codes and data in an Excel sheet with user information? If so, the user may be provided with the code from Excel spreadsheet by using the Spreadsheet to Form widget. You may use the user's email address or phone number as the unique field. 

    Please refer the following guide that can help you with using this widget. 

    https://www.jotform.com/help/442-How-to-Use-the-Spreadsheet-to-Form-Widget

    Hope this information helps! 

  • Profile Image
    cmueller1233
    Answered on April 03, 2018 at 04:35 AM

    The Excel sheet does not contain any user information, just the codes.  

  • Profile Image
    Kiran
    Answered on April 03, 2018 at 05:49 AM

    Unfortunately, it is required to have the user information in the Excel spreadsheet to fill the form fields. Could you confirm if a field can generate the alphabet based code on the form similar to Unique ID or Random value generator widgets? If so, we can forward the thread to our backend team as a feature request for evaluation.

    Thanks!