Button that opens PDF or Embed PDF?
I am trying to have a button from a button bar on the Dashboard open up a PDF. What is the best way to achieve this?
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew Legendnp,
Assuming that you have the PDF as a file attachment in any table in your app, make a formula URL field on that table with the following formula
URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0"
Change the 99 to the field ID holding your file attachment. Do not give the field a label and that will expose the code when you view the record. Then just copy and paste that URL as the URL for the Dashboard button. You will need to make sure that either all users in the app have access to that table to view all records, or you may choose to flag that file attachment field in field properties to be viewable by all users without logging in.
Thanks Mike, I tried to do this. The attachement if Field ID 6 in my Documents Table. So I changed the 99 to a 6. I also had to select something for the Record ID, so I thought doc name would work but, the link is not working.
URLRoot() & "up/" & Dbid() & "/a/r" & [Document Name] & "/e6/v0"
- MarkShnier__You
Well, you should copy and paste the formula exactly except to change the 99 to 6.
If you changed field ID 3, which is normally [Record ID#] to another name then you need to put in the field name which holds the record ID number
