Same Sort Field value for more than one column

Question

Hi Everyone

I have a grid field in which 3 columns are populated by the same DB column and I also want to set same sort Field value for them.

Is there any way to set so because when I try it throws an error that Sort Field value must be unique.

Mathieu Drouin · Answer

You can't use the same field twice in a grid to sort. I think possibly the only way you could do this is to create 2 additional custom record fields.

Mike Schmitt · Answer

Generally the best approach here is to just define the sort field for only the first column in such a collection, and leave the other columns alone. Out of curiosity, why do you have 3 columns for the same underlying field? Have you considered consolidating these into one column (or at least, fewer than 3)?

Mike Schmitt · Answer

If they're the same column in the DB / CDT, then they're the same column. What is "separated" about them, if they aren't represented by separate elements within the CDT?

Same Sort Field value for more than one column

Top Replies