Dear Zoho,
We really need help with a particular formula.
We run a debt recovery company.
BACKGROUND:
1. The app has a form called "New Claim".
That's the form we use to create new records.
2. The form produces a report called "All Claims".
The purpose of the report is to help us look at records based on the age of a particular record.
We want to be able to know how long we've had the record open just by looking at the report, rather than by looking at the record it self.
3. To be able to view records based on age of record we have a date field called "Today Field".
And we have a formula field called "File Age" which is supposed to calculate the age of the file.
The formula is days360(Added_Time,Today_Field).
Both these field are visible as columns in the "All Claims" report.
4. The problem is that we need the "File Age" formula to be recalculated automatically on a daily basis, without us having to open and update each record in order to force the recalculation.
Currently the best I can do is use a formula like days360(Added_Time,today) or days360(Added_Time,zoho.currentdate) but these formulas only work if the indivudal record is updated.
5. In other words, the desired result is for us to be able to view the exact age of every record in a report on a daily basis without having to open each record so that it's updated with the current date.
6. I don't know how to automatically update every record on a daily basis so that we can work out the record's age.
I was thinking that it might be possible to do via scheduler, but I'm not sure how to code it.
I thought that may be I could update the "File Age" with the days360(Added_Time,zoho.currentdate) formula but I don't know if that would work.
QUESTION
7. Could you please tell me how I can get the "File Date" to automatically calculate the age of every record on a daily basis, so that I we don't have to update every record manually?
Thank you so much
Zubin