Right, so yes a Report Link field, unfortunately does cause the two apps to be "Dependant" and behave like one large app, which will negatively affect performance.
You can make a link to display a record if you know either the Record ID# or the Key field. But other than that, no you can only display a report.
URLRoot() & "db/" & [_DBID_TABLE_DBID]& "?a=dr
&key=" & URLEncode([My key field field value])
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com------------------------------
Original Message:
Sent: 07-28-2020 09:16
From: Hannah Wright
Subject: Formula URL - View Record Without Record ID#
We have recently discovered that creating a report link to view a record on another app will create a relationship between those two apps. We have a complex system so we would like to avoid app to app relationships. It is for this reason we are moving toward iframes for this type of functionality.
With this in mind, is there any way to create a link to view a specific record (not a report) without having that records Record ID#? In other words, can you use a field other than the Record ID# in the url to view a record?
I appreciate any feedback!
------------------------------
Hannah Wright
------------------------------