FORM FORMULAS

A FORMULA is any expression that can be evaluated to return a value. We call them "FORM FORMULAS" because they are always evaluated in the context of a specific FORM and they are alway placed in properties of ant ITEM TEMPLATE OBJECT that accept FORMULAS as their value

FORMULAS can be used to:

• Assign a calculated value to an ITEM in a FORM. In this case, the ITEM does not need input form a user, because it will be automatically calculated
• Assign a default value to an ITEM: Sometimes it is necessary to assign a default value to an ITEM even though it is still necessary the input from a user
• ITEM conditions: an ITEM can have an associated condition that determines whether that ITEM will be used in the FORM or not (see ITEM TEMPLATE OBJECT)

• OBJECT CODES
  • LIBRARY OBJECT CODES
    • "@FORM" OBJECT CODE (FORM TEMPLATE)
    • "@ITEM" OBJECT CODE (ITEM TEMPLATE)
    • "@TASK" OBJECT CODE (TASK TEMPLATE)
  • OBJECT.DATA CODES
  • "ADDRESS" OBJECT CODE
  • "ADMISSION" OBJECT CODE
  • "CASE" OBJECT CODE
  • "CHANNEL" OBJECT CODE
  • "COMMENTS" OBJECT CODE
  • "CONFIGURATION" OBJECT CODE
  • "CONTACT" OBJECT CODE
  • "DATA" OBJECT CODE
  • "DESCRIPTION" OBJECT CODE
  • "EVENT" OBJECT CODE
  • "FORM" OBJECT CODE
  • "IDENTIFIER" OBJECT CODE
  • "IMAGE" OBJECT CODE
  • "ITEM" OBJECT CODE
  • "OUTCOME" OBJECT CODE
  • "PROGRAM" OBJECT CODE
  • "PROTOCOL" OBJECT CODE
  • "REFERRAL" OBJECT CODE
  • "ROLE" OBJECT CODE
  • "ROW" OBJECT CODE
  • "SESSION" OBJECT CODE
  • "SETTINGS" OBJECT CODE
  • "SUBSCRIPTION" OBJECT CODE
  • "SYSTEM" OBJECT CODE
  • "TASK" OBJECT CODE
  • "TEAM" OBJECT CODE
  • "USER" OBJECT CODE
• INTRODUCTION TO FORMULAS
• OPERAND DATA TYPES
• ACTION FORMULAS
  • ACTIVITY_INSERT()
  • ADMISSION ACTIONS
    • ENROLL()
    • DISCHARGE ()
    • PROTOCOL_INSERT(ANSWER_ID)
    • PROTOCOL_TRANSFER("PROTOCOL_ID", "TEAM")
    • REJECT ()
    • ADMISSION_PERFORMANCE_SET()
    • ADMISSION_REFERRAL_SET()
    • ADMISSION_TRIAL_GROUP_SET()
  • CLIENT_REQUEST ()
  • EVENT_CLOSE ()
  • EVENT_INSERT()
  • FORM_CLONE()
  • FORM_CLOSE ()
  • FORM_OPEN ()
  • FORM_REPORT ()
  • FORM_SHOW ()
  • GOAL_SET ()
  • TASK_CANCEL ()
  • TASK_INSERT()
  • TASK_LOCK (task_reference, do_lock = true)
  • WS_CALL($endpoint, $function, $parameters)
• EXPORT FORMULAS
  • CDA ()
  • EXPORT (TYPE, FORMAT)
• CASE FORMULAS
  • ASSOCIATE_INSERT ()
  • CASE_SET ()
• DEVICE FORMULAS
  • DEVICE (item, tag)
  • DEVICE_CONNECT (DEVICE)
  • MEDICAL DEVICES XML SAMPLE
    • † Pulseoximetry (NONIN)
    • All devices
    • † Spirometry
    • MIR SPIRODOC/SPIROTEL CONFIG
  • DEVICE_DATA(DEVICE_BYTES, DEVICE_TYPE, [PARAMETER])
• LOGIC FORMULAS
  • LOGIC_RANGE(VALUE, R_MIN, R_MAX, VALUE_LESS, VALUE_INRANGE, VALUE_GREATER{,QUESTION_TYPE})
  • LOGIC_RANGE_N(NUM_SEGMENTS, REFERENCE_VALUE, SEGMENT_1,...,SEGMENT_N, VALUE_0,...,VALUE_N ,QUESTION_TYPE)
  • LOGIC_IF ( condition item , true item, false item)
• DATE FORMULAS
  • DATE ()
  • DATE_ADD()
  • DATE_DIFF()
  • IS_DATE()
  • IS_TIME()
  • TIME ()
  • TODAY()
  • WEEK_DAY()
• MATH FORMULAS
  • ABS ()
  • MATH_SUM ()
  • MATH_MULT ()
  • MATH_DIVIDE ()
• OBJECT FORMULAS
  • GET_VALUE (OBJECT, PROPERTY{, PARAMETER})
  • GOAL_GET ()
  • GRAPH_EVOLUTION()
  • GRAPH_SPIRO (DATA_STRING, TYPE{,TAGS})
  • HTML (XML, XSLT)
  • LINK ()
  • SETTING_GET( SETTING_CODE{, SCOPE, SCOPE_ID})
• OPTION FORMULAS
  • GET_LIST (SCOPE, PROPERTY{, PARAMETER, OPTIONS})
  • OPTION_SELECT (selection = ALL)
  • RANDOM_OPTION ()
  • GET_LIST_MEMBERS()
  • CODE_LIST()
• STRING FORMULAS
  • CONCAT ()
  • BASE64_ENCODE ()
  • BASE64_DECODE ()
  • CONCAT_NON_EMPTY ()
  • REPLACE (search, replace, text)
  • TEXT_RENDER (text)
• SCORING FORMULAS
  • • BAECKE - Homemade activities
  • • BAECKE - Leisure activities
  • • BAECKE - Sport activities
  • • Body Mass Index
  • • CCQ Total scoring (CCQ_TOT)
  • • CCQ( SYMPTOMS, FUNCTIONAL, MENTAL)
  • • Charlston Comorbidity Index
  • • Cumulative Dose ( cigars packet/ year)
  • HAP() (Human Activity Score)
  • • Health Survey Scoring (SF36 v.2)
  • • Rehabilitation Activity (SGRQ_A)
  • • Rehabilitation Impact (SGRQ_I)
  • • Rehabilitation Symptoms (SGRQ_S)
  • • Six-minutes walk test (6MWT) - LLN
  • • Six-minutes walk test (6MWT) - REF
  • ASCVD_10Y_RISK() (ArteroSchlerotic CardioVascular Disease Risk)
• USER FORMULAS
  • USER_PREFERENCE_GET ()
  • USER_PREFERENCE_SET ()
• VALUE FORMULAS
  • COUNT ()
  • JSON_VALUE()
  • MAX ()
  • MIN ()
  • VALUE_CONTAINS ()
• † DEPRECATED FORMULAS
  • † SETTING_SET()
  • † SET_VALUE ()
  • † TASK_REPORT ()