Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Designing a Customer Relations Manager

Featured Replies

  • Newbies

I'm trying to decide what would be the best approach to design a Customer Relations Manager. There's already a complete "Contacts Manager" in place (FM7), which is (or will be) used as a starting point for the CRM, debet control and some other databases (in a small fashion company).

I'm a novice developer, and often struggling to wrap my head around relationships (of the database kind). Some things I can get to work, some not...

The CRM is fairly simple: it is used to track conversations between the sales dept. and customers. A short topic line, and longer input field where the gist of the conversation is filled in. Was it by tel, fax, email ? Is it a new topic, open, or closed ? Dates, persons, etc...

What I would like to develop, is something akin to a forum (like this one), where each customer (about 250) has - or will have - his own list of topics, which can be "opened", "followed-up", or "closed". Each rep of the sales dept. should be able to go into the CRM database, select a customer, and "post" a new topic, or follow up, etc...

As I see it now, I should have a database with 250 records (the current customers), with auto-adding of new records when a new customer is created in the (external) Contact Manager database. Each of these records has the ability to list all of the topics, and of course create new topics. Note: creation of new Customer records should be prohibited from within the CRM database.

What would be the best approach to something like this, or are there better ways of doing this ? Any ideas, hopefully none too complex ?

Thanks.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.