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 13.1.111.0, Hot Fix 4, Windows 7.
TIA
06-20-2011 04:47 AM
06-20-2011 12:48 PM
Thank you. That should work.
06-20-2011 12:53 PM
06-20-2011 01:18 PM
Hello mrobbins,
If you do have an interest in developing these types of solutions yourself, the SDK for Act is free and available here.
If you have any development specific question feel free to drop by the Developer's Lounge
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.