Gravity Forms Populate Anything

What does it do?

GF Populate Anything allows you to dynamically filter and populate field choices and values with posts, users, taxonomies, terms, Gravity Forms entries, and databases. Pretty much anything! Choices and values can be filtered based on the values entered/selected in other fields allowing you to fetch and populate fresh, dynamic data as the user interacts with the form.

GF Populate Anything also provides support for Live Merge Tags which allows you to display dynamic, filterable data in your field labels, descriptions, and content.

Features

Documentation

1. How do I enable this functionality?
2. Feature Details
   1. Populating Choices Dynamically
      1. Example Configuration
      2. Frontend
   2. Populating Values Dynamically
      1. Example Configuration
      2. Frontend
   3. Filtering Objects
      1. Filter Groups
      2. Filter Operators
      3. Filter Property
         1. Post
         2. Taxonomy Term
         3. User
         4. Gravity Forms Entry
         5. Database
      4. Filter Values
         1. Default
         2. Form Field Values
   4. Field Value Objects
      1. Example Field Value Object Configuration
   5. Live Merge Tags
      1. Fallback Modifier
      2. Example: Use Field Value in Another Field’s Label
      3. Example: Show Total in Submit Button
   6. Count the Number of Results
3. Known Limitations
4. FAQs
   1. Why aren’t users created with the Gravity Forms User Registration populating in my multisite?
   2. I’m not seeing all results?
   3. How do I add a placeholder or a blank space to the first populated option in a Drop Down?
   4. How do I add Checkbox Values as Choices?
   5. How can I differentiate similar items when populating into a Drop Down?
   6. How can I filter Posts those published in the last month?
   7. Why isn’t my Custom Post meta key selectable when filtering?
   8. Some Post meta values are missing from the filter drop down.
   9. How can I disable GF Multi-Page Navigation links while Populate Anything is loading data?
   10. Can I populate data from another database?
5. Hooks
6. Related Articles

How do I enable this functionality?

After GF Populate Anything is installed, you’ll want to enable “Populate Choices Dynamically” or “Populate Value Dynamically” for a given field in the Gravity Forms Form Editor. Here’s what that looks like when populating choices.

	Add a field that supports choices such as Drop Down or a text-based field such as Single Line Text.
	Enable dynamic population for the fields that you wish to dynamically populate.
	Select an object type that you wish to populate the field with.
	Optionally add filters to show the desired objects.
	Designate what object properties should be displayed by setting the Choice or Value Template.

Feature Details

Populating Choices Dynamically

If you wish to dynamically populate a choice-based field’s choices, you can do so by enabling “Populate choices dynamically” in the field’s settings.

Example Configuration

In the example below, we configured a radio button field to have its choices dynamically populated with users who have the “Administrator” role.

Frontend

Here’s what the configured radio button field looks like on the frontend.

Populating Values Dynamically

Populating values with GF Populate Anything is similar to how populating choices work. Enable “Populate value(s) dynamically” in the field’s settings and then configure it accordingly.

Example Configuration

In the example below, we configured a single line text field to have its value populated with the post title of the most recently added post.

Frontend

Here’s what the configured single line text field looks like on the frontend.

Filtering Objects

Filter Groups

Create groups of conditions that filter which objects are populated into the field. Add a condition to your group with the (+)/(-) icons to the right. All conditions in a group must be true for the group to match. Add another group by clicking the “Add Filter Group”. Objects that match any group will be populated into the field.

Filter Operators

• is
• is not
• > (greater than)
• < (less than) * >= (greater than or equal to)
• <= (less than or equal to)
• contains
• starts with
• ends with
• is LIKE
• Available wildcards
• % – Zero, one, or multiple characters
• _ – Single character

Filter Property

Depending on the object type you select, you will have different properties to select from.

Post

• Author
• Parent Post
• Post Content
• Post ID
• Post Status
• Post Title
• Post Type
• Post Taxonomies (Dynamic)
• Post Meta (Dynamic)

Taxonomy Term

• Name
• Parent Term
• Slug
• Taxonomy Term
• Term ID
• Term Meta (Dynamic)

User

• Display Name
• Role
• User Email
• User ID
• User URL
• Username
• User Meta (Dynamic)

Security Note: On multisite installations, the User object type will only search users from the current site.

Gravity Forms Entry

• Created by (User ID)
• Entry ID
• Fields (Dynamic)

Database

The Database Object Type’s properties are dependent on the table you select. Once you select a table, the properties will be all available columns on the MySQL Table.

Security Note: On single site installations, the Database object type is only available to administrators.

Filter Values

Default

After selecting the filter property, the Filter Value dropdown will be populated with a list of values that apply for that property. For example, if you are populating posts into a field and add a filter condition for the “Post Status” property, the Filter Value dropdown would be populated with a list of available post statuses (e.g. Draft, Pending Review, Published).

Form Field Values

Objects can also be filtered by values entered by the user when the form is filled out. After selecting the filter property and operator, select the desired field from the Form Field Values option group. When a user enters a value into the specific field, the objects populated into this field will be filtered by that value.

Field Value Objects

One common use case with GF Populate Anything is populating field values from a field with dynamically populated choices. You can do this by manually configuring the Object Type and Filters to use field values, but an even easier way is to use a Field Value Object.

Field Value Objects are available on any field that supports values when there is another choice-based field that has dynamically populated choices on the same form.

Example Field Value Object Configuration

In the example below, we wired up a single text field to display the user ID of the selected user in the radio field above it.

The Fields

The Selected User ID Field Settings

The Frontend

Live Merge Tags

When GF Populate Anything is activated, any merge tag prefixed with an @ will be automatically replaced when its associated field is updated. Live Merge Tags can be used anywhere within your form (labels, descriptions, choices, values, and HTML content).

Fallback Modifier

Live Merge Tags support a special modifier :fallback which can be used to display content when the merge tag does not have a value. For example, if the user can optionally provide their name but you want to greet them regardless, you could use, Hello @{Name:1.3:fallback[there]}. If a user entered their name as David, it would read Hello David but if the user entered no name, it would read Hello there.

Example: Use Field Value in Another Field’s Label

Example: Show Total in Submit Button

Count the Number of Results

Use the {count} merge tag as a custom Value Template to populate the number of returned results instead of a value. This is useful for conditional logic where you want to show or hide a field based on how many objects exist.

For example, say you have an order form and the first 50 customers to purchase should receive a discounted price. Populate a hidden number field with the entry count.

That count can be used with conditional logic to show a Discount field to the first 50 customers.

Known Limitations

• List fields can only be populated to/from other List fields.
• Dynamic checkboxes are not available when exporting form data.
• When populating from custom database tables, the primary key must be the first column of the database.
• Populating File Upload fields is not supported.
• Using checkboxes as Form Field Values in filters is not supported
• Live Merge Tags do not work with HTML fields in GravityFlow Workflows in the WordPress Admin
• Live Merge Tags in field labels of the form connected to a WooCommerce Product with the WooCommerce Gravity Forms Product Add-ons do not render in the cart
• Live Merge Tags cannot be used within <script> tags.

FAQs

Why aren’t users created with the Gravity Forms User Registration populating in my multisite?

When a user is created with the GF User Registration Add-On in a multisite install, they aren’t given a primary_blog meta key in the database, and Populate Anything specifically looks for that key to determine which site they belong to.

Use the gppa_object_type_user_limit_to_current_site hook as a workaround.

I’m not seeing all results?

By default, Populate Anything will only display up to 500 results to guarantee the best performance, but we do have a way of increasing this number.

Use the gppa_query_limit hook to adjust the maximum number of results that can be returned in your query.

Do note that increasing the limit to allow for large queries will increase memory usage on your site. Depending on the number of results queried, this can cause out-of-memory errors. Some object types, such as the Entry object, also require more memory. One way to combat this is to set up a field (or multiple) that can filter down the results of subsequent fields.

How do I add a placeholder or a blank space to the first populated option in a Drop Down?

You can use the Placeholder setting on the Appearance tab to add a default choice:

Please note that Gravity Forms won’t let you add a space as the placeholder, but you can add a non-breakable space ( ) and it will create a blank choice.

How do I add Checkbox Values as Choices?

By default, Gravity Forms stores checkbox values as arrays separated by commas, and when Populate Anything pulls in those values, it populates them as they are stored. Luckily, we have a snippet that will populate checkboxes from an entry as choices: GP Populate Anything: Checkboxes from an Entry as Choices

How can I differentiate similar items when populating into a Drop Down?

When populating items with the same or similar choice labels, you can differentiate between the similar items by following these steps:

1. Activate the Enable enhanced user interface option on the Appearance tab.
2. Set the Choice Template’s Label to a custom value by selecting “Add Custom Value” from the Drop Down and then entering a custom template. For example, this will show the post title and the post ID.

The end result is a searchable Drop Down field with a unique identifier for each choice.

How can I filter Posts those published in the last month?

Populate Anything’s results can be filtered on relative dates with this snippet. It adds merge tags that can be used as Custom Values in this format: {INTEGER UNIT ago}. For example, to filter Posts from a month ago, use the merge tag {1 month ago}.

Why isn’t my Custom Post meta key selectable when filtering?

When a meta field is created with a custom field editor, such as Advanced Custom Fields, the newly created field is simply a placeholder. Until it is used in a post, it won’t be found by Populate Anything.

Some Post meta values are missing from the filter drop down.

By default, Populate Anything has a 1000 record limit when accessing meta values for a Post. We have a snippet that will let you modify that limit. To use it, change 1000 to whatever limit you’d like to set.

How can I disable GF Multi-Page Navigation links while Populate Anything is loading data?

Add the following CSS to automatically disable Multi-Page Navigation links while data populates.

Can I populate data from another database?

By default, Populate Anything will only show the database that the current WordPress installation is on. Use the following snippet to register an additional database with custom credentials. Do note that only SQL databases are supported.

The snippet requires some configuration, which is covered in the installation video linked in the snippet’s description.

Hooks

• gppa_allow_all_lmts
  
• gppa_array_value_to_text
  
• gppa_autoloaded_object_types
  
• gppa_default_operators
  
• gppa_disable_form_navigation_toggling
  
• gppa_field_objects_query_args
  
• gppa_get_input_values
  
• gppa_gf_entry_reformat_date_fields
  
• gppa_has_empty_field_filter_value
  
• gppa_has_empty_field_value
  
• gppa_hydrated_field
  
• gppa_input_choice
  
• gppa_input_choices
  
• gppa_is_supported_field (JS)
  
• gppa_live_merge_tag_value
  
• gppa_lmt_whitelist
  
• gppa_loading_field_target_meta
  
• gppa_loading_target_meta
  
• gppa_max_property_values_in_editor
  
• gppa_missing_filter_value
  
• gppa_no_choices_text
  
• gppa_no_choices_value
  
• gppa_no_results_value
  
• gppa_object_merge_tag_replacement_value
  
• gppa_object_type_col_rows_query
  
• gppa_object_type_filter_after_processing
  
• gppa_object_type_properties
  
• gppa_object_type_restricted_database
  
• gppa_object_type_user_limit_to_current_site
  
• gppa_prepopulate_field_values
  
• gppa_process_template
  
• gppa_process_template_cache_key
  
• gppa_process_value_as_date
  
• gppa_query_cache_hash
  
• gppa_query_limit
  
• gppa_run_pre_render_in_ajax
  
• gppa_should_force_use_field_value
  
• gppa_should_get_term_by_id
  
• gppa_should_trigger_change (JS)
  
• gppa_template_rows
  
• gppa_value_specification
  

Related Articles

• How To Populate Data Based on the Current User
• How To Evenly Distribute Leads to a Sales Team with Gravity Forms
• Using Gravity Forms as a Simple Database
• How to Check Checkboxes (and Other Choice-based Fields) Conditionally
• How To Look Up Previous Entries with Gravity Forms
• How to Populate WooCommerce Order Data into Gravity Forms
• How to Update Posts with Gravity Forms
• Show Login Link for Existing Users with Gravity Forms User Registration
• Gravity Forms Zip Code Validation: A Step By Step Guide
• Gravity Forms Email Validation: Check Emails Live Prior to Submission