CoreBOSBB
Field expression formulas - Printable Version

+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Development (https://discussions.corebos.org/forumdisplay.php?fid=18)
+--- Forum: coreBOS Development (https://discussions.corebos.org/forumdisplay.php?fid=4)
+---- Forum: coreBOS (https://discussions.corebos.org/forumdisplay.php?fid=5)
+---- Thread: Field expression formulas (/showthread.php?tid=90)

Pages: 1 2

Field expression formulas - myhomewise - 02-11-2015

I appear to have an issue with my field expression formulas:

<!-- m --><a class="postlink" href="http://awesomescreenshot.com/09c4e2tfc5">http://awesomescreenshot.com/09c4e2tfc5</a><!-- m -->

the formula should be as follows Totals Fees = promo fees + merchant fees + lender fees

here is a screenshot
<!-- m --><a class="postlink" href="http://awesomescreenshot.com/0ed4e2tn28">http://awesomescreenshot.com/0ed4e2tn28</a><!-- m -->

it edit view the forumla works:
<!-- m --><a class="postlink" href="http://awesomescreenshot.com/0214e2tufd">http://awesomescreenshot.com/0214e2tufd</a><!-- m -->

I have not made no changes to code only created custom fields

Re: Field expression formulas - joebordes - 02-11-2015

Try putting the sum directly, eliminate the equal sign

Code:
cf_696 + cf_698 + cf_700

note that this is execute on the save event, not when loading the edit screen

Also, please use the workflow update field task, Field formulas are obsolete, workflows are more powerful and will keep getting bug fixes and enhancements while field formulas will be left there as it is only for backword compatibility.

Re: Field expression formulas - myhomewise - 02-12-2015

I did both things you requested I eliminated the "=" as well as created a workflow vs a field expression. I am still experiencing a similar problem. I am now also having if I enter 1,000 in 1 custom field and 500 in another the values will change and the total fees formula does something odd.

FYI these are all currency fields with 7 value length and 2 decimals

Re: Field expression formulas - myhomewise - 02-12-2015

what it also seems to do for example if i add 10,000 to a currency field it will drop zeroes it change it to 10

Re: Field expression formulas - joebordes - 02-12-2015

Try eliminating the formatting from the users configuration. That part of the code never quite worked correctly. Set it to work as:

- no grouping nor thousand separator
- point as decimal

Re: Field expression formulas - joebordes - 02-12-2015

The formulas and update fields really do work well and your desired formula is really simple. I doubt the problem is there.

Re: Field expression formulas - myhomewise - 02-12-2015

After changing :

Digit Grouping Pattern 123456789

the problem was eliminated

How come this problem never occurred in the original Vtiger 5.4, I ask because i preferred, Digit Grouping Pattern 123,456,789

Re: Field expression formulas - myhomewise - 02-12-2015

Is there a way inside Corebos to have the Digit Grouping Pattern 123,456,789 and the workflow equations still work properly?

Re: Field expression formulas - joebordes - 02-12-2015

I'd say this has happened always, that part of the code has never worked correctly since it was released by vtiger. In other words, vtiger crm 5.4 had the same problem and we haven't looked into fixing it (yet).

I have been telling users of vtiger CRM 5.4 the same thing I told you for years.

At the moment there is no solution. We will look into it eventually but there are more important things in front.

Re: Field expression formulas - myhomewise - 02-12-2015

I have provided some screenshots showing this works in Vtiger 5.4

<!-- m --><a class="postlink" href="http://awesomescreenshot.com/0f74eadn20">http://awesomescreenshot.com/0f74eadn20</a><!-- m -->

<!-- m --><a class="postlink" href="http://awesomescreenshot.com/0dd4eaer19">http://awesomescreenshot.com/0dd4eaer19</a><!-- m -->

<!-- m --><a class="postlink" href="http://awesomescreenshot.com/0284eaf660">http://awesomescreenshot.com/0284eaf660</a><!-- m -->