# Getting relation entry by index **URL:** \ **Category:** Ask for Help\ **Created:** [July 19, 2024, 10:45pm UTC](https://community.glideapps.com/t/getting-relation-entry-by-index/75025 "2024-07-19T22:45:02Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Jason\_Bronfeld](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jason_bronfeld/32/64705_2.png) [@Jason\_Bronfeld](https://community.glideapps.com/u/Jason_Bronfeld)\ **Post date:** [July 19, 2024, 10:45pm UTC](https://community.glideapps.com/t/getting-relation-entry-by-index/75025/1 "2024-07-19T22:45:02Z")
I have a table with nautical information data for each day of the year. The left column is the date and then there are about 30 different columns of distinct data for each day. I can create a relation based on date that returns a specific row of the table. To get the data of a column in that row, I’ve been creating lookups for each column against the relation and then making an array from those columns and selecting an index of the array, is there a way to just get the nth element of the relation? cheers, JB ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 19, 2024, 10:55pm UTC](https://community.glideapps.com/t/getting-relation-entry-by-index/75025/2 "2024-07-19T22:55:48Z")
You could put the Make Array in the other table, and then you only need one Lookup column. ---
**Author:** ![Jason\_Bronfeld](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jason_bronfeld/32/64705_2.png) [@Jason\_Bronfeld](https://community.glideapps.com/u/Jason_Bronfeld)\ **Post date:** [July 19, 2024, 11:39pm UTC](https://community.glideapps.com/t/getting-relation-entry-by-index/75025/3 "2024-07-19T23:39:15Z")
The other table meaning the table with the data itself? Can I do that if it’s a Google sheet? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 19, 2024, 11:47pm UTC](https://community.glideapps.com/t/getting-relation-entry-by-index/75025/4 "2024-07-19T23:47:18Z")
Yes, the table with your dates and other data. Yes you can definitely add computed columns to any table, even one sourced from a google sheet. ---
**Author:** ![Jason\_Bronfeld](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jason_bronfeld/32/64705_2.png) [@Jason\_Bronfeld](https://community.glideapps.com/u/Jason_Bronfeld)\ **Post date:** [July 20, 2024, 12:11am UTC](https://community.glideapps.com/t/getting-relation-entry-by-index/75025/5 "2024-07-20T00:11:01Z")
Not sure I’m following the Make Array suggestion. In the data table rows (dates), columns (data), adding a Make Array asks me to select a column and then for that column adds all the dates. I’d have to do that for each and every column. Sort of the same as a look for each and every column. Is there a way to just index into the relation? It’s really easy for me to calculate the row in the relation (the column in the data table) that I need. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 20, 2024, 12:19am UTC](https://community.glideapps.com/t/getting-relation-entry-by-index/75025/6 "2024-07-20T00:19:53Z")
No you can’t index the relation unfortunately, but didn’t you say that you created an array from all your Lookup columns? Wouldn’t it be the same process, but make that array in your dates table instead of the table where you had the relation and lookups?