How to use Form Calculation Widget with Payment integrations ?

  • indianacrc
    Asked on January 24, 2016 at 11:00 AM
    My next question, and this really only applies to Meeting Rooms because the total price = ((Number of Days [*each day having a coefficient*]) x (Seated or Unseated) x (Square Foot [*using a QTY maybe in the integration??*])) + (Half Day Surcharge - if Yes = .1 x SquareFoot). So it's not a simple pick a predefined value. There are multiplication tables involved. Can this integration do form calculation logic like I have it set up in Jotform? To view on the form below select Meeting Room for both Event Space and Confirm Event Space and you can play with the Meeting Room section to get what I need to build next.
  • Kevin Support Team Lead
    Replied on January 24, 2016 at 11:10 AM

    Hi,

    That logic only can be handled by the Form Calculation widget, if would like to pass that result to the payment field then you would need to use a different method on your payment integration, you should use the option "Collect donations/Custom amount payments".

    Then pass the value from the calculation to this total field.

    Please, do let us know if you need help, we will be glad to assist you.

    Regards.

  • indianacrc
    Replied on January 24, 2016 at 7:29 PM

    Is there a way to do it more than once per form? I would like to do it 13-16 times depending no which options are selected from hidden fields.

  • Ashwin JotForm Support
    Replied on January 25, 2016 at 4:46 AM

    Hello indianacrc,

    I am not sure if I have understood your requirement correctly. Do you mean to say that you want to have 13-16 conditions in your form?

    Please be noted that you can have any number of conditions in your form but since only one payment tool is allowed in form, you can read the calculation of only one form calculation widget. Please take a look at the following guide on how to pass calculation data to payment field:  http://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field 

    Hope this helps.

    If you meant to ask something else, do get back to us with a question a little more in detail and we will surely help you.

    We will wait for your response.

    Thank you!

  • indianacrc
    Replied on January 25, 2016 at 7:28 AM

    I mean to say that it looks like it is only a single line/condition that can be integrated per form - where I need 13-16 lines/conditions integrated into an invoice from the Jotform.

    It needs to be something like this:

    Sales Agent completes the form.

    Form fields are integrated to an Invoice where Sales Managers can look it over and send it out to the client.

    Here is the Sales Agent form : https://form.jotform.com/60242285356151

    Sales Agent will fill it out and I need to pass these field IDs to FreshBooks in an invoice format:

    RC Sales Quote (Pull)

    --------------

     

    Invoice Tracking Number

    ID: #input_99

    Name: {invoiceTracking}

     

    Date:

    ID: #month_1, #day_1, #year_1

    Name: {date1}

     

    Client Organization

    ID: #input_52

    Name: {organization}

     

    Client Address

    ID: #input_87_addr_line1, #input_87_addr_line2, #input_87_city, #input_87_state, #input_87_postal, #input_87_country

    Name: {clientAddress}

     

    Confirm Space Purchased

    ID: #input_5

    Name: {confirmEvent}

     

    Meeting Room Size

    ID: #input_7

    Name: {meetingRoom}

     

    Meeting Room Type

    ID: #input_8

    Name: {meetingRoom8}

     

    Number of Days

    ID: #input_9

    Name: {numberOf9}

     

    Half-Day Surcharge Total

    ID: #input_13

    Name: {halfdaySurcharge13}

     

    Event Space Total

    ID: #input_15

    Name: {eventSpace15}

     

    Modify Chairs

    ID: #input_16

    Name: {modifyChairs}

     

    Modify 6' Tables

    ID: #input_17

    Name: {modify6}

     

    Modify 8' Tables

    ID: #input_18

    Name: {modify818}

     

    Modify Total

    ID: #input_19

    Name: {modifyTotal19}

     

    Client URL

    ID: #input_77

    Name: {clientUrl}

     

    Directory Listing

    ID: #input_20

    Name: {directoryListing}

     

    Directory Listing Price

    ID: #input_21

    Name: {directoryListing21}

     

    Notes

    ID: #input_48

    Name: {notes48}

     

    Sub-Total

    ID: #input_55

    Name: {subtotal55}

     

    Early Bird

    ID: #input_24

    Name: {earlyBird}

     

    Discount Rate

    ID: #input_112

    Name: {discountRate}

     

    Adjusted Sub-Total

    ID: #input_56

    Name: {adjSubtotal}

     

    1/2 Price Passes

    ID: #input_30

    Name: {12Price30}

     

    1/2 Price Passes QTY

    ID: #input_32

    Name: {12Qty}

     

    1/2 Price Passes Total

    ID: #input_33

    Name: {12Total}

     

    Booth Style

    ID: #input_26

    Name: {boothStyle}

     

    Booth Style Total

    ID: #input_57

    Name: {styleTotal}

     

    Pipe and Drape

    ID: #input_59

    Name: {pipeAnd59}

     

    Pipe and Drape Deduction

    ID: #input_62

    Name: {pipeAnd}

     

    Deposit

    ID: #input_68

    Name: {depositPrimary}

     

    Grand Total

    ID: #input_69

    Name: {grandTotal}

     

    Addt'l Utilities

    ID: #input_83

    Name: {additionalUtilities}

     

    Agent Name

    ID: #first_43, #last_43

    Name: {agentName}

     

    Agent Number

    ID: #input_44

    Name: {agentNumber}

    -------------------------

    Is there a way to do that?

  • Ashwin JotForm Support
    Replied on January 25, 2016 at 8:52 AM

    Hello indianacrc,

    Okay so if I understand it correctly, you want to create a multi line invoice with FreshBooks integration. Is that correct?

    Since this seems to be a different topic, I have moved your question to a new thread and you will be answered here:  http://www.jotform.com/answers/754977 

    Thank you!