CSV/Excel downloads + Address field: Address field with Country sub-field enabled is being downloaded in random order

  • Profile Image
    membership.dsv
    Asked on January 15, 2021 at 09:10 PM

    Hi,

    I recently added "Country" to an address field in my form. After receiving a submission, I download records as CSV to integrate with a spreadsheet I have. Naturally I need to add an extra column for Country in the spreadsheet.

    However, the order of the address items has changed quite unexpectedly and in a random way. I can compensate for this, but need to know if it is a temporary glitch or a permanent change. The little table below shows the order before and after.

    1610761753_6002461939908_

    The new order does not match the order in the Table on screen. In fact the record on screen does not show the Country at all. I'm wondering if that is the source of the problem. The country shows in the Inbox record.

    1. How do I get the Country to show in the Table?
    2. Will that fix the order of the address elements in the CSV?

    Peter

  • Profile Image
    Patrick
    Answered on January 16, 2021 at 07:00 AM

    Hello! Please allow me some time to check this. I'll get back to you soon with an update.

    Thank you!

  • Profile Image
    Patrick
    Answered on January 16, 2021 at 07:21 AM

    Hello! This seems to be a bug. The display order set for the Address field in the Sheets view is not being followed for CSV/Excel downloads.

    I am able to replicate this issue on a fresh form under my account.

    Following is the issue screencast: https://drive.google.com/file/d/1EVU9Q3d2Z45eKltih1wyMCFD71gGoRRk/view?usp=sharing

    I've escalated this issue further to the concerned team. Once this gets resolved; we'll let you know via an email under this thread.

    Thank you!

  • Profile Image
    Patrick
    Answered on January 16, 2021 at 10:27 PM

    Hello! For some reason; your last reply couldn't be embedded to this conversation. I am attaching it below:

    1610854021_6003ae85303de_Re- CSV-Exc ddr

    I'll reply to your query here shortly: https://www.jotform.com/answers/2829500

    Thank you!