problems with images

[mauro forte]

Hello,

i tried to follow istruction but something is wrong

In this spreadsheet

https://docs.google.com/spreadsheets/d/1vnCXrnVJNFBPD-B1uhEn5Q1mrtpngduL8UexbmpmSmY/edit?gid=1414839482#gid=1414839482

i worked with this autocrat job

SCHEDE UNIFICATE lavorazioni Ma.V. eseguite

But this image <<LOGO>>

https://drive.google.com/file/d/1S7TLRrmnV9GRI_RSx8QYM1i3IfZ3rR0Y/view?usp=sharing

does not appares

Where am i wrong?

Thank you

[David Bain]

The URL you provided (`https://drive.google.com/file/d/1S7TLRrmnV9GRI_RSx8QYM1i3IfZ3rR0Y/view`) is a Google Drive link that allows you to view the file. However, to get the actual image URL that you can use to embed or share the image directly, you need to perform an additional step.

Here's how you can derive the actual image URL from the provided Google Drive link:

1. Copy the file ID from the URL. In your case, the file ID is `1S7TLRrmnV9GRI_RSx8QYM1i3IfZ3rR0Y`.

2. Use the following URL structure to create the direct image URL:

```

https://drive.google.com/uc?export=view&id=FILE_ID

```

Replace `FILE_ID` with the file ID you copied in step 1.

So, for your file, the direct image URL would be:

```

https://drive.google.com/uc?export=view&id=1S7TLRrmnV9GRI_RSx8QYM1i3IfZ3rR0Y

```

This URL should provide you with the actual image file that you can embed or share directly without going through the Google Drive viewer.

Please note that this method assumes the file you're trying to access is an image file supported by Google Drive. If the file is not an image or if you don't have permission to access it, this method may not work.

Doing this using a Google Sheet Formula

Here’s a summary of what you need in order to derive the actual image URL from a Google Drive link using a Google Sheets formula:

1. Open your Google Sheet.

2. In one column (let's say column A), paste or enter the Google Drive links for the images you want to extract the direct URLs for.

3. In the cell where you want the direct image URL to appear (let's say cell B1), enter the following formula:

```

=SUBSTITUTE(SUBSTITUTE(A1, "/view", "/uc?export=view&id="), "/d/", "")

```

Replace `A1` with the cell reference where your Google Drive link is located (e.g., A2, A3, etc.).

4. Press Enter to evaluate the formula.

5. The formula will perform the following steps:

   a. Take the Google Drive link from the specified cell (e.g., A1).

   b. Replace "/view" with "/uc?export=view&id=" to convert the link into a direct image URL format.

   c. Remove "/d/" from the link to extract the file ID.

   d. Return the resulting direct image URL in the current cell (B1).

6. If you have more Google Drive links in subsequent rows, you can copy the formula down to those rows, adjusting the cell references accordingly (e.g., B2 would reference A2, B3 would reference A3, and so on).

By following these steps, you can use a Google Sheets formula to automatically derive the direct image URLs from Google Drive links, making it easier to embed or share the images directly.

[Joseph Schmidt]

Did you look at the information in the FAQ?  You need to use a formula to change the link to one that requests a thumbnail.

Joe Schmidt

https://www.youtube.com/c/JoeSchmidt

 GLUA...@gmail.com

New Visions Blog Entry - Joe Schmidt

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/8b4f553f-9f5f-4605-8b23-02a48ad7e3b8n%40googlegroups.com.

[mauro forte]

thank you Now it's ok!!!!