• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

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
 
S

Supreme

Well-known member
Staff member
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?
 
S

Supreme

Well-known member
Staff member
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?
 
S

Supreme

Well-known member
Staff member
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