How do I get to shrink data values to two columns instead of an array

  • chrispieper
    Asked on November 10, 2017 at 3:22 PM

    This form here.

    https://www.jotform.com/build/71876589794179

    Has a selection of values(Billing codes) the tech can select per job they do. But it puts each Quantity in its own column (example XB3 option - when the value is inputted, it is put under its own column. Is there a way that we could have an input per row and not comma delimited without having to resubmit the form over and over as this would mean they would need to for one Job, if there are multiple billing codes, refill out their details and the job codes again to get to the billing code section.

    I have attached what the outcome would need to be like. So in excel terms the total quantity's of each product needs to be transposed vertically into 2 columns. Billing Code and Quantity.


    Hope this is enough information, we need it to match the rows of our invoices, and the invoices have all the billing codes and quantities under 2 columns and not 10+

     


    Jotform Thread 1296205 Screenshot
  • jonathan
    Replied on November 10, 2017 at 3:55 PM

    ...But it puts each Quantity in its own column 

    The quantity fields were being added on each own column because each field were considered separate field.

    Ex:

    1510347102zzz 2017 11 11 04 Screenshot 10


    If you need the Qty data to be contained on a single field (and column) only, you can try using the Matrix field (Input Table) for the Qty fields instead.

    1510347256zzz 2017 11 11 04 Screenshot 21

    Add each field as Row in the input table and 1 column for Qty input. 

    Let us know if this will not work.


  • chrispieper
    Replied on November 10, 2017 at 5:17 PM

    I did try something like this, and for each row option it just created a column to match. Was there an additional setting in the background for the input box that I needed to adjust to make all the values be stored in one column? seems it wonts to transpose it so that it only makes one row value per submission, where I need a row per billing code

    here is what the spreadsheet looks like after adding the input table. again its the same outcome but done differently. Need it per row like the original question 1510352627ex Screenshot 10

  • Marvih
    Replied on November 10, 2017 at 7:28 PM

    I don't think it is possible to exactly integrate google spreadsheet exactly what you need after each submission.

    Adding some FORMULA might be possible or using Zapier integration

    How do I get to shrink data values to two columns instead of an array Image 10