Hi, is there a solution for my needs here: ...

(Peter Westin) #1

Hi,

is there a solution for my needs here:

I have a designated folder, where I upload images to my articles. The images is named exactly the same as the article numbers.

I would like them to automatically be connected to the corresponding articles in my app.

Is there a way to do that?

Peter

(Frederik Munk Brønserud) #2

I have a solution where I have a column in google sheets with a function like this:

=if([Article no]<>””; “(folder name)/“&[article no]&”.jpg”; “”)

It returns the path for an image with the article number as its name.

The downside is that it does not check weather or not the file actually exists, if it doesn’t, it just shows an error message.

(Steven Coile) #3

You’ll need a virtual column to contain the URL of the image. Set the type the column to Image. Set the App formula of the column to an expression that produces a complete URL referencing the image. Done.