Tables view + Country Sub-Address Field: The Coutry code can't be added to the Tables view if Country has been added later to the Form

  • Profile Image
    membership.dsv
    Asked on January 16, 2021 at 10:25 PM
    How do I get the Country to show in the Table?
  • Profile Image
    Patrick
    Answered on January 16, 2021 at 10:56 PM

    Hello! Unfortunately, this seems to be a bug as well. The Coutry code can't be added to the Tables view if Country has been added later to the Form.

    I've reported this to the Backend team. Following is the issue screencast:

    https://drive.google.com/file/d/162T-J4t5eDU4nD_YPP9IHm2cfJYhG634/view?usp=sharing

    Until this gets fixed; please use the Inbox view instead.

    Our apologies for the inconvenience.

    Thank you for reporting this problem.

  • Profile Image
    membership.dsv
    Answered on January 17, 2021 at 02:16 AM

    Thanks Patrick,

    I do use the Inbox view, but I think I still need the Table to generate a CSV file.

    If I revert my address field by removing Country, maybe the whole problem will go away until such time as the bugs are fixed. Can I be notified when that occurs?

    Peter

  • Profile Image
    Ariel
    Answered on January 17, 2021 at 06:38 AM

    Hello there,

    Thank you for contacting Support.

    The issue has already been forwarded to our Developers. Unfortunately, we can't provide any ETA on when this will be fixed, but as soon as we hear back from them, we will let you know.

    We appreciate your patience.

  • Profile Image
    membership.dsv
    Answered on January 23, 2021 at 12:53 AM

    Hi again,

    I deselected the Country element from the address field options in this form (https://form.jotform.com/201878813627060)

    I hoped this may undo the problem with address field order in CSVs. On the plus side, the Country is no longer shown in the Table (even where it exists in the Inbox), but on the minus side, the CSV still has the address elements in a scrambled order.

    I cloned the form (after deselecting Country) but that did not clear the problem in CSVs. Is there anything else I can do? If not. I'll have to rejig my spreadsheet

    Peter

  • Profile Image
    Patrick
    Answered on January 23, 2021 at 02:18 AM

    Hello Peter! Looks like you'll have to change the order of your spreadsheet columns. The problem with the wrong order in CSV file is replicable on new forms too; so CSV problems can't be fixed by removing the Country problem.

    Our apologies for this inconvenience.

  • Profile Image
    membership.dsv
    Answered on January 23, 2021 at 05:29 PM

    Cheers, Peter

  • Profile Image
    membership.dsv
    Answered on January 25, 2021 at 01:05 AM

    Hi there,

    It looks like I will have to give up on Tables and the CSV. It seems that every time I touch a field in the form or a column in a table, that element goes to the far right of the table. I can see that unused columns move to the end of the list, but there needs to be a way to bring them back to the "correct" order for display and download, based on the order in the form. This is especially important because I have instances where questions are repeated in different contexts on the form, so the order indicates which answer belongs where. Also it is easy to mistake one such question for another when trying to reorganise them. I can't see a way around that short of numbering the questions; something I'm not planning to do.

    I considered hiding, then unhiding questions in the desired order until I got the order I wanted, but that was very tedious and in the end unproductive because the address elements were still jumbled (as you have previously indicated). 

    I noticed that "Address" field appeared in the list of columns as well as the elements of the Address like "Street Address" and "Country".

    FYI, I added a breadcrumbs widget and when I was reviewing the columns of a test table, I am sure it appeared in the middle of the address block, but wherever it was, it did not seem appropriate. Obviously, I was planning to hide it anyway.

    I guess Jotform is working as hard as possible to fix problems with CSVs: I would rank it the most serious glitch I have come across in a working app.

    Peter

  • Profile Image
    Hulya
    Answered on January 25, 2021 at 04:12 AM

    Hi @membership.dsv,

    Thanks for reaching us. I have moved your question to a different thread since it is not related to the this title. Please find the answer in the below link:

    https://www.jotform.com/answers/2847630