concatenate value of two field in un 3 field

PHPMaker General Discussion (PHPMaker)
1

hello,
i have 3 field in phpmaker, 1 field with name DATAAPPUNTAMENTO and 2 field with name ORARIO, i wish value of this 2 field, concatenate in 3 field with name PRENOTAZIONE i have this code , but i can only put value of 1 field, how i can join value of all 2 field ? i wish value of prenotazione , give me all two value of dataappuntamento and orario , so if dataappuntamento have 08/06/2020 and orario 1500 , field prenotazione value must have 08/06/2020 1500
thank you
}

// Load form values
function LoadFormValues() {

// Load from form
global $objForm, $DATABASE;
$DATABASE->DATA->setFormValue($objForm->GetValue(“x_DATA”));
$DATABASE->DATAAPPUNTAMENTO->setFormValue($objForm->GetValue(“x_DATAAPPUNTAMENTO”));
$DATABASE->ORARIO->setFormValue($objForm->GetValue(“x_ORARIO”));
$DATABASE->PRENOTAZIONE->setFormValue($objForm->GetValue(“x_ORARIO”));
$DATABASE->ID->setFormValue($objForm->GetValue(“x_ID”));
}

2

You may simply use “Row_Inserting” (when add a new record) and/or “Row_Updating” (when edit a new record), for example:

$rsnew[“Third_Field”] = $rsnew[“First_Field”] . " " . $rsnew[“Second_Field”]; // adjust the fields name to your actual fields name.

Please read “Server Events and Client Scripts” topic from PHPMaker Help menu for more info and example.

3

hello thank you, please you can say me code i must change ? i have this code
$DATABASE->PRENOTAZIONE->setFormValue($objForm->GetValue(“x_ORARIO”));
i wish field PRENOTAZIONE , = Field x_orario and field x_nome
what i say write ?

4

Try (adjust the field name to your actual field name):

$rsnew[“PRENOTAZIONE”] = $rsnew[“ORARIO”] . " " . $rsnew[“NOME”];

5

thank you i have insert code
// Row Inserting event
function Row_Inserting(&$rs) {
// $rsnew[“PRENOTAZIONE”] = $rsnew[“ORARIO”] . " " . $rsnew[“NOME”];
// To cancel, set return value to FALSE
return TRUE;
}
in servers event /client scripts
but i have errore
Fatal error: Call to undefined method cDATABASE::Row_Inserted() /DATABASEadd.php on line 945

6

mobhar wrote:

You may simply use “Row_Inserting” …

Not in “Row_Inserted” server event.