Different display value in a lookup column in a particular section
Hi community,
In any lookup column default display value will be name column. and also if we start typing in that particular column we will get suggestion based on the display value column. If we change the display value column in object level, it will change for all sections.
Is there a way to change the default display value column and search column for a particular section and in a particular column.
Thank you in advance.
Regards,
Manideep.
Like
Hi!
Yes, you are correct. In Creatio, the default display value for a lookup column is the "Name" column of the linked object, and this value is used in various places throughout the system, such as in drop-down lists and auto-complete suggestions (https://academy.creatio.com/docs/user/setup_and_administration/system_s…)
One option is to create a new object that is a copy of the original object but with a different "Name" column. This will allow you to link to the new object in the lookup column for the section where you want the different display values.
Another option is to use formulas or lookup columns to display the value that you want. For example, you could create a formula column that concatenates two columns from the linked object to create a custom display value. Or, you could create a separate lookup column that links to a different object that has the display value that you want.
While these workarounds can be useful, they do add some complexity to your configuration, so it's important to carefully consider your requirements and the trade-offs involved before implementing them.