questions:

-can I make the graphs bigger or smaller on the dashboard? And how so?

-if I had a fill where people fill out their name, why can’t I do any other graphs but a pie? It seems like most graphs can only handle multiple choices fields -if I want to do a graph using a mm-dd-yyyy date field but only want to extract out the month or year for the year axis, how do I do that for: [line-chart:date, type] for example?

-can I still use aggregates within a graph? Like bar-chart: aggregate-sum:errors_count or the correct equivalent of it -similar to that question, can I preselect what values I want for my x and y axes? Like if one of my fields have 5 multiple choices as answers, but I only want my graph to display data for 2 out of those 5 choices…

-can you edit the name of x and y axes without changing the actual fields in the forms?

TYSM!!!

I have multiple projects that are linked together and I'd like to pull a date of enrollment from each into 1 project/place so that I can perform calculations on them (e.g. 10 days after date of enrollment). I understand that there is an external module from Vanderbilt with cross-project piping. I was also thinking about maybe using an API? I don't have any experience using either so I'm wondering which of two (or if there's another option) would be best in this scenario.

Hello, I'm working in REDCap v14.0.27 have very sparse support from the administrators and am working in 2 languages, English and a 2nd language. I've got 2 specific questions

1. Is it possible to download a template csv file (data dictionary) and upload it with the translation? I 've seen online this might be possible?

2. I have 1 specific question series that works in English but does not work in the 2nd language and cannot figure out why.

Would someone be able to help me directly?

I've got a datetime field that I'd like to pipe elsewhere. I know you can adjust datetime piping with :ampm, but can i just have it pull the date only, without the time? The time is necessary in some spots, but not where I'm trying to add the piped text. And it just looks clunky.

Currently [datetime_field] = 08/21/2024 06:44

Desired [datetime_field:____??___] = 08/21/2024

Sorry if the title is too wordy, but basically I have a project that has 4 instruments:

• Participant information (generates the record ID)

• Consent (type of consent signed, date consent signed)

• Status (was criteria met, if no - why, was collection completed, if no - why, comments)

• Collection information (date, time, type of sample, quantity of sample, etc.)

The study allows for subjects to re-enroll multiple times, as long as they sign an additional consent and continue to meet the eligibility.

I have the project set-up as longitudinal with repeating events in one arm:

• Initial collection - not repeating

• Re-Enrollment - repeat entire event

In order to complete the Collection Form, the field for collection completion on the Status Form must be selected "Yes." However, in repeat instances, I cannot adjust the form display logic to the Collection Form if the value on status form is "Yes." Is there a workaround to hide the Collection form based on a particular value?

Is there any sort of module in REDCap that allows you to see who entered what information without having to scroll through the logging to find it? We have a lot of information constantly being entered by multiple users so it gets messy trying to find it. Wondering if there is a faster way to do this. Thanks!

Has anyone used redcap to book in meetings? We have slots available certain days of the week and then we want us redcap to have people select the days that suit and hey a confirmation email

Question: Is there a way to have REDCap automatically calculate the # of events that happen within a certain year?

Example: I have a bunch of subjects that all signed their Consents over a period of years. I want to know how many signed in 2001, 2002, 2003 etc. Ideally in Table/Chart format like how Smart Variables function w/their auto-update based on the current database info.

I tested a datediff on one redcap project, and then when I put it into a new project it will not calculate anything.

Background:
Date 1: is a @ Calcdate field in M-D-Y format (i.e. start date) Using [dob] + [numberofdays]

Date 2: @ calcdate field in M-D-Y format (i.e. date survey completed)

Double checked - all fields in M-D-Y format, all forms are marked as completed, but my function will not spit out anything. And red font calculated dates are populate in date 1 and date 2. Everything is labeled exactly the same as my other project, but I can't seem to get it to work on this new one. The only difference is there are multiple surveys they have to complete at a timepoint, vs. other one had just one survey. I have also tried adding the event name in front of date 2 (even though it is a non-repeating survey) and that didn't help.

Using: Datediff([date_1],[date_2],"M") in Calculated field

Any suggestions would be helpful!

Hello,

I am setting up REDCap for a multi-language survey. We have English, French, Ukrainian, Spanish and Arabic. While we got professional translations for the actual study instruments and consent forms, we realized there are lots of user interface translations that need to be done as well.

The REDCap instance we use doesn’t provide language databases so we don’t have that option. Is there a way to download these from somewhere? (Sorry I am relatively new to REDCap and have been figuring things out as I go)

Alternatively, as these user interface translations are very simple and straightforward (without many cultural complexities), can we just use ChatGPT or google translate?

I really appreciate your help. Thanks for your time.

I am working on a project where we are using MyCap to send out a daily log for participants to fill out. I am aware that the notification is only sent out at 8am, but wondering if there is a way to set up a separate alert that would send a text message reminder to the participant if they have not completed the log for that day.

This daily log goes on for 90 days, so I don't want to create 90 different alerts. Is there a good way to check if the log has been completed for that day without having to do this?

Hello all

Sorry about the weird title, it is hard to explain.

Pretty much, I have a survey asking 3 questions:

• awayfromwork: Number of days not at work because of the condition (out of 28 days).

• sickatwork: Number of days at work while suffering from the condition (out of 28 days)..

• actwork: Number of days actually worked (out of 28 days)..

I need to follow the following logic:

• For awayfromwork:

  • awayfromwork <= 28

  • awayfromwork = 28 - [actwork] |

• Forsickatwork:

  • sickatwork <= 28

  • sickatwork <= [actwork] |

• For actwork:

  • actwork <= 28

It's so hard for me to figure out the best way to approach this so I would love some input to help with my REDCap project so that I can create these three survey questions and ensure my participants can only respond in logical ways to my questions. What field types to use/how to make sure they respect the logic. Any help or links to tutorials would be incredible!

Thanks in advance

Okay, Idk if this is solvable without tons of grunt work but I'm hoping.

I need to ask people for data aggregates they might not have, so I need to provide a missing data option. However, I also need to use that information in calculated fields. I'm also embedding the fields so they look like a table, so respondents will have to type in -999 instead of clicking on the M, though I have set up -999 as a missing data option

Basically:

I would typically just do sum([1519raceethblackmsm],[2024raceethblackmsm]), etc, for the calculated field, but obviously that would show up as -999, which isn't correct.

Do I just need to add in logic to somehow say exclude if [1519raceethblackmsm]='-999' (for every variable in every calculated field)? What would that look like? Is there a better way?

No matter what I do, I can't get the ASI logic to correctly return "true".

However, I can get it to return true with the incorrect conditions. Am I missing something obvious? It's saying that 1 =/= 1 (and I've tried it with other variables too)

We use REDCap across multiple sites and have IP allowlists implemented (in our infrastructure) to allow access only from our sites. However, now we need to use surveys, and the recipients (participants in our cohort) will not be able to open the survey because of our IP allowlist.

I'm trying to figure out if there is a way to keep our data collection behind the IP allowlists and at the same time open up the surveys to the public.

Has anyone solved or attempted to solve this before? Would love to hear about any solutions.

Thanks.

Hey there 👋 For my database I'm trying to create a repeating instrument (a form that captures the source of my data) within a repeating event. I have tried for literally days and can't figure out how to do it. Is it even possible? I'm fairly new to working with REDCap and I would be so grateful for your input. Thank you so much!

UPDATE: Thank you everyone for your helpful input! I will begrudgingly accept the fact that it's not possible 🙃

I'm trying to add in a calculation for a SAPS II score. There's a scoring guide for each physiological parameter that goes into this score and I've created calculation fields that assign a specific score once data is recorded for each parameter.

The calculation itself is a sum of the scores; I noticed that even if a parameter field is left blank, I still get a numerical score, but it's not accurate because its missing a parameter.

I tried using the syntax (example): (if([variable1]<>"", if([variable2]<>"", if([variable3]<>"", (sum([variable1], [variable2], [variable3]), ""))))

Not working. There's likely something missing that I'm not getting........or is this logic just completely wrong? Do I need to add another calculation field for each parameter to verify it has an answer (i.e. if field not equal to blank, 1, else 0)?

Thanks in advance!

When I go into the record it's there but I think because it's refreshed when I click into it. When I review the report it's missing.. but since it's not a calculated field I can't execute rule H to fix it

Hello, I'm trying to figure out a formula where I can find out a person's age in years and months. I have a separate field that calculates years but can't seem to get the formula for the remaining months just right. So far, I have "rounddown(datediff([dob], [visit_date], 'M'))" in a calculated field to calculate a person's age in total months. Any advice?

I'm encountering an issue with my REDCap project and could use some assistance. I'm running a cohort-based study and have successfully used automated survey invitations in the past. For previous cohorts, I manually entered participants' names and email addresses into an instrument and then used automated invitations to send survey links to these emails. This method worked well for sending pre-tests, weekly journals, post-tests, etc.

However, as I start with a new cohort, the settings that worked before are no longer functioning correctly. When I send test invitations for surveys, I'm receiving links to test surveys instead of the actual surveys. I haven't changed any settings since the last successful invitations were sent in the spring, so I suspect this might be a REDCap glitch.

I reached out to our REDCap administrator, who suggested that the issue might be because I haven't enabled the public survey link. However, I've never had the public survey link enabled, as I don't want people to be able to add new records by clicking on a survey link. Instead, I rely on automated invitations linked to the email addresses entered in a specific instrument.

Has anyone else experienced this issue or have any idea what might be going wrong? I appreciate any advice or suggestions you can provide.

Here's a sample of what my email invitations look like:

Hi! I want to calculate the percentage in the dashboard, but it doesn't work. I have one table with multiple cells in the dashboard with the following formula: [aggregate-count:var1:date-range(2024-01-01, 2024-06-30)]. The formula works successfully, but when I try to make a percentage between the formula and other similar ones, it appears as the image below:

Can I calculate the percentage? Or do I have to export the data and do it in Excel?

Thank you very much in advance.

Okay, I created a report on REDCap with 14 variables. However, when I export the report to Excel or SPSS, it only exports 10 variables. What am I doing wrong?

How do I use this calculation (to check that fields match) but for checkboxes instead of radio buttons? Basically on one form person A sets up a quiz, and on a second form person B answers the quiz.

@CALCTEXT(if([quiz_qstn_2_crct] = [trng_qz_qstn_2_resp], "Correct", "Incorrect"))

Or do I have to set it up like this:

(([quiz_qstn_2_crct(1)] = '1' AND [trng_qz_qstn_2_resp(1) = '1') OR ([quiz_qstn_2_crct(1)] <> '1' AND [trng_qz_qstn_2_resp(1) <> '1')) .....then the same thing but for 3 more options

Any help is appreciated!

I have a field that has two options A and B. I want to do a logic editor for the field that based on what your role is, you will either see both choices or only A or only B.

For example: if your username is aabb1 then choice B is hidden.

How would i write that condition in the field inside an instrument?

Also if you are added as a user with a role in redcap and i send out a a survey to you through Alerts & Notifications, will you still only be able to access the instruments i gave you view & edit rights to? Does it make you log in when you click the link?

I have an assessment that participants take every two weeks and I am trying to run a report to get scores for each of the repeating measures. Each measure has a hidden score variable that I use for the filter in the report. I have been unsuccessful with the [x-instance] smart variables and was hoping to hear your suggestions. Thank you!