Missing HTML field in xls export

[jbYES]

Hi,
I have a form which uses an html element. This element is shown based on a certain logic: If the first two digits of the zip code entry are equal to the entries in the logic fields, then the field should be shown, displaying a sentence “You belong to the east region” and so on.

This works fine online and this entry is also part of the notification email. However, if I want to export the data into excel, this field does not show up.
In the “Data” section for this element, it only says “Show in Email” and “Show in entry”, both are activitated.
Is there a way to include this value in the export to csv or excel?

Thanks a lot,
Jochen

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

[jbYES]

Dear Ally,
thanks a lot for your response.
Yet, it doesn’t seem to work.
I added a hidden field with the ID 3_171
The zip field has the ID 3_5

I ran a couple of tests with new entries and the zip code starting with 01, 02 etc.
I exported the messages, but hidden field is listed, but there are no entries in that column.
Any ideas what’s missing?

I added this code to the settings

jQuery(function ($) {
var $zip = $(‘.quform-field-3_5’);
var $hidden = $(‘.quform-field-3_171’);

$zip.on(‘keyup blur’, function () {
var zip = $zip.val();

if (typeof zip === ‘string’ && zip.length) {
var first2 = zip.substring(0, 2);

if (first2 === ’01’) {
$hidden.val(‘Ost’);
} else if (first2 === ’02’) {
$hidden.val(‘Ost’);
} else if (first2 === ’03’) {
$hidden.val(‘Ost’);
} else if (first2 === ’04’) {
$hidden.val(‘Ost’);
} else {
$hidden.val(”);
}
} else {
$hidden.val(”);
}
});
});

Thanks,
Jochen

Attachments:

You must be logged in to view attached files.

[Ally]

You don't have permission to view this content. Please log in or register and then verify your purchases to gain access.

[Author]

Posts