06-18-2011 09:19 AM
Thank you for reading this question. I am new to ACT!, but technically capable (e.g. SQL, C#, etc.)
There are many things I would like to do with ACT! but expect that I need the API to do them. These things would be easy if I were to export my data to Excel, modify it, and re-import it, but many things will not save to Excel, like pictures and "Relationships."
My first question is, in the Contacts tables:
If (ID/Status=="PRIME CONTACT" or ReferredBy=="PRIME CONTACT) then I'd like to set IsPRIME=True, and erase ID/Status and ReferredBy
ID/Status and ReferredBy are the string fields that ship with ACT and IsPRIME is a checkbox that I added to the contact usng Design Layout.
I am running Sage ACT! Premium 2011 Version 18.104.22.168, Hot Fix 4, Windows 7.
06-20-2011 04:47 AM
06-20-2011 12:53 PM
06-20-2011 01:18 PM
06-23-2011 06:08 AM
Thank you all.
I will likely need the SDK or a developer's help for other projects, but I've been trying Exponenciel's Automatic Field Calculations and it seems well written well thought out, well supported, and inexpensive. Sage ACT! should consider purchasing Exponenciel and including their product in the standard ACT! package.