Drupal

Drupal, table sorting, data management, content reporting, HTML tables
🕑Jan 28, 2025 🖋John Locke 💬0

Ask Freelock: Sortable tables?

Kevin asks,

Is there a Drupal Add On or Widget that would allow users to sort tables as they're displayed on the website?

Hi, Kevin,

Several options here:

Cliff person smile Drupal  jousting
🕑Jan 17, 2025 🖋John Locke 💬0

Drupal CMS: Making the easy stuff easy

In the past couple days I've gotten two different questions regarding building functionality out in WordPress. This seems a bit...weird with timing, given that Drupal CMS just launched three days ago!

Drupal automation platform, ECA module, Rules module, BPMN visualization, Typed Data integration
🕑Jan 10, 2025 🖋John Locke 💬0

Ask Freelock: ECA vs Rules

Yesterday a client asked us to install Rules module (again, repeating an earlier request, when he had missed my answer that we had installed ECA instead).

Santa in red suit checks map by Christmas tree, presents nearby.

Automatically Geolocate Santa

We've reached the last day of the calendar, and it's time for Santa's visit! Santa has been visiting some famous places all month. With the Geocoder module, Leaflet, a Geofield, and an Address field, you can automatically put each address Santa has visited on the map!

You do need to configure a geocoder source. We're using OpenStreetmap, from the geocoder-php/nominatim-provider.

Futuristic robot with glowing eyes surrounded by text bubbles.

Automatically moderate comments using AI

When you allow the general Internet to post comments, or any other kind of content, you're inviting spam and abuse. We see far more spam comments than anything relevant or useful -- but when there is something relevant or useful, we want to hear it!

With the AI module and the Events, Conditions, and Actions module, you can set up automatic comment moderation.

Like any use of AI, setting an appropriate prompt is crucial to getting a decent result. Here's the one we're trying out:

Cloud graphic with tech-related words and symbols.

Parse out names, addresses, complex fields using AI

We've had several clients working with memberships, who have a single name field with the full name of a person. And then they ask us to build a directory that is sorted by last name. This is a bit hard to do if there's a first name in front of it!

Names don't follow rules very well. Some have apostrophes in them, some have multiple words -- you can't just take the last word of a name and assume that's the last name, because often it just isn't.