Forum Discussion

AnnieRyden's avatar
AnnieRyden
Qrew Member
3 years ago

Report with URL's for Each Record ID#

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

3 Replies

  • 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() & "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's avatar
      AnnieRyden
      Qrew Member
      That worked!!! You're my hero, Evan! I appreciate your help so much!

      ------------------------------
      Annie Ryden
      ------------------------------
      • EvanMartinez's avatar
        EvanMartinez
        Qrew Elite
        Happy I could help Annie and have a great day!

        ------------------------------
        Evan Martinez
        ------------------------------