How can I take pieces from an Address Field and put it into SQL using zapier without having to create single text for each part

Example, I like the use of the address field because of how it's formatted; however, when I am trying to take that data and use Zapier to insert into SQL it only see the whole field and I can't figure out if there is a way to take just parts such as Street.

Like I I want to insert Street into a SQL Column called Street.

Hi,

You can send existing rows from your SQL database to third party platforms such as Gmail.

I think you need to use Webhooks integration if you want to persist data to your SQL database.

You need to write a backend program to insert submission entry to your SQL database, as well as an API to take incoming requests from Webhooks.

You can integrate Webhooks with Jotform to send request to your API the moment a form is sent.

Let us know if you need further assistance.

Hello, I am thinking you misunderstood my question. I was trying to part out the Address field from the Jot Form to get the individual sections such as City. Right now, the address entry submits as a whole, Street1, Street2, City, State, ZIP, Country.

I was asking if there was a way to parse this data when creating the ZAP but I am thinking there isn't and if I want individual pieces for the Address my best bet is to use Single Text Lines

Hi,

Even if you can only parse the address field as a whole, you still should be able to extract the individual section(s), such as city, in your backend api by means of string manipulation.

Let us know if you need further assistance.

Thank you so much. This is helpful.