DESCRIPTION

This formula allows to retrieve any data related with the current form.

OBJECT VALUES

The possible OBJECT values are:

The PROTOCOL of the ADMISSION related with the TASK or EVENT the FORM belongs to (be aware that some TASKS or EVENTS may not necessarily be related with an ADMISSION)

OBJECT	DESCRIPTION
QUESTION	Information about the same question where the formula is calculated
ROW	Information about any question in the same row than the question where the formula is calculated. This is valid only for questions that belong to an array block
FORM	The FORM where the formula is calculated
TASK	The TASK the FORM belongs to
EVENT	The EVENT the FORM belong to
ADMISSION	The ADMISSION related with the TASK or EVENT the FORM belongs to (be aware that some TASKS or EVENTS may not necessarily be related with an ADMISSION)
PROTOCOL	The PROTOCOL of the ADMISSION related with the TASK or EVENT the FORM belongs to (be aware that some TASKS or EVENTS may not necessarily be related with an ADMISSION). This scope refers always to the data associated to the current form's CASE.
PROGRAM	The PROTOCOL of the ADMISSION related with the TASK or EVENT the FORM belongs to (be aware that some TASKS or EVENTS may not necessarily be related with an ADMISSION). This scope refers always to the data associated to the current form's CASE. (is the same as CASE but filtering the PROPERTY of the current program of the form)
CASE	The case the EVENT or TASK is related to, or the ADMISSION the EVENT or TASK is related to (be aware some EVENTS may not be related with a CASE).
SUBSCRIPTION	Information on the TEAM associated to the SUBSCRIPTION the ADMISSION belongs to
USER	Information on the active session's USER
TEAM	Information on the TEAM associated
SESSION	Information on the current session
SYSTEM	Information of the system

PROPERTIES

The properties to be retrieved from the selected form object are listed in the following table:

OBJECT	PROPERTY	DESCRIPTION	PARAMETER	COMMENTS	EXAMPLES
QUESTION	DOWNLOAD_LINK	Returns link tag for download file from question's answer field	ELEMENT		GET_VALUE("QUESTION", "DOWNLOAD_LINK", "12")
ROW FORM TASK ADMISSION SUBSCRIPTION (not implemented) PROTOCOL PROGRAM CASE	DATA_CODE	The most recent value of the ELEMENT in the FORM's CASE, PROGRAM, ADMISSION, TASK, EVENT, FORM or ROW with the referred DATA_CODE. The search will be made only in tasks with task date previous or equal at current date.	The DATA_CODE of the ELEMENT	The results are filtered if the associated DATA_CODE doesn't contain an Answer. "[DATA_CODE]{([option])}{:[index]}" The invocation ordes is first option and then index. "[DATA_CODE]{([option])}{:[index]}" If the DATA_CODE refers to a CHOICE field (radio, check, combo) the default value returns the CHOICE_ID To obtain de CHOICE/s value, order or description would need to specify the [option] following choices: (VALUE): The VALUE of the DATA_CODE (DESC): The DESCRIPTION of the DATA_CODE (ORDER): The ORDER in a CHOICE selection (DATE): The DATE of the associated TASK option parameter must be in UPPER CASE To obtain the reference to the closed TASK where the "DATA_CODE" exists specify the [option] = REF. (REF): The REF (task_id) of the associated TASK To retrieve how many DATA_CODEs are entered in an ADMISSION will use the [option] = COUNT. (COUNT): The number of DATA_CODEs To retrieve how many DATA_CODEs are entered in an ADMISSION with a specified value will use the [option] = COUNT=value: (COUNT=J41): The number of DATA_CODEs If the option field requested for a non CHOICE-associated type is VALUE o DESC, the returned value is always the current VALUE of the answer regardless the "option" requested. Otherwise (ORDER) returns <null> If the returned ITEM is a CODE, the DESC option is available to return a DESCRIPTION of the CODE "[DATA_CODE]{([option])}{:[index]}" When there is more than one element* whith same property, index of element can be indicated like this: "ICD-9:1" = the first ICD-9 "ICD-9:last" = the most recent ICD-9 "ICD-9:n" = number of ICD-9 elements "ICD-9" = will return all the ICD-9 elements delimited by ˝<br>" "ICD-9:1\|3" = will return the first and third ICD-9 elements delimited by ˝<br>" The index can be represented by the number or by the reference to another item of the form (i.e. GET_VALUE("TASK","DATA_CODE",ICD9:$3) and $3 = 1\|2 ) Multiple index (only compatible with scope FORM) (i.e. GET_VALUE("FORM","DATA_CODE",ICD9:$3$4) and $3 = 1\|2 and $4 = 3\|4 then $3$4 = 1\|2\|3\|4)	GET_VALUE ("ADMISSION", "DATA_CODE", "ICD-9:1") GET_VALUE ("ADMISSION", "DATA_CODE", "ICD-9") GET_VALUE(CASE,DATA_CODE,TASK_FOR_TESTING(DATE)) GET_VALUE(ADMISSION,DATA_CODE,TASK_FOR_TESTING(COUNT)) GET_VALUE(FORM,DATA_CODE,TASK_FOR_TESTING(COUNT=J41*))
FORM	ELEMENT	The current value of the ELEMENT referred in PARAMETER	The ELEMENT identifier		GET_VALUE ("FORM", "ELEMENT", "1")
	XML		{ "CDA" }	You may add the parameter "FORMAT" to indicate a particular XML format: "CDA"	GET_VALUE ("FORM", "XML", "CDA")
	FORM_ID	Returns id of current form			GET_VALUE ("FORM", "FORM_ID")
TASK	NAME	Recovers name of the TASK		Literal in language of session	GET_VALUE ("TASK", "NAME")
	DESCRIPTION	Recovers description of the TASK		Literal in language of session	GET_VALUE ("TASK", "DESCRIPTION")
	DATE_TIME	Recovers date and time scheduled of the TASK	SCHEDULED	-	GET_VALUE ("TASK", "DATE_TIME", "SCHEDULED")
	DATE_TIME	Recovers last date and time of modification of the TASK	MODIFIED	-	GET_VALUE ("TASK", "DATE_TIME", "MODIFIED")
	DATE	Recovers date of the TASK schedule	SCHEDULED	Date format depends on language of session	GET_VALUE ("TASK", "DATE", "SCHEDULED")
	DATE	Recovers date of the TASK most recent modification	MODIFIED	Date format depends on language of session	GET_VALUE ("TASK", "DATE", "MODIFIED")
	TIME	Recovers time of the TASK schedule	SCHEDULED		GET_VALUE ("TASK", "TIME", "SCHEDULED")
	TIME	Recovers time of the TASK most recent modification	MODIFIED		GET_VALUE ("TASK", "TIME", "MODIFIED")
	MINUTES	Recovers duration of TASK in minutes	-	-	GET_VALUE ("TASK", "MINUTES")
	ROLES	Recovers roles assigned to the TASK	-	Retrieves list of roles in language of session delimited by "<br>"	GET_VALUE ("TASK", "ROLES")
	USER	Recovers (a list of) [role] name & surname assigned to the TASK	ASSIGNED	-	GET_VALUE ("TASK", "USER", "ASSIGNED") "[Role] Name Surnames"
	USER	Recovers the name & surname of the user who made the last modification of the TASK	MODIFIED	-	GET_VALUE ("TASK", "USER", "MODIFIED")
	TEAM	Recovers (list of) teams assigned to the TASK	ASSIGNED		GET_VALUE ("TASK", "TEAM;", "ASSIGNED")
	TEAM	Recovers (list of) TEAM OWNER of the teams assigned to the tasks	ASSIGNED_OWNER		GET_VALUE ("TASK", "TEAM", "ASSIGNED_OWNER")
EVENT	TYPE	Recovers type of the EVENT	-	There are only 7 types of events: CARE ISSUE SOCIAL ISSUE ADMINISTRATIVE ISSUE TECHNICAL ISSUE ENROLLMENT REQUEST OPINION REQUEST CALL	GET_VALUE ("EVENT", "TYPE")
	POSTER	Recovers NAME of the USER who POSTED of the EVENT	NAME	-	GET_VALUE ("EVENT", "POSTER", "NAME")
		Recovers the ROLE of the USER who POSTED the EVENT	ROLE		GET_VALUE ("EVENT", "POSTER", "ROLE")
		Recovers the TEAM of the USER who POSTED the EVENT	TEAM		GET_VALUE ("EVENT", "POSTER", "TEAM")
	ASSIGNED	Recovers the NAME of the USER the EVENT is ASSIGNED	NAME		GET_VALUE ("EVENT", "ASSIGNED", "NAME")
		Recovers the ROLE of the USER the EVENT is ASSIGNED	ROLE		GET_VALUE ("EVENT", "ASSIGNED", "ROLE")
		Recovers the TEAM of the USER the EVENT is ASSIGNED	TEAM		GET_VALUE ("EVENT", "ASSIGNED", "TEAM")
	ISSUER	Recovers the ISSUER type	TYPE	The user TYPE can be: POSTER: The EVENT was ISSUES by the POSTER CASE: The EVENT was issued by the CASE OTHER: The event was ISSUED by an USER other than the POSTER	GET_VALUE ("EVENT", "ISSUER", "TYPE")
	ISSUER	Recovers name and surname of issuer of the EVENT where the FORM is assigned	NAME	-	GET_VALUE ("EVENT", "ISSUER", "NAME")
	PRIORITY	Recovers priority level of the EVENT	-	It could be High, Medium or empty	GET_VALUE ("EVENT", "PRIORITY")
	DATE	Recovers the POSTING date of the EVENT	POSTER	Date format depends on language of session	GET_VALUE ("EVENT", "DATE", "POSTER")
	DATE	Recovers date the ASSIGNED closed the EVENT	ASSIGNED	Date format depends on language of session	GET_VALUE ("EVENT", "DATE", "ASSIGNED")
	TIME	Recovers time of POSTING the EVENT	POSTER	-	GET_VALUE ("EVENT", "TIME", "POSTER")
	TIME	Recovers time the ASSIGNED closed the EVENT	ASSIGNED	-	GET_VALUE ("EVENT", "TIME", "ASSIGNED")
	DURATION	Recovers POSTER duration of EVENT	POSTER	-	GET_VALUE ("EVENT", "DURATION", "POSTER")
	DURATION	Recovers the duration of the ASSIGNED of the EVENT	ASSIGNED	-	GET_VALUE ("EVENT", "DURATION", "ASSIGNED")
	PHONE	Recovers incoming phone number of the EVENT	PHONE_IN	-	GET_VALUE ("EVENT", "PHONE", "PHONE_IN")
	PHONE	Recovers outgoing phone number of the EVENT	PHONE_OUT	-	GET_VALUE ("EVENT", "PHONE", "PHONE_OUT")
	PHONE_IN_USER	Recovers name and surname of user who has same number as indicated in incoming phone number of the EVENT	-	-	GET_VALUE ("EVENT", "PHONE_IN_USER")
	PHONE_OUT_USER	Recovers name and surname of user who has same number as indicated in outgoing phone number of the EVENT	-	-	GET_VALUE ("EVENT", "PHONE_OUT_USER")
ADMISSION	DATE_TIME	Recovers date when patient joined program to which the FORM belongs to	ENROLLED JOINED DISCHARGED REJECTED SUSPENDED	Date format depends on language of session	GET_VALUE ("ADMISSION", "DATE_TIME_ADMISSION")
	ID	returns ID of admission	-	NUMERICAL	GET_VALUE ("ADMISSION", "ID")
SUBSCRIPTION	NAME	Recovers full name of the TEAM associated with the SUBSCRIPTION	FULL
	NAME	Recovers TEAM_CODE of the TEAM associated with the SUBSCRIPTION	TEAM_CODE
	MEMBERS	Recovers all TEAM_CODE of the type in the PARAMETER field that are MEMBERS of the SUBSCRIPTION	SERVICE etc...	Will return TEAM_CODES delimited by <br>. If the parameter is set only team members with the specified category will be returned	GET_VALUE ("SUBSCRIPTION", "MEMBERS", "SERVICE")
	PHONE	Recovers phone/s of the TEAM associated with the SUBSCRIPTION	empty MOBILE WORK HOME EXT DEFAULT	When there is more than one phone, the index can be defined like this: "MOBILE:1" = first mobile phone of USER "WORK" = will return all work phones delimited by ˝<br>" "DEFAULT" = will return prefered contact phone. empty = will return all phone delimited by "<br>"
	ADDRESS	Recovers address of the TEAM associated with the SUBSCRIPTION	empty number DEFAULT	When there is more than one address, the index can be defined in parameter option. When is necessary to retrieve preferred address parameter option must to be set to "DEFAULT". Empty will return all addresses delimited by "<br>"
PROTOCOL	NAME	Recovers name of the protocol of current form where admission is created	-	Literal in language of session	GET_VALUE ("PROTOCOL", "NAME")
PROTOCOL	DATA_CODE (Not implemented)	The value of the ELEMENT in the FORM's PROTOCOL with the referred DATA_CODE	The DATA_CODE of the ELEMENT	(See DATA_CODE property of ADMISSION object)	GET_VALUE ("PROTOCOL", "DATA_CODE", "ICD-9:1") GET_VALUE ("PROTOCOL", "DATA_CODE", "ICD-9")
PROGRAM	NAME	Recovers name of the program of current form where admission is created	-	Literal in language of session	GET_VALUE ("PROGRAM", "NAME")
CASE	NAME	Recovers full name of the CASE associated with the FORM	FULL	-	GET_VALUE ("CASE","NAME", "FULL")
		Recovers nickname of the CASE associated with the FORM	NICKNAME	Can be used to login to Linkcare mobile application	GET_VALUE ("CASE", "NAME", "NICKNAME")
		Recovers first and second name of the CASE associated with the FORM	NAME		GET_VALUE ("CASE", "NAME", "NAME")
		Recovers surname of the CASE associated with the FORM	SURNAME		GET_VALUE ("CASE", "NAME", "SURNAME")
	BIRTH_DATE	Recovers birthdate of CASE associated with the FORM	DATE	Date format depends on language of session	GET_VALUE ("CASE", "BIRTH_DATE", "DATE")
	BIRTH_DATE	Recovers the AGE of CASE associated with the FORM	AGE		GET_VALUE ("CASE", "BIRTH_DATE", "AGE")
	GENDER	Recovers numeric code of the sex of CASE associated with the FORM	-	'M' - Male 'F' - Female	GET_VALUE ("CASE", "GENDER")
	GENDER	Recovers the literal of the case associated to the form	DESCR	Literal in language of session	GET_VALUE ("CASE", "GENDER","DESCR")
	ID	Recovers an identification number of the CASE associated with the FORM	PASSPORT NATIONAL RESIDENCE DRIVER INSURANCE SOCIAL_SEC STUDY_REF	-	GET_VALUE ("CASE", "ID", "PASSPORT")
	PHONE	Recovers phone of CASE associated with the FORM	empty MOBILE WORK HOME EXT DEFAULT	When there is more than one phone, the index can be defined like this: "MOBILE.1" = first mobile phone of CASE "WORK" = will return all work phones delimited by ˝<br>" "DEFAULT" = will return prefered contact phone. empty = will return all phone delimited by "<br>"	GET_VALUE ("CASE", "PHONE", "WORK") GET_VALUE ("CASE", "PHONE", "HOME:2") GET_VALUE ("CASE", "PHONE")
	ADDRESS	Recovers address of CASE associated with the FORM	empty number DEFAULT	When there is more than one address, the index can be defined in parameter option. When is necessary to retrieve preferred address parameter option must to be set to "DEFAULT". Empty will return all addresses delimited by "<br>"	GET_VALUE ("CASE", "ADDRESS", "DEFAULT") GET_VALUE ("CASE", "ADDRESS")
	MAIL	Recovers e-mail address of CASE associated with the FORM	empty HOME WORK DEFAULT	Empty will return all e-mails delimited by "<br>", "WORK" will return work email of the CASE and "HOME" will return home email of the CASE	GET_VALUE ("CASE", "MAIL", "DEFAULT") GET_VALUE ("CASE", "MAIL") GET_VALUE ("CASE", "MAIL", "HOME")
	IM	Recovers Skype nickname of the CASE associated with the FORM	SKYPE	-	GET_VALUE ("CASE", "IM", "SKYPE")
USER	NAME	Recovers full name of current USER	FULL	-	GET_VALUE ("USER", "NAME", "FULL")
		Recovers nickname of current USER	NICKNAME		GET_VALUE ("USER", "NAME", "NICKNAME")
		Recovers first and second name of the CASE associated with the FORM	NAME		GET_VALUE ("USER", "NAME")
		Recovers surname of the CASE associated with the FORM	SURNAME		GET_VALUE ("USER", "SURNAME")
	BIRTH_DATE	Recovers birthdate of current USER	DATE	-	GET_VALUE ("USER", "BIRTH_DATE", "DATE")
	BIRTH_DATE	Recovers AGE of current USER	AGE	-	GET_VALUE ("USER", "BIRTH_DATE", "AGE")
	GENDER	Recovers numeric code of the sex of CASE associated with the FORM	-	'M' - Male 'F' - Female	GET_VALUE ("USER", "GENDER")
	GENDER	Recovers the literal of the case associated to the form	DESCR	Literal in language of session	GET_VALUE ("USER", "GENDER","DESCR")
	ID	Recovers an identification number of the CASE associated with the FORM	PASSPORT NATIONAL RESIDENCE DRIVER INSURANCE SOCIAL_SEC	-	GET_VALUE ("USER", "ID", "PASSPORT")
	PHONE	Recovers phone/s of the current USER	empty MOBILE WORK HOME EXT DEFAULT	When there is more than one phone, the index can be defined like this: "MOBILE:1" = first mobile phone of USER "WORK" = will return all work phones delimited by ˝<br>" "DEFAULT" = will return prefered contact phone. empty = will return all phone delimited by "<br>"	GET_VALUE ("USER", "PHONE", "WORK") GET_VALUE ("USER", "PHONE", "HOME:2") GET_VALUE ("USER", "PHONE")
	ADDRESS	Recovers address of current USER	empty number DEFAULT	When there is more than one address, the index can be defined in parameter option. When is necessary to retrieve preferred address parameter option must to be set to "DEFAULT". Empty will return all addresses delimited by "<br>"	GET_VALUE ("USER", "ADDRESS")
	MAIL	Recovers e-mail address of current USER	empty HOME WORK DEFAULT	Empty will return all e-mails delimited by "<br>", "WORK" will return work email of the USER and "HOME" will return home email of the USER	GET_VALUE ("USER", "MAIL", "DEFAULT") GET_VALUE ("USER", "MAIL") GET_VALUE ("USER", "MAIL", "HOME")
	IM	Recovers Skype nickname of the session's active USER	SKYPE		GET_VALUE ("USER", "IM", "SKYPE")
	PROFILE	The staff profile of the session's active USER			GET_VALUE ("USER", "PROFILE")
	ROLE	The active role of the USER	empty		GET_VALUE ("USER", "ROLE")
		All the roles in the active TEAM	ACTIVE		GET_VALUE ("USER", "ROLE", "ACTIVE")
		The active ROLE_ID of the session's active USER	ID		GET_VALUE ("USER", "ROLE", "ID")
	TEAM	The active TEAM	empty		GET_VALUE ("USER", "TEAM")
		All the TEAMS the user belongs to with the active ROLE	ACTIVE		GET_VALUE ("USER", "TEAM", "ACTIVE")
		All the TEAMS the user belongs to with the specified role	role		GET_VALUE ("USER", "TEAM", "STAFF")
TEAM	NAME	Recovers description of current TEAM	FULL	-	GET_VALUE ("TEAM", "NAME", "FULL")
		Recovers NICKNAME of current TEAM	NICKNAME	-	GET_VALUE ("TEAM", "NAME", "NICKNAME")
		Recovers TEAM_CODE of current TEAM	TEAM_CODE	-	GET_VALUE ("TEAM", "NAME", " TEAM_CODE")
	PHONE	Recovers phone/s of the current TEAM	empty MOBILE WORK HOME EXT DEFAULT	When there is more than one phone, the index can be defined like this: "MOBILE:1" = first mobile phone of USER "WORK" = will return all work phones delimited by ˝<br>" "DEFAULT" = will return prefered contact phone. empty = will return all phones delimited by "<br>"	GET_VALUE ("TEAM", "PHONE", "WORK") GET_VALUE ("TEAM", "PHONE", "HOME:2") GET_VALUE ("TEAM", "PHONE")
	ADDRESS	Recovers address of current TEAM	empty number DEFAULT	When there is more than one address, the index can be defined in parameter option. When is necessary to retrieve preferred address parameter option must to be set to "DEFAULT". Empty will return all addresses delimited by "<br>"	GET_VALUE ("TEAM", "ADDRESS")
	IMAGE	Recovers insignia image (small image) of current TEAM	INSIGNIA	-	GET_VALUE ("TEAM", "IMAGE","INSIGNIA")
	IMAGE	Recovers logo image (big image) of current TEAM	LOGO	-	GET_VALUE ("TEAM", "IMAGE","LOGO")
SESSION	LANGUAGE	Active language of current user	-	Language code in ISO 639-1 standard	GET_VALUE ("SESSION", "ACTIVE_LANGUAGE")
SYSTEM	WS_LINK	URL for endpoint	-	Endpoint (http://test.linkcare.es/ws/ServerWSDL.php)	GET_VALUE("SYSTEM", "WS_LINK")
	UTIME	Current time in unix format	-	Was used to create a random number To be deprecate in the future. Use GET_VALUE("SYSTEM";"DATE","U") instead	GET_VALUE("SYSTEM", "UTIME")
	DATE	Date or number of week, day or year depending on parameter	letter	If the parameter is one letter (check php docs format column http://php.net/manual/en/function.date.php) will be returned values from returned values column	GET_VALUE("SYSTEM", "DATE", "Y")
			string	If the parameter is string (like 'last sunday') it will return date in common format yyyy-mm-dd hh:ii:ss (check http://php.net/manual/en/datetime.formats.relative.php)	GET_VALUE("SYSTEM", "DATE", "this sunday")
			format	If its format for date like yyyy/mm/dd will be returned date in this format.
			$N	When its needed to pass another date (for example: next sunday starting from date in variable $N) for example: next monday:$5 will check the date in $5 question and search for monday starting from this date	GET_VALUE("SYSTEM", "DATE", "last monday:$5")

Browser not supported