How to get data in different cells

  • Profile Image
    Asked on November 30, 2017 at 03:25 PM

    Hi guys!

    Need help to solve a problem we are having.

    We have a form to get proposals from Chefs for requests we get from clients.

    In one part, we ask them the Chefs to offer some optional stuff (like waiters, dishes, decoration, ...) and to tell us how much they charge for that. (Where it says: Anota aquí los opcionales que quieras agregar y su valor total)


    We are using the Matrix Dynamique widget for it and it works ok for the one who is filling the form.

    But for us, who have to use that data, doesn´t work right. All the data (every option and every value) goes into one single cell in our integrated google spreadsheet. Because of that, we are not able to use that data.

    Is it possible, maybe with other widget, to get every option and every value in a different column but in the same row?


  • Profile Image
    Answered on November 30, 2017 at 03:29 PM

    This is how I get the data in the spreadsheet

    1512073721Data in spreadsheet.png

  • Profile Image
    Answered on November 30, 2017 at 06:10 PM

    Unfortunately this is how the multiple entries and table widgets like Table Input, Matrix widget, configurable list widget work.

    The data value will be all contained on single cell only on spreadsheets.

    If you need the data on separate cell every time, you will have to assign a separate field for the data in the form.

    I hope this help. Let us know if you need further assistance.