• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249 — View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249 — View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249 — View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Error integrating Formaloo with Hubspot due to formatting

Status
Not open for further replies.
T

TheSessions

Member
Hello,

One of my form fields in Formaloo is a multiple checkboxes. However the response received by Pabbly via formaloo uses commas ex: Hockey, Football, Cricket

As per the message below on the pabbly connection page hubspot requires semi-colons, hence I get an error message when try to run the integration test.

Important Note: Pass semi-colon(;) separated values for checkbox (Multi-Select) field types e.g. Hockey;Football;Cricket.

Help would be appreciated!

Thanks,
Samir
 
P

Pabblymember11

Guest
Hey @TheSessions

In the "Relationship Status" field you are passing multiple values where it takes one value at a time.

1678350258447.png
 
T

TheSessions

Member
is it not possible to have multiple values? I thought if there were semicolons inbetween the values then this would be permitted. Is there no way to change it so that multiple values would have semicolons inbetween them?
 
T

TheSessions

Member
unless there's another way to map multiple values? the specific property I'm mapping to in hubspot can accept multiple values as per this message:

Pass semi-colon [;] separated values for checkbox (Multi-Select) field types e.g. Hockey;Football;Cricket.
 
T

TheSessions

Member
Hi @Supreme,

I think I'm not understanding you. Is it possible for me to pass multiple values for the "Relationship Status" field using semi colons? If so, how can I do it?
 
P

Pabblymember11

Guest
Hey @TheSessions

We have made a slight workaround in your workflow to pass the multiple checkbox fields and semi-colon-separated fields.

Please check that once and try again.

1678703233096.png
 
T

TheSessions

Member
Thanks so much @Supreme ! this worked very well.
I've run into another problem for the same workflow.
If you look at the pic below is it possible to replace "result: No Data" with a blank?

In the form submitted in formaloo people can select one of two people by their full name. In Pabbly I used text formatter twice to replace the person's name with their corresponding owner ID from hubspot. I was hoping that if i selected both results in the Hubspot "Contact Owner" field it would use a blank for the person who wasn't selected. Is there another way of doing this? I used this method for a couple other questions as well and it's leading to Red No Data errors.

Thank you!


1679402832684.png
 
T

TheSessions

Member
in an attempt to be more clear, I'm trying to map two formaloo fields to one Hubspot field. One of the two formaloo fields will always have no data. Is this possible? I don't think I can pass a default value (blank field) because I'm selecting data from either a google translate trigger or pabbly replace text trigger.

Thanks again @Supreme
 
T

TheSessions

Member
I think a solution would be that when using Replace Text the input value can be optional and if it's empty the output is just a blank value. Can you make this happen?
 
P

Pabblymember11

Guest
Hey @TheSessions

If your mapped contact ID in the field didn't appear in live automation, it will be considered blank.

In case you need any other value to pass then you can use the Default Value action step.


1679464150046.png
 
T

TheSessions

Member
Hi @Supreme ,

The default value acting step doesn't work in my case. Let me explain

Step 1. Customer fils out the form and selects one of two employee names.

Step 2
Depending if they filled out the form in English or Dutch the employee name field is either rendered data #7 or #26 (just example numbers as I'm not behind my work pc at the moment)

Step 3
I want to map these employee names to hubspot's contact owner field, but this field only accepts the employee id number.

Step 4
I passed a replace text action to replace the employee name from the English form to their employee ID number

Step 5
I passed a second replace text action to replace the employee name from the Dutch form to their employee ID number

Step 6
When mapping the contact owner field in hubspot I select both results from step 4 and step 5, but this results in a no data error because depending if the form was filled in English (step 4) or Dutch (step 5) one of the values will always be empty.

Possible solution: in the replace text action is it possible to remove the input text requirement? This was if it's blank the result will b also be a blank. If the result is a blank then when mapping the result in hubspot it will be a blank value instead of a no data error.
 
Status
Not open for further replies.
Top