# Variable to be displayed on the first row based on another column

**URL:** <https://community.glideapps.com/t/variable-to-be-displayed-on-the-first-row-based-on-another-column/76211>\
**Category:** Ask for Help\
**Created:** [September 7, 2024, 3:18pm UTC](https://community.glideapps.com/t/variable-to-be-displayed-on-the-first-row-based-on-another-column/76211 "2024-09-07T15:18:01Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![scotfield123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotfield123/32/62356_2.png) [@scotfield123](https://community.glideapps.com/u/scotfield123)\
**Post date:** [September 7, 2024, 3:18pm UTC](https://community.glideapps.com/t/variable-to-be-displayed-on-the-first-row-based-on-another-column/76211/1 "2024-09-07T15:18:01Z")

</div>

![Screenshot 2024-09-07 at 16.07.28](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/4/94954b5979fef9680d89b9a5866947df946d8a60.png)  
Hi guys,  
I need a column that needs to display, in this case, the wind speed based on the user site on the first row or on all rows, I know I can use Single value column but if i have 10-20 Sites/Projects I will have so many columns to make. I need this variable together with others to be used to generate a pdf with docs automator. I know it’s a better way but my brain just stop working for now.

thank you

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [September 7, 2024, 3:37pm UTC](https://community.glideapps.com/t/variable-to-be-displayed-on-the-first-row-based-on-another-column/76211/2 "2024-09-07T15:37:45Z")

</div>

Why does it need to be on the first row? Is it because you have a screen built off of this table and need to display that value?

What’s the context?

---

<div class="post-metadata">

**Author:** ![scotfield123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotfield123/32/62356_2.png) [@scotfield123](https://community.glideapps.com/u/scotfield123)\
**Post date:** [September 7, 2024, 4:07pm UTC](https://community.glideapps.com/t/variable-to-be-displayed-on-the-first-row-based-on-another-column/76211/3 "2024-09-07T16:07:30Z")

</div>

Thanks for your reply,  
Yes, I will have a screen like this for each Site/Project. I had some mixt up variables shown here and there and I’m thinking a column that shows on the first row the value that i need based on the site will be more efficient. I hope I make myself clear, English is not my first language, thank you.

 ![Screenshot 2024-09-07 at 16.59.27](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/7/27053caf8fbb6075466ddcb141ae30be5cad722d.jpeg)

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [September 7, 2024, 5:18pm UTC](https://community.glideapps.com/t/variable-to-be-displayed-on-the-first-row-based-on-another-column/76211/4 "2024-09-07T17:18:52Z")

</div>

My question is what’s your ideal way to switch between sites? It appears as though this tab is a summary screen of sorts, but you’re pointing it to a table of site records. A better option will be to use a single row, helper table or the users table for the screen, and then allow your users to dive into a particular site to see that site information orbuild out some sort of UI that allows the user to switch between sites using a choice component or the like. Unless I mistaken?

---

<div class="post-metadata">

**Author:** ![scotfield123](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/scotfield123/32/62356_2.png) [@scotfield123](https://community.glideapps.com/u/scotfield123)\
**Post date:** [September 7, 2024, 5:23pm UTC](https://community.glideapps.com/t/variable-to-be-displayed-on-the-first-row-based-on-another-column/76211/5 "2024-09-07T17:23:05Z")

</div>

You are a star, thank you very much!

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [September 7, 2024, 5:25pm UTC](https://community.glideapps.com/t/variable-to-be-displayed-on-the-first-row-based-on-another-column/76211/6 "2024-09-07T17:25:28Z")

</div>

No problem at all. Let me know if you want into any complications.

---

<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:** [September 14, 2024, 5:26pm UTC](https://community.glideapps.com/t/variable-to-be-displayed-on-the-first-row-based-on-another-column/76211/7 "2024-09-14T17:26:18Z")

</div>

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