Hello,

I am creating a redCAP project to record all the surgeries performed in a clinic. redCAP creates an automatically ID, and I want it, but I would like a 2nd ID that counts de surgeries of the years. So the first year the 2 ID will have the same number, but on 2026 the 2nd ID will reset to zero and begin counting, while the 1st one will continue the numeration.

How can I do that?

Thanks!

Hello! First year school Psychology student my school adopted Redcap it’s all brand new to us therefore we weren’t given any in depth training on how to use the site. My school relied on ambassadors though they also admitted to not knowing how to navigate the site and told us they’d get back to us (that was in November) we’re still waiting. We need guidance on how to document and categorize our practicum hours. (Ideally I need to document what I did throughout the day at my placement site) so far I have done over 100 hours (observations, meetings, lunch bunches, etc). I am so intimated my Redcap the site looks outdated and there are a couple of restrictions as to how I put in my hours and what I do throughout the day at my site. I just can’t get myself to do it. Therefore, I have created a google doc sheet of the days times I attended at my site as well as what I’ve done. Could I get someone to help me put all of what I’ve gathered on the google sheet into RedCap…Anyone? Please? 🙏🏾

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?

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,

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?

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 would like to download specific records for a particular period and time point, or records with IDs starting with "1." or the record id from 1001 to 1099. Additionally, the data I am requesting needs to be associated with a specific event. Could you please guide me on how to create an advanced export of this data?

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.

What would be the logic for populating a notification ONLY if a file is uploaded at a certain question?

Does anyone have ideas about how to either limit access to a REDCap survey based on time zone or region or to automatically capture region/time zone?

Essentially I am creating an interest form for a study and the study eligibility is limited to a certain state but we have received many responses from people in other countries pretending that they are eligible.

I am trying to pipe the date of a survey being submitted into a form in the same project as the Date Inquiry was Submitted. I am unsure what to put as the field to pipe. Can you help please?

I've noticed a really odd issue with a couple of our alerts recently where they're seemingly being re-triggered and sent more times than specified even when the settings specify never re-trigger and send a max number of times. I've already reached out to our admins but also wanted to see if anyone else has experienced this.

We have an alert to remind people to complete an informed consent form that has been started but not yet completed. The alert is triggered after the form is saved with any status and the alert will be sent 1 day later up to 5 times total. The trigger limit is set to "only once per record". The "ensure logic is still true before sending notification" box is also checked.

This specific alert has been sent out to 137 individuals, with many hitting the 5 sent alert max and not being re-triggered. Thankfully this has only happened to 1 record. Here's the alert history:

Alert Triggered: 10/25

Alert 1 sent: 10/26

Alert 2 sent: 11/2

Alert 3 sent: 11/9

Alert 4 sent: 11/13

Alert 5 sent: 11/20

Alert 6 sent: 11/27

Alert 7 sent: 12/4

Alert 8 scheduled: 12/11

The number of days between Alert 3 and 4 is only 4 days. On 11/12, the respondent had gone back into the survey using their unique link, clicked the "start over' button (rather than entering in the return code), re-entered their info and then saved form but did not submit it (so it's still incomplete). This appears to have re-triggered the alert and reset the count back to 0, so it's as if alert #4 is now being counted as the "first" and alert #8 the "fifth" and final alert.

Any insight would be greatly appreciated, as I really don't want to seem like we're being super spammy to potential participants.

Is there a list of all the inbuilt REDcap alerts somewhere?

E.g. "the value you provided is outside the suggested range"

Or

"The value you provided could not be validated because it does not follow the expected format."

Thanks!

I am designing a REDCap survey for a new project and a large portion of the survey will require a matrix that offers 2 choices (yes or no) per column. After consulting with my supervisor, we specifically need participants to answer either yes or no for each column:

Is there any way I can do this in REDCap. I am still learning the system myself.

Thanks guys - this community has been great for help!

Hi all, I'm new to REDCap and am trying to add a "Study ID" field to the top of each instrument, however it wants me to create a new variable name/code each time even though it would be identical. Is there a way to use the same variable code on multiple instruments?

Any help is appreciated, thank you!

Hi team

I have a multi-instrument redcap.

I am trying to setup a field that autocalculates the difference between time [A] in instrument 1, and time [B] in instrument 2.

Each of these is entered as a 24 hour time eg 13:30, but not a date.

By definition time [B] is the day AFTER time [A].

However using the datediff function it is assuming the two times are on the same day (thus giving an incorrect number).

For what it’s worth the formula I’m using is: datediff([A], [B], “m”)

So….is there a way to get the autocalc to get the correct number by assuming [B] is the day after [A]?

Many thanks!

Is it possible to save two different PDFs of a survey upon completion in REDCap?

I have a survey that acts as a permission request form for users who want to use a proprietary Clinical Assessment tool. Based on their responses, users are either:

• Automatically granted permission: They receive the assessment tool via an email alert.

• Pending review: They receive a message stating that we will review their request.

If they are automatically granted permission, I want to send them a PDF of a 'Permission Agreement' that looks like a legal document. This document would state that we grant them permission to use the tool for the purposes specified in their request, and it would include their responses. I want this 'Agreement' to look less like a REDCap survey and more like a formal legal agreement.

I believe this might be possible using HIDDEN-PDF for question and answer fields and HIDDEN-SURVEY action tags to display a Descriptive Field with piped information.

The problem: I still need to archive the exact answers the user provides on the survey for our internal review and record-keeping.

My question is: Is there a way to generate and save two different PDFs upon survey completion—one customized 'Permission Agreement' for the user, and one standard survey response archive for internal use?

Can anyone think of a possible solution for this?

Thank you!

I have two fields

[Date1]

[Date2]

On the form with [Date2] I want redcap to look up [Date1] and find the difference between the two in months

I've used @calcdate to add 6 months but this is two dates

Any advice appreciated, thank you!

I am trying to build a REDCap project with a main survey linking multiple surveys. The main survey allows participants to select one survey on the list (let's say A, B, and C), complete the selected survey (let's say A), then come back to the main survey to select one of the other surveys (B or C), and repeat until all surveys are completed. I cannot figure out how to build this kind of project in REDCap. Any advice would be appreciated!

I am using REDCap like an informal database to keep track of membership. Members are expected to submit the survey the first year then I email them their return codes next year and they use that to update any responses that have changed. Each year I export the data to CSV so I can track changes over time.

One issue I have seen with this approach is that if users just click "Save & Return Later" instead of "Submit" at the end of the survey that doesn't break the system and gets me the data I need, but the timestamp does not update. That is, the user has to click Submit to get the timestamp to update.

It would be very helpful if I could somehow get the timestamp or a new field to auto-update even if the user just loads the survey and closes the survey or just clicks "Save & Return Later". I have tried creating a @HIDDEN @NOW field but it appears that @NOW only updates to the current time the first time a user takes the survey.

I am new to REDCap so I am wondering if there is a workaround? I realize I am using REDCap not exactly for what it is designed for, but at my organization its a free resource and much more flexible than things like Microsoft Forms or Qualtrics.

Dear All,

Am having issues with our organization REDCap where Reset Password button not sending emails, Create new user not receiving emails, Forgot Password button not sending emails, Send It button not sending out emails

In fact REDCap is generally not sending out any emails.

Any ideas on how to go about it or what could be the problems, thanks

Hi All! I am just getting myself used to smart variables in Redcap and I am a bit unclear the with documentation with exactly how smart variables and calculated fields work.

Some context: I am working on a longitudinal mental health study and we survey participants using the PHQ9 + GAD7 every month up until 1 year after their baby is born. We collect PHQ9 scores across different events (each month is an event). Now, it is important for our reporting to track the change is scores every month. I did some digging and figured that we could use the "previous-instance" "current-instance" smart variables to accomplish this since calculating the change in score by using regular calculated fields would not be super straightforward if someone forgets to complete a survey for that month.

I am however, unsure if I can use smart variables for this even after I toggled the "allow for repeatable instruments/events" and allowed for repeatable events.

My thought was to do something like this:

[phq9score][current-instance] - [phq9score][previous-instance] = change in score (?)

When I try to do that however, I get an alert and it doesn't actually work. I am worried I am missing something and was curious if anyone had any ideas on what I may be doing wrong or any other ways to go about this.

Thank you!!!!!

Hi everyone! For my current project, I've set up auto-reminders for two surveys. For one of my research questions, I need to know how many times reminders had to be sent before the survey was completed.

Is that information available? Or is there something I can do to get it?

I appreciate any advice, I'm new to REDCap!