What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Salesforce via Zapier Integration: Selected checkbox values not showing properly

    Asked by scottyslittlesoldiers on November 21, 2014 at 04:28 PM
    the multi-picklist isn't populating correctly either. I think the values need to be separated by semi-colon's or something like that.
    salesforce zapier zapier integration checkbox checkbox values salesforce integrati
  • Profile Image

    Answered by scottyslittlesoldiers on November 21, 2014 at 04:53 PM

    Here are a couple of screenshots showing how JotForm is populating Salesforce via Zapier:

    (screenshots from Salesforce)

     

  • Profile Image

    Answered by scottyslittlesoldiers on November 21, 2014 at 04:54 PM

  • Profile Image
    JotForm Support

    Answered by Jan on November 21, 2014 at 05:47 PM

    Hi,

    Thank you for reporting this to us. I see what you mean. Selecting checkbox values will not show properly in Salesforce data.

    Your form:

    In Salesforce:

     

    Have you tried using the Salesforce Integration only?

     

    I will be escalating this issue to our developers so that they can take a look at it.  We will update on this thread once a solution  is available.

    Thank you for patience.

  • Profile Image

    Answered by scottyslittlesoldiers on November 21, 2014 at 05:50 PM

    Thanks!

    I initially tried the native integration, that didn't work at all except with the basic fields. I didn't like that there was no error to help you solve the issue so I went the Zapier route.

    Cheers!

  • Profile Image
    JotForm Support

    Answered by Charlie on November 21, 2014 at 06:53 PM

    Apologies for the inconvenience that this might have caused you. I see that this has been escalated to our developers and technical team to have a closer look. You will receive a notification when an update has been made.

    Thank you for your understanding.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on November 25, 2014 at 05:43 AM

    Hello @scotyslittlesoldiers

    Zapier's integration with us works in a way that it checks for new JotForm submissions for a specified amount of time. They get the submissions via our API, and the checkbox data returned by our API is in an array format, so it is up to Zapier to display the data in any way they want.

    To make the long story short, I would like to say that this is an issue on Zapier's end. Of course, as you are a JotForm user, we shall be coordinating with Zapier to have this problem resolved. We will update you as soon as we receive news from them.

    In the meantime, may we suggest using the native Salesforce integration? If you are having issues with it, can you please specify what it is exactly?

  • Profile Image
    JotForm Support

    Answered by NeilVicente on November 26, 2014 at 05:13 AM

    Hi again,

    This issue has been fixed.

    Do get back to us if you're still having issues.

    Cheers!

  • Profile Image

    Answered by scottyslittlesoldiers on November 26, 2014 at 06:45 AM

    Hi! That's great news, I'll check it a little later and see how I get on.

    Regarding, the Salesforce integration that you guys offer, I have a lot of fields that I want to sync and it was only working for the default fields (Lead). I could probably spend some time adding each field individually to see which one was the problem but I didn't like the fact that there was no error notification via email so, even if I did get it working, if something went wrong it wouldn't be communicated to me that there was an issue. If something goes wrong with the Zapier sync I get a notification which details the field causing the issue - this makes it easier to maintain going forward. If you could introduce such notifications in the Salesforce integration I'd certainly give it another go.

    Cheers!

  • Profile Image

    Answered by scottyslittlesoldiers on November 26, 2014 at 07:20 AM

    I just test this and it's not working yet. It now separates items by commas but it's not working as it should as it's inserting the concatenated values and not inserting them as separate values. Here are some screenshots:

    Here's what it looks like now:

     

    And here's how it should look:

     

    This isn't just an aesthetic issue as it completely throws out Salesforce's multi-picklist functionality. I've noticed that when you report on these fields they separate the fields with a semi-colon, perhaps when concatenating the values together it might perform as expected if you use a semi-colon rather than a comma.

    Cheers!

  • Profile Image
    JotForm Support

    Answered by Charlie on November 26, 2014 at 08:44 AM

    Hi,

    Thank you for reporting back to us. I'll notify our developers and the technical team regarding this. You will receive a notification when an update has been made again regarding this matter. I apologize if this has caused you some inconveniences. 

    Thank you for understanding. 

  • Profile Image

    Answered by scottyslittlesoldiers on November 28, 2014 at 05:53 AM

    Hey folks - any update on this? I'd really like to go live with this system next week - and everything else is now working perfectly!

    Cheers!

    Louis

  • Profile Image
    JotForm Support

    Answered by NeilVicente on November 28, 2014 at 08:18 AM

    No updates yet, Louis. We will let you know just in case.

  • Profile Image

    Answered by scottyslittlesoldiers on December 16, 2014 at 10:19 AM

    Hi there! Any updates on this? We really need this sorted or we'll have to find a different provider - running out of time! I really think you might have some success using a semi-colon as the separator as opposed to a comma!

    Cheers guys!

    Louis

  • Profile Image
    JotForm Support

    Answered by Charlie on December 16, 2014 at 11:39 AM

    Hi Louis,

    Upon checking the status of your concern, we currently don't have an update yet. But, as my colleague NeilVicente mentioned, you will be notified immediately when a fix or an update has been done.

    I do apologize for the inconvenience that this might have caused you, but rest assure that our developers and other back end team members are already aware of this and being notified.

    Thank you for understanding. 

  • Profile Image

    Answered by scottyslittlesoldiers on December 16, 2014 at 11:50 AM

    No inconvenience! I just need this system to go live shortly and need to use an alternative if this isn't going to be fixed anytime soon - is there any chance you could ask your developers for an ETA so I can make alternative arrangements if there is going to be too long a delay?

    PS - I appreciate it's always easier said than done!

  • Profile Image

    Answered by Ben on December 16, 2014 at 12:58 PM

    Hi Louis,

    I took a look at the details that I can see and all that I can tell you is that the status of this bug has been raised to important, which means that our developers are actively working on the issue to resolve it for you.

    Unfortunately there is no ETA that we could give to you, but as soon as there are any updates you will be notified of this.

    Best Regards,
    Ben

  • Profile Image

    Answered by scottyslittlesoldiers on March 11, 2015 at 06:01 PM

    Hi folks! I noticed this still isn't fixed - any chance someone can take a look?

    I have had to write a hack within Salesforce to get this to work which swaps out the commas with semi-colons. If your developers use semi-colons instead of commas as separators this will fix the problem!

    Give it a try!

    Cheers!

  • Profile Image

    Answered by Ben on March 11, 2015 at 06:19 PM

    Thank you Louis for the info, but as mentioned by my colleague earlier this is the issue on Zapier's end and how they combine the data in array (separated) that is sent to them from our own servers, through the API.

    We are actually waiting for them to get back to us - so that we can update you on this.

    What I would suggest is to open a ticket directly with them, as that might help speed it up for you.

    Basically it is up to them if they would need to combine the already split data using comma or semicolon.

    You can contact them here: https://zapier.com/help/contact-us/

    Thank you.

  • Profile Image

    Answered by scottyslittlesoldiers on March 11, 2015 at 06:22 PM

    Cheers Ben - I'll do that now.

  • Profile Image

    Answered by Sean on March 11, 2015 at 09:38 PM

    Ok. Please provide us with an update once available.

    Thanks

  • Profile Image

    Answered by scottyslittlesoldiers on March 12, 2015 at 12:14 PM

    Hello! I heard back from Zapier. They say they can't do anything unless JotForms uses semi-colons as a separator rather than commas.

    Perhaps in the UI you could provide an option to pick the list separator?

    Cheers!

    Louis

  • Profile Image

    Answered by Ben on March 12, 2015 at 12:19 PM

    Thank you Louis for getting back to us with that.

    I will forward this to our team to see if it would be possible to send a different separator instead of using array as well as your idea about the UI.

  • Profile Image

    Answered by iMatter on April 05, 2015 at 07:12 AM

    I have exactly the same issue!

  • Profile Image

    Answered by Shadae on April 05, 2015 at 10:34 AM

    Hi iMatter,

    I do apologize for the issue that you are experiencing with your integration with Salesforce and Zapier

    We do ask that each user create a new thread to have their issue addressed. Please create a new thread and provide us with more information regarding your inquiry.

    Thank you.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on September 05, 2015 at 03:56 PM

    @everyone

    We are terribly sorry for the very late update, but we are happy to inform you that the separator for checkbox options have been changed from comma to semi-colon. Salesforce integration via Zapier should now fetch the multi-picklist field data correctly.

    Thank you very much for your patience on this matter and for your continued patronage.

    Cheers!

  • Profile Image

    Answered by iMatter on September 05, 2015 at 10:41 PM

    Great - but I just tried it and it doesn't appear to be working. I'm still seeing commas. I even tried to create a new checkbox field, in case it only works for new fields created since the change. But still just commas.

    Is there something else I need to do?

  • Profile Image
    JotForm Support

    Answered by Jan on September 06, 2015 at 01:58 AM

    @iMatter

    I moved your inquiry on another thread so that we can assist you properly. Here's the URL of the new thread: http://www.jotform.com/answers/655790

    Thank you for understanding.