How can I get the short column names (fieldname) in the Excel Report?

  • Profile Image
    Dew
    Asked on February 07, 2012 at 01:20 PM

    How can I get the short column names (fieldname) in the Excel Report?

    Thank you.



    This is a re-post of a comment on How to Create an Excel Report?

  • Profile Image
    NeilVicente
    Answered on February 07, 2012 at 01:36 PM

    I am not sure if I understand your question correctly. What do you mean by short column name (field name)?

    Can you please provide more details regarding the nature of your question so we can come up with an appropriate answer or solution?

    We'll be waiting for your response. Thanks!

  • Profile Image
    Dew
    Answered on February 07, 2012 at 02:22 PM


    Thank you for your prompt response.
    I mean the field names that can be inserted when generating email. Those would be very helpful to receive in Excel format because I use a FileMaker Pro database to keep all the data I collect from jotform and I'd like to use the column names of the Excell report as the field names in my FileMaker database.
    Thank you!

    Dew

  • Profile Image
    NeilVicente
    Answered on February 07, 2012 at 03:03 PM

    Sorry but it still sounds vague. When you said "field names that can be inserted when generating email", were you referring to the form field placeholders such as these?

    {categoryselect}
    {presenterIs}
    {presentationPreference}

  • Profile Image
    Dew
    Answered on February 08, 2012 at 11:00 AM


    Yes, those! I would like to be able to export the data in Excel using those as the column headers. It is possible?
    Thank you!

  • Profile Image
    Dew
    Answered on February 08, 2012 at 11:00 AM
  • Profile Image
    fxr
    Answered on February 08, 2012 at 04:01 PM

    Dew,

    Unfortunately, its not possible to use them field variable names on the Excel downloads of your submissions. 

  • Profile Image
    dellquaysc
    Answered on March 10, 2016 at 07:36 AM

    I too would like to name the column names used in the database and therefore the spreadsheets etc. Using the label content as a column name makes them very cumbersome and not very user friendly.

    Would it not be possible to provide a property of the input field that we could set ourselves that would then be used, in preference to the label if it exisited.

  • Profile Image
    EltonCris
    Answered on March 10, 2016 at 08:45 AM

    @dellquaysc

    We will answer your question here http://www.jotform.com/answers/791724. Thanks!