-
joelrtaub3939Asked on January 30, 2019 at 12:06 AM
I want a number 1 to be downloaded to my excel spreadsheet, so I tried to put a simple 2-1= that didn't work, tried to put a 1 value in but that didn't work either. What do I do?
-
Nik_CReplied on January 30, 2019 at 2:27 AM
Could you please provide the form URL you're referring to and field which you would like to pass to the spreadsheet.
We'll wait for your response.
Thank you!
-
joelrtaub3939Replied on January 30, 2019 at 8:43 AMhttps://form.jotform.com/90185416958164
The `events to enter` field multiple choice. I tried calculated value, but
could not do it properly, can you help
Joel
... -
BJoannaReplied on January 30, 2019 at 11:19 AM
Do you want to show Calculation values inside of the Excel file instead of the field options?
To achieve that you will have to add a Form Calculation widget to your form and set the "Events to enter" fields inside of the Form Calculation widget as String (A-Z), like this.
You will then have to separate columns inside of the Excel file, one with field options and one with the calculation values. You can also remove "Events to enter" column from the Excel file.
Here is a demo form - https://form.jotform.com/90294601588968
Feel free to test it and clone it.
If you want to perform a calculation with assigned values, set the "Events to enter" fields inside of the Form Calculation widget as Number (0-9).
-
joelrtaub3939Replied on January 30, 2019 at 12:25 PM
When a person selects 0ne or more fields, I just want the download to excell to show just a mark of some sort to show up as the download is going on a form which allows only one space for an answer. Is this possible?
-
BJoannaReplied on January 30, 2019 at 1:32 PM
I'm sorry but I do not understand your request. Can you please explain in more details what exactly are you trying to achieve and provide us an example of what you want to see for that field inside of an Excel report. If possible provide us a screenshot as well.
-
joelrtaub3939Replied on January 30, 2019 at 2:43 PMPlease ignore the question, I did figure out a work around, thank you for
your suggestions
Joel
...