I came up with this idea working with a user who has a very extensive list of parts with their associated part numbers.
The Problem: The user wanted to be able to search by either the part description, or the number (instead of just one of those items).
The Solution: Create a copy of each field with it's associated reference data. (I found it helpful to label each set of fields based on how we were searching). For the first set, have field A (parts number) initiate the flow of data (this is the drop down we will be searching), and have the description field reference the part number. . For the second set, set it up in the opposite order: Description will initiate the flow of data, and Parts Number will reference the Description.
Then, add a field (either a drop down or a multiple choice field) allowing you to select which method you would like to search by. I put this field at the top of the screen.
Add a condition to the fields with the reference data that allow the proper fields to appear based on which type of search you'd like to do (see screenshot below):
Once you've set up your reference data and conditions properly, you're ready to save and publish!
Comments
Please sign in to leave a comment.
Video explanation link is broken...
Howdy David,
Thank you for bringing this to our attention! We are currently working to record a fresh video to replace the broken link. Once it is available, I will add a comment to this post.
Did this video ever get made?
Howdy Charlie,
Not yet! But as soon as the video is produced, I will be sure to include it here. If you are following this post, you will receive an email whenever a new comment is posted, so you will be notified when the video is added.
How about now? The video link complete?