Solved: Question about Ref column Drop downs - Page 2

peter_jenkinson · 05-12-2021 11:07 PM

Hello guys is there maybe a way I can add a date(Permit Date Column) in backets or something next to my key in the drop when using a ref column?

something like this?

or maybe another suggestion , basically they need to see the bc number(key) and the date to know which is the right one?

Suvrutt_Gurjar

One approach is to make the Date column a label column. However, I suspect you have many records with one date value. So Date as label may not work. If so, you may explore the below approach.

You could create a VC in the parent table with an expression something like CONCATENATE([Existing Key Column], " - ", [Permit Date Column]) and please assign it as a label column. This label column will display in the dropdown showing dates as well.

View solution in original post