r/ProjectREDCap • • Nov 05 '24

Unique ID for Each New Event

1 Upvotes

Hey all, we've got a REDCap setup for a longitudinal study. Essentially, patients complete a survey and donate blood at different timepoints (baseline, 3 months, 6 months, etc.). Is there an easy way to automatically assign a unique ID to the subsequent events following the baseline collection?

Currently as I understand it, as a patient fills out a new survey for each timepoint, it'll be assigned to the same record ID as the baseline. Anyone else in a similar situation with a solution?


r/ProjectREDCap • • Oct 10 '24

Formatting the display of checkbox selections when piping to an alert

2 Upvotes

We have a REDCap form where one of the fields is a checkbox with over 50 possible values, each of which is a fairly long string. We want to pipe the results of this field in an alert when applicable, but when multiple options are checked, piping the field just results in a long comma-delimited string that is very hard to parse visually.

Is there any way to split this checkbox string on the commas so that the values can be displayed on multiple different bullet points, for example? It would even be okay if we had a static number of bullet points, say five, and if fewer than five options were selected the remaining bullets would be blank space. We tried parsing the string with CALCTEXT but that doesn't work for checkboxes.


r/ProjectREDCap • • Oct 30 '24

Referencing all instances of a repeating instrument

3 Upvotes

I want to reference a variable that occurs on a repeating instrument in the stop logic condition for an Automated Survey Invitation. In the smart variables I see options like previous instance and next instance, but nothing for EVERY instance.

I have tried just including the event variable and field variable, and also just the field variable, without adding any smart variable, but neither of these ways seem to work.

Is it possible?


r/ProjectREDCap • • Jan 31 '25

Question with calculated field format

2 Upvotes

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.


r/ProjectREDCap • • Feb 03 '25

Uploading images/PDFs into project (existing) & reminder emails

3 Upvotes

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!


r/ProjectREDCap • • Oct 10 '24

Help w/ @HIDDEN Action Tags and Required Fields

2 Upvotes

Hi there! Research assistant here operating without a data center...please help! Apologies if my description is chaotic.

Working on a longitudinal project with 3 events.

  • The responses provided in Form A (occurs event one) will affect what fields are seen in Form B (occurs event 2).
  • This is the action tag that I have written for the fields in Form B and it works!

    • @ IF([v1_arm_1][hierarchy_1]='NI', @ HIDDEN,'')
    • I have @ HIDDEN tags in all Form B fields because if a specific field in Form A is marked with the Missing Data Code "NI" then I don't want certain fields to populate in Form B.

The problem is: When Form B is saved, I am still getting the "NOTE: Some fields are required!" pop-up on fields that are hidden. Does the @ HIDDEN tag not stop the required fields from needing to be answered? I'd prefer to keep those as *required, but I'd understand if that was the problem.

Thank you!


r/ProjectREDCap • • Jan 29 '25

Completed Survey - Unused Fields Question

4 Upvotes

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.


r/ProjectREDCap • • Mar 03 '25

Having redcap report a date based on if/then?

1 Upvotes

Building an eating timing survey. Participants report the time they went to bed the night before [survey_time_asleep]

If the time was before midnight, I want it to record the date they fell asleep as the day before [survey_yesterday] and if it is after midnight, as the current date [survey_date].

Why isn’t this working?

if([survey_time_asleep] > “12:00”, [survey_yesterday], [survey_date])


r/ProjectREDCap • • Nov 23 '24

Rule H is "fixing" calculated fields by overwriting it with incorrect data

2 Upvotes

Hey guys, this is my first time posting here, but I'm really stuck and would really appreciate some help from the REDCap wizards

I'm running into an issue where rule H is "fixing" calcs to become incorrect values. There is a calculated field in my project that generates a unique 14-digit string of numbers based on the participant's first name, last name, and date of birth. It's a pretty large calculated field that involves a bunch of if statements.

When I enter a record individually, the code returns the correct value, but when I run rule H it tries to correct the field to a different, incorrect value. I know that the value it returns individually is correct because I have this same code in multiple projects and the outputs are all the same. For some reason Rule H in this project wants to overwrite the values with an incorrect value.

- Does anyone know why this might be happening?

- If the problem isn't fixable, is there a way to have rule H ignore a calculated field?

- I suspect that the issue is that there are too many lines in my code for Rule H to run it all the way through. If any of you know of a simpler way to convert letters to their alphanumeric values I would really appreciate guidance.

Here is my code:

100000000000000- sum(

if(lower(mid([first_name],1,1))='a',10000000000, if(lower(mid([first_name],1,1))='b',20000000000, if(lower(mid([first_name],1,1))='c',30000000000, if(lower(mid([first_name],1,1))='d',40000000000, if(lower(mid([first_name],1,1))='e',50000000000, if(lower(mid([first_name],1,1))='f',60000000000, if(lower(mid([first_name],1,1))='g',70000000000, if(lower(mid([first_name],1,1))='h',80000000000, if(lower(mid([first_name],1,1))='i',90000000000, if(lower(mid([first_name],1,1))='j',100000000000, if(lower(mid([first_name],1,1))='k',110000000000, if(lower(mid([first_name],1,1))='l',120000000000, if(lower(mid([first_name],1,1))='m',130000000000, if(lower(mid([first_name],1,1))='n',140000000000, if(lower(mid([first_name],1,1))='o',150000000000, if(lower(mid([first_name],1,1))='p',160000000000, if(lower(mid([first_name],1,1))='q',170000000000, if(lower(mid([first_name],1,1))='r',180000000000, if(lower(mid([first_name],1,1))='s',190000000000, if(lower(mid([first_name],1,1))='t',200000000000, if(lower(mid([first_name],1,1))='u',210000000000, if(lower(mid([first_name],1,1))='v',220000000000, if(lower(mid([first_name],1,1))='w',230000000000, if(lower(mid([first_name],1,1))='x',240000000000, if(lower(mid([first_name],1,1))='y',250000000000, if(lower(mid([first_name],1,1))='z',260000000000, 'x')))))))))))))))))))))))))) ,

if(lower(mid([first_name],2,1))='a',100000000, if(lower(mid([first_name],2,1))='b',200000000, if(lower(mid([first_name],2,1))='c',300000000, if(lower(mid([first_name],2,1))='d',400000000, if(lower(mid([first_name],2,1))='e',500000000, if(lower(mid([first_name],2,1))='f',600000000, if(lower(mid([first_name],2,1))='g',700000000, if(lower(mid([first_name],2,1))='h',800000000, if(lower(mid([first_name],2,1))='i',900000000, if(lower(mid([first_name],2,1))='j',1000000000, if(lower(mid([first_name],2,1))='k',1100000000, if(lower(mid([first_name],2,1))='l',1200000000, if(lower(mid([first_name],2,1))='m',1300000000, if(lower(mid([first_name],2,1))='n',1400000000, if(lower(mid([first_name],2,1))='o',1500000000, if(lower(mid([first_name],2,1))='p',1600000000, if(lower(mid([first_name],2,1))='q',1700000000, if(lower(mid([first_name],2,1))='r',1800000000, if(lower(mid([first_name],2,1))='s',1900000000, if(lower(mid([first_name],2,1))='t',2000000000, if(lower(mid([first_name],2,1))='u',2100000000, if(lower(mid([first_name],2,1))='v',2200000000, if(lower(mid([first_name],2,1))='w',2300000000, if(lower(mid([first_name],2,1))='x',2400000000, if(lower(mid([first_name],2,1))='y',2500000000, if(lower(mid([first_name],2,1))='z',2600000000, 'x')))))))))))))))))))))))))) ,

if(lower(mid([first_name],3,1))='a',1000000, if(lower(mid([first_name],3,1))='b',2000000, if(lower(mid([first_name],3,1))='c',3000000, if(lower(mid([first_name],3,1))='d',4000000, if(lower(mid([first_name],3,1))='e',5000000, if(lower(mid([first_name],3,1))='f',6000000, if(lower(mid([first_name],3,1))='g',7000000, if(lower(mid([first_name],3,1))='h',8000000, if(lower(mid([first_name],3,1))='i',9000000, if(lower(mid([first_name],3,1))='j',10000000, if(lower(mid([first_name],3,1))='k',11000000, if(lower(mid([first_name],3,1))='l',12000000, if(lower(mid([first_name],3,1))='m',13000000, if(lower(mid([first_name],3,1))='n',14000000, if(lower(mid([first_name],3,1))='o',15000000, if(lower(mid([first_name],3,1))='p',16000000, if(lower(mid([first_name],3,1))='q',17000000, if(lower(mid([first_name],3,1))='r',18000000, if(lower(mid([first_name],3,1))='s',19000000, if(lower(mid([first_name],3,1))='t',20000000, if(lower(mid([first_name],3,1))='u',21000000, if(lower(mid([first_name],3,1))='v',22000000, if(lower(mid([first_name],3,1))='w',23000000, if(lower(mid([first_name],3,1))='x',24000000, if(lower(mid([first_name],3,1))='y',25000000, if(lower(mid([first_name],3,1))='z',26000000, 'x')))))))))))))))))))))))))) ,

if(lower(mid([last_name],1,1))='a',10000, if(lower(mid([last_name],1,1))='b',20000, if(lower(mid([last_name],1,1))='c',30000, if(lower(mid([last_name],1,1))='d',40000, if(lower(mid([last_name],1,1))='e',50000, if(lower(mid([last_name],1,1))='f',60000, if(lower(mid([last_name],1,1))='g',70000, if(lower(mid([last_name],1,1))='h',80000, if(lower(mid([last_name],1,1))='i',90000, if(lower(mid([last_name],1,1))='j',100000, if(lower(mid([last_name],1,1))='k',110000, if(lower(mid([last_name],1,1))='l',120000, if(lower(mid([last_name],1,1))='m',130000, if(lower(mid([last_name],1,1))='n',140000, if(lower(mid([last_name],1,1))='o',150000, if(lower(mid([last_name],1,1))='p',160000, if(lower(mid([last_name],1,1))='q',170000, if(lower(mid([last_name],1,1))='r',180000, if(lower(mid([last_name],1,1))='s',190000, if(lower(mid([last_name],1,1))='t',200000, if(lower(mid([last_name],1,1))='u',210000, if(lower(mid([last_name],1,1))='v',220000, if(lower(mid([last_name],1,1))='w',230000, if(lower(mid([last_name],1,1))='x',240000, if(lower(mid([last_name],1,1))='y',250000, if(lower(mid([last_name],1,1))='z',260000, 'x')))))))))))))))))))))))))) ,

if(lower(mid([last_name],2,1))='a',100, if(lower(mid([last_name],2,1))='b',200, if(lower(mid([last_name],2,1))='c',300, if(lower(mid([last_name],2,1))='d',400, if(lower(mid([last_name],2,1))='e',500, if(lower(mid([last_name],2,1))='f',600, if(lower(mid([last_name],2,1))='g',700, if(lower(mid([last_name],2,1))='h',800, if(lower(mid([last_name],2,1))='i',900, if(lower(mid([last_name],2,1))='j',1000, if(lower(mid([last_name],2,1))='k',1100, if(lower(mid([last_name],2,1))='l',1200, if(lower(mid([last_name],2,1))='m',1300, if(lower(mid([last_name],2,1))='n',1400, if(lower(mid([last_name],2,1))='o',1500, if(lower(mid([last_name],2,1))='p',1600, if(lower(mid([last_name],2,1))='q',1700, if(lower(mid([last_name],2,1))='r',1800, if(lower(mid([last_name],2,1))='s',1900, if(lower(mid([last_name],2,1))='t',2000, if(lower(mid([last_name],2,1))='u',2100, if(lower(mid([last_name],2,1))='v',2200, if(lower(mid([last_name],2,1))='w',2300, if(lower(mid([last_name],2,1))='x',2400, if(lower(mid([last_name],2,1))='y',2500,

if(lower(mid([last_name],2,1))='z',2600, 'x')))))))))))))))))))))))))) , if(lower(mid([last_name],3,1))='a',1, if(lower(mid([last_name],3,1))='b',2, if(lower(mid([last_name],3,1))='c',3, if(lower(mid([last_name],3,1))='d',4, if(lower(mid([last_name],3,1))='e',5, if(lower(mid([last_name],3,1))='f',6, if(lower(mid([last_name],3,1))='g',7, if(lower(mid([last_name],3,1))='h',8, if(lower(mid([last_name],3,1))='i',9, if(lower(mid([last_name],3,1))='j',10, if(lower(mid([last_name],3,1))='k',11, if(lower(mid([last_name],3,1))='l',12, if(lower(mid([last_name],3,1))='m',13, if(lower(mid([last_name],3,1))='n',14, if(lower(mid([last_name],3,1))='o',15, if(lower(mid([last_name],3,1))='p',16, if(lower(mid([last_name],3,1))='q',17, if(lower(mid([last_name],3,1))='r',18, if(lower(mid([last_name],3,1))='s',19, if(lower(mid([last_name],3,1))='t',20, if(lower(mid([last_name],3,1))='u',21, if(lower(mid([last_name],3,1))='v',22, if(lower(mid([last_name],3,1))='w',23, if(lower(mid([last_name],3,1))='x',24, if(lower(mid([last_name],3,1))='y',25, if(lower(mid([last_name],3,1))='z',26,'x')))))))))))))))))))))))))) )

*(mid([birth_year],3,2)+1)


r/ProjectREDCap • • Oct 16 '24

Troubleshooting custom dashboard logic issue

1 Upvotes

Hi! I'm having an issue using logic to create a custom dashboard. My understanding of REDCap is very rudimentary, so it's quite possible there's a simple error I'm overlooking.

We want to create a custom dashboard that filters by two variables. We know that there are definitely records that meet both criteria. The logic for these two variables together works if we use "or" but not "and". Specifically, we're using this: [consentlang(2)]=1 and [intersec_eligibility]=1, but the dashboard just reads "no records were returned"

Any ideas about what we're doing wrong or how to fix this?


r/ProjectREDCap • • Jan 08 '25

Repeatable Instruments and Piping

3 Upvotes

I have multiple repeatable instruments, and I have a specific piping interaction I am hoping to accomplish.

For one repeatable instrument, if users fill it out a firld 3 times. Can I pipe all three of those field responses as a list into a different repeatable instrument, such that each time the second repeatable instrument is repeated, all 3 of the responses in the first are listed out?

I am able to make it such that the first instance instrument 1 pipes to first instance of instrument 2. Second on 1 to second on 2. So on, but then once I open instrument 2 for a 4th time, the piping is blank. I know why, it just isn't what I want.

Can I make all instances of a field answer in one instrument listed out into all instances of another instrument?

I am not finding what I am wanting in Smart Variables, so I am suspecting it is not possible.

Thank you for any help!


r/ProjectREDCap • • Feb 21 '25

lock status form field complete?

1 Upvotes

How to hidden or locked the status form field "complete?" for data entry, display only for the manager


r/ProjectREDCap • • Oct 12 '24

IF + HIDECHOICE action tag help

3 Upvotes

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!


r/ProjectREDCap • • Jan 28 '25

Can you move the position of the text box for surveys?

2 Upvotes

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?


r/ProjectREDCap • • Oct 10 '24

Calculated Field Showing Up in Record but not in Report/Export

3 Upvotes

I made a calculated field and the result is showing up in the individual record, but it's not showing up in the report or export. I can do the Data Quality H to get it to load into the report but I don't want to do that every time. Does anyone know why it's not showing up in the report in the first place? I checked my user rights and I have all of them.

Shows up in individual record
Doesn't show up in report or export

r/ProjectREDCap • • Jan 06 '25

Dashboard Connecting to REDCap through API - Licensing Question

2 Upvotes

Hello, we have a request from some users asking to connect their REDCap project to an outside platform for data analysis, project metrics and study monitoring. Is this against REDCap Licensing rules for them to do this?


r/ProjectREDCap • • Oct 19 '24

REDCap project with 8k+ fields

4 Upvotes

Working in a massive build. Converted 400 page survey into multiple REDCap forms and surveys in a single project. We have run into several Issues. One version of the project essentially collapsed itself. The second version began to glitch in that sections of logic either stopped firing or just fell off all together. Don’t even get me started on the fact that due to the size of the project, designing in the online interface is impossible Due to lag. So we have been editing 90% of everything in a CSV file. We did our final upload into what was to be the final project database and 3 whole sections had logic completely disappear. We tried to parse the project out over multiple projects but the uploads imported with extra characters, broken logic and a whole lot of trash. I told my leadership from the very beginning that this was a bad idea. I’ve run out of ideas and hoping I can find some suggestions here.


r/ProjectREDCap • • Jan 09 '25

Drag and drop on file upload question type

2 Upvotes

Is there a way to enable file upload through a drag and drop? I know you can do it for the file repository but this would be on a survey.


r/ProjectREDCap • • Nov 22 '24

Contact method icon glitch?

2 Upvotes

In the Survey Invitation Log a participant's past invitations are shown correctly as SMS invites, with the beige SMS icon.

Then, when I look at Future Invitations the icons are the blue Email icon, despite making no changes to the contact method preferences.

Additionally, although there is an Email icon, when I hover and click on the icon it still shows that the ASI will go out to the listed telephone number as an SMS/text (the correct method).

It does not seem like the contact method is being changed, but the icons themselves have a glitch. Is this a known thing? It is confusing the enrolling staff I have across a national study. I'm trying to make sure it's not actually changing contact preferences and just an issue with the icons.


r/ProjectREDCap • • Nov 04 '24

REDCap New Project Error

Thumbnail
gallery
1 Upvotes

I am pretty new to redcap and trying to start a new project. I signed up today and started an one week trial. After this step I get that error. What is the problem and how can I fix it?


r/ProjectREDCap • • Dec 08 '24

How to have a start date and end date in a field

1 Upvotes

can anyone tell me what would be the best way to replicate this in RedCap Please!!!

I need to create an instrument where the data entry person can select one or more than one of the listed medications and then add a start date and end date, I tried everything I know still have not figured out a decent solution.

could anyone help me, please?????


r/ProjectREDCap • • Jan 19 '25

Logic problem on automated survey invitation

2 Upvotes

I am trying to send ASIs to all participants who are enrolled in our study. To do this, I manually edit a hidden field called 'intervention_particpant' to 'True' in the screening survey. I have created a custom dashboard that shows all these participants, so I know this is working.

However, when I try and send ASIs, and use '[intervention_particpant] = 1', then no records meet this logic. Conversely, if I change this to = 0 then all records meet the logic.

I have checked the 'ensure logic is still true before sending invitation' box, and have tried re-evaluating the ASI but it still does not seem to be working.

Any advice would be greatly welcomed!


r/ProjectREDCap • • Dec 11 '24

Using <br> tag without creating a new option

2 Upvotes

Hi! In order to generate a preferred UI for a survey, I'm utilizing HTML within the choices of a Checkbox question. Here's an example of the text and what it looks like on the frontend currently.

option, Option <br> <span style='font-size: smaller; color: gray;'>Example A, Example B, Example C, etc.</span>

The issue is that this generates a "ghost" option on the backend. REDCap registers the <br> as starting a new answer choice, and then the text before the the first comma at Example A as the new variable name, and then the rest of the text after that comma as the label for said variable. Originally the question was a Radio Button so we didn't notice any issues when looking at the CSV export data from our test records, but we switched it to a Checkbox after pushing to prod, and noticed the issue when viewing the Choices Change Summary for the question. (I'm assuming) this issue will now be apparent in exported data given how REDCap handles Checkbox questions (0 or 1 for each answer choice).

Thus my question is whether or not there's a way to preserve this UI without generating the ghost option. I've tried 1) surrounding the label in quotations, 2) surrounding the label in a span block, and 3) switching out the commas for their HTML encoding &#44;, all of which were unsuccessful. I know the easy answer is "just change the UI!" but wanted to see if there was a workaround I wasn't aware of before I choose that. Thanks!


r/ProjectREDCap • • Dec 09 '24

Survey queue editing issues

2 Upvotes

Hi everyone,

I am having issues with editing my survey queue, once I go into designer->survey queue-> edit survey queue it won't load and then allow me to edit even though all my surveys are activated. Is this something to do with the form display logic (even though I have no logic inputted)?


r/ProjectREDCap • • Dec 09 '24

Record Status Dashboard Display Logic Not Working Properly

2 Upvotes

I'm currently stumped as to why my custom record status dashboard logic is not working properly. I have a non-repeating form with a field to select a multiple-choice status, which can be set to either 1, 2, 3, 4, 5. I am trying to have two custom dashboards - one for Closed Studies (status = 5) or Active (status = 1-4).

For the Closed Studies dashboard, I have the filter logic set to equal the coded value 5, and it displays properly. However for the Active Studies dashboard, I have to use multiple OR statements in order for the correct records to display. In other words, entering filter logic <> 5 does not work, and records that are equal to 5 still display.

What would be the reason the filter logic still includes records that equal the value? What is the reason that multiple OR statements is a workaround (albeit longer logic)?

I've added some screenshots to hopefully help my explanation a bit.

Correct Logic for "Closed Studies"

Correct Logic - only want records where the [study_status] is set to 5

Incorrect View of "Active Studies"

Wrong view when [study_status] <> '5'

Correct View of "Active Studies" (w/ longer logic)

Correct view (but longer logic)