# Table data retrieval **URL:** \ **Category:** Ask for Help\ **Tags:** tutorial\ **Created:** [March 23, 2025, 7:56pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923 "2025-03-23T19:56:25Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Braunne](https://avatars.discourse-cdn.com/v4/letter/b/71e660/32.png) [@Braunne](https://community.glideapps.com/u/Braunne)\ **Post date:** [March 23, 2025, 7:56pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/1 "2025-03-23T19:56:25Z")
Hi, I have a table for which I need to retrieve data in cells one at a time, I don’t need to find the index, just the data in this table. I hope my question is clear. I don’t need the table index, just the data in cells **one** at a time. (the users of glide regular tables in a portal app) Thanks for your help ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [March 23, 2025, 8:16pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/2 "2025-03-23T20:16:52Z")
I think it would make it easier to assist you if you explained the flow or user experience in the layout editor: what action does the user take and what do you expect to happen? If for instance you had a button and every time the user tapped it some value in the next cell below needed to be shown: - Create a helper table with initial value is 0 - Create a relation to the table with the collection and relate to the column with the row index (single relation) - Lookup the value you want to display - When user taps the button, increment the value in the helper table by +1 (You don’t have to create a separate helper table, you could write to the same table.) ---
**Author:** ![Braunne](https://avatars.discourse-cdn.com/v4/letter/b/71e660/32.png) [@Braunne](https://community.glideapps.com/u/Braunne)\ **Post date:** [March 24, 2025, 1:45pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/3 "2025-03-24T13:45:05Z")
Thank you for your answer. It’s a **submit** button rather than a regular button! Ideally, upon loading a tab (screen) values are copied to the corresponding fields in the loaded form from the previous form! (All that is extra information, now, how do I list a table’s single **query** element at a certain index . Or even a **Lookup** at a certain index?) ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [March 24, 2025, 4:56pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/4 "2025-03-24T16:56:58Z")
> [@Braunne](#): > > values are copied to the corresponding fields in the loaded form from the previous form! Are you trying to create a multi-step form? If so, in the Layout Editor, when you create a new tab, you have the option to create a multi-step form. > [@Braunne](#): > > how do I list a table’s single **query** element at a certain index . Or even a **Lookup** at a certain index? Do exactly what you said: create a query column and filter for an index, or create a relation based on a index column. Keep it simple. You’re much better off create simple tables, simple columns, simple actions and workflows. If you’re having trouble visualizing what you are building and don’t really understand the logic of what you’re build, then you’re probably building over your head and need to simplify things. You’ll thank yourself for keeping things simple, because on the long term having to maintain a complex app you don’t understand is a headache. ---
**Author:** ![Braunne](https://avatars.discourse-cdn.com/v4/letter/b/71e660/32.png) [@Braunne](https://community.glideapps.com/u/Braunne)\ **Post date:** [March 24, 2025, 5:29pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/5 "2025-03-24T17:29:53Z")
It is simple. I have some Query and some Lookup. Both are not empty. How do I get the sizes of both of those structures? That’s the missing link ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [March 24, 2025, 5:50pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/6 "2025-03-24T17:50:18Z")
What do you mean with “sizes”? Have you experimented with the `Rollup` column? ---
**Author:** ![Braunne](https://avatars.discourse-cdn.com/v4/letter/b/71e660/32.png) [@Braunne](https://community.glideapps.com/u/Braunne)\ **Post date:** [March 24, 2025, 5:53pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/7 "2025-03-24T17:53:03Z")
no, only `single value` ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [March 24, 2025, 5:59pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/8 "2025-03-24T17:59:09Z")
`Single value` allows you to retrieve a single value of any table. `Rollup` allows you to determine averages, max, min, count of a set of values. For the “size” of set, you might want to experiment with the `rollup` column. ---
**Author:** ![Braunne](https://avatars.discourse-cdn.com/v4/letter/b/71e660/32.png) [@Braunne](https://community.glideapps.com/u/Braunne)\ **Post date:** [March 24, 2025, 6:06pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/9 "2025-03-24T18:06:38Z")
Too bad I can’t do `SomeQuery[0..Rollup-1]` or `SomeFeedback[0..Rollup-1]` ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [March 24, 2025, 6:20pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/10 "2025-03-24T18:20:29Z")
Do you mean “sum”? The `rollup` column allows you to sum sets as well. Use the `query` column to call a table and filter it, then you can use a rollup column to sum one of its columns. ---
**Author:** ![Braunne](https://avatars.discourse-cdn.com/v4/letter/b/71e660/32.png) [@Braunne](https://community.glideapps.com/u/Braunne)\ **Post date:** [March 24, 2025, 8:16pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/11 "2025-03-24T20:16:19Z")
How to calculate `Rollup-2` and add it to a table cell? ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [March 24, 2025, 8:18pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/12 "2025-03-24T20:18:33Z")
What do you mean by “Rollup-2”? ---
**Author:** ![Braunne](https://avatars.discourse-cdn.com/v4/letter/b/71e660/32.png) [@Braunne](https://community.glideapps.com/u/Braunne)\ **Post date:** [March 24, 2025, 8:19pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/13 "2025-03-24T20:19:17Z")
`value-another value` ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [March 24, 2025, 8:21pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/14 "2025-03-24T20:21:15Z")
You’ll need to explain in a little bit more detail what you’re trying to achieve. The easiest for you might be to play around with the rollup and query columns to see what their outputs are. ---
**Author:** ![Braunne](https://avatars.discourse-cdn.com/v4/letter/b/71e660/32.png) [@Braunne](https://community.glideapps.com/u/Braunne)\ **Post date:** [March 24, 2025, 8:22pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/15 "2025-03-24T20:22:50Z")
table deduction: `cell = value - value` I cannot explain it further! ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [March 24, 2025, 8:23pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/16 "2025-03-24T20:23:47Z")
The `math` column allows you to deduct. ---
**Author:** ![Braunne](https://avatars.discourse-cdn.com/v4/letter/b/71e660/32.png) [@Braunne](https://community.glideapps.com/u/Braunne)\ **Post date:** [March 26, 2025, 3:02pm UTC](https://community.glideapps.com/t/table-data-retrieval/80923/17 "2025-03-26T15:02:06Z")
Using the `math` column, how do I auto increment (++)? ---
**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:** [March 27, 2025, 1:14am UTC](https://community.glideapps.com/t/table-data-retrieval/80923/18 "2025-03-27T01:14:35Z")
What do you mean by auto increment? ---
**Author:** ![FrancoisDigico](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/francoisdigico/32/75651_2.png) [@FrancoisDigico](https://community.glideapps.com/u/FrancoisDigico)\ **Post date:** [March 27, 2025, 1:21am UTC](https://community.glideapps.com/t/table-data-retrieval/80923/19 "2025-03-27T01:21:33Z")
auto increment, is common in coding and JS, adding +1 automatically to every new row ---
**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:** [March 27, 2025, 1:26am UTC](https://community.glideapps.com/t/table-data-retrieval/80923/20 "2025-03-27T01:26:03Z")
> [@Using math column](https://community.glideapps.com/t/using-math-column/80977): > > Hi, Using math column, how do I implement auto-increment? Thanks This was solved here. [Next page](https://community.glideapps.com/t/table-data-retrieval/80923.md?page=2)