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

    Text Fields not coming into Excel Spreadsheet

    Asked by Billbully on January 15, 2016 at 12:28 AM

    Hello,

    I would like to automate an email to be sent summarizing my third form, so I added text fields to my form in order to provide some context to some of the information in the form.  My email was going to be triggered from a google sheet document because some of my fields have widgets and Zapier told me that widgets sometimes have problems transferring information over.  However, when I looked at the Google Sheets, I noticed that the text is not be transferred onto the spreadsheet.  Is this standard?  If so, do you have any suggestions?  I was thinking of using a calculation field to copy the text, but I wanted to know if you had any better or other ideas or solutions.

    Thanks,

    Jordan

    excel Excel spreadsheet static text
  • Profile Image
    JotForm Support

    Answered by Charlie on January 15, 2016 at 05:04 AM

    Are you referring to the static text on the "Text" field? Unfortunately, they won't be pass on a Google spreadsheet or on any integration because they do not hold an input value. They are static text.

    You could use a simple "Text box" or "Text area" field and then insert or output a value on it using conditional logic. Here's a simple test form: 

    1. Here, I setup a "Text" field, this is mainly for aesthetic purposes only. It will not hold the value of the full name and the email address. I'm using the field name tag here. You can get the field name by checking the "Properties" of the field.

    2. I then setup a "Text area" field to hold the values. I set it to hidden and read-only.

     

    3. I then setup a conditional logic to fetch the value of full name and email address but in a paragraph structure. Here's my conditional logic:

    I fetched the "Full Name" field by using the "ADD FIELD" button. Make sure that it is set to "A-Z".

     

    Now you can easily use the text area field in your integrations without any problems.

    I hope that helps.

  • Profile Image

    Answered by grade4pagasa on January 15, 2016 at 05:29 AM

    Hi Charlie.

    imho, the Text Field is under-utilized, under-appreciated and can be dynamic when using is it as an Output of static text with variables of {field names}. One of its major advantage that I really like is I can apply text formatting (bold, italics, underline, font color, ...) to either the static texts or {field names}. 

    1.) Can text formatting be applied to the output stored in textboxes or text areas? 

    2.) When integrated to Google Sheets, can these text formatting be retained in the cells?

    3.) Is it possible for the Text Field to be passed on to Google Sheets via Feature Request?

    Appreciate the help.

    - Randy

  • Profile Image

    Answered by Ben on January 15, 2016 at 10:18 AM

    Hi Randy, glad to see you on our forums again :)

    I have split your questions to new threads so that we can answer each and in the same allow Jordan to follow up with any questions in regards to this as well.

    Of course, your threads and our answers can be seen on the following links:

    http://www.jotform.com/answers/745975 - about applying style to text in textarea and textbox

    http://www.jotform.com/answers/745977 - about passing formatting to the Google Sheets

    http://www.jotform.com/answers/745979 - a thread that we will raise as a feature request for Text field to be passed to Google Sheets

    We will be answering them shortly.

  • Profile Image

    Answered by grade4pagasa on January 15, 2016 at 10:35 AM

    Hi Ben ! 

    As always, it's a pleasure to hear from you and get valuable tips at the same time. 

    By the way, I'm taking an online course right now on AngularJS (as you know, I'm a frustrated coder 😁) and find it very interesting. Which also made me realize the awesome and important work you guys do at JotForm. 

    I really appreciate all the help you guys do, your patience and wonderful customer service.

    - Randy

  • Profile Image

    Answered by Ben on January 15, 2016 at 11:50 AM

    Thank you for the nice words Randy :)

    I wish you a nice time with AngularJS. I heard good things about it, but never used frameworks much :)

    I have made replies on the new threads and I hope that they will be helpful.

    @Jordan, I have raised the new thread from Randy here http://www.jotform.com/answers/745979 in regards to the Text field being passed to the Google Sheets, so that will be updated if it is made live.

    It also holds a suggestion like using functions to add the content from the text within it through Google functions (no code).