
Displaying external Dropbox images. The solution if your database contain many pictures to keep the database size small.
Pictures say more than words...
Steven
-
Fantastic, thanks for the inspiration! It's been on my "list of things to do later" to find a way to link to external pics.
In my case, I'll be linking to my images on various public websites so I created a separate field where I paste the image address. (And I guess since I'm not using Dropbox, I don't have to use the "let k" thing...)
This is going to save me so much time and reduce my database size. Thanks again!
-
@RoSoft_Steven Rooryck @Choices Software - Dean Westover: So... I just found a potential downside solution to this, at least for my use. Maybe you can help?
This solution works great when I'm in a form, but the images don't show up in the table views.
Am I doing something wrong, or is this a limitation? If the latter, do you have other tricks up your sleeves that could allow me to see images in the table views, short of adding pics to the database?
Thank you in advance! :-)
-
Hi, it works but, i tried with a link from google drive and fail, this is the example link https://drive.google.com/file/d/12eIeQ8cPwWZS2XK3gjiqs1dAQXfG-IhX/view?usp=sharing
-
formula : (to copy/paste)
let strt := index('Shared URL Google One drive :', "d/") + 2;
let nd := index('Shared URL Google One drive :', "/view");
let k := "https://drive.google.com/uc?export=view&id=" + substring('Shared URL Google One drive :', strt, nd);
let c := "'display: block; margin-left: auto; margin-right: auto;'";
html("<img width=auto height=99% align=middle style=" + c + " src=" + k + ">")Steven.
-
Hi there.
I've tried the above formula... and it worked once! but now, the image is not displayed anymore! Any ideas/clues? My formula is this:
let strt := index(Filename, "d/") + 2; let nd := index(Filename, "/view"); let k := "https://drive.google.com/uc?export=view&id=" + substring(Filename, strt, nd); let c := "'display: block; margin-left: auto; margin-right: auto;'"; if Filename then html("<img width=auto height=99% align=middle style=" + c + " src=" + k + ">") else html("") end
Where "Filename" is the field where I store the image url.