Monday 20 May 2024

Viewer Image dan Youtube

 Image Viewer



=if(isblank(V2),"",left(replace(V2,26,7,"thumbnail?id"),71))

=importrange("https://docs.google.com/spreadsheets/d/1GqWE_hl2Y_RjIgD4-Vnok-c_BENnsESUWPWhbiqLFto/edit#gid=1330226964","DataSource!A3:A382")

=if(isblank(D2),"",trim(D2))

=REPLACE(trim(D2),26,7,"thumbnail?id=")

=if(isblank(D3),"",REPLACE(trim(D3),26,7,"thumbnail?id="))

=if(isblank(F3),"",left(trim(F3),71))


Image Viewer

https://lookerstudio.google.com/reporting/2e011255-e5a8-4dda-bf66-9686617d44bd/page/K7bsD

https://lookerstudio.google.com/reporting/9cde7cb5-4b4d-48ac-9cbe-186feb75c222

https://lookerstudio.google.com/reporting/2d82d33a-7fd3-45b6-9a2e-75db12fb9e66/page/xzdsD


Youtube Viewer



=replace($G$1,24,11,RIGHT(A2,11))


http://i3.ytimg.com/vi/wes-QNVsJfg/hqdefault.jpg

https://www.get-youtube-thumbnail.com/


=replace($AO$1,24,11,RIGHT(AF2,11))


=RIGHT(A2,11)

=replace($G$1,24,11,B2)

=replace($AO$1,24,11,RIGHT(AF2,11))


https://lookerstudio.google.com/reporting/2d82d33a-7fd3-45b6-9a2e-75db12fb9e66/page/xzdsD

No comments:

Post a Comment

Eyang Blangkon - Pemahaman Komputer

  https://www.youtube.com/watch?v=U3FozxSSkqw&list=PLx0QHmVBHGxaX33i29rfxda5bc6j6JOMq https://www.youtube.com/watch?v=S6D48H73om4