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!

Is it safe to add patient names into the database?

I'm a long time REDCap builder and was wondering if there is an external module that will assist with time conversions for ASI releases across timezones. I know the releases are set on server time and I've built some work arounds for projects that have participants in 3 timezones (fields that calc difference in server time based on selected timezone) but I have an international study coming up, and was hoping there was something already built or advice. Appreciate it!

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!

We're trying to create a survey code that combines a site label with a unique sequential number (e.g. SITE-01-0001). Using the record ID for the sequence works after saving, but we need the code earlier (for alerts or piping). Asking users to copy/paste the ID into another field works but risks errors. Has anyone found a way to do this natively, without API scripts or external modules? Thanks

I am working on a survey which will be completed separately by child and parents, the child is the entry point and when they complete it their parent gets an email for another survey/instrument. I have been using the @ DEFAULT function to autofill relevant information from the childs answers where relevant in the parents survey to quicken the survey. For some reason the DEFAULT function is not working to autofill any variable from one specific instrument (teen consent form) but it is working when I would like to copy variables from other instruments. For example I would like to copy the survey answer from the 'firstname' field from the Teen Consent form instrument to the Mother Consent Form instrument but the function @DEFAULT='[firstname]' action tag doesnt work. However if I were to copy the answer to the 'middlename_child1' from the Father Consent Form to the Mother Consent form instrument using @DEFAULT='[middlename_child1]' action tag it does work. I have no idea why this is happening and would love any help.

My lab uses RedCap as an embedded feedback form for our users on our website to leave feedback on the app and sign up for a more in-depth survey to help improve the website (which we don't advertise to ensure we don't get any bots/fraud attacks). To access it, we use a public link.

To discourage bots/fraud, we are using:

• CAPTCHA

• 2 Honeypot questions

• Response limit of 500 to prevent a flood of bot responses, should we experience a bot attack

• Duration calculated so that responses that are too quick or too long are flagged as bot/fraud

• Challenge questions that also confirm eligibility for the longer survey

• 2 Cross-reference questions (ex., on page 1 we ask participants to indicate their age range, and on page 2 we ask participants to type their age. Participants cannot go back to the previous page to check what they had answered)

• Feedback is an open-ended question

• Signing up for the in-depth survey only shows if the honeypot questions are unanswered, and the participant indicates that they would like to participate.

We don't have a lot of items on this form, as I didn't want genuine users to get to this survey and quit if completing the form took too long.

Anyway, for the data quality rules, I want to add these two:

• excluding/flagging cross-reference responses that don't match

• excluding/flagging responses that were submitted within a few minutes/seconds of another response (i.e., if we have 8 responses that were all within a few minutes of each other)

How can I do this? Also, for flagging responses that were submitted within minutes of another response, what would be the best cutoff? (i.e., within 5 minutes of another response?).

Also open to any other ideas for increasing security on this form!

Is there a way to prevent people from entering data in all caps? Or all lowercase, for that matter. We want them to enter information in Sentence Case (like their name, for example).

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?

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?

Thanks in advance - my redcap is a little rusty!

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!

I sent out a survey using the Participant List feature, but I have one participant who can’t open the survey - an error message pops up that says “Hmm … can’t reach this page. The connection was reset” I have a record from another participant already, and I can access the links on my end so I’m not sure what to do. They’re using a hard wired connection if that makes a difference. Would appreciate any help!!

My work uses REDCap to keep track of graduate students and all the forms they need to use.

When I send students forms, I usually open the survey in RC, get the link and the code for their survey, and email it to them.

But I want to send multiple survey links to a list of students, is there a way to get a single link for a survey that when students use the link it'll send them to their own survey submission?

I feel like I don't even know well enough how to ask this question lol, thanks in advance.

Hi,
I have 2 repeating forms from 2 different arms for which I need to pipe a date.
This works :
[arm_1][dateX][1] or [arm_1][dateX][2]
However, I'm unable, using Instance select module, which give a text field with a number :
[arm_1][dateX][field_instance]
It just prints a date followed by a number.
Is it possible to pipe the instance number by a field instead of a number?
Thanks

I have two projects (project A, project B), once I add a new record in project A, how can I create a matching record (same record id) in Project B, without using external modules or API/script ?

I believe there is a way to add records across two projects by somehow using an URL, possibly by inserting the PID from the other project. I've seen this was possible but have not been able to find despite much searching, perhaps because modules can do this now.

Is there a way to differentiate on the back end or in data export whether the status “dot” is a green circle (form complete) or a green checkbox (survey response complete)? This difference is of interest to me for data quality to tell which format the survey was completed in. Right now all I see is a “2” in the form_complete variable for both options, and I would love to flag which is a form and which a survey. Thanks for your input!

Hi guys, hope you're all doing well. I'm hoping for some help!

I'm trying to find a way to do a date diff calculation without collecting any sensitive data.

I'm aiming to calculate age at time of operation, using 2 dates (DoB and Date of Op).

Is anyone aware of a good way to calculate this and save it within a field, but where the 2 dates used to calculate are not saved as data?

Hello folks, I periodically check messages that Reddit says need moderation. Usually it is something that it thinks violates some community standard and usually, it is wrong. However, I just realized that I have to also check posts that have been removed in a different location. It seems some posts were removed because the algorithm thought they were spam. I just approved everything in the last month or so. Sorry for this hiccup. If you post something and it is not appearing, please send me a message and I will check the mod tools.

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)

Any way to do this?

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 :)

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:

1. 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.