Payl Pal Payments, limit submission #'s and incomplete payments

  • Profile Image
    jaycw7
    Asked on August 29, 2012 at 01:34 PM

    Hi

    I am setting up forms to accept payment via paypal but I will only have a limited number of products available and so I will want to have the form hide the submit button once that limit is reached which I will do with the conditions.

    BUT, I am wondering if someone hits the submit button and gets redirected to paypal and does not complete the payment, will that still count as a submission?  And does only a completed payment result in a submission?

     

    I will use the Form ID widget

    Lets say I  I only have 20 of these products available and so I set a condition that when the form hits 021 it hides the submit button, and shows an image indicating that we are sold out.  Will those numbers only increase on the FORM ID, once a payment has been successfully processed or does it increase as soon as the submit button is hit regardless of the outcome of the payment? 

    I hope I am making sense.  You guys are pretty good at figuring out my convulted inquiries

  • Profile Image
    gori-mathew
    Answered on August 29, 2012 at 02:18 PM

    Hi,

    Thanks for contacting us. Complete submission are fully paid and submitted forms.

    For Unpaid submissions they  are kept on your submissions page's Incomplete Payments section.

    These are not considered (and counted) as a submission, so you will not receive an email alert for it, nor will it be added to your form's submissions count.

    You can forward them to your form's submissions by clicking the Complete Submission button:

  • Profile Image
    jaycw7
    Answered on August 29, 2012 at 02:23 PM

    Awesome thanks.  Lets say I have the limit set at 020 (using conditions and unique ID widget) and a person fills out a form (we'll call it #006) and it results in an incomplete payment.  Will form 006 remain incomplete until it gets paid or deleted or does it only get considered # 006 once the payment has been completed and submitted?

  • Profile Image
    gori-mathew
    Answered on August 29, 2012 at 03:05 PM

    Since an incomplete payment (#006) happens when someone who submitted your form did not continue with the payment process such as logging in to Paypal and paying for the amount to be paid. 

    You can try contacting them and asking them why they did not complete the payments. Otherwise you may delete them since if you complete the submission such that they are completed any submitted, this does not charge the user who submitted the form and will only get considered as one payment submission hence deducted from your payment form quota.

    You may have a look at the link below for more guidelines.

  • Profile Image
    jaycw7
    Answered on August 29, 2012 at 03:15 PM

    Sorry...I'm not following...that response didn't make sense to me.  I'm just going to need to try it out and see what happens I guess.

    I'm wonder if while that incomplete submission (006) is in limbo would the next submission (person who wants to buy) filling out form # 006 or would that make it 007?  

     

    Does that make sense?  I need strict limits on the # of purchases available.  I'm going to be doing a big discounted sale but will only have a limited # of products available at that price.  If I set the forms to be limited by using the unique ID and conditions ( all fields are hidden when the unique ID hits 021) so that no one can purchase the product, I can't have any number of those 20 be used up from incomplete purchases.  I need to know if it only counts in the system once the payment has been submitted and successfully completed and the person has submitted the form.

  • Profile Image
    NeilVicente
    Answered on August 29, 2012 at 04:37 PM

    @jaycw7

    Essentially, each submission (whether ultimately paid or not) is initially considered as incomplete. Therefore, all submits will trigger the Unique ID field to increment.

    I perfectly understand what you're trying to achieve with this. However, the way JotForm currently works won't make this possible. We apologize for these shortcomings.

    I can imagine a workaround involving the use of custom PHP scripts. I am not sure if it's worth the time and effort though.

  • Profile Image
    jaycw7
    Answered on August 29, 2012 at 05:39 PM

    Thanks Neil.  Having this be the case is absolutely vital to much of what I am doing so yes it would be worth the time and effort otherwise I will need to use another service when it comes time to launch.  What would be involved in creating/utilizing those custom scripts?  Someone has to have done this before so it can just be duplicated, no?

    Thanks again

  • Profile Image
    NeilVicente
    Answered on August 29, 2012 at 05:57 PM

    Now that you asked, I remember that there is a guide created by one of our able colleagues that may help you achieve the same effect.

    http://www.jotform.com/help/169-Create-a-submission-limit-using-JotForm-with-PHP-and-RSS-Reports

    I personally have not tried it, so I will have to test it and get back to you for updates.

    I hope it does work though, because the workaround I had in mind involves a LOT of custom programming.

  • Profile Image
    jaycw7
    Answered on August 29, 2012 at 06:35 PM

    Thanks I hope this works.  If it doesn't, what happens next?  

     

    I tried downloading the PHP file and I have no idea how to upload it to my site or what I am supposed to upload.

    I also have no idea what #4 is talking about.

  • Profile Image
    jaycw7
    Answered on August 29, 2012 at 06:40 PM

    Sorry guys.  Forms are going to be absolutely vital to what I am doing and I need this feature.  I am pre building my forms and testing them before we launch and we are expecting heavy traffic.  At which point I will be buying the professional package.  I need to know things will work properly first hand.  Any help as you know is much appreciated

  • Profile Image
    jaycw7
    Answered on August 29, 2012 at 07:17 PM

    I'm about to run myself through with a sword :)

  • Profile Image
    jaycw7
    Answered on August 29, 2012 at 07:45 PM

    In the submissions ->incomplete payments section it says that incomplete payments are deleted every 30 days.  Is there a way to change this for particular forms where they delete after like 2 minutes?  Do is that system thats in place to delete the incomeplete payments something that online operates across all forms and for the entire site as awhole?

  • Profile Image
    NeilVicente
    Answered on August 29, 2012 at 07:46 PM

    I am still on the process of testing. I will get back to you as soon as possible. Thanks!

  • Profile Image
    jaycw7
    Answered on August 29, 2012 at 07:51 PM

    You guys are unreal.  Seriously.  I'm not even a paying customer yet and how on the ball you are with things.  Its simply second to none.  I am a huge promoter and will keep on recommending your service BIG TIME.

    Thanks for everything thus far.  ANXIOUSLY waiting a reply...

  • Profile Image
    NeilVicente
    Answered on August 29, 2012 at 08:11 PM

    I was able to make the solution I suggested a while ago work as intended.

    However, I am not sure if it is optimized to accept large amounts of form submissions. I will have to talk with the author of the said guide.

    We will get back to you the next working day, after we figure out whether it can be adapted for your goal.

    In the meantime, check out the solution in action:

    http://www.sranrrr.com/limit-submissions.php

    That form is limited to 10 submissions. Refer to the form's RSS list below to see the form's submissions (currently empty):

    http://www.jotform.com/rss/22417494866060

  • Profile Image
    jaycw7
    Answered on August 29, 2012 at 08:19 PM

    Thanks Neil.  I just tried it out and submitted 12 or so and they all went through.  I'm hoping we can find a solution...

    Thanks so much for your help!

  • Profile Image
    jaycw7
    Answered on August 31, 2012 at 02:13 PM

    Any word on this?

  • Profile Image
    Mike_T
    Answered on August 31, 2012 at 05:19 PM

    It looks like that Neil's work around is working fine. Mentioned above page is showing pre-defined "You can no longer submit an entry" warning message instead of the form.

    You can try to follow the next article to set up something similar:

    Create a submission limit using JotForm with PHP and RSS Reports

    Note: Your server have to support PHP, otherwise you will not be able to run PHP script.

    I think that Neil will get back to you as soon as he is available.

    Thank you for cooperation.

  • Profile Image
    jaycw7
    Answered on August 31, 2012 at 05:25 PM

    Yeah I checked it again this morning and it did show that but when I filled out the forms the other day, it let me fill out more than the limit of 10.  

    I also have no idea what half the instructions in that article mean.  

    Is it possible to embed a form like this into facebook still or will it only work if used directly on my website?

    Also, I will need a lot of forms like this and I don't suppose they can just be duplicated?  How long does it take to set this up approximately?

    Thanks again guys, you're awesome.  I hope this solution works becasue I really want to support JotForm

  • Profile Image
    Mike_T
    Answered on August 31, 2012 at 07:18 PM

    Yeah I checked it again this morning and it did show that but when I filled out the forms the other day, it let me fill out more than the limit of 10. 

    I am not sure how that happen, but I hope that script developer (Liyam), can help us to sort this out. We will get back to you as soon as we have any updates.

    Is it possible to embed a form like this into facebook still or will it only work if used directly on my website? 

    I think that you will be able to create a webpage on your website, and them embed that web page to your Facebook.

    Also, I will need a lot of forms like this and I don't suppose they can just be duplicated? How long does it take to set this up approximately? 

    It should not take much time, maybe a few minutes per form when you know what to do.

    Thank you for your kind words :)

  • Profile Image
    NeilVicente
    Answered on September 01, 2012 at 07:37 AM

    @jaycw7

    Yeah I checked it again this morning and it did show that but when I filled out the forms the other day, it let me fill out more than the limit of 10. 

    Did you use your browser's back button after filling out the form? Apparently, the script only checks the submission upon page load. That means the form can be submitted again and again simply by pressing the back button. I don't think your users would do that anyway since your form will redirect to the payment page.

    I also have no idea what half the instructions in that article mean. 

    We will have to revise the guide to make it easier to understand for people with very little PHP knowledge. Also, the scripts need to be optimized for large-scale uses.

    Unfortunately though, I wasn't able to talk with the guide's author. We'll get back to you as soon as we sort this out.

  • Profile Image
    jaycw7
    Answered on September 01, 2012 at 01:35 PM

    Thanks Neil.  I will wait to to hear back. Fortunately I am only doing 10-50 submissions at a time which isn't a ton more than what you had set up.

     

    I am also looking at just setting up a shopping cart to look after this task but now the problem I am finding with them is I am so limited in how many email notifications I can set up and I need to have a specific email notification per product sold (which I could do using the forms)

    I also like how shopping carts provide excellent reports re: sales and I cannot automatically do this with a form builder....unless youi know of a plug in that does this?

     

    Thanks!

  • Profile Image
    Deygus
    Answered on September 01, 2012 at 04:25 PM

    Hi Jay, I apologize in advance because currently the answer to your shopping cart question is unforuntately no. This is just not something that can't be done right now. I suppose it could become possible in the future maybe since technology advances roughly every 3-6 months but that is something that I can not say for sure of even when or how if at all and I am certain our developers will be looking into it if they havent already started when they have time so long as they aren't busy with higher priority issues. The only thing besides that is the possibility to use our form builder to host a product form that sells products via our providers lists such as google checkout, paypal, and other providers on the payment tools list that is able to calculate the quantities for such. However, this is more of a means to accept payments and its not necessarily a shopping cart per say. Please see these threads: http://www.jotform.com/answers/121603-Is-there-an-add-to-cart-feature and http://www.jotform.com/answers/24754-I-need-a-shopping-cart-for-PayPal and http://www.jotform.com/answers/2396-Is-there-a-future-for-Jotform-and-carts

    I hope this helps clear some of this up but if you have more questions let us know so we can clairify.

  • Profile Image
    jaycw7
    Answered on September 01, 2012 at 04:44 PM

    Sorry, maybe I didn't explain properly.  As an alternate solution to aforementioned problems, I was considering just using a shopping cart service such as Magento etc instead of trying to accomplish through JotForm but I think if we can nail down this solution that Neil has created and assisted me with then this will work find.

    The only real reason I would use a shopping cart service is to limit the amount of products that can be sold.  But it looks like Neil found a solution just need to know a bit more.  

     

    Also, I was curious if people had access to API?  I was wondering about getting my own programmer to create the solution I need.  Is this possible?

     

    Thanks guys

  • Profile Image
    Deygus
    Answered on September 01, 2012 at 04:57 PM

    No need to be sorry about anything, we are here to help you as much as possible and we are very willing to do whatever it takes to do so. Also, I deeply apologize if it seems that I misunderstood you. I assure you that I understand what you're trying to do loud and clear and hopefully my colleague Neil will get back to you with a promising solution along with contact of the author as he mentioned. For now though, I will begin looking more into API use and let you know once I find out more about it.

  • Profile Image
    jaycw7
    Answered on September 01, 2012 at 05:27 PM

    No need to apologize either!!  You guys are absolutely off the charts good!  I am constantly blown away with the quality of support, features and how inexpensive the service is.  

    I think we are close as far as a solution and am looking forward to hearing back.  Thank you all for your help

  • Profile Image
    jeanettebmz
    Answered on September 02, 2012 at 02:06 PM

    @jaycw7

    The API access is still under development. We hope to have this released in the near future

    Cheers!


  • Profile Image
    NeilVicente
    Answered on September 03, 2012 at 05:53 AM

    @jaycw7

    The form will be embedded on a PHP page that is hosted on your web server. Therefore, your server needs to be able to run PHP scripts.

    This PHP page will determine whether the form has reached the limit or not, then display or hide it accordingly.

    Let me know if you meet those requirements so we can proceed in implementing this solution.

  • Profile Image
    jaycw7
    Answered on September 03, 2012 at 12:41 PM

    Thanks Neil!

    I am with Blue Host and they do PHP.  As long as it accurately stops at a specified number and only after an order is successfully processed and doesn;t count incomplete payments this should work well!

    I assume it should only take afew minutes to implement?

    Can I set it up so if it is sold out it shows an image or page?

    Thanks you guys, much appreciated

  • Profile Image
    fxr
    Answered on September 03, 2012 at 02:14 PM

    @jaycw7

    The guide in Neils link should be quick to set up.

    If you want to show a 'Sold Out' image, just change the line:

    echo "You can no longer submit an entry";

    to

    echo "<img src="//link.to/where/myimageis.jpg";

     

    The formatting may need a little tweaking to get it looking how you would like, but go ahead and follow the guide and let us know if you have any questions or would like some help formatting elements on the 'thankyou page'.

  • Profile Image
    jaycw7
    Answered on September 05, 2012 at 06:16 PM

    Thanks guys.  I will forsure

  • Profile Image
    jaycw7
    Answered on September 05, 2012 at 07:42 PM

    Tried it and cannot get it to work. I replied via other threads if that is easier.

    Thanks