-
indianacrcAsked on January 24, 2016 at 11:00 AMMy 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 LeadReplied 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.
-
indianacrcReplied 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 SupportReplied 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!
-
indianacrcReplied 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 SupportReplied 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!