Forum Discussion
EvanMartinez
4 years agoQuickbase Staff
Hi Annie,
One way to create a field that has this data is to use a formula URL field and drop a formula like the one below into the field settings:
------------------------------
Evan Martinez
------------------------------
One way to create a field that has this data is to use a formula URL field and drop a formula like the one below into the field settings:
URLRoot() & "db/" & Dbid() & "?a=dr&key="&[Record ID#]"
This formula will pull the right realm and app id for the record dynamically and then add in the record to display for you. Clicking it will then take you right to the record it comes from. The only thing you might need to change is where the formula says "&[Record ID#]"
specifically if your key field for that table was set to something other than the default Record ID. You would just swap it out for the name of your actual key field. Then when it shows up on your report it should be a URL with all the information you would need and you can add it to your export.------------------------------
Evan Martinez
------------------------------
AnnieRyden
4 years agoQrew Member
That worked!!! You're my hero, Evan! I appreciate your help so much!
------------------------------
Annie Ryden
------------------------------
------------------------------
Annie Ryden
------------------------------
- EvanMartinez4 years agoQuickbase StaffHappy I could help Annie and have a great day!
------------------------------
Evan Martinez
------------------------------