I need assistance implementing the Last Activity Time or Last Modified Time into custom forms. Everything I've tried is not working.
I have ZohoCRM set up to sort my contacts based on Aged Importance. If I don't need to contact the client, they don't show up on my list. If I need to contact them, those who are more Important show up at the top of the list. Less important clients move up the list the longer I delay contacting them.
In order for this to work, I need to be able to compare the current time with the Last Activity Time. Days Since Last Contact is a custom formula using the code below. The code does not show an issue with syntax, but it does not get updated with new records. How do I calculate this?
Datecomp(Now(),${Contacts.Last Activity Time})/60/24
The procedure is a little complicated, so here is some additional detail if you need it.
On a side note: why won’t formula fields update with existing records yet?!
Any help is appreciated. I need this functionality and am nearly ready to switch to a different CRM if I can’t get this to work.
Writer is a powerful online word processor, designed for collaborative work.