How to call the PDF Link that i created

Hi Good Day, I do have a problem with the formula. I’ve created a Automation that when I click Yes in Create PDF it with provide the link of the created PDF. But when i click it the link provided “404 - File or directory not found.”


My formula for the Actions is:

Data: set the values of some columns in this row.

CONCATENATE(“https://www.appsheet.com/template/gettablefileurl?appName=”, ENCODEURL(“MonthlyPerformanceReportDatabase-1750141”),"&tableName=", ENCODEURL(“Monthly Performance Report Database”), “&fileName=”, ENCODEURL(CONCATENATE("/Files/"[MONTHS],"-",[Discussion Planner Key],".pdf")))

When i check on the folder where the PDF is saved and created it’s there but when i click the link in g sheet. The error is “404 - File or directory not found.”

Thanks community if someone will help me with this. Thank you

Hi @John_Paul_Armisa

What you want to achieve is pretty similar to what is described in this post:

You have to keep in mind that the link you want to provide is a relative path from your default folder path.
With Automation, I reproduced it this way (other similar options exist, this is ONE option).

The purpose here is to create a quote, store it in a team drive and giving access to user then.
To do so, I make an action, visible to users, to write “filename” in quoteFile column.
Then, the automation fires to create a file, because it is based on a change made on this column.

  1. create Action “write_TimeStamp_QuoteName”

With expression for the column QuoteFile (type : File):
"\Files\" &TEXT(NOW(),"YYYY_MM_DD - hh_MM_ss") & "_Quote_" & [QuoteReference]& ".pdf"

([QuoteReference] is a value from the row)

  1. Then, create a bot:

  2. here is the settings for event:
    image

Expression : [_THISROW_BEFORE].[QuoteFile]<>[_THISROW_AFTER].[QuoteFile]

  1. Here is the setting for Process:
    image

  2. And the setting for the related task:

Expression :

SUBSTITUTE(
	SUBSTITUTE([QuoteFile],
     	"\Files\",""
     ),
     ".pdf","")

I think what you are specifically looking for is this last expression.

  1. Here is the result:
    a) in the app:
    image

b) in the source sheet:

c) in the team drive folder:
image

Can you let us know if that works for you, and tick that post as a solution if that answer your question ?

Cheers !

EDIT : minor changes

1 Like