# Automatic selection of a line by dropping down another line

**URL:** <https://community.glideapps.com/t/automatic-selection-of-a-line-by-dropping-down-another-line/34894>\
**Category:** Ask for Help\
**Created:** [November 22, 2021, 7:44am UTC](https://community.glideapps.com/t/automatic-selection-of-a-line-by-dropping-down-another-line/34894 "2021-11-22T07:44:19Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Waser\_I\_Solutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/waser_i_solutions/32/34937_2.png) [@Waser\_I\_Solutions](https://community.glideapps.com/u/Waser_I_Solutions)\
**Post date:** [November 22, 2021, 7:44am UTC](https://community.glideapps.com/t/automatic-selection-of-a-line-by-dropping-down-another-line/34894/1 "2021-11-22T07:44:19Z")

</div>

Hello, I have two lists in Google Sheet, one with car brands in text and one with car brand logos. I want to select the car brand in text via choice and the appropriate logo should be selected automatically, I would like to display this logo as an image, how does that work?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 22, 2021, 8:24am UTC](https://community.glideapps.com/t/automatic-selection-of-a-line-by-dropping-down-another-line/34894/2 "2021-11-22T08:24:09Z")

</div>

- Create a User Specific Column to hold the choice of car brand
- Add a Choice Component to a Details Screen  
– Sheet: the sheet that holds the columns with car brands and logos  
– Values: the column with the car brands  
– Data: the User Specific Column created above
- Now add a Relation column that joins the user specific column to the column with the list of car brands. This should be a single relation
- Create a Lookup Column that fetches the car logo via the relation column
- Finally, add an Image Component to the Details Screen, and use the Lookup Column as the image source.

---

<div class="post-metadata">

**Author:** ![Waser\_I\_Solutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/waser_i_solutions/32/34937_2.png) [@Waser\_I\_Solutions](https://community.glideapps.com/u/Waser_I_Solutions)\
**Post date:** [November 22, 2021, 12:04pm UTC](https://community.glideapps.com/t/automatic-selection-of-a-line-by-dropping-down-another-line/34894/3 "2021-11-22T12:04:45Z")

</div>

Hallo, danke für deine Antwort. ich baue eine Glide-Seiten, da finde ich die Choice-Wahl nur bei Formularen, bei der Glide-App habe ich gesehen, dass ich die Choice-Wahl auch sonst anwählen kann, übersehe ich da etwas oder unterscheidet sich der Workflow bei Glide-Seiten?

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [November 22, 2021, 12:32pm UTC](https://community.glideapps.com/t/automatic-selection-of-a-line-by-dropping-down-another-line/34894/4 "2021-11-22T12:32:47Z")

</div>

It should be the same.

---

<div class="post-metadata">

**Author:** ![Waser\_I\_Solutions](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/waser_i_solutions/32/34937_2.png) [@Waser\_I\_Solutions](https://community.glideapps.com/u/Waser_I_Solutions)\
**Post date:** [November 22, 2021, 1:50pm UTC](https://community.glideapps.com/t/automatic-selection-of-a-line-by-dropping-down-another-line/34894/5 "2021-11-22T13:50:28Z")

</div>

It worked, thank you for the quick help.

---

<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:** [November 23, 2021, 1:51pm UTC](https://community.glideapps.com/t/automatic-selection-of-a-line-by-dropping-down-another-line/34894/6 "2021-11-23T13:51:11Z")

</div>

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