Hello. I would use the path with the least changes and effort, bill.comm-->quickbooks-->quickbase, you could send data from bill.com to identify the job, quickbooks has some note fields that can be used to "make this travel" fact.
Thank you
Marcelo Benavides Torres
Marcelo and I have been discussing this issue away from the forum and I have already expressed to him that this is not the optimal outcome for our users since this will not create a tangible relationship in quickbase between the invoice and the job record and will only enter a text value into the field. I am looking for a way to create a tangible relationship between records through pipelines, if it is possible.
If you can post some data from both tables without sensitive details , it might be possible to figure
For a tangible relationship to happen, QuickBase is irrelevant , it needs to be present before data comes into QuickBase via pipeline or otherwise , it could be artificial key or a combination of few records which makes business sense.
