# Find from a list from within a form
**URL:** https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106
**Category:** Ask for Help
**Created:** [June 18, 2021, 4:25am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106 "2021-06-18T04:25:39Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@abe.sherman](https://community.glideapps.com/u/abe.sherman)
#### Post date: [June 18, 2021, 4:25am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/1 "2021-06-18T04:25:39Z")
upon a user clicking that + Button to create a item, i would like to force the user to check and see if that item already exist by scanning the UPC or entering the UPC manually, If the UPC matches. It should give the user a relationship of the link it has found. Otherwise If item was not found then let the user fill out the rest of the form using Visibility. My issue is how do i search a item with the filters making sure that the item dose not already exist in a form. I had no issue figuring this out outside of a form scenario.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 18, 2021, 5:44am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/2 "2021-06-18T05:44:52Z")
I’m not sure if this is possible when using a form. The problem is that the new row isn’t added until the form is submitted, and so there is nothing to build a relation with.
I would use a custom form on a details layout, with the input components writing to user specific columns. Then you can build a relation and check for duplicates in real time.
---
### Author:  [@abe.sherman](https://community.glideapps.com/u/abe.sherman)
#### Post date: [June 18, 2021, 6:06am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/3 "2021-06-18T06:06:57Z")
what about doing this without the forms and without using a inlist relation?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 18, 2021, 6:10am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/4 "2021-06-18T06:10:13Z")
If your scan result is written to a user specific column then sure, it’s easy.
---
### Author:  [@abe.sherman](https://community.glideapps.com/u/abe.sherman)
#### Post date: [June 18, 2021, 6:12am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/5 "2021-06-18T06:12:09Z")
Yep already long past that part i am falling into issues after resetting it.
It works but then jumps to the line. Good. But then if i need to reset it.
I made a relation to the line and another button to reset it.
But then it goes to line 2. Or grays out.
---
### Author:  [@abe.sherman](https://community.glideapps.com/u/abe.sherman)
#### Post date: [June 18, 2021, 7:34pm UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/6 "2021-06-18T19:34:59Z")
@Darren_Murphy
Watch the video to see where i am getting stuck at.
[](https://www.youtube.com/watch?v=MGygEI5CM04)
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 19, 2021, 8:34am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/7 "2021-06-19T08:34:04Z")
@abe.sherman you appear to be making that a lot more complicated than it needs to be. If all you’re trying to do is find out if the entered value already exists, it’s just a matter of creating a multi-relation from that column to the column that holds the data you’re matching against. If that relation is not empty, then you have a match. That’s it.
---
### Author:  [@abe.sherman](https://community.glideapps.com/u/abe.sherman)
#### Post date: [June 21, 2021, 12:16am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/8 "2021-06-21T00:16:50Z")
Sorry that does not work for me. What i am trying to do is, If found data Then show Data in the bottom, Otherwise show a hint no data found if data is entered and there is no match. also remember i am using multi user text.
[ ](https://www.youtube.com/watch?v=5qmDfxk9g7U)
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 21, 2021, 1:36am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/9 "2021-06-21T01:36:30Z")
Instead of trying to make the row jump to the matching row while you are typing, I would instead always let the detail screen attach to the first row. Then create a relation and lookups for all of the data you want to see. The lookup columns are what you will display on the screen. The thing is, instead of hopping between rows, you will always be displaying and working with the first row.
I think trying to make the filter jump around to different rows, especially while typing, is going to make your search bar unpredictable and give you the problems you are having now
---
### Author:  [@abe.sherman](https://community.glideapps.com/u/abe.sherman)
#### Post date: [June 21, 2021, 2:43am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/10 "2021-06-21T02:43:50Z")
Ok have a look at the update, any idea?
[ ](https://www.youtube.com/watch?v=E4eIbt_jP-8)
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 21, 2021, 3:18am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/11 "2021-06-21T03:18:57Z")
I wonder what would happen if you set up a custom action on your Add button that first does a View Details through the relation, followed by the Show Form action. Hopefully it would then be sitting on the correct row through the relation, so you would have access to the details of that matching item within the form.
---
### Author:  [@abe.sherman](https://community.glideapps.com/u/abe.sherman)
#### Post date: [June 21, 2021, 3:28am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/12 "2021-06-21T03:28:52Z")
Will it work with Multiple UPC? i did do a test from a view. But from the Single Relationship it currently fails. Assuming it has multiple matches.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 21, 2021, 3:33am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/13 "2021-06-21T03:33:18Z")
Change it to a multi-relation and then display it as an inline list.
Then from there, do what Jeff said.
---
### Author:  [@abe.sherman](https://community.glideapps.com/u/abe.sherman)
#### Post date: [June 21, 2021, 3:37am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/14 "2021-06-21T03:37:02Z")
That worked immediately. Going to redo everything to the new inline list.
---
### Author:  [@abe.sherman](https://community.glideapps.com/u/abe.sherman)
#### Post date: [June 21, 2021, 3:56am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/15 "2021-06-21T03:56:30Z")
one last Q to finish up this project.
Using the filter on the item itself.
Why does it not work?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 21, 2021, 4:06am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/16 "2021-06-21T04:06:48Z")
Try using lowercase true
Also, add a checkbox component to the screen pointing at that same column. This will help you debug
---
### Author:  [@abe.sherman](https://community.glideapps.com/u/abe.sherman)
#### Post date: [June 21, 2021, 4:11am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/17 "2021-06-21T04:11:11Z")
This just got interesting. The glide table shows a solid True
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 21, 2021, 4:15am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/18 "2021-06-21T04:15:20Z")
yes, so that indicates that you’re not on the row that you think you’re on
---
### Author:  [@abe.sherman](https://community.glideapps.com/u/abe.sherman)
#### Post date: [June 21, 2021, 4:16am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/19 "2021-06-21T04:16:41Z")
I am defiantly on it. I can see the info on top and the image.
Is this a bug?
---
### Author:  [@abe.sherman](https://community.glideapps.com/u/abe.sherman)
#### Post date: [June 21, 2021, 4:36am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/21 "2021-06-21T04:36:56Z")
OK i see where i messed up thank you guys for your help i believe i got it from here.
[Next page](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106.md?page=2)