I have an app where the app creates a PDF report and stores that in Google Drive. You can click on an action button to access the report via this column:
[Open PDF] = /PDF Storage/<Report Folder>/010506b81.pdf
This works fine. As does the versioning, where the last digit of the file name is the version number so that each change creates a new PDF file.
What I want to be able to do is to use the above link to create a URL that the user can click on whilst in a form view. Some stuff i've already tried:
- Show the link as a Show/URL column - doesn't work as its not a true URL
- Show as a File type column - you can only add files in form view
- Automatically download the PDF upon save via an action - doesn't work as the App writes to [Open PDF] and then tries to download the file before the PDF is uploaded to Google Drive
Anyone solved something like this before?
Simon, 1minManager.com
LinkedIn
Twitter
