# How to display multiple items **URL:** \ **Category:** Ask for Help\ **Created:** [January 7, 2022, 11:57pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833 "2022-01-07T23:57:29Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![StinsonOwner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stinsonowner/32/37079_2.png) [@StinsonOwner](https://community.glideapps.com/u/StinsonOwner)\ **Post date:** [January 8, 2022, 5:47pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/21 "2022-01-08T17:47:56Z")
I think Im happy with this layout, but Uzo mentioned altering on dates or mileage for the “Next Due” kinda thing. I would LUV your input on that if you know how.? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [January 8, 2022, 6:06pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/22 "2022-01-08T18:06:06Z")
Ok, now your data is structured… Add 2 more column’s (type: number): miles Copy what you have in the 1st column but just numbers Time… copy only numbers of months… Question… this app is for 1 car or multiple? Single driver or multiple? If multiple drivers… do they drive 1 assign car or all of them? Is this app for 1 person to manage events, or multiple? What is the multiple check… is for time or mileage? ---
**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:** [January 8, 2022, 6:06pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/23 "2022-01-08T18:06:55Z")
> [@Jeff\_Hager](#): > > Now that you have your relation set up, you would create a tab in your app that points to your mileage table. This is key. You are still pointing your tab to the Scheduled MX table instead of the Mileage Interval table, but if you are happy sourcing your tab on the Scheduled MX table and using grouping, then you can ignore anything I mentioned about setting up the relation or creating the Mileage Interval table. You wouldn’t need them with the way you have it set up now. ---
**Author:** ![StinsonOwner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stinsonowner/32/37079_2.png) [@StinsonOwner](https://community.glideapps.com/u/StinsonOwner)\ **Post date:** [January 8, 2022, 9:46pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/24 "2022-01-08T21:46:44Z")
Uzo, Im building this just for my RV so only one vehicle and there is only one driver. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [January 8, 2022, 10:16pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/25 "2022-01-08T22:16:42Z")
ok, so that will be easy … what is that multi-check point? it is for miles or time? did you create 2 number columns for miles and months? and 1 date column for timestamps? ---
**Author:** ![StinsonOwner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stinsonowner/32/37079_2.png) [@StinsonOwner](https://community.glideapps.com/u/StinsonOwner)\ **Post date:** [January 8, 2022, 10:17pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/26 "2022-01-08T22:17:44Z")
Now that I have the structure like I want it thanks to you guys helping this is what I would like to do… When I mark an item complete, I would like for it to set the NEXT date or mileage. Then an Alter for that Next would be awesome. ---
**Author:** ![StinsonOwner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stinsonowner/32/37079_2.png) [@StinsonOwner](https://community.glideapps.com/u/StinsonOwner)\ **Post date:** [January 8, 2022, 10:18pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/27 "2022-01-08T22:18:38Z")
That is a good point, the multi point was in the manual, I will have to re-read and determine if its mileage or time ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [January 8, 2022, 10:20pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/28 "2022-01-08T22:20:00Z")
ok, check that… once you create these 3 extra columns, is time for creating some math columns… let’s start with time… Let’s title it “next inspection” and use a math column with formula timestamp + (months \* 30) that will give you the date for the next inspection for this task note: you need to set up a starting date in all timestamps rows… it can be a date of purchase or last inspection date ---
**Author:** ![StinsonOwner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stinsonowner/32/37079_2.png) [@StinsonOwner](https://community.glideapps.com/u/StinsonOwner)\ **Post date:** [January 8, 2022, 10:29pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/29 "2022-01-08T22:29:07Z")
@Uzo, this looking correct? ![Screen Shot 2022-01-08 at 4.26.08 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/0/5055b767434d110bb43d1043090d18f2bab63c6f.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [January 8, 2022, 10:31pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/30 "2022-01-08T22:31:54Z")
almost… timestamps can’t be boolean … and make a starting date for all rows, so the math column won’t give an error… you don’t need a completed column… for the math column use the ARRAY formula or copy down formulas ---
**Author:** ![StinsonOwner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stinsonowner/32/37079_2.png) [@StinsonOwner](https://community.glideapps.com/u/StinsonOwner)\ **Post date:** [January 8, 2022, 10:34pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/31 "2022-01-08T22:34:05Z")
Ok, changed Timestamp from Boolean to Date ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [January 8, 2022, 10:39pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/32 "2022-01-08T22:39:49Z")
now you have the next inspection dates… create a new column … “inspection DUE” and put formula `=ARRAYFORMULA(IF(F2:F="",,IF( now()> F2:F, "INSPECT",""))` ---
**Author:** ![StinsonOwner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stinsonowner/32/37079_2.png) [@StinsonOwner](https://community.glideapps.com/u/StinsonOwner)\ **Post date:** [January 8, 2022, 10:45pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/33 "2022-01-08T22:45:20Z")
Which one? ![Screen Shot 2022-01-08 at 4.44.32 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/4/d4c42509b169dfcb84bbe23caad8e51bd53e3b63.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [January 8, 2022, 10:46pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/34 "2022-01-08T22:46:38Z")
oh… you wanna do that at Glide table? then use the math column… but you won’t be able to use google scripts to send notifications ---
**Author:** ![StinsonOwner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stinsonowner/32/37079_2.png) [@StinsonOwner](https://community.glideapps.com/u/StinsonOwner)\ **Post date:** [January 8, 2022, 10:48pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/35 "2022-01-08T22:48:01Z")
No I just didn’t know where to put that code… ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [January 8, 2022, 10:49pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/36 "2022-01-08T22:49:02Z")
the formula is for the google sheet new column… put it in the second row note: it will take up to 10 seconds for glide to sync it… to avoid that, you can replicate that math column in the glide table for instant result ---
**Author:** ![StinsonOwner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stinsonowner/32/37079_2.png) [@StinsonOwner](https://community.glideapps.com/u/StinsonOwner)\ **Post date:** [January 8, 2022, 10:55pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/37 "2022-01-08T22:55:10Z")
![Screen Shot 2022-01-08 at 4.54.20 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/0/0047518606fac0d57956f885ae169555dfc2cfed.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [January 8, 2022, 10:57pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/38 "2022-01-08T22:57:45Z")
put one of the timestamps with the earlier date… like 1/1/2021 to test arrayformula… what formula do you have in the F column? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [January 9, 2022, 4:17am UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/39 "2022-01-09T04:17:32Z")
Let me know if everything works… ---
**Author:** ![StinsonOwner](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/stinsonowner/32/37079_2.png) [@StinsonOwner](https://community.glideapps.com/u/StinsonOwner)\ **Post date:** [January 9, 2022, 4:02pm UTC](https://community.glideapps.com/t/how-to-display-multiple-items/36833/40 "2022-01-09T16:02:25Z")
@Uzo, #1 thank you so much for jumping in and spending your Sat night to help me. It was awesome and I learned a lot watching you work. Im sorry for going dark on you but it was kiddo bedtime and then convinced us to watch a movie. I think this app is awesome and much more powerful now. Give me a day to review your changes and I will post back if I need to ask any questions. Have a great week. [Previous page](https://community.glideapps.com/t/how-to-display-multiple-items/36833.md?page=1)