FINFO returns information from Facility Setup for the specifed or current facility.
SYNTAX:
FINFO("Facility", "Field")
"Facility": The facility Unique Indentifier in quotes (i.e. "OPSWWTUTOR"). Leave blank (i.e. "") to use the current facility.
"Field": Which field to retrieve. Valid settings include:
"FILENAME"
"DIRECTORY"
"NAME"
"DASHMSG" - See Using Dashboard Message for example.
"LOCKDATE"
"OPSTIMEZONEID"
"SITEADDRESS1"
"SITEADDRESS2"
"SITECITY"
"SITESTATE"
"SITEZIP"
"SITEPHONE"
"SITEFAX"
"SITECONTACT"
"DESIGNCAPACITY"
"PERMITNUMBER"
"PERMITSTARTDATE"
"PERMITENDDATE"
"NOTES"
"PLANTMANAGER"
"FACILITY_I.???" - to refer to a facility additional info field where ??? is replaced by the field name.
NOTES:
EXAMPLES:
FINFO("","Name") returns "Rocky Creek WWTP" if you are currently in the tutorial database.
FINFO("OPSWWTP","PERMITNUMBER") returns NM34321, the permit number for the OPSWWTP facility.
CONCAT(FINFO("","CITY"),", ",FINFO("","SITESTATE")," ", FINFO("","SITEZIP")) returns Rio Rancho, NM 87124
=CONCAT(FINFO("","NAME"),char(13),FINFO("","SITEADDRESS1"),char(13),FINFO("","SITECity"),",",FINFO("","SITEState")," ",FINFO("","SITEZIP")) returns:
Rocky Creek WWTP
1316 Jackie Rd
Rio Rancho, NM 87144
The cell is set with wrap text on. The CHAR(13) is a hard return character. CONCAT concatenates the strings together