Score functions

Formfacade provides built-in functions that can be used to assign points for answer choices in multiple choice, checkboxes, grid questions and calculates scores. Here's the list of score functions:

SCORE

Score function can be used to assign points to answer choices in multiple choice, checkboxes and grid questions and calculate the total score.

Syntax:
SCORE(scope, point-1, point-2, …, point-n)

where

  • scope - determines whether to assign points to a specific question in the form, all questions in the section, all questions in the form or only the questions that has the matching search term in the description
  • point-1, point-2, … point-n - points to be assigned for different answer choices (a), (b), (c), (d), (e) etc in sequential order

SCORE - ALL

You can set the scope to ALL in the score function to assign points for all the questions in the form and calculate the overall score.

Syntax:
SCORE(ALL, point-1, point-2, point-3, …, point-n)

Example usage:
SCORE(ALL, 1, 2, 3, 4, 5)
SCORE(ALL, 2, 3, 10, 8)

SCORE - SECTION

You can set the scope to SECTION in the score function to assign points for all the questions in the section and calculate the section score.

Syntax:
SCORE(SECTION, point-1, point-2, point-3, …, point-n)

Example usage:
SCORE(SECTION, 1, 2, 0.5, 0.25, 0.25)
SCORE(SECTION, -1, -2, 0, 2, 1)

SCORE - QUESTION

You can add the entry#id for a question as the scope to assign points for that specific question in the section and calculate the individual score for that question.

Syntax:
SCORE(question, point-1, point-2, point-3, …, point-n)

Example usage:
SCORE(entry###, 1, 2, 0.5, 0.25, 0.25)
SCORE(entry###, -1, -2, 0, 2, 1)

Note: Type @ and select the required question from the list to add its entry #id in the above formula.

SCORE - SEARCH

You can add the search term as the scope to assign points for all the questions with description that has matching search term and calculate the score.

Syntax:
SCORE(search_term, point-1, point-2, point-3, …, point-n)

Example usage:
SCORE("Physical activity", 1, 2, 0.5, 0.25, 0.25)
SCORE("Food & diet", -1, -2, 0, 2, 1)

GRIDSCORE

Gridscore function can be used to assign points to the answer choices for specific rows in a grid question and calculate the score.

Syntax:
GRIDSCORE(question, rownum, point-1, point-2, … point-n)

where

  • question - entry #id for the grid question. Type @ and select the required question from the list to add its entry #id in the above formula.
  • rownum - determines the rows for which the points must be assigned to calculate the score. This could be single row or multiple rows. For example, [2, 3, 5, 10] will select the rows 2, 3, 5 & 10
  • point-1, point-2, … point-n - points to be assigned for different answer choices (a), (b), (c), (d), (e) etc in columns. These points will be assigned in sequential order starting from column 1.

    Example usage:
    GRIDSCORE(entry###, [2, 3, 7, 8], 1, 2, 3, 4, 5]
    GRIDSCORE(entry###, [1, 4, 5, 6], -2, -1, 0, 2, 1]