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.
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. 👌
With the new accounts system you can authorize new Google accounts and select previously connected accounts directly in your Google Sheets feed settings too!
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.
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.
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!
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.
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
anddatetime
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.
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,
Thanks for the kind words Veronique. We don’t have an ETA for supporting 2-way sync between Gravity Forms and Google Sheets.
Best,
Hello Dario,
Thanks for your reply. Is this something planned? Or even doable?
Bests,