Forum Discussion

ShaneMiller1's avatar
ShaneMiller1
Qrew Cadet
3 years ago

Updated attachment (photo) not showing

Hello,
I currently have 2 fields:

Screenshot Link 1 - File attachment field
Screenshot 1 Preview - Rich Text formula field 
("<img src=\"" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e43/v0\" />")

My issue occurs after someone updates the [Screenshot Link 1] field. When this happens, the [Screenshot 1 Preview] continues to show the original photo and not the updated one. Any ideas or recommendations are happily welcomed. I assume it has to do with the cache, but haven't a clue how to fix it.
Thank you



------------------------------
Shane Miller
------------------------------
APIs and custom code
File attachments
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    3 years ago
    This syntax will defeat caching if the file name changes.

    "<img src=" & URLRoot() & "up/" & Dbid()
    & "/g/r" & QB32Encode([Record ID#])
    & "/e" & QB32Encode(12) // 12 is the fid of the file attachment field
    & "/va/" & URLEncode([Picture]) // my file field is called [picture]
    & " width=30>"

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • ShaneMiller1's avatar
      ShaneMiller1
      Qrew Cadet
      3 years ago
      That's really interesting! Thank you!

      ------------------------------
      Shane Miller
      ------------------------------