Announcement

Collapse
No announcement yet.

Date fields: Inline calculation

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Date fields: Inline calculation

    Feature Request: Date field to be calculable

    Issue: Reference: https://github.com/espocrm/espocrm/issues/2552 Int/Float/Currency fields can be inline calculated, would like Date field also to be calculable as well. Currently you would need to use some calculator website, manual counting/in head maths, creating your 'Math' function using Spreadsheet, or using EspoCRM formula function.

    Proposal: Date field to be able to do calculation; perhaps something like this:
    Current field date: 10/09/2023

    New feature: 10/09/2023+15 > "Save field" > Date: 25/09/2023

    Potential issue: that assume it all "15" days, so we might need to do extra deliminator, perhaps it like this:


    Example: 10/09/2023+15d > "Save field" > Date: 25/09/2023​ (+15 days)
    Example: 10/09/2023+2w > "Save field" > Date: 24/09/2023​ (+2 weeks)

    EspoCRM already have these function using Formula.


    Use Case:
    1. Calculate expiry date
    2. Adding time frame for period
    3. Due date
    4. Calculate odd number of dates
    5. Calculate long time date
    6. Estimate of age
Working...
X