Hi Community,
I have a Returns section with the "Total amount of return per request" field whose value must be filled by adding the "Ticket Cost" of the data from the Tickets detail.
How can I create a business process for the same.
Sharing the screenshot for reference.
For example: Considering the screenshot attached here, the value in the "Total amount of return per request" field should be sum total of the "Ticket Cost" of the data from the Tickets detail, i.e., 2272
Thanks in advance.
Dolly Priya
Like
Hello Dolly,
You need to create a process that will be triggered upon record adding to "Tickets" detail (using "Signal 1" process element) that will read this added record using "Read data 1" process element. Then this process should read "Returns" section record that is related to the record added to "Tickets" detail on "Signal 1" step (so to get the current value of "Total amount of return per request" field) using "Read data 2" process element. Then you need to add "Modify data" element that will edit related "Returns" section record "Total amount of return per request" field as a sum of exiting value read in "Read data 2" process element and "Ticket cost" field value from "Read data 1" process element. So something like on this screenshot http://prntscr.com/r7xb1p.
Please also note that the process will only work in case there is already some value for "Total amount of return per request" field and for new records added to the detail, so you need to update existing "Returns" section records with proper current values (using SQL update query).
Best regards,
Oscar
Oscar Dylan,
Hello Oscar,
in this case i made the sol and work correctly with Ticket added Signal and Ticket Modified Signal but doesn't work with Ticket Deleted Signal why ?
thanks
Ibrahim Nour El-Din,
Please un-check the checkbox "Run following elements in the background" for the business process with a start signal "Record deleted", it should resolve the issue.
In case the issue persists, please provide us with a screenshot of your business process along with it's settings.
Best regards,
Anastasiia
Anastasiia Zhuravel,
thanks for your reply,
i was missing something and i did it and worked correctly
thanks
Anastasiia Zhuravel,
Dears in my case using Creatio 7.18.3 didn't works to manage when a record is deleted, the trigger works, but when read data, get error