Transcription
Hey guys, welcome to my YouTube channel.
In this video, I'm going to show you how to generate an image URL in Google Sheets. If you have an AppSheet app that uploads photos, then once you upload the photo and save, it goes to your Google Sheets. You cannot view the image unless you go to the AppSheet and view the image, right?
So, I created one column here that every time I edit or upload a photo in AppSheet, it generates a URL.
To do that, let's go to the AppSheet. Let's review first the table where I'm working with the photo. So here we have a column named "photo," and the type is an image. We have a photo URL; this is where we are going to construct the formula to automatically generate the photo URL in Google Sheets.
This photo URL is based on the column name.
Let's create an automation. Let's say I'm just going to name this as "update photo."
Configure event. You can name the event. So I'm going to trigger this on an update.
Add step. You can name this type as well.
So in the step "run data action," select the photo URL, and we are going to use the expression here: concatenate the get file table URL.
I'm going to explain this. I'm also going to paste this in the YouTube description for your reference.
So here we have the URL to get the image. It's an AppSheet.com template: get table file URL.
App name is very important, so you have to replace this app name. To get the app name, just go to your browser and copy this above here.
So app name is equals to PDF app, and you can put it here.
Table name: what is the table name that you're working with? So the table name is "image URL." You put it here.
File name: what is the column, the reference column that you're going to create a URL? So in this example, it's an image type, and the column name is "Auto."
Now let's go and try. If you are going to add a photo in AppSheet, it will generate here, wherein you can click the link and view the photo.
All right, let's try. Let's say yes.
Okay, so I'm going to the Google Sheet and see if it generates a URL.
So here it generates a URL, and I click the URL. See, I can view the photo directly.
And this is also dynamic. Let's say I'm going to edit this photo and replace it.
Okay, I'm going to replace this, for example, by this.
Okay, and then once the sync is done, I'm going to my Google Sheet, and let's say if this changed the photo as well.
As you can see, it changed the photo.
So the URL is dynamic.
So this is how you generate a URL, the photo URL or image URL in Google Sheets using the AppSheet.
All right, so if you learned something in this video, don't forget to subscribe or comment if you have any questions.
Thank you so much for watching, and see you next time in my next video.