View Options - Group by Header


I have a primary view that has two group levels, name and contract date, with an additional date field, inspection date, as the next column order field (see image below)

When clicking on the name to drill down one level, the view looks like this.

Annotation 2020-06-02 151038

The problem is with two date fields and only “Inspection Date” in the header, it is difficult to understand which date is which. I would like to add a text prefix so the contract date would display “Contract Date - 5/11/2020” with the inspection date below. Is the best way to do this to create a virtual field with this information, or is there a more direct way to do this?


It would certainly be the easiest way to do it, but I fear it may then not sort correctly, since the virtual column will be a Text value, not a Date value, and may not sort chronologically. But it may. I’m not sure! Give it a shot!

Will you ever have more than one inspection date per contract date? If not, perhaps don’t group by contract date and just display it as another column? You might use a format rule to differentiate the two column values.

You are correct with the sorting issue, it sorts alpha instead of chrono. There will usually be multiple inspections per contract date so I need to group these inspections dates under the contract date. Currently I added an a 3rd grouping level so it group and sorts correctly, but is one extra level for the user to click through.

It works, not as slick as I would like. If there are any other suggestions please let me know.

Steve, thanks as always for the help.

1 Like