Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Entity formulas menu unavailable #928

Open
fbmteam opened this issue Nov 13, 2023 · 12 comments
Open

Entity formulas menu unavailable #928

fbmteam opened this issue Nov 13, 2023 · 12 comments

Comments

@fbmteam
Copy link

fbmteam commented Nov 13, 2023

Hello,
In the last update of Atrocore and AtroPIM, the FORMULAS option (menu) no longer appeared in the entity, where functions are used, for example, to concatenate fields and create composite keys. Has this feature been discontinued, or is there another way to do the same? Thank you very much

Core 1.7.6
PIM 1.10.1
DAM 1.6.1

@atrolex
Copy link
Collaborator

atrolex commented Nov 14, 2023

We decided to remove this functionality as nobody of known us customers is using it. It was "inherited" from EspoCRM and we never supported it. With the module "Advanced Data Types" you can create a field of type "script" and define the calculation logic there. Calculation is always done on the fly. Module price is 690 EUR.

@Vladzimir
Copy link
Contributor

Vladzimir commented Nov 29, 2023

Can you give an example of the formula? Because there is not a word about this either in the documentation or in the demo! Therefore, it is not at all clear how to transfer your formulas and connect your third-party PHP scripts to the module you specified.

We decided to remove this functionality as nobody of known us customers is using it. It was "inherited" from EspoCRM and we never supported it. With the module "Advanced Data Types" you can create a field of type "script" and define the calculation logic there. Calculation is always done on the fly. Module price is 690 EUR.

@fbmteam
Copy link
Author

fbmteam commented Nov 29, 2023

Good afternoon. The functionality existed and was available at the level of each entity in the menu where the entity's DELETE is located. This functionality was removed in the latest software update. If there is no information about the functionality in the documentation, it does not mean that the functionality did not exist. We use this functionality to concatenate fields to create composite keys that validate the record as unique.
We have already spoken with Atrocore and this topic has already been resolved. Thanks

@Vladzimir
Copy link
Contributor

Good afternoon. The functionality existed and was available at the level of each entity in the menu where the entity's DELETE is located. This functionality was removed in the latest software update. If there is no information about the functionality in the documentation, it does not mean that the functionality did not exist. We use this functionality to concatenate fields to create composite keys that validate the record as unique. We have already spoken with Atrocore and this topic has already been resolved. Thanks

Can you give an example of your script in new realities?

@fbmteam
Copy link
Author

fbmteam commented Nov 29, 2023

Field4 = string\concatenate(Entity.field1 , Entity.field2 , Entity.field3)

ifThenElse(CONDITION, CONSEQUENT, ALTERNATIVE)

@Vladzimir
Copy link
Contributor

Vladzimir commented Nov 29, 2023

Field4 = string\concatenate(Entity.field1 , Entity.field2 , Entity.field3)

ifThenElse(CONDITION, CONSEQUENT, ALTERNATIVE)

Not quite clear. Does it work without the above module, if so how, or does it work with it?

@fbmteam
Copy link
Author

fbmteam commented Nov 29, 2023

We have already spoken with Atrocore and this topic has already been resolved. Thanks

@Vladzimir
Copy link
Contributor

We have already spoken with Atrocore and this topic has already been resolved. Thanks

Why is it so difficult to answer how you solved this problem, instead of answering with riddles?

@atrolex
Copy link
Collaborator

atrolex commented Dec 1, 2023

Dear @Vladzimir, we "inherited" dynamic calculations directly from Espo. This can be done using the paid Advanced Data Type module. You can also develop your own module to calculate something on the fly. We are discontinuing the formula functionality we inherited from EspoCRM, it is too difficult for us to support it.

@Vladzimir
Copy link
Contributor

Dear @Vladzimir, we approach dynamic calculations directly from Espo. This can be done using the paid Advanced Data Type module. You can also develop your own module to calculate something on the fly. We are discontinuing the formula functionality we inherited from EspoCRM, it is too difficult for us to support it.

But in the docks for this module there is not a word about this functionality, as well as examples of use.

@atrolex
Copy link
Collaborator

atrolex commented Dec 4, 2023

yes, docs are still behind, With the module you get a new data type "script", so you can create a field or an attribute of type script. Script is some Twig script, which can take any input and calculates anything on the fly, when requested. It return a value of real data type, like integer, float, string, etc..

@Vladzimir
Copy link
Contributor

new data type "script", so you can create a field or an attribute of type script.

How can I make changes to another field using this module?
Previously I used a function like name = nameOther
Whenever a product was changed, the field was automatically saved with the required value.
How can I do this now?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants