Is # invalid in image links?

[Austin]

Is # a reserved character in appsheet image columns? I have them in file names on my drive and if I remove the # they work and with it they don’t even if I am able to copy the cell and paste it into my file explorer(with the full path in front) and open the image.

[Steve · Accepted solution]

The hash (#) has a special meaning in URLs. Best to avoid the character, but if you must use it, wrap the filename with ENCODEURL() in the expression used to construct URLs.

See also:

help.appsheet.com

ENCODEURL()

Text encoded for use in URL

en.wikipedia.org

Fragment identifier

In computer hypertext, a fragment identifier is a string of characters that refers to a resource that is subordinate to another, primary resource. The primary resource is identified by a Uniform Resource Identifier (URI), and the fragment identifier points to the subordinate resource. The fragment identifier introduced by a hash mark # is the optional last part of a URL for a document. It is typically used to identify a portion of that document. The generic syntax is specified in RFC 3986. The...

[Austin]

We’re using Zapier to grab attachments and put them in google drive so should be able to remove it before we get the file to convert to images. Thanks,