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

Is there a way to save the actual URL link of the file in the Google Spreadsheet?
The back end support people will be interfacing the Sheet and they need to be able to just click on the link in the sheet to open the file.

1 Like