Add read data mode into business processes: "Read random record in the selection"

I was trying to choose a random user as a sender of the automatic email in Business process.
I wanted to avoid development in C#. Using only business process elements as in the cloud version. Creatio Sales Enterprise v.7.16.

The workaround I found for random is a formula like

RoundOff(DateTime.Now.Ticks / 17) % 2 == 0 ? "user1" : "user2"

This selects one of the strings "user1" or "user2", and by this string, whether it's Full name, Email, or else, the user can be determined.

But this works only for 2 users and crashes if any string changes.

 

I think such situations happen when we simply need to pick up a random element of selection.

 

But then I thought Creatio could add a new read data mode:

 

This isn't as complicated to implement, is it?

2 comments

Dear Yuriy,

 

Thank you for the idea! I will definitely pass it to our R&D team so they could consider implementing the following functionality.

 

Best regards,
Angela

Hi Yuriy,

 

As a workaround this gap of ootb solution You can store list of users in eg. Parameter 1- Text unlimited , separated by semicolon.

 

Next You may use Your random function to build formula like this one ...

[#Parameter 1#].Split(';')[RoundOf(....)%1]) .

 

Regards,

Marcin

Show all comments