Tweet
Hi,
I am new to EspoCRM, and I have a couple of questions about the Entity Functions in the Formula Scripts. I would like to write a script where it would take the number value from a particular field from one entity record and add it to the values from the field for several other entity records. For example, suppose I had the custom field "Tickets" and the values in the field contained the amount that each record had paid. I would then want a script that would sum those amounts for multiple other records in the same entity.
I looked in the documentation, and based on the descriptions of the functions the only non-custom function that would seem to be able sum values like this is entity\sumRelated. However, per the documentation, "Functions of the Entity group operate with a target record. There can be only one target record available in formula-script context."
My question, therefore, is does anyone know if there is a way to write additional commands into the script that would allow me to use the entity\sumRelated function to sum values from multiple entities?
Failing that, does anyone know if there would be a way to write a custom function that would accomplish the same task?
Thank you in advance for any help that you provide.
I am new to EspoCRM, and I have a couple of questions about the Entity Functions in the Formula Scripts. I would like to write a script where it would take the number value from a particular field from one entity record and add it to the values from the field for several other entity records. For example, suppose I had the custom field "Tickets" and the values in the field contained the amount that each record had paid. I would then want a script that would sum those amounts for multiple other records in the same entity.
I looked in the documentation, and based on the descriptions of the functions the only non-custom function that would seem to be able sum values like this is entity\sumRelated. However, per the documentation, "Functions of the Entity group operate with a target record. There can be only one target record available in formula-script context."
My question, therefore, is does anyone know if there is a way to write additional commands into the script that would allow me to use the entity\sumRelated function to sum values from multiple entities?
Failing that, does anyone know if there would be a way to write a custom function that would accomplish the same task?
Thank you in advance for any help that you provide.
Comment