10-11-2016 10:10 AM
I use ACT Pro 2011 on Windows. I created a custom user field for anniversaries. Every year I need to increase that number by one. Is there a quicker way then going in file by file, erasing the old number and typing the new number?
10-11-2016 10:56 AM
10-11-2016 11:19 AM
I send them a mail mereged letter congratulating them on their state bar anniversary with that number inserted into the document. Every year that number is one year larger.
10-11-2016 12:12 PM
10-12-2016 01:13 AM
I'd agree that, for your needs, having one field for a date and another for number of years would work best.
Just to add to what Mike said - it's possible to display "Years Since Date" using the calculated fields already present in Act!
10-12-2016 02:34 AM
05-21-2018 01:46 PM
I now have the most up-to-date ACT: Act! Pro Version 188.8.131.52, Update 3. Can you please tell me how to use the "Years Since Date" you mentioned back in '16? Or is there a better way to add 1 to a number in a user field?
05-22-2018 01:21 AM
You simply need to add a new 'calculated' field to your database. To do this you'll need to be logged in as the administrator, and you'll need to make sure you're the only user logged into your database. I also highly recommend you back up your data before making these changes.
First, go to Tools > Define Fields
Next up, choose the area of the program you want the new field to be (Contacts, Companies, Groups etc) and then click Create new field
Name the new field whatever you'd like, and set the field type to Calculated
Finally, on the next page, set the Calculated Field type to Date, choose the field you are calculating FROM, and select the formula - in this case Years since - then you can click finish.
Lastly, you'll just need to add the new field to your layout so it's visible!