Custom fields to prioritize follow-up with Contacts

Custom fields to prioritize follow-up with Contacts

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.

  1. Each Contact has a custom Importance field (0 is unimportant and 9 is highly important)
  2. Each Contact has a custom Contact Frequency field... How often (in days) the person should be contacted (30, 60 90, etc.)
  3. Each Contact has a custom Aged Importance field.
    • Aged Importance is 0 if I don't need to contact them.  For example...it has been less than 60 days since I've contacted them and their Contact Frequency=60
    • Aged Importance is equal to Importance if I need to contact them.  For example... it has been 75 days since I've contacted them and their Contact Frequency=60.  
    • A contact is past due if it has been 30 days since I should have contacted them.  If Contact Frequency is 60 days, then this contact would be past due at 90 days.
    • Aged Importance increases by 2 if the contact is 30 days past due.
    • Aged Importance increases by 4 if the contact is 60 days past due.
    • Aged Importance increases by 6 if the contact is 90 days past due.

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.

    Access your files securely from anywhere


          All-in-one knowledge management and training platform for your employees and customers.






                                Zoho Developer Community




                                                      • Desk Community Learning Series


                                                      • Digest


                                                      • Functions


                                                      • Meetups


                                                      • Kbase


                                                      • Resources


                                                      • Glossary


                                                      • Desk Marketplace


                                                      • MVP Corner


                                                      • Word of the Day


                                                      • Ask the Experts





                                                                Manage your brands on social media



                                                                      Zoho TeamInbox Resources



                                                                          Zoho CRM Plus Resources

                                                                            Zoho Books Resources


                                                                              Zoho Subscriptions Resources

                                                                                Zoho Projects Resources


                                                                                  Zoho Sprints Resources


                                                                                    Qntrl Resources


                                                                                      Zoho Creator Resources



                                                                                          Zoho CRM Resources

                                                                                          • CRM Community Learning Series

                                                                                            CRM Community Learning Series


                                                                                          • Kaizen

                                                                                            Kaizen

                                                                                          • Functions

                                                                                            Functions

                                                                                          • Meetups

                                                                                            Meetups

                                                                                          • Kbase

                                                                                            Kbase

                                                                                          • Resources

                                                                                            Resources

                                                                                          • Digest

                                                                                            Digest

                                                                                          • CRM Marketplace

                                                                                            CRM Marketplace

                                                                                          • MVP Corner

                                                                                            MVP Corner









                                                                                              Design. Discuss. Deliver.

                                                                                              Create visually engaging stories with Zoho Show.

                                                                                              Get Started Now


                                                                                                Zoho Show Resources

                                                                                                  Zoho Writer

                                                                                                  Get Started. Write Away!

                                                                                                  Writer is a powerful online word processor, designed for collaborative work.

                                                                                                    Zoho CRM コンテンツ





                                                                                                      Nederlandse Hulpbronnen


                                                                                                          ご検討中の方