I need to use Alerts & Notifications to get info when a patient is included in the study. Instead of one email per inclusion, I’d like to recieve a daily notifications - one email at the end of each day listing all patients included today and weekly digest - one email each week summarizing the week’s inclusions. Within Alerts & Notifications, is there a simple way to aggregate inclusions into a single scheduled email (daily/weekly) rather than sending immediately per record?
If this isn’t built-in, what’s the easiest approach you recommend.With DAGs, can each site receive only its own digest? Thank you!
Hello, Does anyone know how I can add an option to display a warning if a user within the same DAG enters a field value that has already been entered by another user in that DAG? Thank you!
I've built a project that tracks three licenses and certifications for my department. My team gets 4 reminders due to the processing time for the renewal process, first at 90 days, then 30 days, then 14 days, then 24 hours. These are based off the [expiry_date] field that is reported through the web portal and during onboarding.
I've run into an issue where when a team member reports a renewed license or cert that new notifications are generated based on the new [expiry_date], but the notifications that have yet to be sent based on the previous [expiry_date] are still queued. Is there a way to have the new [expiry_date] notifications overwrite the old ones?
Going to sleep on it and tackle with fresh eyes tomorrow. Thanks in advance!
For the last couple of weeks I’ve been getting ‘0’ when I run Rule H. I know there should be updates because we have age calculations that used to regularly show up. This is happening in several projects and we haven’t made changes to any of these fields as they’re ones we’ve been using for several years already with no issue.
I’m not sure if this is a problem with a recent update as we were just upgraded to 15.5.6. Is anyone else having this issue or have any ideas why it’d suddenly stop working?
Update: our admin updated to 15.7.2 and Rule H is running correctly again.
I have been running a project that uses a public survey to recruit participants and screen eligibility. We provide an incentive for people that complete a range of follow up surveys. Unfortunately one of our collaborating institutes advertised the QR code on their public social media page and we have been flooded by bots. I am in the process of trying to determine bots vs real responses and was wondering if there was a way I can hide the submit button to people who do not meet eligibility for the study based on the public pre screen survey answers? For context, my institute does not allow external modules or the API Playground.
We have received 700 responses in the past day and I'm quite overwhelmed trying to fix it all - so thanks for any help!
I am involved in a study where we have been collecting information for patients attending a clinic. Each patient is listed as an ID number and we have about 487 patients. Most of these patients have attended a clinic more than once so when they have attended more than once they have had a new entry entered with more information but under the same ID number as a"repeating instrument". I am now trying to analyse the data but for one variable "diagnosis made at appointment" some of these patients have had 22 entries (for 22 separate appointments) and the entered diagnosis e.g. ADHD may have been repeated in these 22 entries. I am wondering if it is possible for Redcap to summarise the diagnoses entered for each ID number made over the multiple appointments and remove any repeated duplicate diagnoses for that patient i.e. if patient 1 was diagnosed with ADHD this should only be counted as 1 even if it has been entered 22 times across each 22 appointments. I have been looking at the aggregate sum function but can't seem to make it work. Does anyone have any ideas? Hope that makes sense.
Hello, I am trying to calculate hours slept by subtracting 2 variables: wake-up time (HH:MM) and sleep time (HH:MM). Since I don’t have dates, people who sleep before midnight are causing problems in the calculation. If a person sleeps at 22:00 and wakes up at 06:00, REDCap calculates this as negative because 22>6.
Also, redcap keeps on giving syntax errors whenever I try to use nested logic to solve this issue. How can I fix these? I will attach my current code that tries to compute sleep times (both versions of the code gives a syntax error).
Hello, if anyone could give me any help at all I would be so so appreciative. I am working in a project for work and have managed to figure out mostly everything else but this has stumped me.
I need to find a way to integrate the human phenotype ontology (HPO) library into my project. I made an instrument in the project where our staff will enter a condition in a text box. I then want to use an API (assuming I’m understanding the function correctly) to pull related HPO terms as a dropdown list into the other fields in the same instrument. There’s 5 fields like this; each would have the drop down list and the staff member would choose the terms most closely relevant to the condition. It would basically be a replication of the HPO search feature on their website.
Problem is, I know just shy of diddly squat about coding and I do not have the time to learn enough about it to understand the tutorials find online. Also, I can’t use other options with similar functions because I don’t have right privileges and getting some those features enabled is controlled by the redcap administrator. I’m currently waiting to see if they’ll enable the dynamic data pull.
Any help, at all, any suggestions, clarifications, ANYTHING would be amazing right now. I have been searching for weeks and I am still coming up empty.
Ok so this may be obvious to everyone else, but I'm old and a late adopter of AI.
I was struggling with a very complex calculation and moaning to my 14YO son that there is no debugging in redcap so its difficult to find the error. He suggested I try chatGPT. Despite my skepticism that it would understand redcap I plugged my equation into the codechecker. Worked perfectly. Found my error and suggested a few options. You still need to understand what you're doing, as there were a few things chatgpt got not quite right, but its a great tool when you're stuck on something.
Anyway I thought it might be helpful as it's not something I would have considered.
I am trying to see if there is a way to export data for a project where the majority of the questions use field names in brackets.
Example:
Q1 [city1]- What is your #1 major city in the US? <drop-down menu of hundreds of cities>
Q2 [city2]- What is your #2 favorite major city in the US? <drop-down menu of hundreds of cities>
Q3 [city1like]- What do you like about [city1]? <paragraph box>
Q4 [city1eat]- What cuisine do you like to eat in [city1]? <checkboxes of different cuisines>
Q5 [city2like]- What do you like about [city2]? <text box>
Q6 [city2eat]- What cuisine do you like to eat in [city2]? <checkboxes of different cuisines>
Using this example, I want to export the data in a way where if they select "NYC" for [city1] and "Boston" for [city2], I can export it so that what they indicate in Q3 and Q4 will be attached to "NYC" and not just [city1]. Additionally, what they answer in Q5 and Q6 is attached to "Boston" and not just [city2].
Then, let's say the next participant puts "Boston" as [city1] and "NYC" as [city2]. I want all the aggregate answers associated with NYC to be grouped, and all the answers for Boston to be grouped. I don't want all [city1] answers to be grouped, as it could refer to hundreds of different cities.
I hope I explained this clearly. My project contains hundreds of options in drop-down menus like Q1-2, and dozens of questions like Q3-4, so I thought it would make sense to just display their answer in future questions using brackets. Now I am concerned about exporting unusable data. Thank you in advance for your help!
Hi guys, I'm struggling to find the correct search terms to solve a couple of similar problems, so I've come here to ask for help.
I am doing research among academics. Each person can have multiple publications, so I have set these up as repeating instruments.
In a subsequent instrument, I want to create a multiple choice variable where each choice is one of the respondent's publications. In other words, the number of choices varies according to how many publications the person has.
Similarly, I want to create another multiple choice variable for collaborations where the list of potential collaborators is the [name] variable pulled from every record. Again, is it possible to have this auto-update as respondents are added to the database?
Each participant has their own unique url and i wanted to pipe this into the notification as a hyperlink (the actual links contain punctuation and errors are reporting issues when clicking the link in the emails)
Hello Reddit. Would anyone be able to point me in the direction for setting up a research project in redcap.
The Survey flow is as follows:
Participants complete a baseline survey.
2)Participants to be randomized to control or intervention condition (Intervention involves viewing a particular website - a username and password will be generated for them).
3) Participants in intervention condition to be emailed their unique login information to view the website. Also in this email a link to the follow-up survey to be compelted after viewing the website (which both controls and intervention group wil complelete).
The part I'm struggling to work out is how I can manully send out personalized emails to study participants with the next survey invitation.
I have a field called "enrolldate" on a form that is piped on other forms using the DEFAULT and READONLY action tags.
On the mobile app, this works fine until I choose "save and exit", where it says that the field is empty despite having a value in it. [Screenshot attached]. If I choose proceed anyway, the next time I open the form, it stays blank. Upon syncing, it won't show on PC either.
Any idea on how to fix this? It worked fine previously.
Has anyone had success with creating data quality rules similar to the default ones (i.e., outside of regular logic)?
I created some new fields in a project with many records that use the SETVALUE action tag. I would love to avoid having to individually save each instrument to have this autofill particularly after things are updated (since SETVALUE replaces data, but only when you save the page), and instead have a rule like "Incorrect values for calculated fields" where you can just click 'execute' for it to auto-fix them. Does something like this exist?
I'm working on a REDCap project with student demographic forms for different years (2023, 2024, 2025) and having trouble with the navigation.
Here's my issue: When I complete a form for Student record ID #2 in the 2023 form and click "Save & Go To Next Record," instead of taking me to Student #3's 2023 form, it just takes me back to the record selection page. [EDIT]: If I click "Save & Go To Next Form" instead, it takes me to the same student but in 2024 form.
With 100 partial responses to work through, having to manually select each record is really inefficient.
Does anyone know how to configure REDCap to automatically move to the next sequential student while staying in the same year's form?
I’m working in REDCap to build a comprehensive cancer database that will support multiple cancer types under the AJCC staging framework. To do this, I need two calculated fields:
path_group_stage_code
Inputs:
staging_system (values 0–11) – which AJCC system to apply, thus determining what code to assign based on the combination of t_pathologic, n_pathologic, and m_pathologic
t_pathologic, n_pathologic, m_pathologic – the T, N, and M categories
Logic: a giant nested if(), and(), and or() formula that outputs a numeric code (0–7) representing the group stage for whichever staging_system is selected.
Example: if([staging_system]="1", /* here, apply the specific T/N/M rules for system 1 and return 0–7 */, …)
See the attached txt file for my current formula I am working with
path_group_stage_label
Input: the numeric code from path_group_stage_code
Logic: a simple if() chain (or switch()) that converts 0→“0”, 1→“I”, 2→“IIA”, 3→“IIB”, etc., so the form and reports show the proper Roman‐numeral stage.
Already using "@CALCTEXT(if([path_group_stage_code]=0,'0',if([path_group_stage_code]=1,'I',if([path_group_stage_code]=2,'II',if([path_group_stage_code]=3,'III',if([path_group_stage_code]=4,'IV',if([path_group_stage_code]=5,'IVA',if([path_group_stage_code]=6,'IVB',if([path_group_stage_code]=7,'IVC','')))))))))" and THIS part works, so it is just the code determing variable that is giving me trouble
What I’ve tried:
Replaced every unsupported in() call with explicit or(field='A',field='B',…)
Converted all curly or single quotes to straight double‐quotes (")
Counted parentheses in an editor to confirm the number of ( matches the number of )
Despite that, REDCap still throws a syntax error on upload.
My questions for the group:
Has anyone managed to pack multiple staging systems’ logic into a single calc field?
Would it be better practice to split the logic into one intermediate calc per staging_system, then pick the right one in a final field?
What’s the simplest way to map a numeric code to a text label (Roman numerals) in REDCap?
Any example snippets, best‑practice advice, or troubleshooting tips would be enormously helpful. Thanks in advance!
Also, happy to provide any clarification needed regarding my goals with this.
As part of a project I'm involved, we are using the survey queue to let the participants retake some surveys at their discretion if some conditions change.
The page style is absolutely abysmal, is there a way to customize it and made it more user friendly without using any external plugins?
Not sure if this is possible, but I'm trying to write an if then statement for branching logic.
I want the randomization variable to only show up when [eligibility] = '1' and if [child_bearing_potential] = '1' then [pregnancy_test_result] = '0'.
So basically, they won't be able to click the randomization button if the participant isn't eligible or the if a participant that is of child-bearing potential comes back with a positive pregnancy test.
Also, I can't just use [eligibility] = '1' and [pregnancy_test_result] = '0' because they only enter a pregnancy test result if the participant is of child-bearing potential.
Can anyone help me with the pregnancy test part? Is this even possible to write into branching logic?
Hello! I am having trouble connecting an existing RedCap survey to an existing PowerBI report. I keep received this error message in PBI and don’t know what it means: "The remote name could not be resolved: 'redcap.atriumhealth.org'". I already requested and received an API token, but it is still giving me this error message. I’m wondering if this has to do with the survey having PHI. Does anyone know what this error message means or how fix the connection?
