GWW 290: Something Wicked This Way Comes

Greetings, adventurers!

I’m so flattered when folks tell me that this newsletter is the one that they save so they can read it with their full attention. 💜

It’s also why I feel obligated to let you know that we’ll be skipping next week’s edition to give me (and the other American wizards) the opportunity to stuff our faces with Thanksgiving turkey without getting any gravy on our keyboards. 🦃

For those of you who also celebrate it, Happy Thanksgiving! And for everyone else, next week’s Black Friday deals will surely satisfy your appetites. 😄

Speaking of which…

Incoming: Black Magic Black Friday Sale

It’s our only sale of the year and it kicks off in just a few days—next Monday, Nov 23rd!

Here’s a quick breakdown of our deals and who each one might be right for.

• 10% off any Basic license
  You’re a curious adventurer testing the waters before casting your first spell.
• 20% off any Advanced license
  You’ve discovered your magical aptitude and are ready to wield stronger spells.
• 40% off any Pro license
  You’re ready to get serious about leveling up your magical repertoire.
• 50% off the Wiz Bundle
  You’ve gone full wizard—this unlocks nearly every spell in our arsenal.

If you want to get to know us better—and hear some of our top product highlights for 2025—Clay and I spent nearly an hour chatting it up with Gravity Forms’ Matt Medeiros.

And if you want to be notified when our deals are live…

New: GC Google Sheets 1.4

Have you ever noticed that the most annoying problems are often the most annoying to solve? Well, we sure did with this one. 😆

Here’s the story. We store a little meta data in each sheet to map rows to the the Gravity Forms entry that created it. This is what allows us to automatically update a row when its associated entry is updated.

The issue is that Google Sheets has a ridiculously small limit for this meta data, so eventually, you run out of space, and those entry updates no longer update newer rows.

With GC Google Sheets 1.4, we’ve replaced our dependency on this Google Sheets’ developer meta and instead created our own lookup system. We did a whole write up on how it works and why you’ll love it.

And yes, this new version is fully backwards compatible. 👌

Spotlight: Building an Automated Real Estate Directory

What happens when your “real estate directory” is actually just… you, a form, and a spreadsheet? For 10KGuarantee.com, manually matchmaking every single buyer to an agent was a bottleneck that simply wouldn’t scale, especially with a $10,000 reputation on the line.

This is where Johan d’Hollander (Geek on the Road) stepped in and said, “no more!” He conjured an auto-updating directory using GC Google Sheets to bridge data and GP Populate Anything to pull it live into Gravity Forms. Now, buyers filter agents by city, browse profiles, and choose the best agent for one of life’s biggest decisions. All that manual matchmaking? Poof—gone. ✨

Step behind the curtain to see exactly how Johan built it in this week’s Spotlight.

Snippet: Custom Loading Text for OpenAI Stream Field

This is a good one. From the mysterious lab of our Supreme Sorcerer Seabass comes a powerful (and fun!) snippet that allows you to customize the loading text for GC OpenAI’s Stream field. Just look at how beautiful this is!

This is a very customizable snippet too with options to change the text, color, shimmer duration, spinner tweaks, and more!

Product Updates

Gravity Perks

GP Advanced Calculations (v1.1.20)

• Fixed an issue where conditional statements in a nested form would not work if the referenced child field shared its ID with a parent field.
• Fixed an issue where alphanumeric product field values (e.g. B2, C3) were incorrectly converted to numbers in calculations, causing value mismatch errors in conditional statements.

GP Bookings (1.0-alpha-4.1)

• Improved behavior with multi-day events coming in from calendar syncs. Multi-day events with a start and end time are now handled correctly.
• Improved JavaScript bundle sizes.
• Fixed issue where multi-day calendar events from external calendars with past start dates, but future end dates, were not imported.
• Fixed issue where rescheduling using the [gpb_manage] could throw improper validation errors in some situations preventing rescheduling.
• Fixed issue where resource fields in Automatic Assignment allocation mode did not work with services that are nightly.
• Fixed issue where resource fields with Automatic Allocation would not show the resource in the entry list and entry details.
• Fixed issue preventing the “Per Occupant” pricing multiplier from being added.

GP Entry Blocks (1.0-beta-2.21)

• Fixed an issue where the Entries Loop “Grid view” was splitting entries across columns instead of displaying whole entries within columns.

GP Submit to Access (1.0.13)

• Fixed an issue where GPSA replaced all .entry-content instances during AJAX refresh.

Gravity Connect

GC Google Sheets (1.4.0)

• Added support for specifying a lookup column when updating entries, including an “Automatic” option. This removes the dependency on Google Sheets’ limited developer meta and paves the way for future improvements.

Gravity Shop

GS Product Configurator (1.0-beta-2.45)

• Fixed issue where Woo quantity selector appeared incorrectly on multi-page forms.