Displaying external Dropbox images. The solution if your database contain many pictures to keep the database size small.
Pictures say more than words...
Steven
24 replies
-
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 + ">")
-
Thank you Dean !
-
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?
-
Not that i'm aware of.
-
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 Antonio,
See screenshot below :
I hope I was allowed to share the image....
Steven
-
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, 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 ¡¡
-
'Shared URL Google One drive :'
is the name of the textfield containing your URL. You should change it to the name of your text-field's name. -
(The ":" is missing)
-
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
-
The fieldname is missing the ":"
-
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)
-
Hi all,
I have tried using the above script in a formula but without any success when using Google drive, is there any way to adapt the script to work with links to Dropbox?
The script Westy provided works perfectly with Dropbox links but not with Google Drive for me unfortunately.
I do have an issue where the files display in form view but neither Cards or List views using this script. -
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?
Content aside
-
3
Likes
- 1 mth agoLast active
- 24Replies
- 4103Views
-
4
Following