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

    Need only the dollar amounts of donation to appear in excel

    Asked by SUAA on January 13, 2014 at 11:20 AM

    When I create an excel sheet from my Legal Fund Contribution Form I get additional wording along with the dollar amount in Column M.

    Contribution (Amount: 500.00 USD) Total: 50.00

    I would like only the dollar figure (50.00) to appear in the column so I can add formulas without having to retype the amounts in another column.  Is that possible?

    50.00

    http://www.jotform.com/excel/40124504768048

    http://www.suaa.org/SUAALegalFundDonationForm.php

    Page URL:
    http://www.suaa.org/SUAALegalFundDonationForm.php

    donation JotForm populate other box copy value
  • Profile Image
    JotForm Support

    Answered by abajan on January 13, 2014 at 12:34 PM

    Currently, the best way I can think of to achieve that would be to insert an extra textbox into the form and then after re-embedding the form, add a script to the page to populate the new box with just the dollar value. (The new box would be hidden from view via injected CSS or some other manner.) The problem with this approach is that the Excel sheet will now have an extra column. So, you would still have the column with the

    Contribution (Amount: 500.00 USD) Total: 500.00

    Perhaps my colleagues can devise a better workaround.

  • Profile Image

    Answered by SUAA on January 13, 2014 at 04:55 PM

    That would be fine to have the 2 columns.  I don't know how to add a script to the page to populate the new box with just the dollar value and hidden with CSS) Can u help me with that?

  • Profile Image
    JotForm Support

    Answered by abajan on January 13, 2014 at 06:11 PM

    No problem. I'll work on something and get back to you later tonight (Barbados time).


    Ciao for now

  • Profile Image
    JotForm Support

    Answered by abajan on January 13, 2014 at 08:39 PM

    Hi again,

    Please do the following:

    1. With the form loaded in the form builder, click the Contribution field

    2. Click the Widgets menu and enter the word hidden in its search box


    3. When the Hidden Box widget appears, click it

    4. Rename its label Dollar Value (or some other name that would distinguish it from the other Contribution field)

    5. Save the form and copy its full source to your computer clipboard

    6. Paste the code into your web page

    7. Copy this code and paste it anywhere under the form code, preferably just before the page's closing body tag. If you view the source of this page, you'll see the script in that very position. It's not crucial that it be placed there but that is one of Yahoo!'s page speed guidelines. What is important is that the script follow and not precede the form code.

    8. Save the page

    Please let us know if you need clarification on anything or experience any problems.


    Thanks

  • Profile Image
    JotForm Support

    Answered by abajan on January 13, 2014 at 08:54 PM

    Regarding Step 4, you could actually label the hidden field Contribution because the other field doesn't have that label.