Table Form - Widgets to text for split and create new column

  • jana.projetovoj
    Asked on December 22, 2020 at 9:13 AM

    Hi guys,

    When I created my form I used a widget to collect data in a dropdown style with two levels.

    Now, I need to analyse data and I cannot:

    1. Group data from this column
    2. Use the data from this column and split them in two different columns
    3. Create a new column from this (duplicate) with data in a text type column

    Is there a way to solve one of this demands mentioned before?

  • Alexander_G
    Replied on December 22, 2020 at 9:42 AM

    Hello, Jana!


    I split your questions to 3 different threads. Kindly, check the answers to your questions below:

    How to use the data from submission column and split them in two different-columns

    How to create a new column from the submission column and duplicate it in a text-type column


    About your first question - Group data from this column:

    As I understand you correctly - You can try to use Google spreadsheet integration for example.

    In Google docs, you can use the Import function of the spreadsheet to manipulate the Submission sheet data to another sheet and analyze it.

    Important! Make sure you do not touch or modify the Submission sheet used by google integration to avoid breaking the integration.

    The imported data can be manipulated then separately from your form submission data.


    Also it can be suitable for your other questions.


    If it is not you wanted - please, provide us more details about your issues.

    Let us know how we can be of further assistance. 


    Best,

    Alex