- cmueller1233Asked 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?
- JotForm SupportVictoria_KAnswered 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.
If you could clarify the idea you are trying to implement, we could search for possible workarounds to get this ready.
- cmueller1233Answered 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.
- JotForm SupportKiranAnswered 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.
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.
- cmueller1233Answered 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.
- JotForm SupportKiranAnswered on March 29, 2018 at 07:06 AM
- cmueller1233Answered on March 29, 2018 at 09:43 AM
The codes are predetermined, there not to be random.
- JotForm SupportKiranAnswered 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.
Hope this information helps!
- cmueller1233Answered on April 03, 2018 at 04:35 AM
The Excel sheet does not contain any user information, just the codes.
- JotForm SupportKiranAnswered 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.