I recently started with REDCap and I am facing a situation where, I have a date field in Form A and multiple choice question in Form B. I am trying to display Form C, if the date duration is over 50 days from the value at Form A AND the value in Form B = X or Y. However, I am succeeding with only the later part of the logic from Form B. the duration is not working well as expected. I am not able to figure out how to fix this. Any suggestions?
The complete response time of a respondent is shown on every questionnaire, but they are not shown in the actual dataset when downloaded for statistics. Is there any way we can have that?
I had completed data entry in "form-1" . Now I created another form called "form-2" where some of the data in "form-2" are the same in "form-1", may I know how I should assign the value from "form-1" to minimize the data entry time? Thx. I tried @DEFAULT but it doesn't seems to work.
Great video! Thank you! I am trying to do a calculation for a BMI's within different ranges to set up a scoring system. I can't figure out how to do this. Any suggestions?
([weight]/(([height]/100)*([height]/100))) This assumes that weight is in kilograms and height is in centimeters. After you have calculated the BMI, you can use branching logic to classify the calculated BMI into different categories. For example, you could create a new field "BMI Category" and set up the following logic: If BMI is less than 18.5, then BMI Category is "Underweight." If BMI is 18.5 to 24.9, then BMI Category is "Normal weight." If BMI is 25.0 to 29.9, then BMI Category is "Overweight." If BMI is 30.0 or above, then BMI Category is "Obesity." In the field for "BMI Category", you could set the branching logic like this: Field: BMI Category Choice: Underweight Logic: [BMI] < 18.5 ***You would repeat this for the other categories, adjusting the logic to reflect the correct BMI ranges.***
Great work. i need your help to find out total stay during hospital stay. with days and times too. like this Date of admission: Time of admission: Date of discharge: Time of discharge: Total stay at hospital date and time
Step 1: Find the difference in days. If you have the dates in the format of Year-Month-Day (e.g., 2023-06-23), you can subtract the date of admission from the date of discharge. This will give you the number of full days spent in the hospital. Step 2: Adjust for the admission and discharge times. You'll then need to adjust this total by the admission and discharge times. For instance, if a patient was admitted at 15:00 (or 3 PM) and discharged at 10:00 (or 10 AM), you'd subtract 5 hours from your total (since the last day in the hospital was not a full 24-hour day). The total stay in the hospital would then be the difference in days calculated in Step 1, adjusted by the difference in hours calculated in Step 2. ***When you're working with times, be sure to convert everything into the same units (for instance, you might convert days to hours, or you might convert hours to fractions of a day).***
Id recommend starting very simple with either a subtraction or addition calculation to verify it works. Then continue with more complex calculations. The blue 'Special Functions' button that appears on the top when building a calculation has a lot of great tips
Very Helpful thank you!!!
I recently started with REDCap and I am facing a situation where, I have a date field in Form A and multiple choice question in Form B. I am trying to display Form C, if the date duration is over 50 days from the value at Form A AND the value in Form B = X or Y. However, I am succeeding with only the later part of the logic from Form B. the duration is not working well as expected. I am not able to figure out how to fix this. Any suggestions?
The complete response time of a respondent is shown on every questionnaire, but they are not shown in the actual dataset when downloaded for statistics. Is there any way we can have that?
I had completed data entry in "form-1" . Now I created another form called "form-2" where some of the data in "form-2" are the same in "form-1", may I know how I should assign the value from "form-1" to minimize the data entry time? Thx. I tried @DEFAULT but it doesn't seems to work.
to use @DEFAULT you have to tell it a value so for example @DEFAULT = "1" or @DEFAULT = "[field_variable_name"
How we can reduce the date of record from the date of birth?
Great video! Thank you! I am trying to do a calculation for a BMI's within different ranges to set up a scoring system. I can't figure out how to do this. Any suggestions?
([weight]/(([height]/100)*([height]/100)))
This assumes that weight is in kilograms and height is in centimeters.
After you have calculated the BMI, you can use branching logic to classify the calculated BMI into different categories.
For example, you could create a new field "BMI Category" and set up the following logic:
If BMI is less than 18.5, then BMI Category is "Underweight."
If BMI is 18.5 to 24.9, then BMI Category is "Normal weight."
If BMI is 25.0 to 29.9, then BMI Category is "Overweight."
If BMI is 30.0 or above, then BMI Category is "Obesity."
In the field for "BMI Category", you could set the branching logic like this:
Field: BMI Category
Choice: Underweight
Logic: [BMI] < 18.5
***You would repeat this for the other categories, adjusting the logic to reflect the correct BMI ranges.***
Great work.
i need your help to find out total stay during hospital stay. with days and times too. like this
Date of admission:
Time of admission:
Date of discharge:
Time of discharge:
Total stay at hospital date and time
Step 1: Find the difference in days.
If you have the dates in the format of Year-Month-Day (e.g., 2023-06-23), you can subtract the date of admission from the date of discharge. This will give you the number of full days spent in the hospital.
Step 2: Adjust for the admission and discharge times.
You'll then need to adjust this total by the admission and discharge times. For instance, if a patient was admitted at 15:00 (or 3 PM) and discharged at 10:00 (or 10 AM), you'd subtract 5 hours from your total (since the last day in the hospital was not a full 24-hour day).
The total stay in the hospital would then be the difference in days calculated in Step 1, adjusted by the difference in hours calculated in Step 2.
***When you're working with times, be sure to convert everything into the same units (for instance, you might convert days to hours, or you might convert hours to fractions of a day).***
Despite the following all stages for calculation, the calculation field does not work for me.
Id recommend starting very simple with either a subtraction or addition calculation to verify it works. Then continue with more complex calculations. The blue 'Special Functions' button that appears on the top when building a calculation has a lot of great tips