I am looking for a perfect way to manage mailing list and entire contact database for my organization.
Database basically contains
Name, designation, department, sub department, company/organization/institution name and type (type: government, non government, university, corporate, judiciary etc.), multiple email addresses, phone numbers, address etc.
Database should give flexibility in such a way multi level filtering eg: filter all email address of government officials from a particular state
Any one should able to add details to the database. Also something which can directly scan a business card.
I understand a custom solution is the one which can satisfy all such requirements. But is there a ready made highly customizable platform to do the job?
Our existing solutions are Google Contacts and a Google form with Google sheets back end and have nearly 3000 entries. Can the suggesting solution have the option to import contacts from he existing arrangement?
Thanks in advance for all inputs.