Forum Discussion
36 Replies
Sort By
- _anomDiebolt_Qrew EliteUse the HTML5 <video> tag to embed a video.
- PatPatQrew TraineeI've been playing around with the <video> tag and can't seem to get it to work. I was under the impression it was because the <video> tag was not supported. Do you know for certain that this tag is supported? Here's what the formula looks like:
"<video src=https://intersystems.quickbase.com/up/"; & Dbid () & "/a/r" &
[Record ID#] & "/e9/v0\" width=\"170\" height=\"85\" controls>\n<p>If you are reading this, it is because your browser does not support the HTML5 video element.</p>\n</video>" - ArchiveUserQrew CaptainMark, I'm trying to get the thumbnail photo to enlarge as you mentioned will happen if the first 2 lines are uncommented. So this is what I have:
"https://www.quickbase.com/up/"; & Dbid () & "/a/r" &
[Record ID#] & "/e27/v0\"height=\"800\" width=\"1000\" target=_blank/> " &
"<img src = https://gesco.quickbase.com/up/"; & Dbid () & "/a/r" &
[Record ID#] & "/e27/v0\" height=\"200\" width=\"250\" target=_blank />"
When displayed though it shows "https://www.quickbase.com/up/biajkmurz/a/r4/e27/v0"height="800"; width="1000" target=_blank/>" to the left of the thumbnail photo.
It appears that the top lines are missing an "<" but I tried putting it at the beginning and it still didn't work.
Can you help?
Thanks!
Ryan - QuickBaseCoachDQrew Captainyes, it look like my posted answer was missing the <a href part at the beginning.
Here is one that works. I see that when I pasted it in, this forum lost some of my formula. Note that you will need to remove the extra spaces in the h r e f and the and w w w
If you don't want a new window, then you leave out the target = blank.
"<a h r e f=\"h t t ps://mycompany.quickbase.com/up/" & Dbid () & "/a/r" &
[Record ID#] & "/e6/v0\"height=\"1000\" width=\"1250\" target=_blank/> " &
"<img src=\"h t t p s://mycompany.quickbase.com/up/" & Dbid () & "/a/r" &
[Record ID#] & "/e6/v0\" height=\"300\" width=\"375\" target=_blank />"
Also since I made that formula I now realize that you should just specify a width or a height (but not both), and it will automatically scale the missing one. If you specify both, then it forces an aspect ratio distort the original photo.- mvelicumvelicuQrew TraineeHi ,
I use your formulas for creating a field,thank you very much , It shows well in a report, but when I click on the image, the current firefox tab goes from report display to the current record display , and then it opens another tab where it shows the picture.
What I don't like is the current tab behaviour . I don't want to see the view of the current record, I want to stay on the report page.
Do you know how I can accomplish this ?
Thanks,
Mihai - QuickBaseCoachDQrew CaptainThe solution is to change the report to not allow to view the record. (uncheck the view box).
But then you ask "but how do they view thew record?"
Make a view button as a URL formula and make it be the first column on the report. Label the button is just V to keep it short.
urlroot() & "db/" & dbid() & "?a=dr&rid=" & [record ID#] - mvelicumvelicuQrew TraineeThanks, it worked
best regards,
Mihai
- JohnParhamQrew CadetI can't find where I get the attachment ID
- JohnParhamQrew Cadetnevermind
- SatyenVoraQrew Member/v0\ speaks to the version number. if you have something that may have iterations you will want to consider how best to approach it. I removed it from the coding, but it's probably not the best option. Is there a way to have it check the most recent version, like /v%\ or similar syntax?
- MCFNeilQrew Captainv0 is the most recent version. Odd I know.
v1 is the most recently replaced.
v3 would be the oldest available version if you allow up to 3 revisions, etc - SatyenVoraQrew MemberWhen I had it as v0 the image preview did not update when it was replaced with a new image (not even v1, but deleted and replaced completely).
- QuickBaseCoachDQrew CaptainIt's an issue with cacheing in your browser settings. I don't claim to b an expert and it will depend on the Browser you are using, but there will be a setting in their somewhere as to if the browser will chache content. They do that to speed up rendering on the screen, but the result is that it may render old data.
If you are stuck, let me know which browser you are using and I will have a look at my similar settings.