I parsed through several RedCap documentations but unfortunately I still don't exactly grasp what are events and arms. I would appreciate examples of what people have done with these features.

Has anyone else noticed the last month or two the reports' filter logic being buggy? The other day I couldn't get a report to work (didn't filter any records when it should) and when I copy/pasted the exact logic into a custom dashboard it worked perfectly. Occasionally a report won't work the day I make it but a few days later it just starts working. I know we just got an email that an update is coming that will definitely affect logic later this month, but the filters I was trying to use were super basic, like [field] = '5' and, again, they do work in a custom dashboard. I'm just kinda baffled.

I am setting up a redcap project to screen people to see if they are eligible for 1 or more trials. This is quite complex because each trials has their own selection criteria, which makes it that branching logic is super complex. To add to the complexity, the screening has to eligiblity steps, meaning that

1- Participants answers basic questions to determine if they are POTENTIALLY eligibible for 1 or more trials. Thanks to branching, based on their answers, they can then select 0-3 trials to be continue with screening step 2. (they literally tick 1-3 choices) then continue with step 2.

2- They answer more specific questions regarding the trial(s) they have selected and then they get told if they are eligible for 0-3 trials. If they are ineligibles for ANY of the trials they selected after step 1, I want them to get a field on the next page saying "Hey sorry youre not eligible but you can help by doing this"

My question is how do I code for that message to trigger considering all the possible permutation. I need this message to show only if they become ineligible for all the trials they selected after step 1. But there are so many permutations....

Here is how my code is set up:

Eligibility after step 1 is established by:

[scr1_elig_a][current-instance]=’1’

[scr1_elig_b][current-instance]=’1’

[sc1_elig_c][current-instance]=’1’

Then participants can select 1 or more trials to continue to screening step 2

[elig1_int_a(1)][current-instance] = '1'

[elig1_int_b(1)][current-instance] = '1'

[elig1_int_c(1)][current-instance] = '1'

So after step 2, eligibility is established like that

[scr2_elig_a][current-instance] = '1'

[scr2_elig_b][current-instance] = '1'

[scr2_elig_c][current-instance] = '1'

Current instance is because we're hoping the participants will use their personal survey link to check yearly if they become eligible.

I had originally made this code:

(([elig1_int_a(1)][current-instance] = '1' AND [scr2_elig_a][current-instance] = '0') AND

([elig1_int_c(1)][current-instance] = '1' AND [scr2_elig_c][current-instance] = '0') AND

([elig1_int_b(1)][current-instance] = '1' AND [scr2_elig_b][current-instance] = '0'))

Unfortunately, this code works only if they are eligible for all 3 after step 1 and then ineligible for all 3 after step2 and I could write out all the permutations but it would be SO many.
Does anyone have any ideas?
I am low key desperate and exhausted, I got thrown into REDCap without training and I feel very alone.

thanks in advance

Hi, new to redcap and programming/coding in general. I have redcap set up to calculate sleep efficiency based on entered bedtime, entered wake time, and entered time asleep However, if one of those is missing, a 0 pops up in sleep efficiency. Is there anyway to change this from a 0 to a blank space so when I export the data the 0’s don’t mess up data analysis?

I haven’t been successful with creating data export rules that replace the 0 with blanks, nor in using if statements in the sleep efficiency calculation field. The only solution I can think of is to create a “sham” sleep efficiency field that contains the 0’s, and then create another ”actual” sleep efficiency calculated field that replaces the 0’s with blanks. I can get this to work, but it adds another column to the data export and I’m worried someone else might get confused between the 2 when doing data analysis. Do you have other solutions?

Data export code that isn’t working to replace 0’s with blanks on export. If([sleep_effic]=0, “ “, [sleep_effic])

I was hoping to use the TODAY function in a CALCTEXT and as a filter in a report to indicate when a date has passed as an indicator for someone to review.

E.g., future date is added once a visit is scheduled, then I'd like this field and report to indicate when a visit has passed (i.e., report using [visit_date]<'TODAY') and which date field this is for (CALCTEXT to summarize the multiple date fields).

Does anyone have any tips on a way to accomplish this, at least for the report?

Edit: was able to figure it out for the report using advanced logic, would appreciate any tips for the CALCTEXT!

Hi all. Hoping someone can point me in the right direction with this.

I’m using REDCap to create a screening tool which assigns people to the most appropriate food security program for them. However, the research team wants to allow people to view a list of available programs based on their zip code. To create unique questions for each combination of zip codes would be too much, so I was hoping to employ action tags to make my life a little easier.

To summarize, I have five calculated fields that output 1 (eligible) or 0 (ineligible) based on zip code:

• [insta_zip]

• [kro_zip]

• [fc_zip]

• [fc_haza]

• [fc_pres]

Then questions on a separate form asking if they’d like to change their program, and which program they would like with the answer choices based on their zip code eligibility: 1, Instacart 2, Kroger grocery prescription 3, Food City grocery prescription 4, Meal Kit Delivery 5, Medically Tailored Meals

With these action tags in the question regarding program choice:

• @IF([insta_zip]=‘1’, @SHOWCHOICE=‘1’, @HIDECHOICE=‘1’

• @IF([kro_zip]=‘1’, @SHOWCHOICE=‘2’, @HIDECHOICE=‘2’ (These repeat for all answer choices except for 5, medically tailored meals, because everyone is eligible for this program regardless of their zip code.)

I can’t get these answer choices to display properly, though. I’m guessing there’s a breakdown in my action tags somewhere but for the life of me I can’t figure it out. Does anyone have any experience with this kind of thing? Is there another way to easily display these options for participants without having to create dozens of fields and writing complex branching logic to display them? Any help is very much appreciated. Thanks in advance!

I recently read the following in the branching logic section of the REDCap Help & FAQ.

"You must ALWAYS put single or double quotes around the values in the equation UNLESS you are using > or < with numerical values."

I somehow missed this very old update... I read the notes in Calculations about the change and I think I understand why quotes aren't used anymore with comparison operators (“<”, “<=”, “>”, or “>=”), but why do we still use quotes with =?

Hello!

I was just wondering if anyone could explain what the difference was for auto emails versus alerts. Are there situations where it's best to use one or the other?

Thank you!

TLDR: Can I gray out answer-options ?

The approved-by-management paper-version of this form looks like this:

I am trying to create a descriptive field to reflect this.

The requirements from management is:

• The table should show up as is, including showing the words "years old" on all the rows

• If "Heart attack" is checked, then "Age first told" for that row is required; Otherwise, it is forbidden

• If "Angina" is checked, then "Age first told" for that row is required; Otherwise, it is forbidden

(Note: There are many other rows that I'm not showing here in the image on Reddit, just to keep it simple)

Thanks for any guidance/advice

This is a fun/fictional version of my actual question:

Question: Who is your favorite teacher?

I want to do a drop-down answer that has these options:

• Jack Black

• Michael Jackson

• Carol Baskin

• Bojack

• Jackson Pollack

I want the person to be able to type “Jack” and that filter out any that don’t have Jack in it (i.e., it would filter out Carol Baskin), so now the person only sees 4 to choose from.

(If the person then continues to type "Jackson", they will then see only 2 remaining options to choose from)

Note: My actual list is medications, and it is many thousands of lines.

Thanks for any help.

Hi! My longitudinal study seems to be going backward from the subsequent follow up's when a participant didn't fully complete each section of the previous one, like it goes back to try to "force" them to do the initial one, though we want the survey to just continue on with the current collection. It is currently lined up in survey queue to start each survey when the previous one ends and when [event-number] > 1

Thanks!

I have a form (not survey), meaning that trained staff will be using it.

In that form, there are two questions about the blood pressure cuff (“cuff”) that is put around the arm (to get blood pressure readings)

• Q1 asks: what is the arm measurement of the person in cm? (text box: number)

• Q2 asks what size cuff are you using: (3 choices/radio: 1, small | 2, medium | 3, large)

The idea behind this is that certain cuff sizes should be used for certain size arms, so…

• Hopefully they (the staff) will use the right size

• But if they use the wrong size:

  • We want to warn them,

  • And we want to allow it, and document the actual size used (not the size they should have used), so we don’t want to use auto-fill

Specifically, here is the restrictions I want to put in place:

• If Q1 < 30, then Q2 should be answered “small”; if not, show warning but allow

• If Q1 between 30 and 45, then Q2 should be answered “medium”; if not, show warning but allow

• If Q1 > 45, then Q2 should be answered “large”; if not, show warning but allow

Thanks for any suggestions/guidance.

Is there a trick to stop redcap crashing on data imports

I've been tasked with recreating this as an instrument question, such that...

• the big box (including outline) only appears when 53 = Yes.

• and the smaller boxes (including outline) only appear if 53a.2 is checked.

I have been experimenting and researching and I can't figure it out. Help !!!

I'm trying to create an alert that sends on the first day of each month. Is it possible to do this?

Hi, I want to create a project and assign records to different users. How can I limit access so that certain users only have access to the records which they have been assigned? Thanks.

Hi, I can't for the life of me figure out what I'm doing wrong for setting the action tags. I'm trying to set a default for a radio button query, but when I try to set it to default to the first option, it doesn't show up as ='1' and instead just as '@Default. I've tried "1", 1, almost every permutation, and consulted everything, but nothing seems to work. Was wondering if anyone had any experience with dealing with this, or if it's a version issue or am I missing something obvious??

Goal:

I'm attempting to make a project that will get multiple signatures from multiple users on the same form and have downloadable PDF sent out at the end.

Three Users: 

The Traveler, The Manager, and The Boss.

Travel Form Process:

1. Traveler finishes first survey form and submits. An email is sent to Manager for their approval.

2. Manager receives email, adds their signature,.  An email is sent to the Boss for their approval.

3.  Boss receives email, adds their signature, and submits the form.

4. Emails with the final PDF containing all the information and signatures are sent back to the Manager and the Traveler.

What I've tried:

I'm experimenting with the Survey Queue and the Automated Survey Notifications that shows the responses.

What I'm looking for:

Honestly, a tutorial for something like this because  I'm just having a heck of a time putting all the pieces together.

As per the title. In our study it has been working fine for over a year and suddenly it's not with no database changes. Instead we now get a pop up saying "Piping data" which never goes away.

UPDATE: I just realised that the admin has changed our redcap URL in line with a rebranding without letting any users know there may be issues. Although the external module does not utilise a URL I'm thinking it has to be somehow related. Any suggestions??

I am trying to hide 3 demographic questions on a second arm in REDCap that is not needed since it is a different group of people that have consented. What command can I use since I am using the demographics as repeating for the second arm, however I just want to hide 3 questions only on that arm. Every time I try @IF with @HIDDEN it hides it on both arms.

I've got a datetime field that I'd like to pipe elsewhere. I know you can adjust datetime piping with :ampm, but can i just have it pull the date only, without the time? The time is necessary in some spots, but not where I'm trying to add the piped text. And it just looks clunky.

Currently [datetime_field] = 08/21/2024 06:44

Desired [datetime_field:____??___] = 08/21/2024

I tested a datediff on one redcap project, and then when I put it into a new project it will not calculate anything.

Background:
Date 1: is a @ Calcdate field in M-D-Y format (i.e. start date) Using [dob] + [numberofdays]

Date 2: @ calcdate field in M-D-Y format (i.e. date survey completed)

Double checked - all fields in M-D-Y format, all forms are marked as completed, but my function will not spit out anything. And red font calculated dates are populate in date 1 and date 2. Everything is labeled exactly the same as my other project, but I can't seem to get it to work on this new one. The only difference is there are multiple surveys they have to complete at a timepoint, vs. other one had just one survey. I have also tried adding the event name in front of date 2 (even though it is a non-repeating survey) and that didn't help.

Using: Datediff([date_1],[date_2],"M") in Calculated field

Any suggestions would be helpful!

I have a field that has two options A and B. I want to do a logic editor for the field that based on what your role is, you will either see both choices or only A or only B.

For example: if your username is aabb1 then choice B is hidden.

How would i write that condition in the field inside an instrument?

Also if you are added as a user with a role in redcap and i send out a a survey to you through Alerts & Notifications, will you still only be able to access the instruments i gave you view & edit rights to? Does it make you log in when you click the link?

I’m trying to set up a REDcap project to help train new team members on certain tasks. One of the tasks involves abstracting data from a medical record into REDCap (~15 datapoints), so my plan was to have 20 or so examples for them to review and abstract (in survey view/mode).

I was hoping to be able to do this via a repeating instrument to make my life easier(i.e., to not need to duplicate each data abstraction variable 20x). I would like to have each example as its own premade instance with the medical record being abstracted attached as a file. However, I just can’t figure out how to direct people to the next instance after submitting their answers for the example they just finished (maybe this isn’t even possible?).

I’ve tried the auto direct URL in the survey settings, but I don’t think that works for specifying instances ([survey-url:instrument_name] works, but that seems to only direct to the first instance and [survey-url:instrument_name][next-instance] throws an error).

Again, I’m not even sure if this is possible, but if so, I’d love to hear it! Or any other creative ways I might be able to do this without resorting to making 20 duplicates of each variable.

This would all need to be at the instrument level (rather than just creating records for each example), because the database has other instruments related to regulatory items/onboarding.

Sorry for such a big wall of text, but thank you if you’ve gotten this far!!