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

[scotfield123]

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

[Robert_Petitto]

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?

[scotfield123]

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.

[Robert_Petitto]

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?

[scotfield123]

You are a star, thank you very much!

[Robert_Petitto]

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