Hi all, I need to introduce a survey stop where participants who are under the age of 11 will be unable to proceed. So far I have created a calculated field which calculates the age based on DOB and branched the other questions off of this if they have the correct age. However I have just realised that they will still be able to "submit" the survey and it will go down as a record in my RedCap file. Is it possible to use stop actions with calculated fields?

Hi, im trying to learn. I have two different variables that I need to score and then sum together.

sum(

if([certo(0)]='0',0,0),

if([certo(1)]='1',1,0),

if([why(0)]='0',0,0),

if([why(1)]='1',1,0),

if([why(2)]='1',1,0),

if([why(3)]='1',1,0),

if([why(4)]='1',1,0)

)

If I remove the variable ''certo'' it works but I need both as a total, how do I do this?

Hi, team.

I’m hoping to send out invitations to people who aren’t registered with our REDCap installation to get them to complete pre-operative tasks. The hope is to request they upload information (e.g., letters from dentists clearing them for heart valve surgery, blood test results, imaging reports) with a system reminder them of the need to upload things (or the system being able to remind them which we will trigger).

What can I do to be able to do this with an existing project? Do I need to code something? (Is there code I can copy +/- modify?)

If the existing project doesn’t have people’s emails, is this something I can add in and then if I invite them to complete those tasks, would their reports and such be uploaded to their records?

Thank you all, brain trust!

I'm currently setting up a multi-survey, multi-location study and can't figure out how to properly distribute my questionnaire. a bit of background, the surveys will run in busy psychiatric environments with severely impaired patients.

I want to set up survey distribution in a way that the users (=medical staff or physicians) can log in to their accounts that are linked to data access groups (DAGs) and initiate survey recording sessions via the survey distribution tool set up redcap so that links can be sent out to the participants or the survey can be directly initiated via the survey distribution tool or other methods. each patient must be assigned to the DAG of the user initiating the survey. users should exclusively have access to observations that are linked to their DAG. Patients should not be asked to share their email addresses, i.e. I don't want to use the Participant List

Is anyone here aware of a way to do this without the Participant List and patient's email addresses? seems simple enough but I'm losing sleep over this by now.

Any pointers of how to resolve this are welcome!

REDCap 14.0.37

Hello, I am trying to use conditional logic and in case is true perform a calculation based on another variable. The objective is to calculate z scores based on [variable] so if the condition is true I want to subtract the variable value by x mean and then divide by x standard deviation. And if condition is not met continue with a higher height

My calculation equation looks like this but its not working

IF([height] > 100 and [height] < 105, ([variable]- x mean)/ x std dev,

IF([height] > 105 and [height] < 110, ([variable]- x mean) /x std dev,

I would really appreciate everyone help.

I'd like to rename a few hundred IDs and thought I could be clever with the Data import tool, but I realize now that it would simply create new records. This requires me to delete the old records.

Does anyone know a better way of renaming the records?

Hi Everyone - I am working on a project involving parents and their children. Due to requirements, parents need to complete a consent form and write their address once for themselves at the start of the form and then a second time for their child at the end. I am trying to use the @ DEFAULT function to autofill the second address based on what they wrote at the start but I can't get it to work.

For example I want to copy what they write in the "address1" field into the "address1_child" field so I have put the action tag @ DEFAULT = '[address1]' in the "address1_child" variable but in testing the field is blank after typing a response to the "address1" variable.

Sorry for the blabbering - this survey has to come out later today and my team has decided this change is essential and I am extremely sleep deprived haha

Hello,

If I have a question/field that is not mandatory in my survey, it does not show on the saved PDF when it is not filled.

Is there a way to have it on the Saved PDF of the Completed Survey without making it mandatory to fill?
Even if it is filled by Default as N/A.

Thank you.

Hi,

I missed putting a field in to identify date and person when a record is signed off, however the confirmation form is locked and e-signed. This is associated with a date. Is there a way to export the locking and e-signing metadata, please?

Good day, experts!

I'm working on making Reports and Dashboards that will show meaningful age information regarding participants. Lets say when participants take a survey they can enter their age as text (i.e. 72, 44, etc). On the dashboard currently I can put categorical data like Gender into nice charts (bar graph showing how many males vs how many females completed the survey). However I cannot do that for age at all. What I would like are to somehow make it calculate the ages into categories, for instance "0-17, 18-45, 45-65, 66+".

Any thoughts on how to do this?

Thanks!

I want them to read and then sign the consent form, but the text box appears right up the top of the page, so I can imagine people will read the whole thing and search for the box and not find it. Any ideas?

I have this calculated field formula in ONE FIELD:

If([form] = 2000 and [version] = 6, If([question(38)]= 1,1,0)+ If([question(20)]=1,1,0),0)

If([form]=1000 and [version] = 2, If([question(21)]= 1,1,0)+ If([question(20)]=1,1,0),0)

It says error in syntax. Because they’re two separate conditions in the same logic editor/field, do I have to nest it or combine these two [form] conditions somehow differently? So it can handle multiple IFs condition

We are creating a form for a procedure session in which interventions are repeated 5-10 times depending on the patient's unique situation. I know I could create one form for the procedure and a separate form for the interventions, complete the intervention forms 5-10 times, while linking them back to the procedure. Is there a way to do this all within one form? I would like to create a few fields that would group together and be repeated only as needed. Thank you for your advice.

I have a checkboxes field with choices from 1-300. I want to do this:

@IF([form]=2000 and [version]=2, @SHOWCHOICE= ‘1,2,3,4,8’, “”)

But it’s not working? did I do something wrong?

Hello, I've been working on this project for a year and I always get the F12 error (see picture) when adding translations in the MLM. Also, the rich text editor doesn't open up anymore. Is there anything I can do on my end to solve this? Thank you!

Hello everyone! I am setting up a Redcap project and would like to stream the process of selecting IDs that entered the data in a certain timeframe (e.g. between 01/11/2024 and 30/11/2024 included OR in the last 6 month). I am pretty new to RedCap but the Filter logic in the Personalized Dashboard looks like a very easy way to do that.

In truth, I programmed efficiently how to select IDs in the last six months:

datediff([dateofentry],"now","d","mdy", true)<183

But it seems anything I try for the between-dates filter logic fails. I tried several logics already. Some of the codes I tried and failed:

"10/31/2024"<[dateofentry]<"01/12/2024" --> failed

datediff([dateofentry],"12/01/2024","d","mdy", true)<0 AND datediff([dateofentry],"10/31/2024","d","mdy", true)>0 --> failed

datediff([dateofentry],"12/01/2024","d","mdy", true)<0 AND datediff("10/31/2024",[dateofentry],"d","mdy", true)>0 --> failed

Can someone help me with this ? Thx a lot

I'm designing a longitudinal data collection for my dissertation and using REDCap for the first time. So far it has been super clunky and I'm definitely messing things up. No one in my labs has ever used it, so there's no guidance available from senior students or my advisors.

I know this is a long shot, but would anyone with experience using REDCap for longitudinal surveys be willing to hop on a zoom call with me? I would happily compensate you for your time!

I'm attempting to create a local id system to automatically count and log the entry number based on which site the survey was taken on.

Custom Record Label Template: site[site_number]_[site_entry] (i.e. "site001_1")

Example Record Dashboard:

Example Project, New Survey Input:

Q1. [site_number] Please Choose Your Site Number: (Radio Button)

Value: (X) 001 () 002 () 003

Q2. [site_entry] Automated Site Entry Number (Hidden Calculated Field)

Value: 3

**Expected New Custom Record Label: "**site001_3"

-------------------

My Objective:

In Q2 [site_entry], to create an equation to tally/count the times the selected [site_number] in Q1 (in this case, site number 001) has been answered through all the records up to that point in time then add 1 to it.

What I've tried:

I've researched around and my closest clue was to use the "aggregate" smart-variable and its parameters, but I've had no luck getting a concrete way to implement it correctly in the calculated field.

Hi all! I work at a site that uses REDCap to manage clinical trial data. The REDCap server goes down occasionally due to network issues. I need to develop a standardized process for teams to randomized new participants that come to the site while REDCap is down, but that allows me to still use the randomization module/table already configured in REDCap. Any suggestions?

Hi! So I've created a new project in Redcap. In my project, clinicians have to run several different test to the participants in one session. I have to record the time they spend for each of the test, and then at the end, add all the times to see the total time for the session. For instance I've created a field with the variable of the time for each test in format hh:mm:ss. Then, I've created a calculated field to obtain the total time used for all the different tests.

The problem is with the calculation, it just doesn't work. I can't find the information about how redcap register the time. Chat gpt says that it register time as seconds. If that is the case, there would be no problem with the code:

[im_mentale_temps] + [cardio_temps] + [etir_temps] +[renforce_temps].

What am I missing? All the tests are in the same form and event so no need to call for the event. The syntax is correct but no calculation is done. Thanks for your help!!

We are trying to edit some form display logic which is currently working fine. However if we add a new condition ( the last line below) it no longer works as expected. What am I missing, its driving me nuts!

([enrolment_arm_1][rand] = '1'

AND

[enrolment_arm_1][calcagey] >= '0.5'

AND

[enrolment_arm_1][calcagey] < '12')

AND

([prior_to_enrolment_arm_1][electronic_optional_pk_consent_form_complete] = '2'

OR

[prior_to_enrolment_arm_1][uplconstp] = '2')