# How to display image under certain conditions?

**URL:** <https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025>\
**Category:** Ask for Help\
**Created:** [June 13, 2022, 4:48pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025 "2022-06-13T16:48:19Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\
**Post date:** [June 13, 2022, 4:48pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/1 "2022-06-13T16:48:19Z")

</div>

I have two columns, as shown with the screenshot below.

 ![Screen Shot 2022-06-13 at 12.43.36 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/3/0305189a827446f449a2dd2fdfe38a9bab952700.png)

I’d like to display certain images based on the status of the order. I tried to do it inside of a “if/then” column but it doesn’t give you the option to add an image. Is there an easy way to do this?

 ![Screen Shot 2022-06-13 at 12.48.10 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/c/0cbbcba3f785d90b9dd574e81aff1bd5a8d500cc.png)

Thank you!!

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [June 13, 2022, 5:01pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/2 "2022-06-13T17:01:20Z")

</div>

Hi @moshi,

You can paste the Image Address there and you will see the Image Address in Data Editor but once you connected that in the list image section you will get the image!

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/9/19b889980c1a1743997a627d6cf95320bf78d006.png)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/5/954a0a5535ea00ac98cc49c80a6b18ca54f259b3.png)

To make this easier what I do is ( this is a tip that I learned from this great community ) create another table/sheet and store the images and in the table that I’m building the if/then else column I will create a single value column to get that relevant image and if there more some more single value columns to get that images! And when I edit the image going to that table/sheet it also updates in the if/then else column.

Thank you

---

<div class="post-metadata">

**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\
**Post date:** [June 13, 2022, 5:13pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/3 "2022-06-13T17:13:38Z")

</div>

So the goal is to have the spreadsheet automatically fill the column with the accurate image-type, so copying/pasting the image link wouldn’t work for this particular app.

Just confirm what you’re saying:

1. SHEET\_ONE = contains all the images for the status type
2. SHEET\_TWO = contains a column that fetches the images from SHEET\_1

Here’s where I’m at right now:  
I created the second sheet

 ![Screen Shot 2022-06-13 at 1.08.40 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/26818540a29f84a3abb5e9a249975fd5bd4dd2f6.png)

I then created a single relation on SHEET\_2

 ![Screen Shot 2022-06-13 at 1.09.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/08177ac49244c9424c97a4eae5a8245cfdf1d149.png)

I know the relation is working properly because I see this:  
 ![Screen Shot 2022-06-13 at 1.11.54 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/3/a3c3186643d191e6721f4d79eba580d21e425489.png)

Now I just need a new column in SHEET\_2 that actually get’s the image from SHEET\_1 using the relation we created right. But how do I do that? What would the next step be

Thank you so much for everything bro, you’re a big help!

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [June 13, 2022, 5:21pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/4 "2022-06-13T17:21:07Z")

</div>

Use a [Lookup column](https://docs.glideapps.com/all/topics/computed-columns/primary/lookup-column) to get the image from the relation!

Lookup Column - relation (order …) \> Image For Status Type

---

<div class="post-metadata">

**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\
**Post date:** [June 13, 2022, 5:26pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/5 "2022-06-13T17:26:33Z")

</div>

Oh wow! I didn’t know about that feature!!

Okay so I just tried it but why does it show both images?  
 ![Screen Shot 2022-06-13 at 1.25.10 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/f/7f149f68c90b022091772aa8902f77d6b923d102.png)

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [June 13, 2022, 5:29pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/6 "2022-06-13T17:29:08Z")

</div>

Is it possible to show your Lookup column settings?

---

<div class="post-metadata">

**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\
**Post date:** [June 13, 2022, 5:30pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/7 "2022-06-13T17:30:51Z")

</div>

![Screen Shot 2022-06-13 at 1.30.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/1/41f9660935bdd478700bcbea8356af35572a328c.png)

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [June 13, 2022, 5:32pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/8 "2022-06-13T17:32:37Z")

</div>

I mean get the image from the relation column that you created! I believe it’s the relation (order → status image )

Lookup column - relation (order → status image ) \> Image For Status Type

---

<div class="post-metadata">

**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\
**Post date:** [June 13, 2022, 5:32pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/9 "2022-06-13T17:32:50Z")

</div>

Here’s the relational column too, incase that helps

 ![Screen Shot 2022-06-13 at 1.30.25 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/1/41f9660935bdd478700bcbea8356af35572a328c.png)

---

<div class="post-metadata">

**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\
**Post date:** [June 13, 2022, 5:35pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/10 "2022-06-13T17:35:55Z")

</div>

Sorry I’m confused, just to confirm:

1. Status of Orders HAS this  

2. Order HAS this  

Right now within the “Orders” sheet there is a relational column & a lookup column.

---

<div class="post-metadata">

**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\
**Post date:** [June 13, 2022, 5:40pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/11 "2022-06-13T17:40:22Z")

</div>

> [@Dilon\_Perera](#):
>
> (order → status image )

the status image is not inside the “Orders” Sheet, It’s inside the “Status of Orders” sheet.

The IMAGE we want is inside “Status of Orders”.

We want the IMAGE to go inside “Orders”

The lookup & relation is inside of “ORDERS”.

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [June 13, 2022, 5:44pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/12 "2022-06-13T17:44:52Z")

</div>

Made a quick video that will help here!

https://player.vimeo.com/video/719956150?h=2516ce1900&app_id=122963

---

<div class="post-metadata">

**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\
**Post date:** [June 13, 2022, 5:50pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/13 "2022-06-13T17:50:53Z")

</div>

OHHHHHH! It makes sense now ahah, thank you so so so much. There was a confusion because I never knew about the Lookup Feature, also didn’t know how it works.

You’re honestly the best, thanks again!!

---

<div class="post-metadata">

**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\
**Post date:** [June 13, 2022, 5:56pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/14 "2022-06-13T17:56:39Z")

</div>

sorry last question @Dilon_Perera

I’m trying to display the LookedUp image but it doesn’t show up

 ![Screen Shot 2022-06-13 at 1.55.46 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/3/231b9bd90439349023ceb144605940d5729fcb22.png)  
 ![Screen Shot 2022-06-13 at 1.56.16 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df963c30c0f859b1ab2a8da47a4b3ca4dd3458c0.png)

Why is that?

---

<div class="post-metadata">

**Author:** ![moshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/moshi/32/43745_2.png) [@moshi](https://community.glideapps.com/u/moshi)\
**Post date:** [June 13, 2022, 5:59pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/15 "2022-06-13T17:59:23Z")

</div>

wait never mind! It worked, I was just looking inside the wrong order/user

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [June 14, 2022, 5:59pm UTC](https://community.glideapps.com/t/how-to-display-image-under-certain-conditions/43025/16 "2022-06-14T17:59:51Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.
