Adding link to a template

[Oleksandra_Bohomolov (Oleksandra Bohomolova)]

During the creation of a request, the user can upload files using the column with the file type. We also have a template for the PDF document (workflow rule), which displays all the information about the request. We want the names of user files in this pdf to be clickable, and when you click on them, a new window with this file opens. We have the following formula for file link, but it doesn’t work (we get error # 404). What could be wrong?

How it should look like:

What we get clicking the file name:

UPD:
Seems that Appsheet generates a link with two extra digits. without them, the file opens. Perhaps the slash sign ‘/’ from the file path is not encoded correctly. How to fix it?

[MultiTech_Visions]

Dont URL encode a URL

You only really need to include that if you’ve got special characters. If everything is already a string that you’re concatenating together - with no / . { } () etc. - then there’s nothing to encode.

So inside your manually constructed file link - you could remove all the ENCODEURL() parts I think.

• Dashes are acceptable in a URL, so are underscores; and the URL is already a URL.

[Oleksandra_Bohomolov (Oleksandra Bohomolova)]

But the files are store in the folder called “MRS_Attachment_Files”, so the fileName part in url looks like MRS_Attachment_Files/filename. Please correct me if I’m wrong.

[MultiTech_Visions]

@Oleksandra_Bohomolov

MRS_Attachment_Files/filename

You are correct in this - so you would need to ENCODEURL() that forward slash.