Need only the dollar amounts of donation to appear in excel

  • Profile Image
    SUAA
    Asked 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

  • Profile Image
    abajan
    Answered 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
    SUAA
    Answered 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
    abajan
    Answered 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
    abajan
    Answered 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
    abajan
    Answered 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.