If you're using Isotope (https://isotope.metafizzy.co) for this as well, you'll likely need to write some custom JS for this to tell Isotope to use the <select> options as filters and trigger it on 'change'. See this jsFiddle: https://jsfiddle.net/desandro/9pSyj/

Then you'd use the same code I provided before for the list options, but with a select and options instead.

<select id="work-flters">
  <option data-filter="*" class="filter-active" value="*">All</li>
  <?php foreach (getListOptions('yourTableForWorks', 'category') as $value => $label): ?>
    <option data-filter=".<?php echo htmlencode($value); ?>" value=".<?php echo htmlencode($value); ?>"><?php echo htmlencode($label); ?></option>
  <?php endforeach; ?>
</select>

You will need to customize the code above using your table name and you may not need the "data-filter" attributes because you'd be writing Javascript (check out that JS Fiddle) to tell the browser that you're filtering on the change of the select "#work-filters" and use the value as the isotope filter value.

I think the link I found with a simple Google search will help in this case as I don't believe it's in Isotope's base functionality to use a select versus another HTML element.

Please let me know if this helps at all.

Thank you for your post. I've taken a look at the filtering code you have posted and the demo website that you linked. My first suggestion would be to make the new field in the multi-record section be switched to have a type of "list" where you could add your own options and labels. The option value would be the class name that you would want to be able to filter on later, and the label value would be what would display in the list of brands.

Example (note the pipe "|" delimiter between the option and label):

rolex|Rolex
patek|Patek Philippe
...

Then, your code could use a built-in CMS Builder function called "getListOptions", demonstrated below in a code sample. You would swap out "yourTableForBrands" with your section's table name and the "brandFieldName" with the field that has the list options saved for it:

<ul id="portfolio-flters">
  <li data-filter="*" class="filter-active">All</li>
  <?php /* use getListOptions on the table fieldname to get all options available*/ ?>
  <?php foreach (getListOptions('yourTableForBrands', 'brandFieldName') as $value => $label): ?>
    <li data-filter=".<?php echo htmlencode($value); ?>"><?php echo htmlencode($label); ?></li>
  <?php endforeach; ?>
</ul>

...

<div class="row portfolio-container" data-aos="fade-up" data-aos-delay="200">
  <!-- STEP2: Display Records (Paste this where you want your records to be listed) -->
  <?php foreach ($galleryRecords as $record): ?>
    <div class="col-lg-4 col-md-6 portfolio-item <?php echo htmlencode($record['brandFieldName']); // Same field name used to get the list options above ?>">

    ...
    Code you've already got working
    ...

    </div>

  <?php endforeach ?>
</div>

Please let me know if that helps you at all!

You should be able to do this with a simple plugin. You would need to utilize the viewer action "viewer_output_rows" seen below in the first line. 

addAction('viewer_output_rows', 'pluginName_convertToSmartQuotes', null, 1);
function pluginName_convertToSmartQuotes($rows, $listDetails, $schema) {
  $fieldsToConvert = array('content', 'title', 'field_1', 'field_2'); // List your fields that you want to convert in this array
  //Check against $schema if the column exists
  $columnsExist = function_to_check_if_keys_exist($fieldsToConvert, $schema);
  if (!$columnsExist ) { return $rows; } // Just return rows if nothing exists
  foreach (array_keys($rows) as $index) {
    $row = &$rows[$index];
    foreach ($columnsExist as $field) {
      if ( isset($row[$field]) && $row[$field] != '' )  { 
        $row[$field] = preg_replace(array('/\b"/','/"/',"/'/"), array('”','“',"’"), $row[$field]); 
      }
    }
    
    unset($row);
  }
  return $rows;
}

I did use some pseudo code to indicate what functionality you'd be looking to create [ function_to_check_if_keys_exist() ]  so you can get the idea of what would need to be done. This pseudo function would need to be written to return an empty array if no columns/keys match or the columns that match.

If you're looking for us to write a quick plugin to help you accomplish this, send us an email at support@interactivetools.com and we would be happy to help you further and it shouldn't take much time at all. 

Let me know if that helps or if you have further questions!

In this case you could use the `mysql_count` function ( mysql_count($tableName, $whereEtc) ). Used in the below format:

$jeffCount = mysql_count('project_management', "`current_owner` = 'jeff'");

This would return a count for every project associated with Jeff's name. If you needed to filter by other parameters (like project_status = 'active' for example) you could add that to the second part, setting it up like a where clause concatenating with AND/OR etc.

Please let me know if this helps you at all for your situation.

We'd recommend that you upgrade to the latest version of CMS Builder and see if that resolves the issue, as the issue might be specific to this version of CMSB (3.51) combined with the version of PHP you are using.

If that doesn't resolve the issue, you can send an email to support@interactivetools.com and we can investigate and debug the issue further.

We can't think of a way to do this without the use of a plugin. You could take a look at using the `record_preedit` hook to add the required options to the request on page load with a plugin, or alternately contact us at support@interactivetools.com and we can provide you with more information or help by building the plugin.

Feel free to send us an email and we'd be happy to help and provide you with more information on this option.

Did mizrahi's reply help you achieve your desired result? Please let us know.

Jenna

Just wanted to follow up here and say that, after talking to my colleague, there is nothing wrong with using the `sendMessage` function. The `nlb_sendMessage` was created specifically for newsletters but the sendMessage function has many other features you can use. There aren't any disadvantages to using it, just advantages really. Check the file lib/mail_functions.php around line 43 for all the features of the sendMessage function.

Please let us know if you have any further questions.

If you were to use the "Get options from MySQL query (advanced)" as seen in the screenshot attached you would be able to set your own limit or leave out the limit entirely.

You could use a query like :

SELECT yourFieldName
  FROM `<?php echo $TABLE_PREFIX ?>your_tableName`
ORDER BY yourFieldName ASC

Feel free to omit the ORDER BY clause, but it would be handy in this case because you have >1000 records to display. It would default to orderBy the numerical index (num) column of your brewers table.

Let me know if that helps you with your question or if I should dig in deeper and find something else to help you out.

Just wanted to add something to this thread. Built into CMSB is a function called redirectBrowserToUrl (defined in lib/http_functions.php) which essentially provides the functionality you mentioned here, without having to write the header('Location: http://fullurl.com') and the die().

It can be used like so:

if (!$your_sectionRecord) { redirectBrowserToUrl('your-new-page.php'); }

Note that since this still uses the header('Location...') functionality of php it still needs to be be put before any other kind of information, as you mentioned in your post (copied below).

Just remember that since you're setting an HTTP-header, you must not have sent any kind of output before (not even a blank space at the end of an included file) or you'll throw a "Warning: Cannot modify header information - headers already sent" error. Test your page after the modification to make sure that it works as planned, and proceed accordingly. 

Please let me know if this is useful for you.

Thank you for your post. You can safely ignore this warning as we are going to make an update in the next version to fix this issue. See post https://www.interactivetools.com/forum/forum-posts.php?postNum=2245179#post2245179 for more details.

And if you need a patch to remove the warning in the meantime, Dave has made a suggestion on this post https://www.interactivetools.com/forum/forum-posts.php?postNum=2245190#post2245190 

Again, we will update CMSB in the next release to fix this warning that shows for some MariaDB users when the MySQL and MariaDB versions don't match up.

Please let us know if you need anything else.

Would you be able to submit a second level support request for this? https://www.interactivetools.com/support/request/

We would like to take a look and see what's going on. In version 3.54, I am able to have additional lines of search terms after "_all_" without having to change the field type from "none" for "updatedDate" so I'd like to take a look and see what's happening with your install of CMS Builder.

Ideally, we would not want to need to change the field type for default fields. 

I'll keep an eye out for a support ticket from you, and as always, we're happy to help.

Are you still looking for us to chime in on this one? I notice it's from December 2020.

Please let us know if you're still looking for assistance.

Are you still searching for an answer on this?

Please let us know.

Do you have a lot of options to select from? In the "list" functionality, it's expecting default values to be separated by a tab character. I was able to go into my text editor (or I'm sure word processors would work too), and separate my options with a tab (\t) and have them automatically select all in newly created items in my section. See screenshots below.

Note that the options will be converted into an array to check against, character for character of the option value... so the default value options, only separated by a "tab", must match the values in your options list.

Please let me know if that helps.

Just so I'm clear on this, the error is because there is no $musicians_lisingsRecord at all because there's no parameter passed at the end of the url?

My guess would be that you need to check if $musicians_lisingsRecord is set first then.

<?php if (isset($musicians_lisingsRecord) && $musicians_lisingsRecord['list_page_image']) : // Because $musicians_lisingsRecord will not be set if no url param passed?>
  <?php foreach ($musicians_lisingsRecord['list_page_image'] as $index => $upload): ?>
    <img src="<?php echo htmlencode($upload['thumbUrlPath3']) ?>" width="<?php echo $upload['thumbWidth3'] ?>" height="<?php echo $upload['thumbHeight3'] ?>" alt="" />
  <?php endforeach ?>
<?php endif ?>

Or you could try near the top of your file, where you first getRecords for $musicians_lisingsRecord, the following:

if (!$musicians_lisingsRecord) { dieWith404("Record not found!"); }

Please let me know if this helps at all.

I'm glad I was able to help with this! Looks great!

I think I may have a solution for you. In /lib/common.php we have the following function:

// array_groupBy:
//   eg. $recordsByNum = array_groupBy($records, 'num');
//   eg. $recordsByCategory = array_groupBy($records, 'category', true);
//       foreach ($recordsByCategory as $category => $categoryRecords) { ;;; }
// PHP Alternate: $recordsByNum = array_combine(array_column($menuRecords, 'num'), $menuRecords);
function array_groupBy($recordList, $indexField, $resultsAsArray = false) {

It allows you to group the returned results into an associative array with the column of your choice. In your case you may use it like:

$groupedStaffRecords = array_groupBy($staffRecords, 'categories', true);

Putting that line beneath your $staffRecords list near the top of the file. You would then loop through the $groupedStaffRecords using a foreach loop:

<?php foreach ($groupedStaffRecords as $category => $records) :?> 
  <?php if($category == '4'): ?>
     <?php $total_staff = count($records); // Set a total variable to use for the columns?>
     <?php foreach ($records as $key => $record): // this is the loop of the individual records in this category ?>
       <!--below it checks if it's the last result and is even (% 2) modulus operator checks if it is divisible by the number -->
       <?php if ($key == $total_staff && $total_staff % 2 !== 0) : ?>
         <div class="small-12 medium-12 large-12 cell">
       <?php else: ?>
         <div class="small-6 medium-6 large-6 cell">
       <?php endif ?>
           <!-- show record content -->
         </div>
     <?php endforeach ?> 
  <?php endif ?>
<?php endforeach ?>

You'll probably have to modify some things to ensure they work for your specific use case, but this should help to get you started in the right direction.

Let me know if this helps or if I need to clarify anything.

I downloaded the version of the Geocoder plugin (v1.05) and it doesn't include the API Key for use in the maps api call.

// Changed Line 123 from $url = "https://maps.googleapis.com/maps/api/geocode/json?sensor=false&address=" . urlencode($address)
// To below:
$url = "https://maps.googleapis.com/maps/api/geocode/json?address=" .urlencode($address);
// Include the GEOCODER API KEY, added this
if (@$GLOBALS['GEOCODER_GOOGLE_API_KEY']!= '') {
  $url .= "&key=".$GLOBALS['GEOCODER_GOOGLE_API_KEY'];
}
//This stays so it gets added if it exists
if (@$GLOBALS['GEOCODER_REGION']) {
  $url .= "&region=" . urlencode($GLOBALS['GEOCODER_REGION']);
}

Normally, I wouldn't suggest updating a plugin below the line that says not to update below... but this is an outdated version of the plugin. In later releases, it got updated to properly use the GEOCODER_GOOGLE_API_KEY.

That being said, I tested locally and finally got it to work (after it getting the denied status many times). I also utilized other fields like the ones we tried earlier, using the slash (/) between your field names and the Google-understood fields.

Please give this a shot.

Note that when you update to a more recent version of Geocoder in the future, it should be self-resolved.

Please give this a try: 

$GLOBALS['GEOCODER_ADDRESS_FIELD_COMBOS'] = array( // values should be ", " separated. alternates should be "/" separated.
  'address, city, province/state, postcode/zipcode/zip',
  'city, province/state, postcode/zipcode/zip',
  'province/state, postcode/zipcode/zip',
  'address, city, province/state, country',
  'address, city, province/state',
  'postcode/zipcode/zip/address',
  'property_street_address/address, property_city/city, property_state/state, property_zip/zipcode'
);

I'm wondering if since you're declaring a new set of field combinations that the plugin doesn't understand what you're trying to do and therefore Google cannot figure it out either. By adding the alternates accepted by Google, it may wind up working properly.

Please let me know if this is helpful and if not, I will continue looking.

I'd be happy to try to get to the bottom of this with you. I just need to confirm which version of the Geocoder plugin you're using and on which version of cmsbuilder? In this post you say v1.05 and v3.06 respectively but on https://www.interactivetools.com/forum/forum-posts.php?postNum=2244363#post2244363 you say latest and v3.53.

I want to ensure I am using the same version as you are when I try to see what my settings are versus yours.

We are working on getting appropriate documentation for setting up the Google API keys, as it is far too confusing for everyone (myself included sometimes).

Let me know which versions you're using and I'll do my best to help you out.

Thanks!

Just wanted to do a quick check in regarding this thread: are you still searching for a solution to restrict user access to sub-folders?

Please let us know if we can be of assistance.

Was Codee's reply sufficient for your update question?

This is an old post so I want to check with you first, but if you still need assistance we'd be happy to help.

Just taking a look at this old post and noticed that there could still be unanswered questions. Do you still require assistance?

We'd be happy to help, please let us know.

I just wanted to check in on this post: was Hans able to help you get to an acceptable solution for this, or are you still looking for guidance?

Please let us know.