How can I split a field into 3 different fields (columns)?
Example: field value 345-9871-265
The – would be the split factor. One field 345 and other 9871 and the other 265.
This can be achieved by small Java rule.
$form.getValue("xPath").split("-"); will give the first part
$form.getValue("xPath").split("-"); second part and so on.
Please see attached solution as an example; Review and let me know if you need further assistance with this.
Same code can be written for Repating table only Xpath field name will be the name of column. Attached example has both scenarios ; it has been created in version 12.0.
Please sign in to leave a comment.