fill existing items checkboxes, neverRemove

3 posts by 2 authors in: Forums > CMS Builder
Last Post: May 29   (RSS)

By gkornbluth - May 28 - edited: May 28

Hi Rez,

There are 2 recipes in my CMSBCookbook that I think can help.

1) http://www.thecmsbcookbook.com/recipedetail.php?RESET-THE-VALUE-OF-A-FIELD-IN-ALL-RECORDS-OR-IN-FIELDS-IN-MULTIPLE-TABLES-CHECK-BOXES-ONLY-292

2) http://www.thecmsbcookbook.com/recipedetail.php?RESET-THE-VALUE-OF-A-FIELD-IN-A-MULTI-RECORD-TABLE-DATE-FIELDS-ONLY-511

If you don't already have a subscription to the Cookbook, you can get a free trial subscription using the link http://www.thecmsbcookbook.com/trial.php

Also, in V3.54 and maybe some other earlier versions, there's a check box available when you add either a check box or date field to an editor that says, "Update all existing records with this value" which should set the dates or checkbox value to all existing records.

Just back up the table data before mucking about.

Hope that gets you closer to your desired outcome,

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 gkornbluth - May 29

Hi Rez,

There's also another improvement in 3.54 I noticed.

REMOVEDATE UPGRADE NOTES
Prior to this version, the default behavior for removeDate was to hide a post if
the field was blank. We've reversed this so that posts with a blank removeDate are hidden.
Before upgrading from older versions, verify that no sections are relying on the old behavior.

This removeDate explanation is a bit confusing and as soon as IT clarifies, I'll post it here.

What this means, is that previously if you had a removeDate field, and it was blank, then the post wouldn't show. Now,
the removeDate only functions if a date is entered, so if there's no date, it is assumed that the record has never
remove checked.

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