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.
Is it possible to use different header values than the question in csv export?Asked by andygarcia on February 02, 2015 at 11:59 PM
I want my form to say "First Name" but I want the header value to be "firstName" in the csv exported file. Is there a way to do this?
I did some checks on your inquiry and sorry to say I was not able to locate any setting within the report feature of the form to support your request. The titles given to the headers in the report are identical to labels given to the fields on your form. It appears that you would have to manually adjust the header titles of each column after downloading your CSV/Excel file. I hope this answers your question. Do let us know if you need further assistance in the future.
I ended up finding a solution that worked. It doesn't actually change the name of the fields, but it copies the values of the fields to other hidden fields with the header that I want. Then, when I export it, I just choose the columns with the new header.
In the edit form main page:
Step 1: Create a text box in your form with the title of the header that you want
Step 2: Change the text box to hidden by clicking the settings button and clicking "Hide Field"
Step 3: Click the "Setup & Embed" tab
Step 4: Click "Conditions"
Step 5: Choose "Update a form field value" and click "Next"
Step 6: In the top drown down menu, choose the field you want to have a different header for.
Step 7: In the second drop down menu to the right, choose "Is filled"
Step 8: Click "Show advanced Options" and check the box that says "Add field to equation as text by default"
Step 9: In the upper right corner, click "Add Field" and choose the field you want copied
Step 9.5: You can add other characters to the new field at this point if you want
Step 10: In the "Output to field" drop down at the bottom, choose the text box that you created in the first step
Step 11: Save and that's it!
I am glad that you found a solution to your issue. If you feel the need for further assistance feel free to contact us. We are more than happy to help out. :)