Need either full jpg link in attachment field or help identifying the record and field IDs in the link

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

My file attachment link looks something like this:

https://consulting.quickbase.com/up/xxxxxx/g/rcfhr/ebk6/va/samplepic.jpg

I will be using these links in an html-based user page. I either need the field to display this entire link (not just the attachment name) or be able to refer to other fields e.g. https://consulting.quickbase.com/up/xxxxxx/g/r[recordID#]/e[fieldID]/va/samplepic.jpg

The problem with the latter is that I don't understand how the letters in the link are referring to my numeric field IDs. Is there some conversion that I need?

Photo of Taylor

Taylor

  • 52 Points

Posted 4 years ago

  • 0
  • 1
I'm not entirely sure I understand the question, but have you tried the format.

URLRoot() & "up/" & [_DBID of your table]  & "/a/r" & [Record ID#] &
"/e140/v0"

Where the field with the image is did 140 in this example.
Photo of Taylor

Taylor

  • 52 Points
Yes, thank you! That worked perfectly!