Configuration List -Request - submitted data in multiple cells in Excel sheet

  • Profile Image
    CinderellaSunflower
    Asked on January 29, 2017 at 07:25 PM

    Hey! I am working with an event that wants to be able to sign up families and individuals for four classes throughout the event. I would like each form to be one family, but the individuals sign up for different classes. The way I'm trying to fix this is by using configurable lists, that is, normal fields for the family's info as a whole, but a config. list to add individuals' info. I guess I have a few questions about this:

    1) is there a better way to do this? This is the most efficient solution I have come up with, but it requires some work on my end to put individuals into the spreadsheet on separate lines, as the config. list enters them into one cell. I could have each individual submit a form, but that seems like more work than necessary on their part.

    2) I suppose that what I really want to know is how to put the config. list fields on two lines rather than just the one. This has been asked before, but all the answers I could find were tailored too specifically to each situation for me to pull out the solution I need.

    Thank you very much!

  • Profile Image
    CinderellaSunflower
    Answered on January 29, 2017 at 10:19 PM

    UPDATE: this has been sort of resolved by making the width of the form essentially 100%, as well as increasing the width of the website it is embedded in. Still, if there are any answers, let me know, as this solution is not ideal.

  • Profile Image
    Ian
    Answered on January 30, 2017 at 01:34 AM

    I'm afraid this can only be achieved manually.

    You can refer to the guide below to learn how to split text from a single cell to columns.

    https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7?ui=en-US&rs=en-US&ad=US

    Video tutorial: https://youtu.be/8lkEH0IHE7Y

    I will still forward a feature request regarding this to our developers. However, I cannot give you any guarantee that this will be implemented soon since they will still need to check its feasibility. You will just be notified via this thread for updates if there are any.

  • Profile Image
    Ian
    Answered on January 30, 2017 at 01:36 AM

    I'm afraid this can only be achieved manually.

    You can refer to the guide below to learn how to split text from a single cell to columns.

    https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7?ui=en-US&rs=en-US&ad=US

    Video tutorial: https://youtu.be/8lkEH0IHE7Y

    I will still forward a feature request regarding this to our developers. However, I cannot give you any guarantee that this will be implemented soon since they will still need to check its feasibility. You will just be notified via this thread for updates if there are any.