Help on Relation and Formula

[Nishan Perera]

Hi,

I need some help on to create a formula, refer below.

If Stock.StockDateMonth = StationaryRequest.CreatedatMonth, Then + to Stock.TotalIssue + StationaryRequest.DispatchUnits


There are three entities which is Items, Stock and Stationary Request.

• Relevant Item is link to Stationary Request
• Relevant item is link to Stock

So the item is the middle one for the relation. what I wanted to do is get the "dispatch units" value from relevant item Stationary request entity and update on the same relevant item stock total issue entity.


Stock Entity





Stationary Request Entity



Each month there will separate record for Stock and above one for Jan 2020 and only for one item.

Highly appreciate help on this.

[Nishan Perera]

Can anyone help me on this ?

[esforim]

I probably cannot. What have you tried though? I can't even think of any workaround, still in holiday mode.

[Nishan Perera]

hhahaha. I'm always on espocrm. developed some themes, and a app for android (web to app like PWA). actually i think this can be done with web hooks but I don't have knowledge for it. tried with formulas. But no luck.