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. [image]

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.

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. [image]

Change it to a multi-relation and then display it as an inline list. Then from there, do what Jeff said.

That worked immediately. Going to redo everything to the new inline list.

one last Q to finish up this project. Using the filter on the item itself. [image] [image] [image] Why does it not work?

Try using lowercase true Also, add a checkbox component to the screen pointing at that same column. This will help you debug

This just got interesting. The glide table shows a solid True [image] [image]

yes, so that indicates that you’re not on the row that you think you’re on

I am defiantly on it. I can see the info on top and the image. [image] Is this a bug?

OK i see where i messed up thank you guys for your help i believe i got it from here.

Bonjour, Just a comment. Stop using “True” and “False”, I use 0 and 1 for all calculations, ifthen, filter, visibility, … and it works fine. “True, False” are just literal expressions of a Boolean value.

Find from a list from within a form

Ask for Help

Darren_Murphy July 6, 2021, 1:37am 31

Topic		Replies	Views
Determine if row exists in a table Ask for Help	10	2271	December 4, 2021
Show Form Screen Ask for Help	14	153	January 22, 2025
"IF" and "Lookup" in glide Ask for Help	11	1455	June 9, 2021
Anyway to make sure a relation field does not scan itself? Ask for Help	4	76	December 14, 2024
Check if current specific row entries match before adding new ones Ask for Help	6	790	March 6, 2023

Find from a list from within a form

Related topics