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

    Zapier: will show output with curly brackets and double quotes rather than plain text

    Asked by just2izy on July 14, 2013 at 06:02 AM

    Hi guys.

    I am using Zapier to send SMS notifications based on form responses. There is however an issue.

     

    Text Formatting of the Output of the Purchase Order Widget

    I am sending a customer response SMS in which I want to include the items selected within a Purchase Order widget.

    The nicely formatted text sent via email notifications is not what is seen by default when you use the widget within Zapier. 

    The output from the purchase order widget in Zapier looks like this:

     {"product":["VAIO E Series SVE15126CXP (Amount: 1,290.00 GHS)","Microsoft Wireless Mobile (MHC-00026) (Amount: 80.00 GHS)"],"currency":"GHS","total":"1,370.00"} 

    Which is awful when sent to customers as an SMS and also the additional characters use up the 160 character limits of SMS.

    Any help getting this better formatted?

    For now I am using a workaround via Custom Filters in Zapier. 

    purchase email style size email notifications
  • Profile Image
    JotForm Support

    Answered by EltonCris on July 14, 2013 at 12:02 PM

    Hi,

    First off, how about using our direct solution? Check if this is possible with your requirement. http://www.jotform.com/answers/232717-How-to-setup-an-SMS-Mobile-Notification

    However, if you'd prefer using Zapier, may we know which 3rd party app are you integrating JotForm? Can you name the SMS app? I am not sure if we may be able to come up with a solution but we'll see if there's any possibilities. I think the filter solution you've mentioned would be the best workaround for this.

    Thanks!

  • Profile Image

    Answered by just2izy on July 14, 2013 at 02:11 PM

    The direct solution isn't ideal in this situation.

    I am using TelAPI as the 3rd party app but it would be the same issue with others. It was the same with Twilio.

    The issue is that the prodcut widget's output is in the format below so the SMS 3rd party app will just take all that DATA and send it as an SMS.

    {"product":["VAIO E Series SVE15126CXP (Amount: 1,290.00 GHS)","Microsoft Wireless Mobile (MHC-00026) (Amount: 80.00 GHS)"],"currency":"GHS","total":"1,370.00"} 

    I am just wondering why the output in Email notifications, are well formatted but this is not.

    In crafting an email to consumers, all I do is use the {PRODUCT WIDGET ID} and I get a nicely formatted output when the email is actually sent out by Jotform.

    Can't the product widget's output be similarly formatted in Zapier? Is there a technical reason it is within curly brackets and each item is surrounded by double quotes? It looks like a JSON reponse would (I am not a hard core dev but dabble in a bit of code).

    Anyway I will continue using the workaround, please pass along the issue maybe your devs might come up with an awesome solution in a future release.

    Thanks!

  • Profile Image

    Answered by jeanettebmz on July 14, 2013 at 04:57 PM

    I can see Email data output shows plain text correctly . It will grab data and put it into variable tags using curly brackets such as {PRODUCT WIDGET ID}

    However ZAPIER API seems to use something different, as the output shows double quotes and brackets. 

    We need to find out if this is something that needs to be improved on Zapier side or our side so, I am certainly passing this our developers

  • Profile Image

    Answered by just2izy on July 14, 2013 at 05:24 PM

    Thanks

  • Profile Image

    Answered by zapier on July 14, 2013 at 06:00 PM

    Hey guys! Zapier folks here. 

    We do indeed use the double bracket syntax {{}}.

    So, the core issue looks like the way we handle "lists" of data (the ["VAIO E Series SVE15126CXP (Amount: 1,290.00 GHS)","Microsoft Wireless Mobile (MHC-00026) (Amount: 80.00 GHS)"] from your pasted example). I'm sure we can come up with a solution that "combines" those lists into one text field that has no nasty syntax there.

    Hop on Zapier and ping us with a support request and include a link to this thread, that will help us identify your account and anything we need to fix it.

    A big thanks to the JotForm folks for helping so far! :-D

    -Bryan, co-founder @ Zapier

  • Profile Image

    Answered by jeanettebmz on July 14, 2013 at 09:18 PM

    Hello Bryan!

    Thanks a lot for your comments which have been added to the ticket and will be surely read by the developer in charge of it

  • Profile Image

    Answered by just2izy on July 16, 2013 at 07:58 AM

    Seems between Jotform and Zapier, you guys have fixed it!!

    Thanks for the awesome service!

  • Profile Image
    JotForm Support

    Answered by abajan on July 16, 2013 at 08:55 AM

    Very happy to know that the issue has been resolved. Glad we could help.

    Cheers