In the form that I have created, I have an arrival date (list of guests for Airbnb) for each guest that comes. For some reason they are not listed in chronological order in the form in multi-column list view. This is also true in the records list to the left of my form in single column view (which display the date and the persons last name for some reason) because I have specified in Sort & Group Settings that the First Sort Field is the Arrival Date. All the rest are unspecified. It seems to be keying off of the second column as well which is last name.
when I click on the ascending or descending button, the dates are all messed up some 2016 dates are at the top and bottom of the list. 2017 dates are out of order.
Any help will be appreciated.
Charlie
Can you please email me an archive of your file and I’ll investigate.
Do you have the Group Records By setting set to a specific field? If so, try changing that to Unspecified.