• 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: sequential Number for forms

sequential Number for forms 12 years 6 months ago #20025

  • majidps2
  • majidps2's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 6
  • Thank you received: 3
Hi ,
I used Below code for generate Sequential number for my forms
//<code>
$db=JFactory::getDBO();
$db->setQuery("SELECT COUNT(`SubmissionId`) cnt FROM #__rsform_submissions");
$db->query();
$result=$db->loadResult();
return intval($result)+1;
//</code>

But when more than one user open the form and submit the number is duplicated ,

Please Help me , Thanks
The administrator has disabled public write access.

sequential Number for forms 12 years 6 months ago #20044

  • majidps2
  • majidps2's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 6
  • Thank you received: 3
Anyone can't answer me ?
The administrator has disabled public write access.

sequential Number for forms 11 years 7 months ago #25026

  • ounyai
  • ounyai's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 4
  • Thank you received: 1
Hi,

I am also having the same issue. When two or more people are using the form, there are duplicate numbers, how can this be prevented. Thanks.
The administrator has disabled public write access.

sequential Number for forms 11 years 7 months ago #25079

  • upbm
  • upbm's Avatar
  • OFFLINE
  • Junior Boarder
  • Posts: 34
  • Thank you received: 4
hello,

Modify your script with the new one that is shown here.
www.rsjoomla.com/support/documentation/v...for-submissions.html
This script should be executed only when processing the form.

Older scripts documentation were updated.

Didier.
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!