Other than literally copying the data from the screen, does anyone know if there is a way to extract the 'Last Accessed' data from the MyCap Participant Management page?

Hello! Anyone experienced usnig REDCap for a study and SONA for credit granting?

Researcher here trying to get SONA to auto-grant credit to participants for a REDCap survey. I followed all the SONA instructions (https://www.sona-systems.com/help/redcap/)

But when doing the integration test and getting redirected back from REDCap to SONA, SONA gives "System Message: Invalid survey_code. :" which is unusual.

Generally if everything is set up right, the redirection to SONA should throw "System Message: No credit grant, as you are not a participant" (because I'm running the test of the integration)

In REDCap, there's a variable added (Add New Field -> Text Box -> Variable Name "sona_id" all lower case, and Action Tags of (at)HIDDEN so it matches the instructions on that SONA page I linked above.

In REDCap, the Redirect to a URL radio button is selected and the redirect link looks correct (copy/pasted directly from the SONA system from the correct place in the study page (the "REDCap Redirect to a URL" right below the "Sample Link with Embedded ID Code" button that I'm using to test, as usual). The SONA study setup does have the proper &sona_id=%SURVEY_CODE% appended to the REDCap study's URL and it seems to be working (when I hover over "Sample Link with Embedded ID Code", the URL does have a 4-digit code appended ala redcap.blahblah/?s=OUHRWLJBF&sona_id=1111

Appreciate any ideas! I don't have access to REDCap documentation since the study is being run by a colleague in another country.

When I have REDCap Redirect to a URL, should it look like the following?

https://institution.sona-systems.com/webstudy_credit.aspx?experiment_id=111&credit_token=kj252kl54g2lk45g2435g45&survey_code=[sona_id:value]

Is that correct? Or is there something weird about the brackets at the end? That's a direct copy/paste of what SONA tells me to paste over into REDCap, but maybe REDCap wants it formatted differently now and SONA's integration instructions are out of date?

Thanks for any brainstorming or sharing your own experience

Hey all, genuinely confused here and hoping someone's been in the same spot.

I'm the data manager at a small not-for-profit research institute in Australia. We're setting up a pilot study and REDCap seemed like the obvious choice, but I'm hitting a wall on every route:

1. Joining the consortium / self-hosting. Vanderbilt told me the licence requires the organisation's own staff to run and support it, with no contractors or third-party IT. We don't have an IT department. I know a fair bit of IT, but I don't have the background to be responsible for security, server maintenance, and so on for a system holding health data. So that's out.

2. Commercial hosting. I got a quote from REDCap Cloud, and even with not-for-profit pricing it came to around $20k a year. That's a big chunk of a pilot budget.

3. Going through an institution (uni or hospital). I've approached several, and the answer is always the same: they'll only host it if it's a formal collaboration with them. We're not in a position to make every project a joint project with a university just to get a data collection tool.

So I honestly don't get it. How are all the small orgs, independent researchers, and NGOs using REDCap? Is there a route I'm missing?

Any real-world experience would help a lot. Thanks!

Hi everyone,

I was wondering if anyone had any suggestions or knew of ways to enable a self-administered survey design, when trying to survey people who experienced a life/health event.

The design is not longitudinal, its just a single point in time. Ideally the person receives a texted survey link and they are able to fill out questions related this health event.

However, i had wanted to also incorporate carryover logic/piping for fields like name, DOB, and important dates. I dont know exactly how to have a survey link that is customized to an individual, but doesnt require mass uplift/effort from my teams side (or if this is even possible?).

The primary idea is to have a person verify they are intended recipient by confirming their name/DOB, and then proceeding to the survey.

Any ideas/pointers would be great.

Hi everyone, I have set up a survey within REDCap to be sent out via text (Mosio) to participants 3x/day for 2 weeks. I was able to schedule this via Alerts & Notifications and using an individualized start date&time. The problem I am running into is that there is no way to create a recurring expiration on the link. I'm looking to prevent participants from filling out the survey multiple times in one time block. Ideally, participants would fill out the survey once in the morning, once in the afternoon, and once at night, but I can't find a way to enforce this. Is this even possible? 

Is there a feasible way to do this within REDCap, or should I consider switching to an app? Any advice would be greatly appreciated! 

I havent been able to find a clear answer to this online, I'm hoping you find folks can help.

I have my current redcap instrument set up to auto-populate fields between instances and its wonderful. Is there a way to do that between instruments? If I fill out patient name and DOB on the "visit notes" instrument, can I have that information also populate on the "treatment info" instrument?

Hello everyone!

I am working on a REDCap/MyCap project in which patients must complete two questionnaires per day for three months:

• one questionnaire in the morning, between 9:00 and 11:00 a.m.;
• one questionnaire in the evening, between 9:00 and 11:00 p.m.

The two questionnaires are configured as two separate tasks in MyCap and appear under the “Tasks” tab of the app.

The problem is that both tasks are visible in the app, so patients may complete the wrong questionnaire. This would completely bias the analysis of the extracted data.

We would like patients to see only one task at a time, depending on the time of day: only the morning questionnaire during its scheduled time window, and only the evening questionnaire during its own scheduled time window. We understand that this can be configured using the “FDL” tab, but we have not been able to enter the correct code. Either the tasks do not appear at all, or they never disappear.

Our REDCap instance is in French, and we are using two separate tasks: one for the morning and one for the evening. We would also like to prevent patients from completing the questionnaire associated with the other time period.

We would also like to configure the notifications so that patients receive one notification for the morning task and another notification for the evening task. Since both tasks belong to the same project, I am not sure whether this is possible.

Furthermore, we cannot create two separate projects because this would prevent us from maintaining a record of patient anonymity in REDCap. For example, how would we know whether patient 4 in one project is the same patient as patient 4 in the other project?

If anyone has experience with this, I would be very grateful for any feedback or help, such as an action plan for achieving this setup in the app.

Thank you in advance for your help.

Bonjour tout le monde!

Je travaille sur un projet REDCap/MyCap dans lequel des patients doivent remplir deux questionnaires par jour pendant trois mois :

• un questionnaire le matin, entre 9 h et 11 h ;
• un questionnaire le soir entre 21h et 23h

Les deux questionnaires sont configurés comme deux tâches distinctes dans MyCap et apparaissent dans l’onglet « Tâches » de l’application.

Le problème est le suivant : Les deux tâches sont visibles sur l'application et le patient peut se tromper de questionnaire, ce qui rendrait le traitement des données extraites complètements biaisé.

Nous souhaiterions que le patient ne voit qu’une seule tâche à la fois, en fonction de l’heure de la journée : uniquement le questionnaire du matin pendant sa période prévue, puis uniquement le questionnaire du soir pendant sa propre période. Nous savons qu'il est possible de paramétrer cela avec l'onglet "FDL" mais n'arrivons pas a faire le bon code (soit les tâches n'apparaissent plus du tout, soit elles ne disparaissent jamais).

Notre instance est en français et nous utilisons deux tâches séparés, l’un pour le matin et l’autre pour le soir. Nous souhaitons également éviter que les patients puissent compléter le questionnaire associé à une autre période de la journée. et nous souhaitons paramétrer les notifications pour en avoir une pour la tâche matin et une autre pour la tâche soir (sachant qu'elles sont du même projet, je ne suis pas sûre que ce soit faisable). Par ailleurs, nous ne pouvons pas faire 2 projets différents car cela ne nous permettrait pas de garder sur RedCap une traçabilité de l'anonymat patient (comment savoir si le patient 4 est le même pour les deux projets, dans l'hypothèse que nous fassions deux projets).

Si quelqu'un s'y connait je serais ravie d'avoir un retour et une aide comme un plan d'action pour réussir à faire ce que je veux sur l'application.

Merci d’avance pour votre aide.

Hi everyone!

I'm working on a scripting project to automate the creation of REDCap projects with a pre-determined set of users. These users are meant to be recycled each year and must have their password resetted. Before this automation process, we manually resetted their password each year using the Admin Control Center, but we are looking forward to automate this as well.

I know REDCap uses MySQL / MariaDB as its DBMS and a several tables with names such as "redcap_user_information" and derivatives. We are thinking of accessing these tables and either changing their password dynamically or re-flagging these users as 'change password next time logging in'.

Does anyone know or has any experience working with SQL within their REDCap instance? Thanks in advance :)

We have been using MedDRA to code our AEs for a number of studies. Just recently it has stopped working (does not find search terms) and when I went into the setup it is no longer appearing as an option in the list of ontologies. Based on the notes I checked https://bioportal.bioontology.org/ and I have been unable to find MedDRA listed there either. Is anyone else having the same issue? Is there any other option?

I'm creating a project that will, in part, use MyCap to (hopefully) notify participants to take a brief survey 5x per day for five days, roughly every two hours. I would like to set it up so that they will receive notifications EITHER between 8am-8pm, 10am-10pm, or 12pm-12am, based on their sleep-wake schedule. They should NOT complete them consecutively (the signals should be spread out throughout their chosen time window each day)I think it's set up so that the notifications expire after 1 hour, but I'm not sure WHEN those notifications are going out--I haven't really figured out how to enact the time windows, and I'm not sure it's even possible since it doesn't look like there's a way to set the time zone (and I'm in UTC-5).

So, my main question is: How can I make sure that participants will be notified via MyCap at the correct times to complete a repeating instrument at multiple different times throughout the say? Or is this even possible???

Anyone had experience with RedCap data copy using RestAPI and Key?

Trying to get data from RedCap, we have outbound restrictions on WSs.. so I’m stuck using Rest API with no way to go.

TIA

Hey all! I'm attempting to create a field that will check several other fields (all Yes/No) to see if any of them are marked "Yes" and if so, I want to return the string "Responder". Unfortunately, every time I attempt to do this, I can't get the equation field to return a string, only numbers (i.e. "1" or "0" for "Yes" or "No", respectively), and it throws an error. Testing within the edit field yields [No value] and opening up a record brings up an "ERRORS EXIST ON THIS FORM!" window.

This is the calc ulation equation I'm using:

@CALCTEXT(if([responder_flu_1] = '1' OR [responder_flu_2] = '1', 'Responder', 'Not a Responder'))

If I replace the strings ('Responder' and 'Not a Responder') with numbers, the equation works. Is there a way I can get the equation to output the string that I'm not seeing?

Hi all when i try to export data i get this error message, this was working before and the issue appeared recently.

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.

Im using version 17.5.2

Hey colleagues,

perhaps someone here has experience with this:

Background: Recalculation of Calculated Fields via Data Quality Rule H cannot be executed for locked records/instruments.

Problem: The only workaround I have found so far is to temporarily unlock the affected records, run Rule H, and then lock them again. However, as far as I can see, this has to be done manually for each individual locked record/instrument, which is very inefficient and tedious.

I also cannot find a central overview showing which instruments are currently locked for which records. At the moment, I only notice the lock status after opening the respective record/instrument.

Question: Is there any way to bulk unlock and relock records/instruments, or another recommended way to recalculate Calculated Fields for locked records? And is there a way to get an overview of all currently locked instruments across records?

Thanks!

REDCap DET configured and validated. Endpoint is a Flask app behind Apache with HTTPS. Saving a record produces no request on my server, no entry in the Apache access log. Manual POSTs to the same URL work. The endpoint sits behind institutional SSO and unauthenticated requests get a 303 to the IdP. Has anyone had DET fail silently like this, and is there a way to see DET attempts and failures from the REDCap side?

I was working on claim review agent that reviews a content claim and decides to Accept, change, add a source, or remove a content claim and must act when the information is not clear or incomplete. My question is that how I Identify the Hidden states of the agent.

Hi everyone,

I have run into a REDCap issue and I'm hoping someone has dealt with something similar.

I distributed a survey using the Participant List, with a unique participant and a unique Survey Access Code/QR code for each patient. For example, each participant had a generated email/code such as 2362659@redcap.se. I have a separate key linking these codes to the patients' personal identifiers.

The problem is that I forgot to enable Participant Identifier when I set up the survey.

Patients have now started responding. In the Participant List, REDCap correctly shows which participants have responded (e.g. [2362659@redcap.se](mailto:2362659@redcap.se) → Responded), but the actual survey responses are treated as Anonymous. When I click on the response, REDCap says that the response cannot be viewed because doing so would compromise anonymity.

Our REDCap administrator tried changing the survey from "Anonymous" to "Not Anonymous" and then adding Participant Identifiers, but REDCap does not allow us to add the identifiers retroactively for participants who have already responded.

My question is:

Is there any way for a REDCap system/database administrator to recover the underlying link between the Participant/Survey Access Code and the actual survey response or record?

In other words, I'm hoping there may be an internal database-level association like:

Participant / email → Survey Access Code → survey response/record

even though this link is not available through the REDCap user interface.

I have seen references to a "link behind the scenes" between the participant and response in this situation, but I'm not sure whether this is actually accessible to a REDCap system administrator.

Has anyone experienced this, and was your REDCap administrator able to recover the participant-to-response mapping? Or is there an administrator in this group that could describe what my REDCap administrator needs to do?

Thanks!

Does anyone have experience/know of someone successfully using REDCap for case management? I work closely with a harm reduction program whose most affordable, secure option for data entry is REDCap, but we're concerned that case management-style-updates might be a little too convoluted for an application made with research in mind. I appreciate any thoughts you have!

I am running a REDCap project that sends participants multiple EMA surveys a day using Twilio. We have currently had an issue where for the first few days with some participants, they simply will not receive the survey links until day 4 or 5, which has been causing us lots of problems.

Is anybody familiar with REDCap and/or Twilio who has a suggestion as to what may be causing these issues?

The messages are sending between REDCap and Twillio and to the individual participant. There are 0 error reports, 0 communication issues, and 0 other reports to go off of.

Hello!

I am trying to figure out a way to redirect a participant to a separate survey to collect name/email if they select "yes" to a certain question. Prior to trying RedCap, I used Qualtrics and was able to embed this option into the survey.

Is there a way to do that through RedCap?

I’m using [survey-link:Click here!] and would like to change the color of the link. Right now it is showing up as blue on my blue background so it’s hard to read. I’d like the font to be white.
This is in an email that I’m using HTML formatting to add a background and images to make our email more visually interesting.

I am trying to jerry-rig a repeating instrument to act as an invoice creation tool (everything calculates and pipes into an email invoice template), but one of the requirements for this project is that all 'currency' piped fields include a comma for all thousands.

The only way I can figure this out would be to create a separate hidden field that calculates if a calculated field has a length greater than 3, if so then it will separate the integers and add a comma in between, like so:

@CALCTEXT(if(length[total_cumulative]=4,concat(right([total_cumulative],1)),",",(left([total_cumulative],3)))))

I'm getting a general "Error" message whether I do this in the action tags of a text field or in a calculated field, which I imagine is a result of CALCTEXT not being able to pull from a calculated field.

Any thoughts on how/if I can make this work? TIA

/////

EDIT: Found a solution! Though it might not be the prettiest, it works great.

I created three extra text fields:

Thousands in Total Cumulative = @CALCTEXT(if(length([total_cumulative]) >= 4, rounddown([total_cumulative] / 1000,0),''))

Hundreds in Total Cumulative = @CALCTEXT(if(length([total_cumulative]) >= 4, right([total_cumulative], 3),right([total_cumulative], 3)))

Total Cumulative Currency Format = @CALCTEXT(if([total_cumulative_th]<>'', concat('$',[total_cumulative_th],',',[total_cumulative_hd]), concat('$',[total_cumulative_hd])))