# Can I save the data entered in the form and use it as a filter in another component? **URL:** \ **Category:** Ask for Help\ **Created:** [September 27, 2019, 9:19am UTC](https://community.glideapps.com/t/can-i-save-the-data-entered-in-the-form-and-use-it-as-a-filter-in-another-component/639 "2019-09-27T09:19:13Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Ruchika\_Abbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchika_abbi/32/204_2.png) [@Ruchika\_Abbi](https://community.glideapps.com/u/Ruchika_Abbi)\ **Post date:** [September 27, 2019, 9:19am UTC](https://community.glideapps.com/t/can-i-save-the-data-entered-in-the-form-and-use-it-as-a-filter-in-another-component/639/1 "2019-09-27T09:19:13Z")
On a form, I’m taking a Date. On submit, I want to use the entered Date as a filter in the InlineList shown after form Submit. Screenshots attached. ![41%20PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/d84be82f8c1232334aaba320e48d8ee438be175f.png) ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [September 27, 2019, 9:33am UTC](https://community.glideapps.com/t/can-i-save-the-data-entered-in-the-form-and-use-it-as-a-filter-in-another-component/639/2 "2019-09-27T09:33:43Z")
Hey @Ruchika_Abbi, welcome. Not yet, but we would like to be able to do this in future for sure. You could probably do this type of filtering with the form submission in Google Sheets however. You could then show that list. ---
**Author:** ![Ruchika\_Abbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchika_abbi/32/204_2.png) [@Ruchika\_Abbi](https://community.glideapps.com/u/Ruchika_Abbi)\ **Post date:** [September 27, 2019, 9:37am UTC](https://community.glideapps.com/t/can-i-save-the-data-entered-in-the-form-and-use-it-as-a-filter-in-another-component/639/3 "2019-09-27T09:37:38Z")
Hi Jack, Thanks for the quick reply. Can you please elaborate? I didn’t quite understand. Do you mean after I submit on the Form component or Google Forms? I want to be able to filter based on the Date I enter on the form in the screenshot attached. ![20%20PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/1X/acd588f24fbf3ea093ca5fc5a1f2456f99554457.png) ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [September 27, 2019, 9:45am UTC](https://community.glideapps.com/t/can-i-save-the-data-entered-in-the-form-and-use-it-as-a-filter-in-another-component/639/4 "2019-09-27T09:45:42Z")
Sorry, yes - that wasn’t clear. I meant Glide Form Button. - Form is submitted with date - Cell in Google sheets is populated with that date - A formula that filters data (FILTER probably) would then read that cell and filter the data accordingly. [https://infoinspired.com/google-docs/spreadsheet/use-date-criteria-in-filter-function-in-google-sheets/](https://infoinspired.com/google-docs/spreadsheet/use-date-criteria-in-filter-function-in-google-sheets/) - That filtered data could be on it’s own unique sheet - You’d then show that sheet in Glide. There would be a delay between the submission and it showing up in Glide as your data would have to do a round trip. In future, we’d like to make this possible and therefore much easier in Glide. ---
**Author:** ![Ruchika\_Abbi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ruchika_abbi/32/204_2.png) [@Ruchika\_Abbi](https://community.glideapps.com/u/Ruchika_Abbi)\ **Post date:** [September 27, 2019, 9:55am UTC](https://community.glideapps.com/t/can-i-save-the-data-entered-in-the-form-and-use-it-as-a-filter-in-another-component/639/5 "2019-09-27T09:55:52Z")
Ah, okay. Don’t think that might work for my requirement currently. 😕 The Inline list in turn will be taking some inputs using the Notes component. If I pick the Inline list from the filtered data, I may not be able to send the updates back to the original sheet. Thanks for the help! ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [September 27, 2019, 9:56am UTC](https://community.glideapps.com/t/can-i-save-the-data-entered-in-the-form-and-use-it-as-a-filter-in-another-component/639/6 "2019-09-27T09:56:37Z")
No worries then. We are working super hard to make it possible to do all these things in Glide! 🙂 ---
**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:** [October 12, 2019, 9:20pm UTC](https://community.glideapps.com/t/can-i-save-the-data-entered-in-the-form-and-use-it-as-a-filter-in-another-component/639/7 "2019-10-12T21:20:30Z")
Just a thought on this, you could change the sorting of your list, so the newest items show on top. Then when you add an audit record, the newest would be be on top and easy to access instead of scrolling to the bottom. ---
**Author:** ![Doomba](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/doomba/32/1133_2.png) [@Doomba](https://community.glideapps.com/u/Doomba)\ **Post date:** [October 29, 2019, 3:01am UTC](https://community.glideapps.com/t/can-i-save-the-data-entered-in-the-form-and-use-it-as-a-filter-in-another-component/639/8 "2019-10-29T03:01:40Z")
This doesn’t solve the problem, but if the inline list shown is in the calendar format, it could help the users scroll down to the date and see the other audit records submitted for that date.