My suggestion is...

Add the ability to sort a field by DATE (instead of only A-Z or Z-A alphabetically)

Sorting a field with dates in it alphabetically puts October "10" dates immediately after January "1" and groups all years by month -- so January 2013, 2014, 2015, etc. all come before October 2013, 2014, 2015, etc. This is a problem, of course, for any records that must be displayed in chronological order.

To get around this, I have to change the date format in Excel to United Kingdom, YYYY-MM-DD, save as a CSV and import. Since Excel reverts dates back to MM/DD/YYYY each time you reopen a file, it requires very careful handling so that I don't accidentally upload with a normal date format. If I do that, I now have to download the whole minibase (in the case of our Brags pages at https://www.cusd80.com/brags, currently 5,000 records), use Excel to fix the errors, save again as 50 (!) separate CSVs, purge the minibase, and re-import 50 CSVs slowly and separately.

2 votes
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Jeff La Benz shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base