Docs & Support

Learn about all the Formidable features and get support from our amazing customer success team.

Developer DocumentationAdd-on HooksGoogle Sheets
frm_googlespreadsheet_escape_value

frm_googlespreadsheet_escape_value

Heads up!
This article contains PHP code and is intended for developers. We offer this code as a courtesy, but don't provide support for code customizations or 3rd party development.

By default, some data is prepended with an apostrophe character if it begins with an =, +, or @, to help prevent issues with people sending formulas that then trigger when you view the spreadsheet, which could be harmful. This is false in cases where the setting is prepending with an = so it doesn't cause issues when you set something like =SUM([123], [124]).

Usage

add_filter('frm_googlespreadsheet_escape_value', '__return_true' );

Formidable Forms makes advanced site building simple. Launch forms, directories, dashboards, and custom WordPress apps faster than ever before.

Parameters

  • None

Examples

Always escape a column value

Use this code to always escape a column value even when there is an = at the start of the setting.

add_filter( 'frm_googlespreadsheet_escape_value', '__return_true' );

Never escape a column value

Use the code below to never escape a column value.

add_filter( 'frm_googlespreadsheet_escape_value', '__return_false' );
Was this article helpful? *

This article may contain affiliate links. Once in a while, we earn commissions from those links. But we only recommend products we like, with or without commissions.

In this article

    We have a small, but amazing team of dedicated people who are committed to helping you achieve your goals and project requirements.


    Copyright © 2025 Strategy11, LLC. Formidable Forms® is a registered trademark Strategy11, LLC.

    Complete your purchase
    Special offer unlocked.
    Get 55% OFF!
    Complete Purchase
    Join 400,000+ using Formidable Forms to create form-focused solutions fast. Get Formidable Forms