How to get real value for Virtual Field

[VictorTWB]

Hi Everyone,

I created a module with field type "virtual" which reflects "Currency". However it does not calculate in Workflow. Does anyone have a solution to get the real value from the field or a way to work around it?

TIA!

[adriangalbincea]

I had a similar issue in the past, and as far as I am aware, virtual fields cannot be used because they refer to other fields. I am curious if anyone can suggest what type of reference field/value can be used in a workflow (I struggled a lot and I could not make it work). In the meantime, I decided to use custom PHP scripts to achieve lots of automations.

[VictorTWB]

Thats great. PHP scripts as in Event Handlers?

[adriangalbincea]

I am not that experienced to create handlers. I am using php scripts run by cron jobs. Probably with the time I will learn to create handlers too. I paid YF support to create me a custom handler.

[mariuszkrzaczkowski]

Describe in more detail:

• new field parameters
• workflow configuration

Screenshots are preferred

[VictorTWB]

1. Employment Module: Store Employee's Basic Salary plus Allowance.

2. Payroll Module: Basic+Allowance Field (Virtual) reflects employment module's Basic Salary plus Allowance. Per Day Salary field to divide salary by 30. Expression as shown below.

I am trying to link these 2 modules so when monthly payroll is being created, it loads and calculate salary and per day salary based on employment profile selected by related field 1:m.