Displaying external Dropbox images. The solution if your database contain many pictures to keep the database size small.

Thank you!

To center photo:

let k := substring('Shared URL', 0, length('Shared URL') - 1) + "1";
let c := "'display: block; margin-left: auto; margin-right: auto;'";
html("<img width=auto height=99% align=middle style=" + c + " src=" + k + ">")

Now I am trying to figure out the smallest number of clicks required to get a dropbox shared file URL. On Windows it seems like the fastest route is to first open the dropbox folder using Windows Explorer and then right-click a file.

Or is there a way to bring up a open file dialog from within Ninox, then right-click the file and copy its shared URL?

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

Hi, thanks, I haven't realized you already answer, but I'm getting this error, and i don't know if it's me or what, but can't get this to work, and the display image it's fine btw that's me ¡¡

missign where ? and yes I know about de textfield i even change the name to the example you give me to see if that was the problem but no

OMG i see it now, Works great , thank a lot ¡¡¡

can we do this with PDF  as well or only Images?

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.

Interestingly, the images DO APPEAR correctly using Ninox app on my iPad, but not working on the app version for Mac. So, clearly a bug. Hope the Ninox team reads these forums

And now its working! (can't understand anything)

I also want to know how to solve this problem, and I also want to know if I can let NINOX automatically upload it to the cloud space after taking pictures, and then delete the files originally placed in NINOX. How do you deal with databases with many pictures?