...
...
...
| bgColor | #DEEBFF |
|---|
...
Calculated Fields is a question type in which the values are recorded in the database and used in future question types. This type can be helpful in a variety of ways such as taking question values or for taking the average response value of questions to determine next steps/statements for the Participant.
| Panel | ||
|---|---|---|
| ||
For this example: |
There are three ‘Stress’ questions the participant will answer using the slider question type. The slider has a minimum value of one and a maximum value of 10, in which the step value (or increment value) is by one. The values from these questions are recorded and used in the Calculated Field question type in order to present one of two statement to the participant for this example.
If the sum values of ‘StressQ1’, ‘StressQ2’, and ‘StressQ3’ are greater than or equal to 15, ‘StressA2’ will be prompted to the Participant. If the sum values are less than 15, ‘StressA1’ will be prompted to the Participant.
...
A question type that enables researchers to create skip pattern formulas by adding / subtracting / multiplying / etc. participant answers to questions.
...
‘StressA1’ will be presented if the response values are below a certain threshold set in the Calculated Field Question Type.
...
‘StressA2’ will be presented if the response values are above a certain threshold set in the Calculated Field Question Type.
...
Click ‘Done’ once fields are completed.
| Panel | ||
|---|---|---|
| ||
Creating Calculated Field Question Type |
To create a Calculated Field Question, click ‘Add a New Question’.
...
| Panel | |
|---|---|
|
...
Creating Questions
Click ‘Add a New Question' to create a new question and select the desired question type.
...
For this example, the Slider Question Type is used.
Setting up ‘StressQ1’ asks the Participant their stress level when they wake up using the Slider Question Type.
...
Clicking ‘Next’, will go to the Settings form where parameters will be set and later used in the Calculated Field Question Type.
...
Click ‘Done' once parameters have been completed. Next step is to create the statements that are prompted to the user.
| Panel | ||
|---|---|---|
| ||
Please Note: the above steps are the same in setting up ‘StressQ2’ and ‘StressQ3’, but with different Names and Question Text. |
| Panel | ||
|---|---|---|
| ||
Creating Statements |
To create a Text Only statement, click ‘Add a New Question’.
...
For this example, one of two statements could be presented using the Text Only question type based on the Participant’s responses.
| |
Creating Calculated Field Question Type |
To create a Calculated Field question, click “+ Add a New Question” on the Questions tab in your study.
Select Calculated Field as the question type and complete the required fields denoted by '*'. Add
...
your questions to be calculated into the Calculated Field Logic field
...
. A list of available formulas for use can be found on this page ➡️ Useful EDC Formulas.
Function names are not case sensitive (i.e., DateDiff, dateDiff, and datediff are all equivalent).
...
| Panel | |
|---|---|
|
...
|
...
Sample Calculated Field Question Creation |
| Panel | ||
|---|---|---|
| ||
Please note, the Calculated Field question type can be added to previously created Assessments and the following steps are only for this specific example in creating a new assessment for the Calculated Field. |
In order to use the Calculated Field for this example, a new assessment needs to be created.
Click ‘Add a New Assessment’ to set up the Calculated Field question.
...
A form will appear to allow filling out the assessment details and Assessment Timeout (minutes). When finished, click ‘Next'.
...
The second section of the form will allow Assessment Questions to be added in which the Calculated Field will be used. When finish adding questions, click ‘Save’ to complete creating the assessment.
...
To find out more about the “Contains” and “iff” formula, please reference the EDC Formula Wiki Page.
...
| Panel | ||
|---|---|---|
| ||
Home | Submit a Ticket | SCC | Privacy |
...