Extracting City and State in Table View

  • Profile Image
    m.brichetto
    Asked on December 30, 2020 at 05:07 PM

    Hi,

    I am using a form that uses the standard address widget to pick up full address information. As you may know very key address data has its own field in the Form, but when swithcing to Submissions Table Mode, the whole address data is in the same coloumn, separated with commas.

    This makes it impossible to analyze and group data by City or State.

    I tried adding a Formula column, but with no knowledge hoy to make it work.

    Can you help me please?

    Thank you.


    Martin

  • Profile Image
    Yau_C
    Answered on December 30, 2020 at 09:24 PM

    Hi Martin,

    You can click on the 'expand column' option to achieve the result that you want:

    1609381424_5fed3630e9443_

    Please let us know if you need further assistance.

    Best,