Forum Discussion

GrahamDavies's avatar
GrahamDavies
Qrew Member
5 years ago

Link to a QB record using a unique field not the Record ID?

Is it possible to create a link to a QB record using a field other than the Record ID? I am trying to connect a different system to QB by using a unique email address for a record in QB. Ideally so...
APIs and custom code
GrahamDavies's avatar
GrahamDavies
Qrew Member
5 years ago
Thanks Austin

Unfortunately I can't change the key to be the email. I have lots of records with no email.

The other system will need to be kept in sync with QB so the email should be available and unique.

I had hoped that because you can import on Email (as it is unique) that I could also link to a record with it.

Any other options or do I need to resort to a full integration with the other system to pull in the Record ID and then use that in the link?

Thanks

------------------------------
Graham Davies
------------------------------
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
Unfortunately, you'll probably have to at least use a connector service to search by the email and update your system with the Record ID#. Once you have that, you're right, it's just a matter of adding it to the end of the URL.

If you can accept a webhook, you could always setup a webhook to push the Record ID# anytime an email address is added or edited.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------