2

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

Pictures say more than words...

 

Steven

21replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Thank you!

    Like
  • 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 + ">")

    Like 1
  • Thank you Dean ! 

    Like
  • 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.

    Like
  • 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?

    Like
  • Not that i'm aware of.

    Like
  • 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!

     

    Screen Shot 2020-08-16 at 5.53.52 PM

    Like
  • @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! :-)

     

    Screen Shot 2020-08-17 at 1.05.53 PM

    Like
  • 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

    Like
  • Hi Antonio,

    See screenshot below :

     

    I hope I was allowed to share the image....

     

    Steven

    Like
  • 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.

    Like
  • 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 ¡¡

     

    Like
  • '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.

    Like
  • (The ":" is missing)

    Like
  • 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

    Like
  • The fieldname is missing the ":" 

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

    Like
    • MG
    • Ppc
    • titanium_fish
    • 1 yr ago
    • Reported - view

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

    Like
    • Javier Gómez
    • Consultant and developer
    • Javier
    • 8 mths ago
    • Reported - view

    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.

    Like 1
    • Javier Gómez
    • Consultant and developer
    • Javier
    • 8 mths ago
    • Reported - view

    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

    Like
    • Javier Gómez
    • Consultant and developer
    • Javier
    • 8 mths ago
    • Reported - view

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

    Like
Like2 Follow
  • 2 Likes
  • 8 mths agoLast active
  • 21Replies
  • 3420Views
  • 2 Following