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

  • Profile Image
    daniel.moore
    Asked on November 02, 2021 at 04:17 PM

    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.

    Screenshot
  • Profile Image
    Yau_C
    Answered on November 02, 2021 at 09:27 PM

    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.


  • Profile Image
    daniel.moore
    Answered on November 09, 2021 at 02:06 PM

    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

  • Profile Image
    Yau_C
    Answered on November 09, 2021 at 07:36 PM

    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.

  • Profile Image
    daniel.moore
    Answered on November 10, 2021 at 09:22 AM

    Thank you so much. This is helpful.