Read Only not enforced

I have a 1:M relationship from module PGOpp to Billing Ledger.

PGOpp has an Amount field which should be read only once Ledgers start being related to it

I changed the Amount field to have Read only if, with the formula:

greaterThan(count($pgopp_partnershipopportunities_apib_apibillingledger_1),0)

But it's not enforced.

I tried changing the formula to:

not(equal(count($pgopp_partnershipopportunities_apib_apibillingledger_1),0))

Still not enforced.

Any thoughts on why it would ignore the formula?

Thanks,

Francesca

0 Chris Raffle 1 month ago

Hi Francesca Shiekh ,

Do you have 'disable_related_calc_fields' enabled in your config / config_override.php? At first I could not reproduce this issue, but once I added that configuration, I am now seeing the same issue. This seems to be a bug because the condition never properly validates from what I can tell.

You should be able to workaround this issue by creating an integer field that performs the related record count and then your greaterThan formula would reference that integer field instead of the direct relationship. However, if you have disable_related_calc_fields enabled, then it is possible there is a scenario where someone adds a related record and can still edit the currency field. The reason is that your parent module record will still not reflect that newly added relationship in the count value until it is explicitly resaved to trigger the calculation.

Using disable_related_calc_fields has significant performance benefits when using a lot of SugarLogic relationship calculations. Our Upsert Calculated Fields plugin handles routine SugarLogic updates of records so things like KPI measurements and related record counts are kept up-to-date to avoid performance bottlenecks and users having to manually save records to trigger recalculations.

Chris

Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Andre Serrazina 1 month ago

Hello Francesca Shiekh ,

I tested this on a stock 25.1 and it's indeed an product bug.
I've documented a new issue using your feedback

#97732 ( portal.sugarondemand.com/ )

I've also created a case using your portal details for you to receive the updates on the issue resolution.

Thanks for reporting this.

Cheers,

André
Cancel
Vote Up +2 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Francesca Shiekh 1 month ago in reply to Andre Serrazina

Fantastic, thank you for going through all that for me Andre Serrazina !
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Francesca Shiekh 1 month ago in reply to Chris Raffle

Hi Chris, I have not disabled related calc fields in config_override, as a matter of fact I cannot find a setting for disable_related_calc_fields in either the config or the config_override in my v14.

Thanks for the tips, I'll see what support says since Andre Serrazina confirmed it's an issue in v25 as well.

And thanks for the tip about Upsert Calculated Fields, I'll take a look at your site.

Francesca
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel