I want to store the LabCode value in database as combination of LabName & LabID property. In LabCode field LabName value stored but LabID not stored. Can you please help me on this.
If the from value is 0 or a negative number, $EXTRACT returns a null string; however, if from is used with to, a from value of 0 or a negative number is treated as a value of 1.
But in other cases it can lead to the wrong result.
Use {%%ID}.
Here's an example:
Calling:
Returns:
Docs.
I want to store the LabCode value in database as combination of LabName & LabID property. In LabCode field LabName value stored but LabID not stored. Can you please help me on this.
Please refer below example.
If you want it stored, make it triggered computed like this:
Docs.
Note that it wouldn't recalc LabCode values for existing rows. If you need that, trigger recalculation with trivial update.
$EXTRACTdoc
Keep in mind that
, so instead
$EXTRACT({LabName},0,3)
should be
$EXTRACT({LabName},1,3)
In this case, it is uncritical, because
But in other cases it can lead to the wrong result.