Hello Community members,
I’m trying to view a workflow pdf in the app itself. I’ve gone through the communty posts and figured that there are 2 ways of doing it - one is to create a file name/file column in the table with open file action to it. Second is to create a column for url.
Despite trying both methods several times - im getting a 404 error for method #1 and bad request for method #2. Seeking help to rectify any errors that I might be committing. PFB the details.
Method 1: Followed the method prescribed in this community post
Created a file type column in the table -In the workflow that creates a pdf, setting the value of file column to : /data/PurchaseOrders/2nd_Apr_202100:50:51 @ 267583bf.pdf
data/PurchaseOrders - relative folder path of generated pdf doc.
2nd_Apr_202100:50:51 @ 267583bf - file name set in create doc task of workflow (used the expression suggested in the post and disabled timestamp)
Later, added an action (external action: to open a file) and set file to [file name]. However, i get a 404 error on clicking the action button
Method 2: Followed the method prescribed by Aleksi in this community post
Created a File URl type column in the table and used the below formula for setting the URl - CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=",“Omxxxxxxx-2559xxx-21-02-23-2”,"&tableName=","Purchase requisition”,"&fileName=",[File name]). [file name] - /data/PurchaseOrders/2nd_Apr_202100:50:51 @ 267583bf.pdf
also tried this formula for URL column -CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=",“Omxxxxxxx-2559xxx-21-02-23-2”,"&tableName=","Purchase requisition”,"&fileName=",encodeurl[File name])
For both URL formulas, I’m getting a “bad request” on clicking the URL in the app.
Would really appreciate if someone can point out the mistake. I have dedicated hours to rectify it myself but to no effect.
Thanks in advance!