Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Finding an Existing record - limited to one field search

cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Stephen_Joslyn
5 - Automation Enthusiast
5 - Automation Enthusiast

When I am searching for a linked record, I can only search if I know the first field (locked) for that table. However, when I start typing, I can see other fields listed in the options for each record that comes up.

Iโ€™d like to search by those other fields, that will still get me to that linked record, not by just the first field.

Example. Many of the linked records are listed like XMANS, XMAND, MANGS, UMIMG, UMIMA
I canโ€™t remember all of these codes, but I know what I am searching for - so if I typed something like โ€œEar Miteโ€ it would show me possible linked records to choose from, of which I would select UMIMG.

Hopefully that makes sense - will try to attach an image.LimiedSearch.png

3 Comments
Kai_Muscher
6 - Interface Innovator
6 - Interface Innovator

This would be more than useful!!! For example: When I have several hundreds of unique PO numbers (reference filed) for several article numbers and suppliers, itโ€™s hard to find the right PO if you are not 100% sure about it.

To me an extended search option is a must.

Thanks & best regards,

K

Nathan_Renner-1
6 - Interface Innovator
6 - Interface Innovator

Adding on to this comment! Iโ€™d love this as well!

Stephen_Joslyn
5 - Automation Enthusiast
5 - Automation Enthusiast

There is actually a simple work around that was suggested elsewhere.
Move your unsearchable field to any field but the first locked field.

Make the first locked field a formula that includes the field you want to search and any other fields.

Then when you are adding a record it will all be available as you type.