What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How to create certain values in export?Asked by bsbjadmin on May 14, 2015 at 12:05 AM
I would like to have options selected from my multi select field to translate to a particular tag list. For example in the volunteer options, if someone selects "Adopt Preceincts..." I would like for it to show (adopt) in my spreadsheet. Can I do this?
create conditions textbox google spreadsheet columns
You can achieve this by assigning a Calculation Value to the selected options.
Check this user guide: -How-to-Assign-Calculation-Value
what happen here is, there is an equivalent value for the selected option.
The Calculation value will be the one that will appear in the submission instead of the value that the end-user can see when the are selecting an option.
OR another method
what happen here is, you can use condition statement to calculate the resulting value into another field.. like a+b=c the 'c' value is the one that will appear in the submission.
Hope this help. Let us know if you need more assistance.
So is there a way for me to have my my volunteer options values to show up in different columns. For example in my form, http://www.jotformpro.com/form/51328555447965, I have a volunteer options listing. When a person signs up for the "general volunteer interest" and "coordinate post card events", I would like the calculation values I add to the form to be inserted in seperate columns. Is this possible?
To my understanding, here's what you would like to happen: You would like to have separate columns for each selection in Volunteer Options checklist.
You would like to have separate columns for each selection in Volunteer Options checklist.
Then, the data that will be inserted to those columns are the Calculation values of the each selection.
Is that correct?
What you can do is create a textbox field for each option in the Volunteer Options checklist and set it to hidden so it will not show on your form.
Then create a condition that will pass the value that you like to the text fields when an option is selected from the Volunteer Options checklist.
With this workaround, creating a text field will also create a separate columns for each selection.
Here's a screenshot of the Spreadsheet:
I would also suggest that you check the conditions created on the form. I didn't add Calculation Values to the Volunteer Options field instead I have created conditions that will hold those values and pass them to the corresponding hidden textbox fields if an option is selected.
I hope this is what you would like to happen. If not, kindly give us more details of your request and we will be glad to assist you further. Thank you.
You have completely solved that problem. I need help with one last thing and it's with the volunteer options that are exported into the spreadsheet. In addition to having them listing individuals based on their value, can I have all the values (not the acutual volunteer options as they are too wordy) combined into the volunteer options column.
Hope I am making sense.
I am not sure if I understood you correctly, but from what I can see from the screenshot provided by my colleague you already have all volunteer options inside of one column inside of the spreadsheet.
If I did not understood you correctly can you please explain in more details your request.
That's correct, but is there a way to substitute shorter values than the long volunteer options. So can I translate the volunteer options to tags separated by ","
You can try to add values to Volunteer option field (e.g. option1, option2, etc.) and than add one more field inside of your form where those values are be passed with conditional logic.
It will look like this inside of Spreadsheet.
Here is my demo form: http://form.jotformpro.com/form/51695512633962?
Hope this will help. Let us know if you need further assistance.
I will definitely test this out...lastly is there anyway to replace a current active form with this new form without losing data from the old form.
If you replace old form with a new form, you will have to integrate new form with Google Spreadsheet, but data form new integration will go into another folder. Your old data will still be saved inside of Google Spreadsheet and inside of your JotForm account.
Hope this will help. Let us know if you need further assistance.
Well I am not using Google Spreadsheet...does that matter. I am simplying downloading the data and using it.
Well, on this case what you would need to keep in mind is that your submissions will be separate as mentioned by my colleague. So your old submissions will be kept associated with your old form and the new ones will be captured in the new form.
Let us know if we can be of further assistance.
Unfortunately, I can't recreate a new Jotform so I have decided to update the current JotForm that's live with the changes you have indicated; however, when I attempt to use the conditional logic it freezes my form. Please advise.
If the form is unusable and if you actually wish to revert your latest changes, please note that we support a handy little feature called Form-Revision-History, which will allow you to revert to a version of your form that didn't have the freezing issue.
I have cloned your form to check it, and I can't seem to replicate the freezing issue. I have cloned the form named My Commitment to 42, and I have added a Conditions as described by our colleague BJoanna above:
This is an excerpt of the submission data, as received on my end from this cloned form:
The long values have been successfully replaced with the shorter values, set as calculation fields. If you continue experiencing any freezing, can you please try clearing your browser cache, and see if that helps.
If I have been looking at the wrong form while testing, please let us know which form it is that is causing your freezing issues, and we will gladly investigate further. Thank you.
Well it appears that everything is working EXCEPT, I am not getting any values in the Volunter_options column.
Here's the form, http://form.jotformpro.com/form/51328555447965.
It seems that you haven't yet added the recommended condition that would populate your Volunter_options column. Please add a new condition (Setup & Embed > Conditions > Add new condition) to Update a field value, as depicted in images above.
In the If field select Volunteer Options, select Is Filled.
Click on Add field on the right, and find Volunteer Options.
After clicking on it, yellow volunteerOptions0-9 will be added to the body of the condition. Click on the part that says 0-9, such that the background turns from yellow to gray and volunteerOptions0-9 turns into volunteerOptionsa-z.
Click on a comma at the right, so that a green comma is added after this volunteerOptionsa-z field.
In the Output To, select Volunteer_options.
I will again post the image of how the condition should look before you hit save on it:
This will ensure that the Volunteer_options column is always populated with these shortened names, such as postcard, or team42.
Please let us know how it goes.