We are hoping to build a service availability checker. I have a client who wants to load in a postcode and house number using a CSV and then us build a form which checks against this data to see if if a user can get the service in their area. If so it would load a specific URL, if not it would load another.
Is this something that can be done using Gravity Forms. I presume it can be done using Conditional Logic, my only concern is how to load the data into this from the CSV.
This sounds like an excellent fit for GP Populate Anything. It allows you to dynamically filter and populate field choices and values from various data sources, including posts, GF entries, users, databases, and more. It can filter choices and values based on what’s entered or selected in other fields.
For your use case, when a user enters their postcode and house number, GP Populate Anything can check these values against your data source to determine service availability.
Although GP Populate Anything doesn’t support standalone CSV files as a data source, you have a couple of good options:
Google Sheets: You can import your CSV file into a Google Sheet and integrate it with GP Populate Anything using the GP Google Sheets plugin.
Custom MySQL Table: For larger datasets, you might get better performance by using a plugin such as wpDataTables to create a custom MySQL table from your CSV file. GP Populate Anything can then use this table in your database as a data source.