Dear all,

I'm tryting to add a counter in my RSForm registration, by using the code below in the defaul value field. When adding {counter:value} in the email text, there is no result.

The table in my MySQL data base is named jos_forme_data and the column name is id, like in below code. Anybody who can help me on this?

Thanks!

BR,
Vlimper

//<code>
$db = JFactory::getDbo();
$db->setQuery("SELECT COUNT(`id`) FROM jos_forme_data" WHERE form_id='".(int) $form_id."'");
return $db->loadResult()+1;
//</code>

I don't know if this code will work in the default value of all versions. Seems like in my Joomla 1.5 it did not work. I haven't checked the changelog in detail to figure it out.

I'd suggest putting it in the PHP Scripts under "Script called on form process" section something like this:
I used this code as a submission counter (to create an invoice number), but you can replace my query with yours. Like this: $db->setQuery("<QUERY HERE>");
Also, replace 'counter' in my code with with your field name. I would set the default value of the field to "0". Whatever you set: $_POST to is what will be saved in the database after the form processes.

Note FormId=3 in my code: you will need to form id to something right now in your code its just a variable name. And check if its form_id or FormId in your version- that is the field name and it will cause the query to cail if its not correct.