Auto Generate numbers

[loudy]

Hello,

I would like to create a simple table, that has a field:
Offline Student ID# [Auto generate with 4 digits number like: 0001]

Any tips. thanks,

 

[loudy]

Hi, while I'm search I found this post: http://fabrikar.com/forums/index.php?threads/create-an-auto-increment-numeric-field.38311/

but still not sure how to get the 4 digits

 

[loudy]

Hi, any guidance, please.

 

[loudy]

Hi, any guidance, please.

 

[troester]

Do you want to store this as a string in the DB?
Or just display?
What do you mean with "autogenerate"? (Autogenerate could be a totally random number)

 

[loudy]

Hi Troester,
Thank you for great support.

What I'm looking to do is a simple form that will has:

Student ID: 4 didits #
First Name:
Last Name:
Email Address:

So on New Record:
Student ID: 0001
First Name: John
Last Name: Sam
Email Address: John.sam@yahoo.com

On save, email will be sent out to the administrator and to the email address in the form with the new Student ID #.

(Autogenerate could be a totally random number) = a Sequential Number such as: 0001, 0002, 0003 ... etc.

Please help.

 

[loudy]

Hi,

please any guidance that can help me to achieve this

thank you so much

 

[cheesegrits]

You'd have to write some custom code in a form PHP plugin, running 'onAfterProcess', which creates your ID from the rowid (primary key element) value, and manually updates the row. It can't be done during normal form processing, as the PK (rowid) value isn't created until the row is saved to the database, as its the database that assigns the auto-incrementing PK.

-- hugh

 

[loudy]

I thought I can do that with the calculation to generate the number or just a simple way to do that.

 

[loudy]

Is that possible to change the auto ID that created when create a list to 4 digits?
when creating a list: ID and Date auto generated.
So I'm thinking to use that id and change it to 4 digits and use it as student ID?

 

[coullet]

You can't change internalID format...

I think you can't do that without some php code. You can also use sql trigger.

 

[cheesegrits]

As I said, the only way within Fabrik that works for your requirements is a form plugin. Can't use a calc, because the PK value won't exist during the submission phase when the calc's are run.

So a PHP form submission plugin, running "onAfterProcess", something like ...

$rowid = $formModel->formData['rowid'];
if (!empty($rowid)) {
   $myId = sprintf('%04f', $rowid);
   $myDb = JFactory::GetDbo();
   $myQuery = $myDb->getQuery(true);
   $myQuery->update('yourtable')-.>set('yourid = ' . $db->quote($myId))->where('id = ' . $myDb->quote($rowid));
   $myDb->setQuery($myQuery);
   $myDb->execute();
}

Change the table and field names in the query to suit.

-- hugh

 

[loudy]

Thank you Hugh,

Just want to be in the right track:
so I have added php plugin in the forms section, and I selected onAfterProcess
here is my full table:

 

[loudy]

Thank you Hugh,

Just want to be in the right track:
so I have added php plugin in the forms section, and I selected onAfterProcess
here is my full table:


and here is my complete code:

$rowid = $formModel->formData['mtoofflinestudent___offlinenumber'];
if (!empty($rowid)) {
$myId = sprintf('%04f', $rowid);
$myDb = JFactory::GetDbo();
$myQuery = $myDb->getQuery(true);
$myQuery->update('mtoofflinestudent')-.>set('mtoofflinestudent___offlinenumber = ' . $db->quote($myId))->where('id = ' . $myDb->quote($rowid));
$myDb->setQuery($myQuery);
$myDb->execute();
}


Am I in the right track, please. not sure which fields that need to be changed.

Thank you so much.

 

[cheesegrits]

In the first line, put rowid back.

In the set(), remove the table name prefix, just offlinenumber.

Sent from my HTC One using Tapatalk

 

[loudy]

Hi, thank you again for your kind help,
I have followed you steps, but the number is still not generated in the [offlinenumber] filed;


any tip

 

[troester]

I assume there's an additional .
$myQuery->update('mtoofflinestudent')-.>set('mtoofflinestudent___offlinenumber = ' . $db->quote($myId))->where('id = ' . $myDb->quote($rowid));

Do you J! error reporting enabled?

 

[loudy]

Hi, here is my setting for the form php:

Not sure still not add the number to the student id filed.

 

[troester]

Can you copy/paste the code (the screenshot is hard to read)?
But it seems you still have the ., remove it.
ent')-.>set

 

[loudy]

here is my complete code:
---------------------------------------------------------

$rowid = $formModel->formData['rowid'];
if (!empty($rowid)) {
$myId = sprintf('%04f', $rowid);
$myDb = JFactory::GetDbo();
$myQuery = $myDb->getQuery(true);
$myQuery->update('mtoofflinestudent')->set('offlinenumber = ' . $db->quote($myId))->where('id = ' . $myDb->quote($rowid));
$myDb->setQuery($myQuery);
$myDb->execute();
}

---------------------------------------------------------

I have removed the . from :
now I got:

Whoops\Exception\ErrorException thrown with message "Call to a member function quote() on null"

Stacktrace:
#0 Whoops\Exception\ErrorException in /folders/plugins/fabrik_form/php/php.php:453