FM_OrgAdminCountry

Overview

FM_OrgAdminCountry is a FiLMS module that allows country-specific organization admins to administrate multiple organizations by country.

It is an automated process that is triggered when:

  • User's role is assigned / changed to one of the country-specific organization admins:
  • Organization's Detail Field "Primary Country" is modified

If the organization's Primary Country is not assigned yet, users with Organization Admin role will administer it.

Installation & Configuration

Installation

Install FM_OrgAdminCountry globally. During installation, FiLMS will create:

  • 2 roles with organization level: Organization Admin Canada & Organization Admin USA
  • Organization's Detail Field "Primary Country" with Lookup (Canada and USA as lookup choices)

Limitation

  • Countries are limited to USA and Canada only.
  • Organization's Detail Field "Primary Country" must be manually filled in to keep everything updated (i.e. assigning country-specific org admins to respective organizations).

FAQ / Troubleshooting

N/A.

Additional Information

Crescent Point

To find out what country is assigned to all organizations, run the following query:

SELECT 
organizations.id,
organizations.name, 
IF(organization_details.value=95,'Canada',IF(organization_details.value=96,'USA','')) AS 'Primary Country'
FROM organizations
LEFT JOIN organization_details ON organization_details.organization_id = organizations.id AND detail_field_id = 193