Allow us to customize what shows up in the relationship field search
If we have a relationship field and start to type in a value, a selection box pops up and shows the options. The text for these options always seems to be the 1st field in the related apps form. I think it would be great if we could customize what shows up there. My reasoning...
I have an app that contains Cities, Zips, Counties and States. It's basically a big lookup table. In another app I would like to reference the City/State/Counties/Zips app in multiple fields such as a Cities field, a Counties Field and a Zips field. However I can't do this because the search only shows "Zips" because that is my first field.
If I could customize what is shown for a reference field...Zips show for my Zips reference field, Counties show for my County Reference field and City shows for my City Reference field...that would be awesome!
Yes you can do that but then you get a lot of un-needed information in your drop down selection. if I'm just searching for County, I don't want to see
"Whippany NJ | Morris County (07981)"
Although I will admit I like the look of that formatting and am going to use it :)
My thinking is that since you can customize the layout look for reference items already, why not be able to customize the look of what shows up in the dropdown list without adding another field to the app. Just makes sense to me.
I've been thinking about this a lot and I actually think the best answer is to have separate apps for States, Zips, Cities and Counties. This would solve all my problems, although would add 3 more apps to my workspaces.
Anyway, if you could customize your related app layout within the relationship drop down, I highly doubt you'd be able to make multiple custom layouts, like one for City, one for State etc.; a possible custom layout would be unique, so that pretty much boils down to concatenating into an initial calc field, IMO.
Please sign in to leave a comment.