Home : FINFO
Q11973 - INFO: FINFO

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

 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/28/2009 3:31 PM.
Last Modified on 8/14/2019 5:00 PM.
Last Modified by Scott Dorner.
Article has been viewed 1295 times.
Rated 0 out of 10 based on 0 votes.
Print Article
Email Article