www.hkvforums.com

Hi,

Can someone who has a working code help me.

I'd like to auto-generate a user submitted tickets codes.

The structure I want is DI-0001...n.

"DI-" is the constant part; "000x" wil grow incrementing by one unit according the last number used.

The field which contains the number is named "N°DI"

The field which contains the generated code is named "CodeDI"

THANKS

To create the default value of the ticket code with below steps.

1. Get the max from the field "N°DI" with ew_ExecuteScalar().
   e.g.
   $maxid = ew_ExecuteScalar("SELECT MAX(<Field>) FROM <TABLE>");

2. Calculate the new ID
   e.g.
   $newid = maxid + 1;

3. Construct the ticket code using str_pad() PHP function then use it as the default value in Row_Rendered Server Event.
   For example:
   if (CurrentPageID() == "add")
   $this-><Field>->EditValue = <New Code>;

Read help file topic: "Server Events and Client Scripts" -> "Some Global Functions" for more information.

Hi,
This is my last code In Page Render event

$bcode="000";
$maxid = ew_ExecuteScalar("SELECT MAX("IDDI") FROM t_di");
$newid = $maxid + 1;
$code=str_pad("$bcode", 4, $newid, STR_PAD_RIGHT);

1 - Is it the right place to ru it?
2 - Could you check my logic.

THANKS

... in Row_Rendered Server Event.
For example:
if (CurrentPageID() == "add")
$this-><Field>->EditValue = <New Code>;

THANKS
IT works now.

I put the code generating function in global Code then called the function from Default value tag of the field.

Best Regards