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

  • CinderellaSunflower
    Asked on January 29, 2017 at 7: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!

  • CinderellaSunflower
    Replied 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.

  • Ian
    Replied on January 30, 2017 at 1: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: 

    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.

  • Ian
    Replied on January 30, 2017 at 1: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: 

    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.