# I must be missing something: how do I automatically take column info in Apps (former Pages)? **URL:** \ **Category:** Ask for Help\ **Created:** [April 30, 2023, 2:36pm UTC](https://community.glideapps.com/t/i-must-be-missing-something-how-do-i-automatically-take-column-info-in-apps-former-pages/61196 "2023-04-30T14:36:56Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [April 30, 2023, 2:36pm UTC](https://community.glideapps.com/t/i-must-be-missing-something-how-do-i-automatically-take-column-info-in-apps-former-pages/61196/1 "2023-04-30T14:36:56Z")
I must be looking in the wrong direction, but I hope you can help. I have a collection of roles (manager/accountant/ etc), when people select a role they can ask that role a question. ‘How do I do X’. In the background I automatically want to add that role to a prompt I send to OpenAI. In apps I did that with taking the information from columns. Can’t find that it the present apps? How do I automatically add the role of choice in a table when adding a question? Hope you can help! ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [April 30, 2023, 2:49pm UTC](https://community.glideapps.com/t/i-must-be-missing-something-how-do-i-automatically-take-column-info-in-apps-former-pages/61196/2 "2023-04-30T14:49:02Z")
Is setting custom values the way to go? ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [April 30, 2023, 4:38pm UTC](https://community.glideapps.com/t/i-must-be-missing-something-how-do-i-automatically-take-column-info-in-apps-former-pages/61196/3 "2023-04-30T16:38:56Z")
To be more clear: it shouldnt be necessary to pick Manager since we’re on the page manager. ![CleanShot 2023-04-30 at 18.37.13@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/ea43fff2b97607e792684d98d8e5dedc6c7e49f2.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 1, 2023, 12:31am UTC](https://community.glideapps.com/t/i-must-be-missing-something-how-do-i-automatically-take-column-info-in-apps-former-pages/61196/4 "2023-05-01T00:31:04Z")
> [@erwblo](#): > > How do I automatically add the role of choice in a table when adding a question? Shouldn’t you be able to reference that in a template, and use the template as your prompt? ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [May 1, 2023, 5:55am UTC](https://community.glideapps.com/t/i-must-be-missing-something-how-do-i-automatically-take-column-info-in-apps-former-pages/61196/5 "2023-05-01T05:55:56Z")
@ThinhDinh Yeah, I work with a template, but I can’t find out how I can get that info anymore. It will be stupid, but where do I automatically collect that the role of the present page in this case is ‘manager’ and in another case booker or lawyer? I use a list from a table with roles and descriptions. So now I ask people to pick the role in a choice component but that is one step too much, they’ve already made a choice by clicking on the detail screen. ---
**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:** [May 1, 2023, 6:33am UTC](https://community.glideapps.com/t/i-must-be-missing-something-how-do-i-automatically-take-column-info-in-apps-former-pages/61196/6 "2023-05-01T06:33:42Z")
It should be right there in the attached table. You’re already using it in the title component, right? ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [May 1, 2023, 6:48am UTC](https://community.glideapps.com/t/i-must-be-missing-something-how-do-i-automatically-take-column-info-in-apps-former-pages/61196/7 "2023-05-01T06:48:34Z")
This is in the table, it’s all there indeed, but I don’t seem to know anymore how I transfer the info from the row I’m at via the detailscreen to the helper table I’w writing too. I use a form where people ask a question and ask them to choose a role, but they have already chosen the role by clicking in the collection / list. [ ![CleanShot 2023-05-01 at 08.44.56@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6f3bcd518001b65a8eca7335b8dd3cd7c45b6991.png) ---
**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:** [May 1, 2023, 6:50am UTC](https://community.glideapps.com/t/i-must-be-missing-something-how-do-i-automatically-take-column-info-in-apps-former-pages/61196/8 "2023-05-01T06:50:55Z")
You should do it as part of the action when they select a list item. Create a Single Value column in your roles table that takes First-\>Whole Row from your Helper Table. Then use a Set Column Values action through that column. ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [May 1, 2023, 7:07am UTC](https://community.glideapps.com/t/i-must-be-missing-something-how-do-i-automatically-take-column-info-in-apps-former-pages/61196/9 "2023-05-01T07:07:16Z")
Ah! Now I understand! Thank you!