Help with File Attachment URL

Question

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

MarkShnierYou · Answer

This syntax should workURLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e99/v0Then replace the 99 with the field ID of the file attachment field.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community