-
chrispieperAsked 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+
-
jonathanReplied 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:
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.
Add each field as Row in the input table and 1 column for Qty input.
Let us know if this will not work.
-
chrispieperReplied 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
-
MarvihReplied 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