Hello there,
This is my object :
My goal is to set the value of Numero like this : BCUSA24PR04152024
Keep in mind that the last 8 caracters (04152024) is based on the value of Date.
Can someone help me to do this ?
Thanks !
you might want to use the change node with a Jsonata expression, something like the follow flow:
[{"id":"9f18f65b9f1c09fb","type":"inject","z":"42e3d9cace994979","name":"","props":[{"p":"payslip","v":"{\"Numero\":0,\"Date\":\"15/04/2123\",\"Code Journal\":\"GS\",\"Exercise\":234}","vt":"json"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","x":855.1428833007812,"y":817.7142944335938,"wires":[["89b5f7eb75d15a3d","7a1dcb12dda9c30e"]]},{"id":"89b5f7eb75d15a3d","type":"change","z":"42e3d9cace994979","name":"","rules":[{"t":"set","p":"payslip.Numero","pt":"msg","to":"\"BCUSA24PR\" & $replace( $$.payslip.Date, \"/\", \"\")\t","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":1220,"y":819,"wires":[["8d90c064c9fb345c"]]},{"id":"8d90c064c9fb345c","type":"debug","z":"42e3d9cace994979","name":"Changed Value","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payslip","targetType":"msg","statusVal":"","statusType":"auto","x":1583,"y":933,"wires":[]},{"id":"7a1dcb12dda9c30e","type":"debug","z":"42e3d9cace994979","name":"Original Value","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payslip","targetType":"msg","statusVal":"","statusType":"auto","x":1164,"y":700,"wires":[]}]
Edit: updated the flow to be correct and use Jsonata.
