Before submit AJAX request

hard to suggect anything without knowing your background. Do you know PHP? Can you handle SQL request to the DB yourself?

Hi Sergey!Thanks for dealing my problem.

Now I use an sql query in my form template php to get the amount of records in the category and than add +1 to it ($sorszam). One of my fields get this value. I use composite title and it's value is based on this field.

// Get a db connection.
$db = JFactory::getDbo();

// Create a new query object.
$query = $db->getQuery(true);                             
$query->select('COUNT(*)');

$query->from($db->quoteName('#__js_res_record'));
$query->where($db->quoteName('type_id')." = 1" );
$db->setQuery($query);
$amount = $db->loadResult();
$sorszam = $amount+1;

My problem is that if more than one people try to submit record at the same time there will be duplicated titles because the title is computed at form entry. To solve this I'd like to run the query and add value to my field before submit.

Then you have to create plugin onBeforeArticleSaveв event

http://docs.mintjoomla.com/en/cobalt/cobalt-events/

Thanks but I can't build the query inside plugin my php and ajax knowledge is poor.

I only can recommend you comething like linda.com to learn or getafreelancer.com to hire in this case.

Sergey!

Do you have any other idea to my problem. I don't insist to the solution above. In your opinion is there any other solution to add individual title to records based on number of pieces (number of records)? Or do you undertake this for additional money?

So you need sequential number in the title? Can you tell me more why number have to be sequential? How important it is that it is series of numbers and not simply random generated code like S45DF, 20J45, ...?

Sorry but yes, I need sequential number because in this section there are orders and this way it is more transparent for my colleagues and clients. Random generated codes are not too communicative.

But you also have a date right. This may give a clean explanation on order. Look PayPal uses rand.