I have a list of URLs in my sheet. I’ve gotten this information with zapier, but they alternate between image URLs and video URLs. If the link is a video, it works perfectly. But if it is a picture, it won’t show it, because it is in a link format. How can I change an URL to an picture in glide?
You use Image components to display images and video components to display videos. If your column contains URLs for both, then you’ll need an IF column that can check within the url to determine if it’s an image or a video. The IF column could check if the url INCLUDES ‘jpg’ for example. If it does, then return the word ‘image’. Else return the word ‘video’. Or something along those lines. Then set a visibility condition on your image component to only show if the IF column is ‘image’. Likewise, display the video component if the IF column is ‘video’.
2 Likes