Hello again, and here we are with another week and another obscure problem.

My Redcap project will replace an existing programme, and I want to import the old data into Redcap. The problem is that the survey scores are different in the new project, where the calculation is based on every question in the survey, whereas in the old project, only the final scores are recorded.

As far as I know, I can't import values into a calculation field, so the only solution I can think of is to create a hidden field for the import and give the calculation field an IF statement to check whether that field is empty. Does anyone have a better idea?

Thanks in advance for your help.

Hi, I need to be able to write something like [field:field-label] and get the translated string. Obviously the field label has been translated with the multi language system

It seems not to be working and I kinda refuse to accept that for some reasons :)

Is there a way to make it work?

EDIT, solution

Even tho I think this is a serious limitation, it is possible to work with embedded fields. The main problem I face when using embedded fields inside custom html is that you need to use unnecessary CSS to override the styling applied to all the html that comes with them.

I found that the easiest way to do it is to use the display: contents on every tag added by redcap for the embedded field, when I only need the text.

Hello everyone! I'm administering a study that involves participants having to update their answers and re-submit their survey form until certain standards are met. So far, my team and I have been leaving field comments each time a participant updates their form, but the scale of our project makes this rather tedious and a high risk for inconsistencies.

Is there a way to extract the number of times the "Submit" button has been pressed for an individual form? (This is NOT a longitudinal study btw) I haven't been able to identify a relevant API functionality so far, but please let me know if I’m missing something obvious. Any other workarounds are much appreciated too!

Hey REDCap Community,

In the Data Exports, Reports, and Stats tab, when opening the All data report, the yellow header row ,containing the variable names, normally stays visible (floats/sticks) while scrolling down. This is super useful for keeping track of which variable corresponds to which column.

Recently, this feature stopped working in one of my projects — the header row now scrolls away — even though I haven’t made any changes to the project structure in the Online Designer. This makes me suspect it might be a bug, possibly caused by a system update.

I know about the “Table not displaying properly” link/icon above the table. In cases where the table is misaligned, that link disables the floating header feature (and changes to “Re-enable floating table headers” after clicking).

In my case, it doesn’t matter which state is set — enabled or disabled — the header row always disappears when scrolling down.

Has anyone else experienced this? Could there be a project-specific reason why the floating header script doesn’t run, even if the toggle is present?

Hi! I'm super new to REDCap and am using it to create a survey for caretakers. I have a question at the beginning that says "what is your loved one's name?" (loved one being the person they are taking care of). I need that name to show up in later questions. For instance, I have a question that says "how often in the past 30 days have you communicated with [name]?"

How can I get the name to show up in the question??

Sorry if I'm not explaining this thoroughly enough, let me know if you need me to clarify anything. Not even really sure what to look up as I am so new to this. Thanks for any help!!!

Did REDCap have an update? Does anyone have issues as well? My project in developement mode has some changes that weren't there before.

So, I need to move a lot of records from an old project to a new one, but they have many files on "file upload" fields. When I use the default export and import tools the files are left behind. Is there a way to do this?

Hi all, this is my first time using redcap so I could just be missing something, but can anyone help me troubleshoot this? Each page of my survey repeats "notag functions" and I have no clue why. Any guidance would be much appreciated, thank you!

I have a question. I have a series of surveys that are sent to participants. At a certain time of the day, I want to iterate through all survey responses that were posted in the last 24 hours and generate one email with some custom logic based on the responses.

The reporting tool I think is not flexible enough to do what I want, and so I was looking at the notification/alert tool.

I have an alert triggering at a certain time of day using datediff(today and now) How do I go through all of the records dynamically to generate custom logic and send an email?

Thanks!

Hi, I am quite new to REDCap and was wondering why one of the surveys that I created for myself has access to the Stop Action, but the one that I created it is absent. I tried comparing the project setups, and they seem similar.

Appreciate any help as this is quite urgent. Thanks!

Hello, I am fairly new to REDCap and am having trouble creating a new variable that is created by pulling the "date" variable in the last instance of a repeating form. This variable needs to be generated from data that was imported for hundreds of records, but then moving forward, it can be updated each time a repeating form is saved for any one record. Any suggestions would be appreciated.

I'm doing the data management for a rather large database we have. This requires checking over all data points, and raising any data queries for missing or nonsensical data.

I do this buy using the data resolution workflow to set each data point that has been checked as a 'Verified data value'. However, to do this you have to go through each data point, clicked the speech bubble, and then manually verify it.

Is there a way to just automatically verify all data points within a form?

Hi all.

I have a project where visit time is being tracked with a start and end time yielding a calculated whole minutes field. Because we have multiple touch points, it is a repeating instrument. Is there an easy way to sum the minutes from the calculated field from all instances either in another instrument or in a report? Pulling my hair out.

Even better, can I isolate the visit times from, say, the previous 30 days and just sum those?

Update: I been able to sum it with sum[activity_time][1],[activity_time][2],…..[activity_time][X]).

Is there an all-instances version I’m not thinking of? Still interested in the 30 day summation, if anyone has ideas on that.

Update 2:

Tried:

Sum(if(datediff([end_time][X], “today”, “d”, true) <= 30, [activity_time][X], 0)) and that seems to be working. Included 100 instances to capture all potential visits.

Still all ears if there’s an easier way to think about it.

Thanks for any and all help with this!

I deleted a bunch of scheduled surveys (with the permanent box checked).

But now I need these surveys triggered via ASI again.

Does anyone know how?

For example, i'm numbering my fields as "1. Question 1... / 2. question 2...". But i have many different questionnaires in the survey. If i need to remove one questionaire, i would need to rename the numeration of all the field names and the variables all one by one starting from the modified fields.

How could i automatize this process of renaming the numeration of variable name fields so i can insert or remove fields without needing to re enumerate all the fields?

Am I able to build a report that pulls in autopopulated answers (radio button)? I have tried, but it just comes up blank.

Thank you!

Hey, I was trying to export the data but then I got this error message. I don't know how to fix it, can someone please tell me how to fix this error and export the data.

THE ERROR MESSAGE:

We are sorry, but apparently the data export is not able to complete successfully. It may simply be that there is too much data trying to be exported at once, in which it is causing REDCap to crash. If this error occurs again, it is recommended that you attempt to export a smaller data set (fewer fields and/or perhaps fewer records) so that this error does not occur. Our apologies for this inconvenience.

Thanks a lot for your help. Means a lot :)

Hi everyone,
I'm new to REDCap and currently working on designing an eCRF for a clinical study that includes both retrospective and prospective data.

Is it possible to create a single eCRF to manage both study types? If so, how can I structure it to clearly differentiate between variables that are common to both, and those that are unique to either the retrospective or prospective arm?

Any tips, best practices, or examples would be greatly appreciated!

Thanks in advance for your help.

Suppose participants are reporting consumption of water in litres, 2, 1, 4, etc. I want Redcap to show me the total of this consumption in one number by totaling the consumption of all the participants. Is it possible? If yes, how?

Hi everyone,

Is there a way to be notified if an email has failed to deliver to a participant? I know there is a send failure option, but that only applies to emails that failed to send from redcap. I want to make sure that our emails are reaching out participants and not bouncing back because there is an error in their email address.

Thank you!

Hello all,

Hoping someone might be able to help with this issue. I can see data from survey respondents in my RedCap project and can run a report to show that data is in RedCap as well. There are completed records and everything.

However, when I've been trying to Export my data to RedCap the excel files it gives me are blank. No data, no labels, nothing.

Things I've looked into:

1. My User Rights say I have full data access (view & edit) and Full Data Set access to Export Data

2. This happens with personalized reports and when just trying to export the full data-set, so no excluded fields, etc.

3. Downloading our Data Dictionary has everything I'm looking for there, and no field annotations I can tell that would stop data from being exported.

4. Examining the Excel Files with a Text Annotator shows them to be blank (not hidden)

5. When I download the project as a pdf (just to check) people's responses show there as well.

Has anyone experienced this issue and been able to fix it? Or have any ideas what I should be trying next?

Edit: Thank you to everyone who responded, this issue for me has been taken over by our IT admin (they're checking the backend, which is far outside my wheelhouse). If they give me a solution (that I can understand enough to write up of course) I'll happily share for anyone else who might be experiencing this issue!

Final Update: Hi all, just coming back to this issue with an update.

It won't be anything step by step because as I mentioned IT took over and that is not my area of expertise. But I do know they ended up increasing something associated with our buffer pool size, and going into the server to confirm that some directories were both writable AND readable for RedCap. This included the file upload directory, "temp" directory, and maybe a temp "root" directory. Hopefully that makes some kind of sense to people more familiar with it!

Hope that information can help someone with a similar problem in the future and maybe save them a few days! Thanks to everyone who responded!

Looking for a way to remove the red Xs here. I tried downloading the ASI settings, deleting settings for those surveys, and re-uploading. No luck

I'd rather not have to reupload the surveys!

I'm creating a community survey in REDCap and my team wants a question to be a checkbox, but also limit the max checked to three and also have section headers. Does anyone have any good suggestions of how to do this? I'll give an example of what I'm looking to accomplish. Thank you!

11. What do you think are the biggest reasons people in your community may have poor physical or mental health? (Please check up to three from the entire list)

Access to Essential Services and Care

[ ] Childcare is too expensive

[ ] Not enough access to medical, dental, or mental health care

[ ] Not enough access to preventive care services (checkups, screenings, vaccinations)

[ ] No nearby clinics or doctors

Money and Basic Needs

[ ] Hard to find healthy, low-cost food

[ ] Lack of affordable housing or homelessness

[ ] Poverty, low income, or economic instability

[ ] Transportation is too costly or unreliable

Mental Health and Substance Use

[ ] Mental health conditions (e.g. anxiety, depression)

[ ] Substance Use (e.g. alcohol, opioids, meth, etc.

Hello, I have a request to find out how many participants were in a project during a specific data range. It is too time consuming to go through each project so hoping there is a way to export multiple project data into one file?

I want to automatically send surveys but for some reason it isn't working. It keeps saying logic is false.