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.
Match Forms with Paypal TransactionsAsked by audabee on September 18, 2013 at 05:48 PM
Sorry if I'm not clear.
Basically we've got a number of forms collecting money & details for events. Our issue comes when we try to reconcile the monies collected with the events - e.g. which is which?
So, is it possible to pass a field through to PayPal which identifies the form or transaction, that is in our case "golf day" or "trivia night"?
In the attached form is there a way of adding a (even hidden) field that will appear on the information in PayPal?
Hello, unfortunately matching the form with paypal transactions is not possible at this time. Although the feature has been requested and is already on the request feature list.
What I would suggest is to use a more descriptive name of the item pusrchased:
For example the Members item is data that wast sent form the form to paypal. If you add a more descriptive Item name maybe you could consolidate the data this way.
Kindly let us know if you need further assistance. Thank you.
The information from the form simply comes across as "Shopping Cart". There is no mention of Members/Non-Members (i.e. the form item descriptions) etc.
I do notice though that on our one subscription type form (which is collecting single membership amounts) that the description is "Membership in advance of The Club".
Even being able to name the "shopping cart" would be helpful.
I will go ahead and pass along your input to the Development Team, now, I am not able to provide an ETA or promise if this feature will ever be implemented, nevertheless the Development Team will review this case and evaluate if the feature is feasible.
No worries, Cesar - I totally understand. I'll think about how to work around the problem in the meantime.
It is now possible to pass form field data to a Paypal transaction. Simply right-click on your form's payment module then choose 'Show Properties'.
Note: only text box, hidden box, and unique ID fields are allowed.
Thank you so much for getting back to me, NeilVicente!
Just to clarify a point - in the form mentioned below, if I select the hidden field (PIA Membership) at the bottom, will the title or the incremented ID be passed to PayPal? Either way, this is a great help for us.
Yes, that is correct.
NeilVicente as discussed in this thread, there may be a bug with this feature. The completed transaction emails weren't coming through when this feature is used but started again as soon as I turned it off.
Please let me know the name of the form that gives this problem when using the new feature. I will get back to you after I finish my investigation.
It's happened with two forms:
http://form.jotformpro.com/form/30678940168968 (this is the one where I first turned off the feature and completed emails then started again). I added a new hidden field called "Christmas Party" and;
http://form.jotform.co/form/22870389075866 same for this one. This one I used an existing hidden field called "PIA Membership".
I had both field enabled at the same time, and no confirmation emails came in. Then, I disabled the field in the first one and emails again started.
Thank you for that information. I will send you an update soon.
Please accept our apologies for the inconvenience.
Sorry for the late update.
JotForm used to send internal data (form id and submission id) as custom data to Paypal. This is used by our system to identify which submission has been "completed". When I implemented your request, I have overlooked this fact, resulting to completed submissions ending up in the 'Incomplete' section.
But since there is a need for our users to match the submissions themselves, I have prepended the custom field data to our internal data.
From now on, custom data will show up on your Paypal account like this:
Hope this solution works well for you. Please let me know if you encounter any problems from here on out.
I'll give it another try.
Edited to say that I've looked at the CSV from the earlier tries (where the transactions didn't complete) and the value does appear in the "Custom Number" field. Awesome!
That's good to hear :)
Sorry to ask the same question. and perhaps I am not understanding the solution provided.
My form also needs to send something to paypal, to match the payment to the registration form Sometimes our patrons will register user A in our form, but user B will be the one paying for it. For that we would like to send paypal a field we can match with the form in jotform report.
Is this what is being solved here?
my form http://www.jotform.com//?formID=33338147689971
Yes, the solution offered should be of help to you. It is possible to send a field's value to Paypal, but only the following field types are allowed:
- Text Box
- Hidden Box (widget)
- Unique ID (widget)
Kindly follow the instructions I have laid out above to start sending a custom field to Paypal. If you have further questions or concerns, please do not hesitate to ask again, although we'd appreciate it if you can open a new thread thereafter.
I tried to do this for the form:
However, I do not get the option to send "My custom field" to PayPal, i just get a list of the required fields that I put in my form.
Kindly create a new thread to avoid any confusions with what is originally discussed in this thread. As we are working on a one issue per thread basis. Thank you.