[pratyush]

Hi all,

I have created a dyna form 'customers details' and i create a table 'customers' in database 'wf_processm' through phpmyadmin. So how can i insert dyna form fields values in 'customers' table when form is submitted or how can i use trigger for inserting values in 'customers' table.

I'm new on this processmaker, so please help me.


Thanks
Pratyush

[liliana]

Hi,

Check this post, you will find the code and an example of how to insert information of your DynaForm in a table.

Regards.

[pratyush]

Thanks Liliana, for your help.

This example is very helpful for me.


One more help please.

I Create a trigger 'customer Id'. the code is below


$selprocess = @@SelectProcessType;

if($selprocess == "2"){

$a = "S";

}elseif($selprocess == "3"){

$a = "M";

}else{

$a = "";

}


$b = @@SelectCustomer;
// die();




$query = mysql_query("SELECT customerName FROM CUSTOMERS WHERE id =".$b) or die(mysql_error());

$rows = mysql_fetch_array($query);

$customername = $rows['customerName'];

$c = substr($customername, 0,3);

//die();

$Data = mysql_query("SELECT generateID FROM PROJECT_ID") or die(mysql_error());

$customerID = mysql_fetch_array($Data);

$rs = $customerID['generateID'];

//die();

if($rs!=''){
$customer_Id = $rs + 1;
}

@@ProjectID = $c."00000".$customer_Id."-".$a;

Here @@ProjectId is a variable and i want this @@ProjectID assign this variable to next form when first form is submitted where @@ProjectID is form field.

This code gives the value of $c and $rs. and i insert this trigger after form submission. but when i submit form then it gives Error that- "it is not possible to execute the query. Please contact your system administrator";

What is this error? please help me.


Thanks

Pratyush