Concatenate Cascading Filter Display Field

[Michael Gruber]

Team,

Is it possible to use a concatenation of multiple fields in the "Display field" for a Cascading (interactive) filter ?

I.e. Rather than choose to display either "number" or "short description", somehow have the ability to display;

"[number] - [short description]"

regards

Michael

[pratikjagtap · Accepted solution]

Hello @Michael Gruber 

1. Create new field

• Navigate to System Definition > Dictionary.

• Find the table where you want to apply the cascading filter.

• Create a new field:

  • Type: String

  • Attributes: Mark it as a calculated field.

  • Calculation: Use a script like:current.number + ' - ' + current.short_description;

• Use this new field as the Display field.

If this solution helps you then, mark it as accepted solution ‌‌✔️ and give thumbs up 👍 !

Regards,

Pratik

[Mark Manders]

Only if you change it on the the table itself. The field will show the display value of the table it's coming from. So if the display value is 'number', it will just show the number. If you create a 'display' field and set that to a combination of multiple fields and make it the display value of that table, it will show you that. Just know that this will be a global change, meaning that it will show up everywhere like this.