How to get data in different cells

  • fepsch
    Asked on November 30, 2017 at 3: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?

    Thanks!







    Jotform Thread 1311513 Screenshot
  • fepsch
    Replied on November 30, 2017 at 3:29 PM

    This is how I get the data in the spreadsheet

    1512073721Data in spreadsheet Screenshot 10

  • jonathan
    Replied on November 30, 2017 at 6: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.