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 ...
Forum Discussion
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
------------------------------
That worked!!! You're my hero, Evan! I appreciate your help so much!
------------------------------
Annie Ryden
------------------------------
------------------------------
Annie Ryden
------------------------------
- Happy I could help Annie and have a great day!
------------------------------
Evan Martinez
------------------------------