JordanMcCaskill
3 years agoQrew Member
Help with File Attachment URL
I have been looking up how to generate the file attachment URL for a while now and the formula that continues to pop up is this one:
URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/eg/v0/" & [Image]
The problem that I have been having is that the [Record ID#] is always passing a number into the url such as:
/up/dbid/a/r12/eg/v0/image.jpg
The correct URL for the image (based on inspecting the HTML) appears to always contain a letter in that position and there is not a direct mapping to numbers as the letters are not sequential:
/up/dbid/g/rn/eg/v0/image.jpg
The value following the dbid is also different but that appears to be a separate issue atm. Any help I could get with creating this URL for the image would be helpful.
------------------------------
Jordan McCaskill
------------------------------
URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/eg/v0/" & [Image]
The problem that I have been having is that the [Record ID#] is always passing a number into the url such as:
/up/dbid/a/r12/eg/v0/image.jpg
The correct URL for the image (based on inspecting the HTML) appears to always contain a letter in that position and there is not a direct mapping to numbers as the letters are not sequential:
/up/dbid/g/rn/eg/v0/image.jpg
The value following the dbid is also different but that appears to be a separate issue atm. Any help I could get with creating this URL for the image would be helpful.
------------------------------
Jordan McCaskill
------------------------------