Gravity Wiz Weekly 208

Explore a sorcerous Google Sheets update with us! Plus, submit conditional logic for GS Product Configurator, day-of-the-week inventory for GP Inventory, and more.

gravity wiz weekly

Greetings, wizards! 

We’ve been working sorcerously hard on a brand new release that I’m super excited to share with you today. And if that’s not enough to get you fully amped for this newsletter, our weekly highlights and new resources will absolutely finish the job.

Without further ado…

GP Google Sheets 1.1 Is Here!

What do you do when you’ve got yourself a good product? You make it even better.

GP Google Sheets v1.1 is so packed with performance and quality-of-life improvements that you might actually shed a tear of joy. 🥲

Quick refresher: GP Google Sheets automatically sends and syncs Gravity Forms data with Google Sheets unlocking new possibilities for your data.

So what’s the big highlight in this new version? 

Bye bye tokens. Hello accounts!

You can now authorize as many Google accounts as you’d like. And you can manage all connected accounts directly on the settings page (including removing accounts). No more problematic “global” authorization. Each user authorizes their own accounts. 👌

new accounts overview in gravity forms google sheets

With the new accounts system you can authorize new Google accounts and select previously connected accounts directly in your Google Sheets feed settings too!

authorize new google accounts with gravity forms google sheets

This convenience extends to spreadsheets as well. In the old days (literally yesterday), you had to step through the Google authorization process even for sheets that were previously connected. Today, connected spreadsheets can be readily selected from a pre-populated list. 

Of course, you can still add new spreadsheets or connect a “new” existing spreadsheet with just a few clicks.

Under the hood

Everything is better, faster, stronger, but most importantly, more reliable. Connection issues are old news. 

In the rare cases where an issue does arise, the new Issues section (a bit on the nose, huh?) will reveal all mysteries and make it a cinch to fix up. 

a new issues section for gravity forms google sheets

Ok, that’s enough gushing from me. Go on and upgrade to the best version of GPGS yet!

Highlights of the Week

GS Product Configurator

Customizable WooCommerce products powered by Gravity Forms, deeply integrated with both ecosystems — it just works.

We’ve added support for Submit Button conditional logic. Configure the desired conditional logic for your Gravity Forms Submit Button in the form editor and Product Configurator will automatically show or hide the Add to Cart button and Quantity input accordingly.

submit button conditional logic for gravity shop product configurator

We also added support for passing a meta key as the value for the {custom_price[META_KEY]} merge tag. This is helpful when you’re using the same GSPC feed for multiple products and are storing the display price in a custom field.

GP Page Transitions

Bring your forms to life with animated transitions between form pages and automatic page progression.

You can now disable auto-progression for a specific page by adding the new gppt-disable-auto-progress class to the Page field’s CSS Class Name setting. This is useful if you have multiple fields on a specific page and you’d like the user to have a bit more control over when they proceed. Page Transitions, ftw!

disable auto page progression in gravity forms page transitions

New Resources

GP Inventory | Day of the Week Inventory

Set specific inventory limits based on the day of the week. Only have a capacity of 5 for your weekday boot camps but can take up to 10 victims trainees on weekends? This snippet is preconfigured for this exact scenario but can be easily modified to check for any day of the week.

GP File Upload Pro | Flip Cropping Aspect Ratio Based on Dimensions

When a Pro customer requested the ability to flip the aspect ratio of their crop depending on whether the current image was landscape or portrait, I honestly wasn’t sure if it was possible. Then I remembered that with the power of our Chief Arcanum Officer (Clay), all things are possible. 🙏

Here’s an example where the default crop ratio is 2/3 but automatically switches to 3/2 for portrait images.

flip cropping aspect ratio based on dimensions with gravity forms file upload pro

Product Updates

GS Product Configurator (1.0-beta-1.8)

  • Added support for Submit Button Conditional Logic. If the submit button is to be hidden, the quantity input and add to cart button will be hidden.
  • Added support for using {custom_price[META_KEY]} in the Display Price feed setting to load a price from the product’s meta.
  • Updated to trigger change event when base price of WooCommerce product changes (e.g. a variation is selected).
  • Fixed issue where order item add-ons could be output multiple times if using the new WooCommerce Blocks and HPOS.
  • Fixed issue where classes on the form were not applied to the <form> element on product pages.
  • Fixed issue where the CSS file for the edit order screen wasn’t being loaded when using newer versions of WooCommerce.
  • Fixed a potential JavaScript error if using GP Nested Forms with Product Configurator.

GP Copy Cat (v1.4.71)

  • Fixed issue with the Name field where if the Prefix input is present, only the Prefix would be copied.

GP Conditional Pricing (v1.4.9)

  • Fixed issue where conditionally hidden Product fields with pricing rules could fail validation.

GP Google Sheets (v1.1)

  • Added new “Issues” section in the Google Sheets plugin settings to quickly see what feeds and fields are encountering issues.
  • Added support for filtering Google Sheet Object Type values by date and datetime values.
  • Added an error notice if a feed’s column map fails to update.
  • Updated script strings to use their own localization callbacks that should run less frequently.
  • Updated the max number of Google Sheets that the Populate Anything Spreadsheet dropdown could show to 500.
  • Refactored JavaScript in the plugin settings and feed settings to use React to improve user experience and maintainability.
  • Refactored server-side PHP code to improve reliability and provide a more solid foundation moving forward.
  • Refactored how Google Accounts are handled. Multiple Google Accounts can now be added for users instead of one. Additionally, Google Accounts can be added directly from feed settings.
  • Fixed issue with the Google Sheets object type where error would be thrown if “Only Show Unique Results” was not checked on a given field.
  • Fixed issue where entry edits going to Google Sheets would sometimes not work if the column mapping didn’t include all of the columns.
  • Fixed potential fatal error with the Google Sheet Object Type for Populate Anything if using an Email field with confirmation enabled.
  • Fixed issue where the column mapping couldn’t update for legacy feeds.
  • Renamed “Tokens” to “Google Accounts” in the Google Sheets plugin settings.

GP Nested Forms (v1.1.40)

  • Fixed a PHP 8 warning.

GP Page Transitions (v1.0.24)

  • Added support for disabling auto-progression for a specific page by adding the new gppt-disable-auto-progress to the page’s CSS Class Name setting.

GP Populate Anything (v2.0.21)

  • Fixed an issue where filtering by Email fields with confirmation enabled could cause a database error due to an invalid query.
  • Fixed issue where fields could show Fill Out Other Fields when editing entries using the Entry Details Edit screen.

GP Post Content Merge Tags (v1.3.12)

  • Fixed issue where Pretty IDs were not generated if entries were created programmatically.

Comments

  1. Veronique Maury
    Veronique Maury November 15, 2023 at 8:13 am

    Hello David,

    Thanks for the insightful blog post as usual.

    Will GP Google Sheets support two way sync (modifying a value in a sheet would modify it in the form entry) natively without resorting to GP populate anyting?

    Bests,

    Reply
    1. Dario
      Dario Staff November 15, 2023 at 8:42 am

      Thanks for the kind words Veronique. We don’t have an ETA for supporting 2-way sync between Gravity Forms and Google Sheets.

      Best,

Leave a Reply

Your email address will not be published. Required fields are marked *

  • Trouble installing this snippet? See our troubleshooting tips.
  • Need to include code? Create a gist and link to it in your comment.
  • Reporting a bug? Provide a URL where this issue can be recreated.

By commenting, I understand that I may receive emails related to Gravity Wiz and can unsubscribe at any time.

"I unsubscribe from every newsletter I get except yours."

Join 25,000 readers and be the first to know of legendary discounts, new releases, free snippets, and other secret sorcery!