Missing HTML field in xls export

Home Forums Quform WordPress Missing HTML field in xls export

This topic is: not resolved
Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #34747
    jbYES
    Participant

    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

    #34750
    Ally
    Support Staff

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

    #34758
    jbYES
    Participant

    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.
    #34773
    Ally
    Support Staff

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

Viewing 4 posts - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.
Be inspired. © 2024 ThemeCatcher Ltd. 20-22 Wenlock Road, London, England, N1 7GU | Company No. 08120384 | Built with React | Privacy Policy