Understanding FormFroggy's Smart Field Mapping

What field mapping means

A Gravity Form is a collection of fields: text inputs, dropdowns, checkboxes, email fields, file uploads, and more. A Google Sheet is a table of rows and columns. Field mapping is the process of deciding which form field corresponds to which spreadsheet column.

With tools like Zapier, you define this mapping manually. You pick each field and assign it a column. With FormFroggy, this is automatic.

How FormFroggy maps fields automatically

When the first submission comes in from a form, FormFroggy reads all the fields included in that submission and creates column headers in the Sheet using the field labels from Gravity Forms. The column order follows the order of fields in the form.

FormFroggy also adds a few standard columns automatically: a submission timestamp, the submission ID from Gravity Forms, and the source URL of the page where the form was submitted.

What happens when you add new fields

If you add a new field to a Gravity Form after the sync is already running, you don't need to reconfigure anything. When the next submission comes in that includes the new field, FormFroggy adds a new column to the Sheet for that field. Existing rows are not affected.

This means your Sheet grows alongside your form. You never need to rebuild the mapping or restart the sync after making form changes.

Multi-value fields

Some Gravity Forms fields collect multiple values in a single field. Checkboxes, for example, allow a user to select multiple options. FormFroggy handles these by joining the selected values with a comma separator in a single column. So a checkbox field with options "Red, Blue, Green" where the user selects Red and Green would appear in the Sheet as "Red, Green".

Multi-part fields like Name (which has a First Name and Last Name sub-field) are included as their full combined value in a single column labeled with the field name.

File upload fields

When a form includes a file upload field, FormFroggy stores the public URL of the uploaded file in the corresponding column. The file itself remains in your WordPress media library. The Sheet contains a clickable link to the file.

Hidden fields and conditional fields

FormFroggy syncs all fields that are included in the submission data sent by Gravity Forms. Hidden fields that pass a value are included. Fields hidden by conditional logic that were not displayed to the user (and therefore have no value) are not included in that submission's row. This keeps your Sheet data accurate without empty columns cluttering the view.

Column headers and organization

Column headers use the field label exactly as it appears in your Gravity Forms field settings. If you change a field label after the sync is running, existing column headers stay as they were. New submissions after the label change will use the updated label, which may create a second column for that field. To avoid this, update your field labels before going live rather than after.

Working with complex forms

For forms with many fields or complex structures, the resulting Sheet can have a large number of columns. This is normal. You can hide columns you don't need directly in Google Sheets, freeze the first few columns for easier navigation, or use filters to focus on specific data. The Sheet structure reflects the form structure, so complex forms produce detailed spreadsheets.