Report with URL's for Each Record ID#

Question

Hello - Is it possible to include URL's of each Record ID when exporting a report? I want to implement a Barcode System. I'm thinking that if I can export a report of all record ID's with their URL's then I could create labels linking to each Record ID URL on a barcode.

Any insight would be very much appreciated. Thanks so much.
Annie

------------------------------
Annie Ryden
------------------------------

evanmartinez · Answer

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:URLRoot() &amp; "db/" &amp; Dbid() &amp; "?a=dr&amp;key="&amp;[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 "&amp;[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 · Answer

That worked!!! You're my hero, Evan! I appreciate your help so much!------------------------------Annie Ryden------------------------------

evanmartinez · Answer

Happy I could help Annie and have a great day!------------------------------Evan Martinez------------------------------

Forum Discussion

Report with URL's for Each Record ID#

3 Replies