Convert comma separated values to new child records

Good call, wouldn't work too well without the reference field values!

ok, im getting a better understanding of this.  I've never done a webhook such as this.  Is there any example you may have?

I�m just heading into a client site right now so I don�t have time to respond with an example.

But my advice includes the following.

Have a look at the Online documentation for the import from CSV API and it will give you an example of the syntax to use near the bottom of the documentation.

You will need to include a user token because everything in Quick Base including web hooks hast to run under some user IDs authority.

If your application requires application tokens, and that is set in the advance properties tab at the application level, then you will also need to provide to user token.

Thanks Mark.  I'll give it a go

It is always a bear to get your first webhook working.

I had some notes to myself of a Webhooks I did for a client

bxv4tx_bjix_8csgf2bk9smkxxxxxxxxxx3r

%RepeatOn%

"[Last Modified By]","Client Name","[old.Client Name]", "[Client Name]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Site Name","[old.Site Name]", "[Site Name]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Contact Name","[old.Contact Name]", "[Contact Name]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Contract Name","[old.Contract Name]", "[Contract Name]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Contract Type","[old.Contract Type]", "[Contract Type]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Industry","[old.Industry]", "[Industry]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Primary Project Manager","[old.Primary Project Manager]", "[Primary Project Manager]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Secondary Project Manager","[old.Secondary Project Manager]", "[Secondary Project Manager]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Large Contract Approver","[old.Large Contract Approver]", "[Large Contract Approver]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Estimator","[old.Estimator]", "[Estimator]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Projected Start Date","[old.Projected Start Date]", "[Projected Start Date]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Projected End Date","[old.Projected End Date]", "[Projected End Date]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Contact Status","[old.Contract Status]", "[Contract Status]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Lock Editing","[old.Lock editing]", "[Lock editing]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Award Date","[old.Award Date]", "[Award Date]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Customer PO","[old.Customer PO]", "[Customer PO]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Required Estimate Submission Date","[old.Required Estimate Submission Date]", "[Required Estimate Submission Date]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Revised Estimate Submission Date","[old.Revised Estimate Submission Date]", "[Revised Estimate Submission Date]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Driving Requirements","[old.Driving Requirements]", "[Driving Requirements]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","One Way Miles to Site","[old.One Way Miles to Site]", "[One Way Miles to Site]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","General Contract Notes","[old.General Contract Notes]", "[General Contract Notes]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Specific Location(s) of Work at Client Site","[old.Specific Location(s) of Work at Client Site]", "[Specific Location(s) of Work at Client Site]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Work Being Performed","[old.Work Being Performed]", "[Work Being Performed]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Purpose of Work being Performed","[old.Purpose of Work being Performed]", "[Purpose of Work being Performed]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Explanation for change to Required Submission Date","[old.Explanation for change to Required Submission Date]", "[Explanation for change to Required Submission Date]", "CO","[Record ID#]","[Record ID#]"

"[Last Modified By]","Specific Location(s) of Work at Client Site","[old.Specific Location(s) of Work at Client Site]", "[Specific Location(s) of Work at Client Site]", "CO","[Record ID#]","[Record ID#]"

%RepeatOff%

6.7.8.9.10.11.14

As Mark mentioned previously, you'll need to update the formula I provided with the record ID# of the parent record, so the created records will be linked back properly. That would look like this:

List("\n",
If(Trim(Part([my comma separated field],1,","))<>"",
[Record ID#] & "," & Trim(Part([my comma separated field],1,",")) & "," & tonumber(Trim(Part([my commas separated numerical field],1,",")))
),
If(Trim(Part([my comma separated field],2,","))<>"",
[Record ID#] & "," & Trim(Part([my comma separated field],2,",")) & "," & tonumber(Trim(Part([my commas separated numerical field],2,",")))
),
If(Trim(Part([my comma separated field],3,","))<>"",
[Record ID#] & "," & Trim(Part([my comma separated field],3,",")) & "," & tonumber(Trim(Part([my commas separated numerical field],3,",")))
)
) // end list

This should give output similar to this, where the Job Card in question has a RID# of 500:

500,Screws,2
500,Plugs,3
500,Nuts,1

The webhook would look something like this--your "clist" values will depend on the field IDs in your child table:

<qdbapi>
<usertoken>USERTOKENHERE</usertoken>
<clist>6.10.15</clist>
<records_csv>
<![CDATA[
%RepeatOn%
[THE BIG LIST FORMULA FIELD]
%RepeatOff%
]]>
</records_csv>
</qdbapi>

In this example above, these are the field mappings in the child table:

Related Job Card: 6
Item:             10
Quantity:         15

Hope this makes sense.

Thanks this does.  I'll give it a crack...  You guys have been a great help thank you

Quick FYI that Usertokens supersede Apptokens. You don't need an Apptoken if Usertoken is passed.

Hi Dan.  So i go the formula and output to work perfectly, but the webhook doesnt seem to be working.  I have tried everything, but no luck.

Am i missing something?

You need to use the correct API.
API_ImportFromCSV

https://help.quickbase.com/api-guide/...