Видео

You can try uc?id instead of thumbnail

You can embed items in Looker directly. If you want to get it out of Drive, you can check out this post about how to do it: www.colby.edu/acits/2020/01/30/how-to-embed-a-video-from-google-drive/#:~:text=Click%20on%20the%20three%2Ddot%20icon%20and%20then%20choose%20%E2%80%9COpen,into%20your%20platform%20of%20choice.

Try this: =REGEXREPLACE(REPLACE(B6,26,7,"uc?id="),"/view.*","")

You could try replacing "thumbnail" with "uc?id="

@@smithviz Thank you so much, its really work ... 🙏🙏🙏

another brazilian guy congrats you for this excellent work. It helped me a lot to format google sheets files for datastudio! Thanks!

Please make sure you check to see if you are getting the green checkmark when you use the DS_USER_EMAIL function in your calculated field.

No need for the paid version. It works with some domains and not others. I'm not sure why. If you are unable to get it to work on the account you are using, try another gmail account and it might work.

Thanks for reaching out. I'd suggest checking the google drive folder where your images are stored. You'll need to make sure the folder and/or the images inside are viewable on the web. This should help. If you are using a Google Site to embed the report, you can set up permissions in at the Google Site level for access but make your report public. You can do this by making the URL unlisted. Reach out if that doesn't help.

Thankyou so much @@smithviz

Sorry about that. You might try this instead: =REGEXREPLACE(REPLACE(B6,26,7,"uc?id="),"/view.*","")

@@smithviz I mean when you copy links from google drive, it would return URLs but not ordered

If you are able to get this to work on your domain with the DS_USER function, you don't need to turn on Filter by Email at all. Just put the ACL fitler on the report level and you'll be good to go.

Great @@smithviz and one more thing do we need to give view access to all the stakeholder so that when they access this report that filter will applied?? OR it automatically give the access when mail id matches with our column value?

@@PrakharBharas Once it is set up, only people that have their email address in the database will be able to access the data. Please keep in mind, this is for emails associated with Google accounts. (It doesn't have to be a @gmail.com though).

@@smithviz Thank you so much for your help

@@smithviz What if the client email is not associated with Google Accounts. Then how can we share the reports with them? I tried searching the answer but didn't get any. Can you please help?

Wow. I'm so sorry to hear you had that issue. I haven't ran into that so far. I wonder if it was something with the domain? That's very strange indeed.

This is a great question. From my experience, there isn't a way to "lock" the size of an image. It is dynamic and it will adjust to the column width. I just end up adjusting the column width to get the image to the size I want.

Thanks for the comment. I'm glad you found it useful.

Thanks for asking. Here is a formula suggestion by another person. Try using this formula to make the resolution better: =left(replace(A5,26,7,"uc?id="),71)

The only place I have seen this is when the emails are not accurate. Filter by Email is case-sensitive. Make sure the email in the data is the same as the email being used in the domain. For example, some emails might be JSmith@email.com or Jsmith@email.com. If your data has emails with all lowercase (jsmith@email.com) it will not work.

@@smithviz Thanks, yes I found that it was written SR@.........

Some domains don't work for this. I'm not sure why and I have been trying to figure it out. Google Developers have yet to answer as well. A work around is to share it with a different Google account and test. If it works on another account and you get the green check mark, save the calculated field and then you will be able to use it on the original account even if you have the red mark.

The level of access would depend on the email addresses associated with that row. You could set up a system called an ACL (access control list). You can then use a checkbox system to decide which emails have access to certain groups (G1, G2, etc).

If your Drive images are restricted by a user email, you can also set this up in your Looker Studio project. You do have the option to Filter by Email, if the email address are also listed in your data source.

I only know how to do this with a script...

Hey there. Thanks for your comments and asking. I haven't had success with this yet, but someone else suggested to change the word thumbnail in the formula with uc. =left(replace(A5,26,7,"uc?id="),71). Give that a try and see if it helps.

@@smithviz I had to adjust the formula to 64 at the end so that it would get rid of /view?u

@@MadeforMath Awesome. Thanks for the update.

Most links seem to work for me, if it is an image. Google Drive links have been the exception. You can also create a calculated field using the HYPERLINK formula: HYPERLINK(URL, Link Label)

Change your formula to allow for open ranges. Instead of A2:A300, make it A2:A.

Welcome

You'll need a time stamp on each file. You might be able to extract that with a script

I've had issues with this myself. Sometimes it works and sometimes it doesn't. I'm sure there is a way to test it and set it up for sure, I just haven't gotten around to figuring it out.

currently face the same issue, image not showing when i blended the data, is this a bug or not ?

You might try using this technique, recommended by another viewer: "I solved it by changing your formula to =left(replace(A5,26,7,"uc?id="),71). i.e. changed thumbnail to UC"

Glad I could help!

if there is anyway to hide it

@@sabrinarina5371 Yes. You can do that. Use this formula instead: =IF(ISBLANK(A2)," ",LEFT(REPLACE(A2,26,7,"thumbnail?id="),71))

You're welcome!

Thanks for sharing this workaround. Awesome stuff!

Had the same issue and this solves it brilliantly! Thank you brother!

Thank you! It helps indeed to have a high quality picture! Don't forget though to replace 71 with 64 at the end of the formula, as now we have less symbols

Thank you. I wish there was a way to display PDFs, but I haven't figured that one out yet.