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.”
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.
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.