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

Question

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
------------------------------

AustinK · Answer

https://help.quickbase.com/api-guide/getrecordashtml.html

As that says if your table uses something other than record id as the key field then you are free to use that. However, you must set your table to use the email as your key field for this to work in the way you are requesting. Since this is grabbing an entire record it must go by whatever your key field is.

Is it possible for you to change the key field of that table, or will that cause you other issues? Are you 100% sure there will never be another duplicate email? Hypothetically what happens in your company(or wherever you are getting the emails from) when a user leaves? Say John.Smith@company.com is the email, when John leaves and another John Smith is hired later on, do they recycle the email? Or create a brand new one with say JohnW.Smith@company.com where they insert a middle initial?

Sign up

Login to the community