Our organization can only have a specific number of clients in a geographic region. We have a Google spreadsheet that shows all of the major metropolitan areas in the United States, as well as the number of openings that are available in each area.
What we want to accomplish within Gravity forms:
A client selects their chosen metropolitan area from a drop down list inside a form.
The form updates in real time from the data found on a Google Sheet and populates the available cities.
The city’s availability number update after a purchase is made by the client. The Google Sheet will be updated with this change. This update doesn’t have to be accomplished by Gravity Forms. I am just adding this so you know that the Google Sheet will change in real time.
The Gravity Form can see in real time that this city is no longer available based on the availability now being zero and excludes this city from the list.
In the future as a client stops ordering and “inventory” is available again, we update the Google Sheet to reflect this new availability and the city will appear dynamically in the form again.
In other words:
How do I use Gravity Forms to pull dynamically changing information from a (Google) spreadsheet?
If not through Gravity Forms, any suggestions on how we can accomplish this? (We have G Suite, Elite Gravity Forms and Zapier as our main tools.)