Forum Discussion
JackFretwell
7 years agoQrew Assistant Captain
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.
JackFretwell
7 years agoQrew Assistant Captain
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.
<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.