Unique identifier

More
13 May 2016 15:53 - 10 Dec 2018 11:10 #1 by Demis [Fox-Labs]
Demis [Fox-Labs] created the topic: Unique identifier
The "unique identifier" field, also called "ticket number" or "case id", generates a unique "service number" for the submission.
It supports series to separate different sequences.
The placeholder {UniqueIdentifier} can be used to represent the ticket number in the On Screen Notification message, and in the notification email.

How to reset the counter for one unique identifier?
The easiest way is to create a new series. Just specify a new series in your Unique Identifier field properties. In most cases, this also reflects what you are actually doing in the real life. For example, if you are launching the second edition of a Photo contest, just specify the series "2nd ed." or "2018". The new counter will automatically start from 0, and you're good to go.

If for some reason, you need to keep the same series while restarting from the beginning, then you have to edit your Joomla database. Remove the corresponding record in the table #_foxcontact_sequences. Remember to replace the hash symbol with your unique Joomla table prefix.
Here are two SQL examples:
DELETE FROM `#_foxcontact_sequences` where `series` = ''
or
DELETE FROM `#_foxcontact_sequences` where `series` = 'my series'
Keep in mind that using this hack, your Unique Identifier is no longer technically unique, as you are going to receive for the second time new enquiries starting from the beginning of the sequence. However, if this is really what you want, you can proceed.

Please pay particular attention while editing your database. Any error here will cause unwanted side effects that we cannot predict right now. You should do it with care and under the guidance of a database expert.

Please Log in or Create an account to join the conversation.