Easter Sale 2025

  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!

TOPIC: Missing squential numbers

Missing squential numbers 12 years 7 months ago #18799

  • liam3
  • liam3's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 10
I am using the script to insert the sequential number into each submission.
Some of these sequential numbers are missing.
Does the script generate/allocate the number when the form is generated?
If someone bails out/cancels the form before confirmation, does it then drop that number (on going backwards and reentering the info it generates a new number)?
//<code>
$db=JFactory::getDBO();
$db->setQuery("SELECT COUNT(`SubmissionId`) cnt FROM #__rsform_submissions");
$db->query();
$result=$db->loadResult();
return intval($result)+1;
//</code>
Last Edit: 12 years 7 months ago by liam3. Reason: speeling
The administrator has disabled public write access.

Re: Missing squential numbers 12 years 7 months ago #18829

  • thithi2
  • thithi2's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 11
By your part of the code I could say that it only get the last number into the DB and do not put this number on it.
It does not give a clue why some number of yours is missing. Does it hapeens a lot?

Also, that´s not a good way to work into sequential numbers. Just because if there are two users using the form can cause both to have the same sequential number. It would be smarter to put it automaticaly by the DB.
The administrator has disabled public write access.

Re: Missing squential numbers 12 years 6 months ago #19354

  • liam3
  • liam3's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 10
i tracked the missing number issue to the fact that due to using several forms, the system allocates a sequential number to each form , not just the one with the add number script.

now if there was a way to use the ticket/support number sequentially instead of randomly..
The administrator has disabled public write access.

Re: Missing squential numbers 12 years 5 months ago #20023

  • majidps2
  • majidps2's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 6
  • Thank you received: 3
Dear Friends ,
I have this problem to , I used above code but i recieve duplicated numbers in my submissions because when more than one user load the form it happens ,
Did anyone know i can solve this problem ?
Thanks
The administrator has disabled public write access.

Missing squential numbers 12 years 5 months ago #20113

I have the same problem as majidps2. I would like to have a unique ID for each submission as I use the form to place order. Some IDs are the same and some are missing.

what is the best solution?
The administrator has disabled public write access.
  • 1

Read this first!

We do not monitor these forums. The forum is provided to exchange information and experience with other users ONLY. Forum responses are not guaranteed.

However, please submit a ticket if you have an active subscription and wish to receive support. Our ticketing system is the only way of getting in touch with RSJoomla! and receiving the official RSJoomla! Customer Support.

For more information, the Support Policy is located here.

Thank you!