Thanks @iamtomgray .
The file picker is what I need because the information is updating a database.
That database is also used however to serve another application that I use (Manychat) that displays those same images to customers in other areas.
My goal is that once that Image is in the google sheet, it is compatible with other platforms as well.
And this process would need to be automated.
The only thing I can think of is perhaps
- A google script that fires on edit to maybe save that link to the drive then replace it when a file.
- create an excel formula…if there was a way that I can get the file location from Glide either by recreating an appropriate URL.
Both of these I feel are a bit much for a few photos but any additional suggestions are appreciated.