Menu
SuiteCRM Pull Request Party hosted by SalesAgility
Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: 7.8 Beta 2: Calculated Fields [Updated]

7.8 Beta 2: Calculated Fields 2 years 3 months ago #43726

  • crm-user
  • crm-user's Avatar
  • Offline
  • New Member
  • Posts: 1
  • Karma: 1
Examples:

Addition of 3 and 4: {add(3;4)}
Addition of two parameters: {add({P1};{P2})}


More help: suitecrm.com/media/kunena/attachments/38...ds-Documentation.pdf
The administrator has disabled public write access.

7.8 Beta 2: Calculated Fields 2 years 3 months ago #44013

  • samus-aran
  • samus-aran's Avatar
  • Offline
  • SuiteCRM PR Party Host
  • Posts: 374
  • Thank you received: 170
  • Karma: 38
Hi Guys,

The User Guide has been updated to include the new AOW Calculate Fields action - you can view it here
..........

SalesAgility - the authors and maintainers of SuiteCRM
Get Involved! Help contribute to the SuiteCRM documentation site.
Last Edit: 2 years 3 months ago by samus-aran.
The administrator has disabled public write access.

7.8 Beta 2: Calculated Fields 2 years 1 month ago #45926

  • phii
  • phii's Avatar
  • Offline
  • Junior Member
  • Posts: 21
  • Karma: 0
Hi every body,

I try to understand calculated field in SuiteCRM. I read user guide (suitecrm.com/wiki/index.php/Userguide#Calculate_Fields)
But I have one question :

in {add(parameter1; parameter2)} can I put field rather value.

like {add(filed1; field2)} to have result in thrid field?

I need to know if it's possible : field3 = field1+field2 when update or insert value in field1 or field2 or both

I hope you can understand what I mean :)

(sorry for my bad english)
The administrator has disabled public write access.

7.8 Beta 2: Calculated Fields 2 years 1 month ago #45954

  • diligent
  • diligent's Avatar
  • Offline
  • Moderator
  • Posts: 45
  • Thank you received: 13
  • Karma: 2
Hi phii,

yes, you can add any fields you wish as parameter to any function in Calculated Fields, and yes, the result of the function can be a value for a third field.

You can find an example which is very similar to your case in the documentation (suitecrm.com/wiki/index.php/Userguide#Calculate_Fields)
Open up the page and search for: Calculate monthly fee for an opportunity

Hope this helps,
diligent
The administrator has disabled public write access.

7.8 Beta 2: Calculated Fields 2 years 1 day ago #47623

  • rapon
  • rapon's Avatar
  • Offline
  • Junior Member
  • Posts: 29
  • Karma: 0
Hi,

I do not have the "calculate fields" in the select action menu (CRM Version 7.7.9). Its feature from 7.8.x ?

Thanks for help.

Radim
The administrator has disabled public write access.

7.8 Beta 2: Calculated Fields 5 months 1 week ago #75441

  • phii
  • phii's Avatar
  • Offline
  • Junior Member
  • Posts: 21
  • Karma: 0
Hi, I'm back here to dig up some solutions :)

I ve used calculated fields in workflow for calculate number like field1+field2=n

But right now I have a new needs with calculated field syntaxe :

I want this kind of thing :

calculated field (account in order) = account in quotes I use that :

{equal({{R0})}

{R0} is my quotes account field but I have no result (field stay empty without error in workflow)

I hope I'm clear (always my bad english sorry).

If some can help me you're welcome :)
The administrator has disabled public write access.

7.8 Beta 2: Calculated Fields 5 months 1 week ago #75443

  • phii
  • phii's Avatar
  • Offline
  • Junior Member
  • Posts: 21
  • Karma: 0
I try

{substring({{R0})}

too because after little search equal is only for number...
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Time to create page: 0.056 seconds
Powered by Kunena Forum