assign unique registration id

Welcome, Guest

assign unique registration id

(1 viewing) (1) Guest

Page:
1

TOPIC: assign unique registration id

assign unique registration id 2 years, 2 months ago #10014

Lauri Komita OFFLINE Senior Boarder Posts: 41	Is there a way to have an entry be assigned a unique id number when it is entered?
	Reply Quote

Re:assign unique registration id 2 years, 2 months ago #10052

Bogdan Catana
NOW ONLINE
Moderator
Posts: 656

Hello,

You can add the following code in the Default Value of a Hidden Field (named for example "index" ):

//<code> 
return "REGISTRATION NUMBER-".str_pad(intval(@mysql_result(mysql_query("SELECT COUNT(`SubmissionId`) cnt FROM ".$RSadapter->tbl_rsform_submissions." WHERE FormId=1"),0)),3,"0",STR_PAD_LEFT); 
//</code>

Note that you will have change the FormId to the id of your form. Now each submission will be given a registration number equal to their submission number.

If you use RSForm! Pro, please post a rating and a review at the Joomla! Extensions Directory.

Reply Quote

Re:assign unique registration id 2 years, 2 months ago #10089

Lauri Komita OFFLINE Senior Boarder Posts: 41	well, this did work. but it seemd to only work on a form with autogenerate layout. so I probably need to manually place the hidden field in the layout? thanks for the information.
	Last Edit: 2 years, 2 months ago by Lauri Komita. Reason: found answer Reply Quote

Re:assign unique registration id 1 year, 10 months ago #10768

Lauri Komita OFFLINE Senior Boarder Posts: 41	We used this for an event registration and it does work. However, we had many problems with duplicate registration numbers when several computers were being used at the same time. How do we make the number assigned be unique/primary?
	Reply Quote

Re:assign unique registration id 5 hours, 1 minute ago #0

RSJoomla! Support Bot
OFFLINE
Moderator

Hello,
This is an automatically generated message.
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 wish to receive our 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: http://www.rsjoomla.com/support-policy.html.

Thank You!
PLEASE NOTE: This topic is NOT locked and you can add replies to it. Other users are free to reply as well. This message has been generated by a bot and has no effect on the topic whatsoever.

Need help ? Submit a ticket!

Reply Quote