# How to view forms inside the app **URL:** \ **Category:** Feature Requests\ **Created:** [June 3, 2020, 12:20pm UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226 "2020-06-03T12:20:06Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Melisa\_Fruit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/melisa_fruit/32/2503_2.png) [@Melisa\_Fruit](https://community.glideapps.com/u/Melisa_Fruit)\ **Post date:** [June 3, 2020, 12:20pm UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226/1 "2020-06-03T12:20:06Z")
Hello guys, I am wondering how can I view the forms inside the glide app instead of opening google sheets and scrolling through rows of data? Can I have a summary of most recent or ordered by date forms? Thanks. ---
**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:** [June 3, 2020, 12:23pm UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226/2 "2020-06-03T12:23:05Z")
Hi Melisa, What kind of information are you collecting through the form? Those things are definitely doable with the right setup of your sheet and relations inside Glide. ---
**Author:** ![Melisa\_Fruit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/melisa_fruit/32/2503_2.png) [@Melisa\_Fruit](https://community.glideapps.com/u/Melisa_Fruit)\ **Post date:** [June 3, 2020, 5:21pm UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226/3 "2020-06-03T17:21:13Z")
Well. Info type is data, producer, item, size, quantity. These will be entered on a daily basis and it would be nice if we could check them through the app and on the go instead of opening laptops etc. ---
**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:** [June 4, 2020, 4:29am UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226/4 "2020-06-04T04:29:45Z")
Hi Melisa I’m back with what would work for your case. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/e9abe173d2d33b542bc308be6fe23004305d27da.png) I have a form to submit the information as you stated. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/89964c67bf1aabb8475454f8b02864b619f808ee.png) I have a Rollup column to take the latest value from the submitted time column, then do a relation back to that same submitted column to get the latest form submit. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/eea2b09cb210f51fbb0edb5b8eee289222c62ddf.png) For the date choice view, I have a choice component that takes values from a “Date” only column, computed in the Sheets. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/626dc9c1c8ba80bce9e7871c0fc62b80824c5626.png) Then I do a relation that matches the user-specific “Date choice” to the “Date extracted” column in the sheets and return multiple matches. I showed it in an inline list, calendar view. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/1/17e9ea20be4679bf840e6a71b29f89f76ba479bb.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/b/b34d97b63758ce6ca046d215ee3fc1e16f8870a4.png) You can try it out yourself [here](https://tdslab.glideapp.io/) in the “Latest form submit”. ---
**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:** [June 4, 2020, 4:52am UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226/5 "2020-06-04T04:52:50Z")
Add a video of it in action. ![ezgif-3-6bbe3ce3c10a](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/09edd927e5e637e1ca8b45beec9b6150b867c3d8.gif) ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [June 4, 2020, 5:48pm UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226/6 "2020-06-04T17:48:30Z")
Maybe I’m not seeing the whole picture, but why not just creating a new tab that points to the forms sheet, and filtering it by date? ---
**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:** [June 4, 2020, 6:01pm UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226/7 "2020-06-04T18:01:36Z")
Thanks for pointing that out, I think it’s just another solution for this and Melisa can choose whatever option she likes. I just wanted to make it quick this morning and did not want to make a new tab lol. ---
**Author:** ![Melisa\_Fruit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/melisa_fruit/32/2503_2.png) [@Melisa\_Fruit](https://community.glideapps.com/u/Melisa_Fruit)\ **Post date:** [June 6, 2020, 8:54am UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226/8 "2020-06-06T08:54:28Z")
Hi Thinh, Choice option looks good. But, I am having problem computing the formula in sheets. I have copied exactly you formula but I am getting a #REF! error. (it says please insert more rows(1). Date submission is a date only format, as well as date extracted. Am i doing something wrong? ---
**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:** [June 6, 2020, 8:57am UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226/9 "2020-06-06T08:57:04Z")
It is something with the range. On reflection I saw I make a mistake in the formula as well, the DATEVALUE(A2) should be DATEVALUE(A2:A), can you try it again and tell me if it works? And did you put the formula in the first cell of the column? ---
**Author:** ![Melisa\_Fruit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/melisa_fruit/32/2503_2.png) [@Melisa\_Fruit](https://community.glideapps.com/u/Melisa_Fruit)\ **Post date:** [June 6, 2020, 9:01am UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226/10 "2020-06-06T09:01:18Z")
NOpe. Still not working ---
**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:** [June 6, 2020, 9:02am UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226/11 "2020-06-06T09:02:39Z")
Can you send me a copy of the data in personal message? ---
**Author:** ![Melisa\_Fruit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/melisa_fruit/32/2503_2.png) [@Melisa\_Fruit](https://community.glideapps.com/u/Melisa_Fruit)\ **Post date:** [June 6, 2020, 9:05am UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226/12 "2020-06-06T09:05:40Z")
> **[Copy of ЧЕРЕШИ - кантарни бележки](https://docs.google.com/spreadsheets/d/1a2XpQYHgmz1-0gxWLm5PeRxrUV29cXzB0iGJdJ-0MxY/edit?usp=sharing)** > > Доса Плод > > ID,Дата,Количество old,ID pallet IN,ID pallet OUT,Брой каси,Пале (кг),Кантар тегло,Нето набрано,Date... ---
**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:** [June 6, 2020, 9:10am UTC](https://community.glideapps.com/t/how-to-view-forms-inside-the-app/10226/13 "2020-06-06T09:10:48Z")
Hi Melisa, can you give [ariesarsenal@gmail.com](mailto:ariesarsenal@gmail.com) access to edit? Which of the sheets do you want to have that formula in? Edit: This issue was resolved after some chats in the Sheets.