15 posts by 8 authors in: Forums > CMS Builder
Last Post: December 27, 2018   (RSS)

By gkornbluth - December 26, 2018 - edited: December 27, 2018

Hi Kenny,

Could you set the section to sort records by  'hidden' or whatever field you use to determine an expired membership, and then by 'name' or 'date', which would automatically put the expired records at the bottom of the list (this doesn't work well with dragSortOrder).

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!

Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By daniel - December 27, 2018

Hey Kenny,

That's an interesting feature, thanks for the suggestion! Give Jerry's solution a try in the short term, but hopefully we'll be able to add something a little more robust in the future.

Thanks,

Daniel
PHP Programmer
interactivetools.com

Hey Kenny,

Another idea would be to move the display members function to a front end report.

That way you could only show the members with active status, and show any other fields laid out in the way that best meets your client's needs, even as a spreadsheet if required.

Then using something similar to the recipe in my Cookbook called: UPDATING A TABLE VALUE WITHOUT RELOADING A WEB PAGE USING AN AJAXURL, the client could change a member's status when required.

A similar (part of) the report could show only inactive members with only a small change in code. For example, if you were using the hidden field to toggle activity, then just change:

  'where'    => " hidden = '0' ", to  'where'    => " hidden = '1' ",

Just a thought...

Jerry Kornbluth

The first CMS Builder reference book is now available on-line!

Take advantage of a free 3 month trial subscription, only for CMSB users, at: http://www.thecmsbcookbook.com/trial.php

By KennyH - December 27, 2018

Good idea, Jerry! This will likely work for me until they can come up with a one-click archive method.

Thanks,

Kenny