# How to search values on a sheet based on the input from a text entry? **URL:** \ **Category:** Ask for Help\ **Created:** [July 3, 2020, 1:10am UTC](https://community.glideapps.com/t/how-to-search-values-on-a-sheet-based-on-the-input-from-a-text-entry/11881 "2020-07-03T01:10:11Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Vitor\_Rosas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vitor_rosas/32/2457_2.png) [@Vitor\_Rosas](https://community.glideapps.com/u/Vitor_Rosas)\ **Post date:** [July 3, 2020, 1:10am UTC](https://community.glideapps.com/t/how-to-search-values-on-a-sheet-based-on-the-input-from-a-text-entry/11881/1 "2020-07-03T01:10:11Z")
Hi friends! I need to implement a function where user can check-in just informing his code (voucher). The procedure must be: 1. User will access the app (public app, without login) 2. User type the code (voucher) on the first screen and “send” this info 3. A new screen is presented with the details of that voucher(name, dates, etc) and a button to confirm the check-in I’m stuck on the step 2, how to search for the entered value on the sheet. Any advice? Regards, Vitor ---
**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:** [July 3, 2020, 1:14am UTC](https://community.glideapps.com/t/how-to-search-values-on-a-sheet-based-on-the-input-from-a-text-entry/11881/2 "2020-07-03T01:14:45Z")
Have the code input as a user-specific field, then make a relation matching that input field with the code field in your “Voucher” sheet. Make all the lookups you need to return the information of the voucher. Then add the button to confirm the check-in, recording the voucher, ask the user to enter his/her email or special IDs. This could all be done in the same screen. Tell me if it works, I fear the user-specific column might act up in a public app. ---
**Author:** ![Vitor\_Rosas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vitor_rosas/32/2457_2.png) [@Vitor\_Rosas](https://community.glideapps.com/u/Vitor_Rosas)\ **Post date:** [July 3, 2020, 2:26pm UTC](https://community.glideapps.com/t/how-to-search-values-on-a-sheet-based-on-the-input-from-a-text-entry/11881/3 "2020-07-03T14:26:59Z")
Hi! I’m trying it, but no success until now. Trying to figure out how to “search” the entered info and automatically bring the results on the same screen (google like). ---
**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:** [July 3, 2020, 2:28pm UTC](https://community.glideapps.com/t/how-to-search-values-on-a-sheet-based-on-the-input-from-a-text-entry/11881/4 "2020-07-03T14:28:58Z")
What are your settings so far? To repeat my points above, I envision a screen with: - A user-specific text entry to store the code - A relation that returns the matching code information - A button to send that info back to your Sheets. ---
**Author:** ![Vitor\_Rosas](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vitor_rosas/32/2457_2.png) [@Vitor\_Rosas](https://community.glideapps.com/u/Vitor_Rosas)\ **Post date:** [July 3, 2020, 3:30pm UTC](https://community.glideapps.com/t/how-to-search-values-on-a-sheet-based-on-the-input-from-a-text-entry/11881/5 "2020-07-03T15:30:57Z")
Now it works!!! ---
**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:** [July 3, 2020, 3:32pm UTC](https://community.glideapps.com/t/how-to-search-values-on-a-sheet-based-on-the-input-from-a-text-entry/11881/6 "2020-07-03T15:32:11Z")
Lovely!