Image preview formula not showing new file
I have a formula field that takes multiple image attachments and displays them on a form. formula is: List(" ", If([Image 18]="", "", "<img width=\"240\" src=\"" & URLRoot() & "up/" & Dbid () &...
Forum Discussion
I had this problem myself.
I think that they design Quick Base to cache the file images if the record is viewed in the Browser within a certain number of minutes. I don�t recall what that number is but it might be about 15 minutes. So in practical terms it may not be a big issue since uploaded images tend to be stable once uploaded and the system will catch up to the change in about 15 minutes anyways. So it may be more of a fear during the testing process that the system is not refreshing to the current file, but in practical terms it will be ok for all users in 15 minutes after the file change, and of course immediate if the user never viewed the image the first time.
But a client had a problem with that and I did this
var text URL = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e15/v0/ target=_blank" & "DummydateTime=" & ToText(Now()) & URLEncode(ToText([IP Image Location])); // that last part is to defeat browser cacheing
var text words = " & )
The effect was to cause the URL to change when the current changed or the name of the uploaded file changed. Those extra parameters are not valid parameter names and are ignored in practice, but it does cause the URL to be different each minute and hence default coaching. But there will be a slight performance hit for the app when you defat cacheing.
I think that they design Quick Base to cache the file images if the record is viewed in the Browser within a certain number of minutes. I don�t recall what that number is but it might be about 15 minutes. So in practical terms it may not be a big issue since uploaded images tend to be stable once uploaded and the system will catch up to the change in about 15 minutes anyways. So it may be more of a fear during the testing process that the system is not refreshing to the current file, but in practical terms it will be ok for all users in 15 minutes after the file change, and of course immediate if the user never viewed the image the first time.
But a client had a problem with that and I did this
var text URL = URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e15/v0/ target=_blank" & "DummydateTime=" & ToText(Now()) & URLEncode(ToText([IP Image Location])); // that last part is to defeat browser cacheing
var text words = "
The effect was to cause the URL to change when the current changed or the name of the uploaded file changed. Those extra parameters are not valid parameter names and are ignored in practice, but it does cause the URL to be different each minute and hence default coaching. But there will be a slight performance hit for the app when you defat cacheing.
Thank you for your solution, Mark. :)