Is it possible to use different header values than the question in csv export?

  • andygarcia
    Asked on February 2, 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?

  • Sean
    Replied on February 3, 2015 at 9:36 AM

    Hello andygarcia,

    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.


    Cheers!
    Sean

  • andygarcia
    Replied on February 7, 2015 at 7:59 PM

    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!

  • Sean
    Replied on February 7, 2015 at 8:58 PM

    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. :)


    Cheers!
    Sean