AGENCY Software Wiki
AGENCY is a Free Software Data System by and for Nonprofits and others
Brought to you by:
ktanzer
(This page is for administrators, for various items that aren't yet documented elsewhere. As needed, they could be moved to other pages)
The default email address for staff is controlled in the database, in the staff view. If an email address is specified in a staff record, it will be used. Otherwise, by default, this line is used to generate an email address:
COALESCE(
tbl_staff.staff_email,
tbl_staff.username_unix,
tbl_staff.username||'@yourdomain.org')::varchar(60)
AS staff_email,
You can adjust that line in a manner that suits you, by editing the file database/pg/agency_core/create.view.staff.sql
You will then need to drop and recreate the view:
BEGIN;
DROP VIEW staff;
\i database/pg/agency_core/create.view.staff.sql
END;