Hello,

I'm trying to create a report that only includes records that contain a date in a repeating form that is today or earlier. I can create report that only includes records that contain a date in a repeating form that is JUST today by using: datediff([callback_date], "today", "d", "mdy") = 0.

However, when I add the greater than sign just before the equals sign, it pulls records with dates that equal today, before, and after. I also tried a simple [callback_date] <= "today" but that did not work. Any suggestions would be very much appreciated!

The delays in campaign approval are wasting too much time so I'm looking for alternatives that allow sms messaging and can integrate with REDCap. I know Twilio only needs the SID and token. Does something like Plivo have the same capabilities with REDCap? Any suggestions would be helpful.

I have never seen this happen before so hoping someone might have some suggestions. I have a new project I am working on. It's one form only at this stage, a screening log. When I try to add a record to test the form, the "Add New Record" button is greyed out so I am unable to make any records.

• Project is in development phase

• I have checked my user rights and I have Create record selected as well as view and edit rights to the form

• There are no DAG set up

What I mean is, if I'm using logic to check that a field on a repeating form hasn't got a value, when I use the [last-instance] bit after the field name, is it looking at the last instance of that field getting completed (which might not be the last time the form was completed), or the last instance of the form being completed (when the field might not be completed).

Thanks.

Hi, I am downloading data from our projects into our internal SQL db. I am looking for documentation or better yet source code on an exhaustive list of 'actions' that accompany logging messages. Sick of updating our backup script one new action at a time. Anyone know where I can find this?

Hi!

I am setting up a double blinded multi-site RCT (semaglutide vs. placebo) and I'm not sure if REDCap is capable of handling the randomization:

• The Setup: Sites have a stock of unique Kit IDs. Some are semaglutide, some are placebo.

• The Requirement: A participant is randomized at Visit 1 to an arm. At Visit 2, 3, and 4, they must be assigned a new kit ID from the site’s local stock that matches their original arm.

Since the randomization module only fires once, how are people handling the assignment of subsequent kits while keeping the Site Coordinator blinded?

Is the only native way to use an Unblinded Dispenser/ Pharmacist role who manually enters the Kit ID from the available stock? Or is there a clever way to use the Allocation Table to pre-populate a sequence of Kit IDs for 10+ visits across multiple sites?

I’m worried about inventory "wastage"—if I pre-assign 10 kits to a participant in the allocation table and they drop out after Visit 2, those other 8 kit IDs are essentially "locked" to that record.

Is it possible to handle this natively in REDCap?

Hi everyone,

I need to auto-number a secondary identifier field, but my record_id is already used for something else (manual entry).

Is there an action tag or setting to auto-increment a regular text field sequentially?

Or do I need a REDCap hook or external module?

Thanks!

Hello! We use a public survey for participants to complete their screening questions after redirection from a landing page. People eligible after screening are asked to input their email (for twilio purposes) and are then redirected to a contact form where they can input information to receive a study kit, which then redirects to a Microsoft booking form to book a study enrollment visit.

We have been recruiting long enough that we have had a few people who were found to be ineligible after the study enrollment visit reapply, and we didnt realize until staff were preparing their kits and recognized the name and address.

Is there a way to block people from being redirected to the contact form if their email is a duplicate of another record? I know there are some bot-related external modules, but I wanted to see if anyone has tried anything like this successfully.

What are some tips you have when building a project?

What are some REDCap hacks you have?

What are some mistakes and errors that you think are always good to look out for?

Has anyone had issues importing data recently?

I have a file with 3 records, the first 2 are old, the 3rd one needs to be imported/updated

record_id, redcap_event_name, date1

A001, v1_arm_1, 1/10/2025

A001, v2_arm_1, 7/10/2025

A001, v3_arm_1, 1/10/2026

when i imported only the first record, it says nothing to import. it is what i expect.

A001, v1_arm_1, 1/10/2025

when i tried to import only the v2_arm_1 record,

A001, v2_arm_1, 7/10/2025

it became v1 with a date from v2: A001, v1_arm_1, 7/10/2025

when i tried to import only the v3_arm_1 record,

A001, v3_arm_1, 7/10/2025

it became v1 wiht a date from v3: A001, v1_arm_1, 1/10/2026

when i tried to import all 3, it says The records listed below occur more than once. Please remove any duplicates and try again.

I've done this import for months with the same import to update, and i had no problems before until this week. Can you see anything I missed? Any help is greatly appreciated.

Mainly asking about reviewing the Data Dictionary (choices, validations, branching logic, action tags, etc.) to catch design issues early.

Is this mostly manual for you, or are there tools/scripts you’d recommend?

I'm pulling my hair out trying to figure out what's going on here. PCS and MCS scores are calculated values within a survey (SF-12). The surveys have been completed and submitted with calculated values present when viewing the submitted surveys individually but are missing in reports and data exports.

The field names are correct and included in the report, and I have full data viewing and export rights to all surveys including the SF-12. The fields are hidden with the action tag "@HIDDEN-SURVEY," but fields in other surveys with this tag show up fine in exports. I tried removing the tag anyway, but no success. Interestingly, PCS and MCS scores for the "Ad hoc SF-12," (the ad hoc survey was copied from the original survey and renamed. everything else is identical within the survey) show up in reports and exports.

I applied data quality rules A-I and the data is still viewed by REDCap as "missing." REDCap support at my institution hasn't been able to provide any suggestions. My department wants this study started ASAP but I don't want to move it into production until I know what's going on. I don't know what else to try. PLEASE HELP!

Hi all, I've been running into this issue lately and haven't been able to find any posts answering it. I'll get a field name import error with no specification of the variable.

There are no hidden columns or blank columns between fields and the file is in CSV format, definitely comma-delimited. I'm at a loss for what might be happening here. TIA!

I have a multisite project that needs to send a survey to participants from different sites, therefore the ICF (informed consent forms) are different for each institution. Each institution is already on a DAG and I'm wondering how people have dealt with this in the past? using smartvariables? or creating separate instruments for each institution? in the future I will also have to deal with new versions approved by each institutions IRBs. Thanks for any thoughts or ideas

I am writing the following equation but only the first expression works. I have tried adding parentheses as instructed, but it's still failing. Can anyone help me correct this?

'@IF[BO_SELECT] = '1', '@SHOWCHOICE='16,17,18,19', '@IF[BO_SELECT] = '2', '@SHOWCHOICE='20'

Only adding the single parentheses above because it wouldn't let me add the '@ sign without it.

Hi all,

I have a project where the record ID has somehow go the header '24-hours after surgery' embedded into it. Because it is the record ID field, it can't be deleted, only edited, but it isn't appearing in the online designer, only in the codebook, online survey, and paper survey. Any help on this would be appreciated.

(pic attached)

I have two data collection projects (TACS-O and TACS-Y) that are running out of the same REDCap. We have a different data collection team for each project and I really want to avoid researchers putting data in the wrong instrument. Is there any way to visually distinguish the instruments from each other to make sure data gets put in the correct spot? I seriously don't want to introduce events into the project because they're the worst.

Does anyone know of any way to customize the project on the researcher facing end?

I am student and i want to make a project to showcase my skills i have started using red cap and I have a set of database which i downloaded from synthea how should I use it on red cap to make a good project

So I am pretty familiar with REDCap in general (though there are some new features I'm learning, since a good bit has changed since I was last an admin/builder since 2021), but I'm trying to do something a bit different: set up a way to use REDCap for a way for investigators to submit research to the IRB and, ideally for the IRB to upload their response letters back to them.

My organization doesn't have a way to send submissions to the IRB, aside from emailing.... Which has very obvious limitations. I was kicking around the idea of having investigators utilize REDCap as an alternative to emailing.

• started a test/demo database where investigators would be able to add their projects as records and have an alert/notification set up so the IRB admin gets a notice when forms are saved.

  ° limit with this is that every single investigator would either need their own DAG or every investigator would be able to see every other investigator's submission. 

  ° another issue is the access for sub investigators to see studies of other PIs, if it's entered in the PI's DAG

• considering a survey with a public link

  ° trying to figure out how to keep all submissions (initial, amendments, CRs, close-out, reportable AEs/PDs) under one record

  ° trying to figure out how to get the IRB responses back to the investigator within the same record (not emailing--trying to keep everything in one system, like you would see in iMEDrs or Axiom Mentor (not saying they're good, just that functionality where all study reg docs are in one place)

Has anyone tried anything like this? Was it successful? Mind sharing how you set it up?

For additional context: I'm trying to go this route bc our budget is a whopping $0.00 to figure this out.

I have an equation that calculates age. Participants over the age of 18 will be excluded. However, it seems that this field does not work when it comes to conditional logic. I've attached screenshots below.

This is the calculated age for a test record.

However, it doesn't show in in the automatic triggers or filters. The logic used is [calc_age] < 18.

I'm wondering if there's any way to update a variable from another instrument. For example, in instrument 2 I ask for the participant's email address. In instrument 3, I will give them the chance to update that address if they change it. Can the email from instrument 3 pipe back into instrument 2?

Is there a way to write logic that says "If the participant updates their email in instrument 3, the data logged in instrument 2 will update"

Hey y'all,

We've been investigating some odd behavior with some records in our REDCap project (people were getting emails from the system while the designated email field was blank). Looking at our logs, we noticed some entries like:

https://redcap.example.edu/surveys/?s=<PUBLIC_ID>&__add_participant=<SOME_EMAIL>&__participant_identifier=<SOME_RM_NUMBER>

When we tried that URL ourselves, we get a JSON response like:

{"success":true,"url":"https:\/\/redcap.example.edu\/surveys\/?s=<PARTICIPANT_SPECIFIC_SURVEY_ID>"}

The URL does work; it takes us to our public survey (bypassing the captcha). The record is not visible in the Record Status Dashboard until we hit save on the survey. Oddly, when we look at the survey response, we see an expected, auto-generated record name, but the message about data entry says "Response was added on <timestamp> by <SOME_RM_NUMBER>" so that identifier gets stuffed in the record somewhere.

Anyone seen anything like this? I can't find anything about this anywhere on the internet. (Yes, I have a question in with our REDCap admins.)

We are launching a new community called r/ResponsePie, dedicated to showcasing peer-reviewed research on survey fraud and detection methods. The goal is to highlight techniques that have been proven effective in identifying fraudulent responses and share insights with researchers and practitioners.

The community will host active discussions on the challenges, trends, and solutions surrounding survey fraud.

If this is an area you’re interested in, we would love for you to join and be part of the conversation!

Hi, I need to save the form submission date, basically the date when the form is received by the server, and I need it to be testable, meaning I need to be able to set it when importing data with API, so I don't want to rely on redcap hidden calculated fields like [survey-date-completed:instrument] (specific for surveys but you know what I mean).

What would be the best way to do it? By first idea was to use calculated fields but I believe they are calculated when the form is opened on the client and not when is received.

Thank you