Convert comma separated values to new child records
So i have a Table for Job cards and a second child table for parts used. These 2 tables are connected with a Line items table:
Job Card --<Line Items >--Parts
I have a third party app that automatically pushes information into the Job card table when employees have completed a job card on site.
The problem I am having is that the line items get posted into quick base separated by commas and the number of units in a different field also separated by commas.
this is how it comes into quickbase:
Field 1[Item] : Screws,Plugs,Nuts,Pipe
Field 2[Quantity] : 2,3,1,1
so I want to create 4 line item records onto the Job card that shows
a. Screws x 2
b. Plugs x 3
c. Nuts x 1
d. Pipe x 1
Is there any way I can take the 2 bits of information and create a child record to bring line items into the job card?
Job Card --<Line Items >--Parts
I have a third party app that automatically pushes information into the Job card table when employees have completed a job card on site.
The problem I am having is that the line items get posted into quick base separated by commas and the number of units in a different field also separated by commas.
this is how it comes into quickbase:
Field 1[Item] : Screws,Plugs,Nuts,Pipe
Field 2[Quantity] : 2,3,1,1
so I want to create 4 line item records onto the Job card that shows
a. Screws x 2
b. Plugs x 3
c. Nuts x 1
d. Pipe x 1
Is there any way I can take the 2 bits of information and create a child record to bring line items into the job card?
