Question

Need help filtering array data between Gravity Form and SQL database

  • 4 January 2021
  • 1 reply
  • 40 views

We use a geocoder on Gravity Forms for residents to report roadway problems. We use a simple Zapier to insert a new row into a SQL database.

We recently switched geocoder plugins, and the new plugin stores the data in a large array, whereas the old one had a simple lat/long field.

We need a Zapier filter/formatting function that will extract the latitude and longitude from this array:
s:829:"a:24:{s:6:"status";s:1:"1";s:10:"place_name";s:0:"";s:13:"street_number";s:5:"19911";s:11:"street_name";s:10:"Ryffel Way";s:6:"street";s:16:"19911 StorehouseWay";s:9:"street_bw";s:16:"Storehouse Way 19911";s:7:"premise";s:0:"";s:10:"subpremise";s:0:"";s:12:"neighborhood";s:0:"";s:4:"city";s:10:"Fort Myers";s:6:"county";s:10:"Lee County";s:11:"region_code";s:2:"FL";s:11:"region_name";s:7:"Florida";s:8:"postcode";s:5:"33967";s:12:"country_code";s:2:"US";s:12:"country_name";s:13:"United States";s:7:"address";s:43:"19911 Storehouse Way, Fort Myers, FL 33967, USA";s:17:"formatted_address";s:43:"19911 Storehouse Way, Fort Myers, FL 33967, USA";s:8:"latitude";s:18:"26.449446004345713";s:9:"longitude";s:18:"-81.78962909346646";s:13:"distance_text";s:0:"";s:14:"distance_value";s:0:"";s:13:"duration_text";s:0:"";s:14:"duration_value";s:0:"";}";
 

And store it, along with all the other Gravity form fields, into a sql database in this format:

26.449446004345713,-81.78962909346646

We need an estimate on cost to create this custom zap.


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +9

Hello @Estero Public Works ! I can help here. - Please feel free to book a call with me here: www.andywingrave.com - If you book using the calendar icon on the bottom right, we can look to create you something during the call.