First Webhook, First Error. API_AddRecord
Trying my first web hook. This is the code so far: MyData %b33nat_ks4k_dkqpnf9dgmkmb2bhh-----% [items_total] "W - Won" "Bombouche" [products] [total_ex_tax] This is for when a record ...
Forum Discussion
Trying stuff out, I'm not familiar with all the components of Quickbase and do have a table from Big Commerce which needs loading.
But, I would like to know if you can put two fields from the source into one field in the destination, I've not seen any syntax for this so just going one for one at the moment.
But, I would like to know if you can put two fields from the source into one field in the destination, I've not seen any syntax for this so just going one for one at the moment.
- Build a formula in the source table to combine the two field values; and then push the value of the formula into the destination field.
- I've done that as
<field fid="10">[items_total][Company Name]</field>
But I don't know the correct coding for a space, e.g.
<field fid="10">[items_total] & " " & [Company Name]</field>
I'm sure this would fail and I'm tempted to try:-
<field fid="10">[items_total]%20[Company Name]</field>
But can't find anything regarding this scenario, anywhere. - No, build a formula in your table to combine the two field values together. I do not believe you can push two values from separate fields into a single field within a Webhook. I'm happy to be corrected. But creating a formula specifically for this purpose in the table would be the easiest solution.
- Grief, the answer to everything is add more fields, I've got close to 700 fields in this table already... I'll create a blank field and add that in as a spacer.
I have got this line which does work :
<field fid="11">[products][billing_company][billing_first_name][billing_last_name]</field>
Which has 4 fields into one via the webhook but no space between them. I was hoping for a bit of code to create a space but a blank field will do. - perhaps then build 1 formula field which is a forced space; and use that as a field to encode between the values repeatedly. You may then be able to use that same 'space' formula for other purposes.
[value 1][space][value2][space] - Exactly, this is what I've just done. I have blank fields to keep items in line when designing awkward screens. I've set the width to be 2 characters so hopefully it will read well.
