Files on google drive

Hi Mel,

Please tak a look at this recent topic: https://forum.ninox.com/t/m1hv4zm/import-an-image-from-web

This was invented by francesco.stefanello and enhanced by Sean

I have partly done what you want, regarding Ninox storage space. For the next part regarding auto copy from Ninox to GD , I have no clue.

I'm using Onedrive. With Google drive it includes one extra step. Sorry if the exact wording in the steps are not 100%, I'm using Norwegian language in GD. So I hope the code works I you want to try.

1: In a TAB, create 6 Text fields named IURL1, IURL2 etc. to IURL6

2: 1: In the same TAB, create 6 Image fields named eg. Image1, Image2 etc.

3: Insert a FX script in the same TAB with ths code:

html("
<script>
    var object = document.querySelectorAll('.component.editor.editor-file');
    object[0].children[2].style.backgroundImage = 'url(" +
    IURL1 +
    ")';
    object[1].children[2].style.backgroundImage = 'url(" +
    IURL2 +
    ")';
    object[2].children[2].style.backgroundImage = 'url(" +
    IURL3 +
    ")';
    object[3].children[2].style.backgroundImage = 'url(" +
    IURL4 +
    ")';
    object[4].children[2].style.backgroundImage = 'url(" +
    IURL5 +
    ")';
    object[5].children[2].style.backgroundImage = 'url(" +
    IURL6 +
    ")';
   </script>
")

4: Go to Google Drive, selct your image, click the "Share" icon and copy link (first select sharing options You/General.)

5: Go to this link: https://www.labnol.org/embed/google/drive/

Copy your link to "Google Drive Link + Generate Embed code. Copy the "!Deirct Image Link"

6: Paste this link into your IURL1 Text field, etc.

Then the image should hopefully show in your Image1 field.

7: OPTIONAL: Insert a URL field under each Image field to allow clich and open image in Fullscreen from Google Drive. Copy the link from step 4 in here.

My example:

I came up with this solution. It might be done easyer, but it works.

In a TAB, create the desired number of Text fields named e.g.  GoogleCode1, GoogleCode2 etc.

Copy/Paste the links from OD (as Jascques described above) into GoogleCode1 , GoogleCode2  etc. 

Use Formula fields for how many embedded images you want, using this code in the FX's.

if GoogleCode1 > "" then
    let gc := GoogleCode1;
    let i1 := index(gc, "/d/");
    let i2 := index(gc, "/view");
    let fid := substring(gc, i1 + 3, i2);
    let iframe := html("<iframe src='https://drive.google.com/file/d/" + fid +
        "/preview' width='480' height='360'></iframe>");
    iframe
end

The script extracts the the Filde_Id, and replace some doubble "" quotes with singe ' quotes.

In the other FX's adjust  "if GoogleCode1 > "" then     and let gc := GoogleCode1;  to GoogleCode2 etc.

I found that width=480 and hight= 360  fits best for me, leaving space for three Images pr. row in Ninox when adjusted to fit. Using lower reolutions may result in "zoom" function gone. It even works with videos from OD, with audio and all.

I found the process a little bit easyer when I "Shared" the whole GD folder in witch I have the desired photos. Then the 'sharing permissions ' choice is not neccesary for each individual photos.  Just 'Copy Link'

I use Windows, not Mac. To simlify further I just installed "Google Drive" for Windows, giving me "Google Drive (G)" as a folder in "This PC". When set up to sync with GD on the web, it is just drag and drop images with Windows Explorer from you Computer into the desired OD Folder. 

tnx, the extractx modification worked when editing my script like below.

I used Regex a bit myself som years ago, in my IT Telecom and A/V job. Creating dial rules for Cisco Call Manager and VCS (Videoconferencing Gatekeeper). But I'm too lazy to deep-dive into that simple, but yet complicated syntax right now, if I dont have to 

Yes, it seems like most files supported by the browser is previewing OK, like PDF, mp3, , Word, Excel etc.

if GoogleCode1 > "" then
    let gc := GoogleCode1;
    var GoogleCode := "https://docs.google.com/document/d/THE-FILE-ID/edit?usp=sharing";
    var fid := extractx(gc, "(.*/d/)([^/]*)", "$2");
    let iframe := html("<iframe src='https://drive.google.com/file/d/" + fid +
        "/preview' width='480' height='360'></iframe>");
    iframe
end