Zapier Zap - Form Fields to New Table Row Addresses Not Working

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have stumbled onto an issue regarding a new Zap that I created for QuickBase Application. To avoid the issues associated with utilizing the HTML Form Wizard on QuickBase's website (especially with as dated as it is and needing to import into multiple tables simultaneously), I created a zap from my Ninja Form on my wordpress website to the QB App I am using.

EVERYTHING.... Worked great.... Until... I got to the Address.

I've tried multiple scenarios....

  1.  Zapier Template to Address Parent Field Directly
  2.  Zapier Template to Each Individual Address Sub-Field Direclty
  3.  Zapier Template to Both Parent Field and Sub-Fields Simultaneously
  4.  Using Address 1 & 2 or Address 1 Only

None of the above seem to work. The data just refuses to cross over into the database, which is becoming quite inconvenient having to manually input addresses for every form submission that comes in, which is defeating the purpose of having this process automated.

Support seems to think it is an issue with Zapier. I however beg to differ... I can take those same form fields and get them to populate any other database field I want. EXCEPT Address Fields... I know that they are somewhat special compared to other fields... And I really don't want to have to re-create my secondary address field just have have data in the database and have to transfer that into the "Quickbase Address" field type every time either... That's just extremely redundant and not pretty.

Hopefully someone has experienced this before and can help assist me in finding a swift resolution to the problem, or an alternative solution. I am open to ideas, such as potentially using Workato or something else. But it's just kind of crappy that outside of this one problem it's all working else-wise.
Photo of Matthew

Matthew

  • 296 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
Maybe a workaround to make it automatic still, is to use a QB Action to take copy the proper values.

Have the Zap write the values to regular text fields, and then have the action copy the values into the address sub-fields..

Just an idea to try.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,466 Points 50k badge 2x thumb
Yes indeed.  That was a trick from Kirk Trachy at EMPOWER.
Photo of Matthew

Matthew

  • 296 Points 250 badge 2x thumb
So.... you seem pretty nifty with tips and tricks...

I've got two forms. (Ninja Forms on a website) Connected to the app with Zapier as mentioned before...

Form 1 - Agreement Form between Business A & B to deliver services with X number of locations.

Form 2 - Site Survey Form for specific location or entity under that Business 1+ more depending on the number of stores that sign up.

I have Organizations that parent the locations (1 to many) and contacts that connect to each location and/or organization.

Without changing the signup process... I would like to automatically detect the organization that is tied to each location (before I had each submission coming in it was doubling up on locations and organizations so I had form 1 do organization and 2 do locations and I'm manually linking all related records) and connect them together.

I doubt this is possible without knowing the RID. But I'm hopeful in case there is a way to maybe blanket most submissions with automation, leaving some user error or mistypes to manual correction.
Photo of Matthew

Matthew

  • 296 Points 250 badge 2x thumb
Also... What about auto-deleting an entry that was created if the first name is equal to 0 or last name is equal to 0. A side effect of using Ninja Forms and conditional fields. 

When you do actions, you only have the option to Add a Record or Modify a Record. And only modify values of fields within that record. Not delete or modify the actual record itself.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 50,466 Points 50k badge 2x thumb
I think that you need to post a new question.
Photo of Matthew

Matthew

  • 296 Points 250 badge 2x thumb
Probably. I was just hoping you might have some insight really quickly without having to make a new thread. I'll repost at a later date. Right now I'm filtering out the 0 results using Zapier. So I'm bypassing the need for any additional modification.
Photo of Matthew

Matthew

  • 296 Points 250 badge 2x thumb
That is a last resort...

Just trying not to be so redundant.
Photo of Matthew

Matthew

  • 296 Points 250 badge 2x thumb
One more thing I don't think I mentioned, but I also tried the combination including the Country and set it to default USA in the Zapier template. I also tried without it.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 26,512 Points 20k badge 2x thumb
Matthew: I am curious how you have Ninja Forms configured. Are you submitting direct to QuickBase or are you going through Ninja Form's Zapier extension? The reason I ask is that Ninja Form's Web Hook extension appears to only support JSON and I can't see how to configure a form to submit to QuickBase directly. See

https://ninjaforms.com/extensions/webhooks/
Photo of Matthew

Matthew

  • 296 Points 250 badge 2x thumb
I am using NinjaForms Zapier Extension to connect it using webhook to Zapier. From Zapier I just connect to QuickBase and add a row upon submission. It does not output in JSON format.

The number 0 is used because it is the default "calculation" for an empty field that gets modified by a conditional statement. I am taking a contact field and allowing the user to choose a checkbox "same as above" which in turn hides the fields when that condition is met.