- sjpdAsked on May 15, 2015 at 04:22 PM
I'm migrating from Adobe FormsCentral. In FormsCentral I was able to re-label column-names (field-names) in the view where submissions are reviewed online. This gave me a way to shorten the resulting column-names in exported Excel spreadsheets. (as opposed to column names that are the entire text of a check box label).
Is there some way to shorten the column names that get exported to Excel? Or substitute the field-name for the label text?
- JotForm SupportBJoannaAnswered on May 15, 2015 at 05:32 PM
So basically you want to change the column names of your Excel report. Is that correct?
Unfortunately it is not possible to change the column name of Excel report during exporting from JotForm. There is no possibility to define new name of columns inside of JotForm.
I could only suggest that you change it manually after exporting.
Hope this will help. Let us know if you need further assistance.
- sjpdAnswered on May 15, 2015 at 06:15 PM
Changing the column name in Excel would be a good suggestion, except that we will be downloading and importing from Excel into an Access database application, repeatedly. So we must map the Excel column names to the Access database.
FormsCentral provided a very nice feature where the column name could be independently edited in the View Submissions display and stored permanently. These alias names were mapped to the original field names transparently, behind the scenes at Adobe.
I suggest that Jotform field names that must be the entire text of a label for a checkbox, is an onerous and inelegant column name in Excel or CSV exported file.
I would see it as an improvement of Jotform could add a feature to allow column name alternatives or aliases in the exported data files. For the alias column names to be useful, they would need to be stored and persistent between successive exports to Excel.
- JotForm SupportjonathanAnswered on May 15, 2015 at 07:06 PM
I will submit a feature request ticket to our higher team support base on the details you mentioned.
The feature will be about the capability to rename/re-label the field name during the process of exporting the data to Excel.
I cannot provide you any time frame on the ETA but we will notify you here for any news/updates on the progress of the request.
- sjpdAnswered on May 16, 2015 at 02:50 AM
Thanks. I've developed a rather cumbersome but effective work-around for shortening column names for radio buttons and check box labels.
I inserted a "text" field above the check box to act as a pseudo label, and set a shortened width in the CSS to leave room for the check box/radio buttons..
Then I renamed the label text of the checkboxes and radio buttons to a useful, short column name for use in the spreadsheet.
And I set the CSS for that abbreviated label to hide it from the form:
This hides the label, and allows the new adjacent text field to substitute as a pseudo label.
Both the label field and the checkbox field need to be set to "shrink" so that the label will appear on the same row as the checkbox or radio buttons.
It's a kludge, and it takes a lot of effort, but it works.
- JotForm SupportChriistianAnswered on May 16, 2015 at 03:06 AM
Glad to hear that you found a workaround to change the column names in question and achieve your purpose!
As my colleague jonathan has said, a ticket has already been raised to create a functionality that will save you a lot of effort. However, we cannot assure you of any timeframe. We will update you as soon as this is worked out.
- andradatudorAnswered on December 07, 2015 at 02:05 AM
- JotForm SupportChriistianAnswered on December 07, 2015 at 02:13 AM
I have moved your vote on a separate thread so we can also escalate a feature request ticket for you and also to add up to the number of user who request the same feature. You can check the thread here: http://www.jotform.com/answers/719204.
Do let us know if you need further assistance.
- SCARHSAnswered on April 15, 2016 at 11:52 PM
+1 to this feature. I just sent a ticket about that.
I could use column alias to have many forms and have more flexibility over the label caption. As of right now, I must have the label name the exact same for every form that I have and it's really time consumming.
I don't completly understand what sjpd said about having a hidden textbox above the other control and having it hidden. What will it do on the excel report? Create an empty column with desired alias?
you then look for alias name and offset +1?
Please include me on the list of distribution for this feature and if someone could assist me on having an alternate solution, I would really appreciate.
- JotForm SupportjonathanAnswered on April 16, 2016 at 12:29 AM
We will attend to your own thread about this here https://www.jotform.com/answers/819971