ContributionsMost RecentMost LikesSolutionsRe: Link to a QB record using a unique field not the Record ID?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 ------------------------------ 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 something very simple so that record could even ben linked from Excel without the RID: https://target_domain/db/target_dbid?a=dr&dfid=10&query={'30'.EX.'user%40domain'} Where field 30 is a Unique Email Address field. When I try API_GetRecordAsHTML it requires the Record ID (Missing "rid" parameter), which I don't have in the other system. I can use API_DoQuery with the query - but that returns XML not a link to a standard HTML form report. Thanks! ------------------------------ Graham Davies ------------------------------