Closest date from related records

[Mark]

Hi,
I want to make it so a field "Delivery date" in my case would be filled in automatically according to related records "Order items". The value that would be placed in the "Delivery date" should be the latest date from those related "Order items" (Every order item has its own delivery date and I need to take the max date value, but I could not find a way to do it in Espo).

[Maximus]

Hi,
Workflow can help you. For example:
1. I created the 'itemDeliveryDate' field for the Sales Order Items entity;
2. I created the 'deliveryDate' field for the Sales Order entity;
3. I created the workflow provided on the screenshot below: