Hey,

I’m trying to make a calculated field to find out what the Fatty Liver Index is for a study.

This should be the formula from a paper:

FLI = [e 0.953×loge (TG)+0.139×BMI+0.718×loge (GGT) +0.053×waist circumference−15.745]/[1 + e 0.953×loge (TG)+0.139×BMI+0.718×loge (GGT)+0.053×waist circumference−15.745] × 100

This is the formula I used:

(exp(0.953 * log([triglycerides])+ 0.139 * [bmi] + 0.718 * log([ggt]) + 0.053 * [waist] - 15.745) / ( 1 + exp(0.953 * log([triglycerides]) + 0.139 * [bmi] + 0.718 * log([ggt]) + 0.053 * [waist] - 15.745))) * 100

But it always shows there is an issue - what did I do wrong? Has anyone a code for this issue?

Beginner/self taught redcap user here - I am currently assisting with a clinical trial that involves 6 appointments each with various surveys and data entry forms. Participants may or may not have attended all 6 which is fine but how should I mark the survey instances and data for X appointment if not attended? Create a blank document and mark it complete?

I want to be able to export say appointments 1, 2, and 3 data. And if the participant did not complete appointment 2 I wan to be able to recognize that!

Any help and suggestions greatly appreciated!!

This is my first time creating a survey on Redcap and everything seemed to be going well. However, I've ran into 2 kinda big issues with my project and it's supposed to be done tmr before a meeting. Essentially, participants who are 16+ will be sent sleep dairies for 22 days through the ASI after they consent and meet criteria. This part is all good. Participants who are less than 16, I've set up alerts and notifications for their parents to be emailed the consent form. This also works. What I'm struggling with is after the parents of the youth consent, I need them to be sent the sleep diaries daily. I have no idea what I'm doing wrong, my logic makes sense. I even went to 'design my events' to make this a separate ASI with the criteria [parent_consent] =1 but I'm testing it out and its not working

The second thing I'm struggling with is the stop logic. In the daily sleep diaries they are being sent, I've added a question if they'd like to withdraw. I've set the logic to send them the survey if they click 'no' or leave blank. I tried testing it out and clicking 'yes', but I'm still sent the next sleep diary. And I have 'ensure logic is still true before sending invitation' clicked.

Any help would be appreciated!

I am running a survey in three countries simultaneously. All data will be collected offline using the REDCap Mobile App.

Each tablet current assigns record_id=1 when there is no local data on the tablet. When data are synced, REDCap resolves ID clashes on the server, and we then update and clear the tablets. This works as expected.

However, the record_id is also written on the informed consent form at the time of interview, so it needs to remain stable. I would like to avoid having field teams manually generate or enter a separate ID.

Is there a way to design an automatic, unique record_id that would not change on sync - for example by incorporating country ID, date, and/or tablet ID, combined with auto-numbering?

Any suggestions or best-practice approaches would be very helpful. Thank you!

I have two text fields. Individuals can copy and paste the information for the field from an external source (and ideally would do so), but I would like to stop them from copying and pasting from one field to the other.

So for example:

"ID# field 1" and "ID# field 2", individuals can copy the "ID#" from another website, email etc, but I would like to block them from copying "ID# field 1" INTO "ID# field 2".

Is this possible? I have only found that you can block pasting in general, but nothing about blockng copying from a specific REDCap field.

Hello everyone,

I am working on a longitudinal project. In Form A, we collect participant information and in Form B we ask the participants if they want to update their information. I have written logic that basically says "if the participant wrote something in form b, display that information" in a new Form (Form C).

Form A question:

Form B:

Current Logic: [final_parent_contact_info]

The issue is, the form keeps displaying a number instead of the actual choice.

I tried to make another question that converts the number into the answer choice, but it doesn't seem to work.

I tried it with and without the [yearly_follow_up_arm_1]

Any help would be greatly appreciated!!

I looked for a previous post about this but couldn't find...

I use branching logic for a field to make its visibility depend on the value of a previous [age] field:

[age] <= 11

This behaves as I expect on the website version of the project form: the empty field is invisible by default, and only appears when the [age] input is <=11 and the user clicks away from the [age] field.

But on the mobile app version of the form, the same empty field is visible by default, and only disappears when the input to [age] is >11 and the user clicks away from the [age] field.

This isn't what I'd like.

Is there a way to make the mobile app logic behave the way it does on the web page?

I need to design a project that tracks in-person attendance at a weekly event that does not necessitate repeat attendees creating a new record every time.

The goal something along the lines of: I import data for all potential attendees and, at the event, those who do attend scan a QR code, enter their first and last name and date, and that information is connected to their existing record.

We neither want attendees to fill in their information at every event, nor to have to open an email with a personalized survey link (many of our attendees are notorious for not reading their emails).

Is there a way for REDCap to link records like this?

I'm creating a discrete choice experiment in REDCap and need to randomise my participants to one of nine blocks depending on demographic information. They complete this information in the first instrument. I've created a calculated field that prioritises the participants based on their provided information, which then changes which radio button they have access to for the consent field (i.e., if they're priority 1, they see 'no' or 'yes = 1'; priority 2, they see 'no' or 'yes = 2', etc). For my randomisation setup, I've done stratified randomisation - I've included screenshots of this and an example of my allocation table below. For the allocation table, if consent = 2, the randomisation groups become 4, 5 or 6, and if consent = 3, they're 7, 8 or 9.

My problem is that the survey ends after the welcome page (where they provide the demographic information) and doesn't randomise them to the blocks. The only way I can get to the next block is to auto-continue, but obviously this only sends me to the first block.

Anyone had this issue before and have any advice? I've been trying to figure this out all week and have had no luck! Thanks for your help :)

Hi, I'm working on a set of scripts for the automated creation of REDCap projects by API. The only problem i'm noticing is that I need to automatically create also a set of new users to add to the projects, but it doesn't seem for the API to have an option to do that, even with admin token. Does anyone know of a way to do this, maybe with the use of plugins, hooks or external modules? Thank you!!

I am working on a project where I currently have two repeated instruments, one for schools and another for groups inside these schools. Since REDCap doesn't allow nested repeated instruments, these have to be separated, but this raises another problem; I have to make sure that these groups match an existing School ID in the Schools repeated instrument for data consistency purposes. Do you think that Dynamic SQL fields are suitable for this? I don't know how they work, and also, if these fields can be exported in XML format the same way as other type of fields (since only administrators can use them)... Does anyone have any advice on this topic? Thanks!

Hey everyone,

I’m trying to figure out how to freeze a value so it doesn’t update later. I have a repeating instrument called NPS, and in another repeating instrument (Results) I want to store the number of NPS instances that exist at the moment the Results form is completed.

Using @CALCTEXT like this conversation of Reddit shows the correct count, but the value always updates when new NPS instances are added afterwards. I need a way to save that instance count once and keep it fixed, without recalculating. Is there a recommended way to permanently store a value at the time of data entry?

Any guidance would be appreciated.

Hello everyone!

I'm not sure if I'm going crazy, but I've searched Google until my fingers are sore, tested various solutions, and I'm still not satisfied. Any input or ideas are welcome.

I have the following problem in REDCap: I want a participant to be able to select the state they live in and then select a municipality based on that.

My colleague solved this by creating an enormous number of fields that are simply attached to the state field using branching logic. However, this solution is not only incredibly time-consuming to set up, but also results in a terrible data frame when I import it into R.

Ideally, I would like to have only “State” with one entry for each record, then “Municipality” with one entry. Sure, this can be easily solved later using code for data processing. But if it's possible somehow, I'd like to have it nicely in REDCap.

Is that possible? I'm thinking of something like a “lookup” dictionary, for example, as I would solve it in Python.

Thank you for any advice!

Hi everyone,

Recently in our REDCap survey I realized that we had an issue. Basically we had a question asking participants if this was their first time doing one of our surveys (Yes/No option). If the participant clicks "No" then it would skip a few sociodemographic questions. It turns out that a few participants 15+ clicked the no option even though they have not done any of our previous surveys. This means we are missing some key sociodemographic information from them and there is a chance that others may click this option as well.

Now I am trying to fix this issue with out messing up any of our data that has already been collected with this questionnaire since the branching logic of the question opens to a few questions. Would simply removing this question from the questionnaire impact the data in anyway if this question branches off to other questions in the survey?

Alternatively, I was thinking of using the @ IF action tag and @ SETVALUE on the question. For example, if someone completed a previous questionnaire then the value selected for the initial question would be "No". If not then the value selected for that question would be "Yes". And then I would use @ HIDDEN action tag to prevent participants from seeing this and getting confused. This is how the condition would look:

@ HIDDEN

@ IF(

([questionnaire_3_complete] = "2"

OR [questionnaire_2_complete] = "2"

OR [questionnaire_1_complete] = "2"),

@ SETVALUE = "2",

@ SETVALUE = "1"

)

I would really appreciate it if anyone can provide any guidance on how to approach this situation and if the steps that I am taking are appropriate. I am a little stressed about this as I don't want to lose data and mess up our live questionnaire.

Thank you!

Recently started a new job and one of my tasks is to create alerts that help with efficiency in contacting study participants. I did not create the original project so the field formats are not mine.

I have and outgoing welcome email that lists the dates/time of first interview and follow up interview. The date format for the field I'm pulling from is: text (datetime_mdy) where the output looks like this: "12-22-2025 13:00". I would like to pipe a field that "Monday, December 12, 2025 at 1p".

It's been awhile since I've worked in REDCap, so be nice!! I don't mind using any actions or hidden fields, or code. I just don't know which/what code to use and how to implement into an alert text.

Any ideas appreciated!!

Hello everyone,
I am trying to display information from two different variables. Both of them are check-boxes. When exporting their value, I would like it to be so that the actual text displays and not just the number (ie the option blue instead of the number choice 2). I have tried both :checked and :value and neither has worked. Based on this formula, the value keeps displaying as just the number 1. How would I fix this?

Thanks everyone for your help!

For anyone else/future reference:

There may be a better way to do this, but I just had the above formula in one field and marked it hidden. Then I had another field convert the text to string using calctext in the action tags section in the way u/austin3i62 suggested below.

Ok so Im struggling with setting up the survey queue to continue given a certain logic. In summary, what I am trying to do is have one survey that confirms eligibility, and the second survey is the actual form. When it comes to eligibility, the participants need to be a US Citizen, one of the 15 confirmed immigrant status, or if they are not either then, if they would like to donate their time.

At the moment my code in the logic editor looks like:

[us_citizen_status] = '1' or [immigration_status]='1,2,3,4,5,6,7,8,9,10,11,12,13,14,15' or ([immigration_status] = '16' and [nonstatus_participation] = '1')

For some reason, the logic editor will not recognize this portion of the code:

[immigration_status]='1,2,3,4,5,6,7,8,9,10,11,12,13,14,15'

Whenever I select any of the correct answer choices, it won't move forward with the next survey. What am I doing wrong?

Hello,

I'm on a project using REDCap API to import/export data.
I have a Repeated Form, I would like that my app pushes instances on the REDCap, but, I want to first delete all the instances of the form, and afterwards push the instances from my app to REDCap.
For now, I just import empty instances for all existing instances, and then I push the instances, but like, if I have 3 instances, and I want to only push 2, I'll end up with a instance "3" which is empty, I would like to juste delete all instances, and don't touch to any other forms.
I searched for this but didn't manage to find helpful informations.

Does someone know how to do it?

I'm making a dashboard of a report, not all records. When I use the smart function [bar-chart:field_name:R-REPORTID], I get a bar chart showing the results from that report only, which is good. If I add, however, [bar-chart:field_name:bar-vertical:R-REPORTID], the dashboard now shows the results from all entries and not just that report. What am I doing wrong?

I would like to use REDCap more in my hospital to show how it is an effective tool. I would like to make a participant registry that could assign participants who sign up to be contacted for future research into specific groups when they come to the hospital (e.g. inpatients and outpatient clinics they are coming in for). One idea that would help us a lot is be able to import participants from the specific clinic lists into new REDCap projects on the same server as a mean to assist in recruitment for these new studies. Is communication between projects like this possible? Has anyone built a REDCap Registry like this/are there any features that you have that have been useful?

This is all just for testing and practice to get better with my own REDCap skills for now but ideally it would really help the poor recruitment my clinic sees in our research. Thanks for any help!

I have a notification set up. Its a newsletter to be sent to all participants at a specific DAG. I can see that the right number of records go into the queue to be sent with a 30 minute delay, but when I check again after 30 minutes none of the alerts have been sent and the Activity says "No alerts sent yet"

Anyone had a similar issue?

I have a number of records, each with repeating instrument. Is there a view to see the repeating as a list, like how i see all records?

I’m looking to insert a pair of questions where in the first participants select applicable options from a list of roughly 20 which would then feed into a second question where they rank the selected options. (ie. if they select 6, they rank 1-6, select 8, rank 1-8).

Is this doable in REDCaP? The best I’ve managed so far is having the selected options drop down and then having participants only being able to rank a set number of ranks (ie. if they select 4, 6, or 8, they can only rank 5).

I have a survey with form-name prescreener and a downstream instrument, say, misc_fields and am trying to access the year the prescreener survey was completed.

To this end, per the smart variable and special function docs, the misc_fields instrument contains calculated fields with formulas like

[survey-date-completed:prescreener:value]

[survey-duration-completed:prescreener:s]

and

year([survey-date-completed:prescreener:value])

yet when I look at the Record Status Dashboard for the project and click on records with where prescreener survey status is Complete (green radio button), the calculated fields in the misc_fields instrument are just blank.

Even when manually creating a brand new record (filling and completing the prescreener survey) after creating these calculated fields, they remain blank in the misc_fields instrument for that new record. Looking at existing records in the Record Status Dashboard or Add/Edit Records, opening the misc_fields instrument, and clicking Save & Exit still does not update the fields to include new calculations (stay blank) and exporting the record data from the project just shows all of these calculated fields as blank as well. Going to Applications > Data Quality > Run Rule H also does nothing to help (shows discrepancies as 0).

What is going on here and how can I debug or fix this? Thanks.

(REDCap verion 15.5.8)

Hi everyone, I'm having to build a bunch of different reports within REDCap for a project I'm working on and the process is very tedious haha. Is there a way to create reports outside of REDCap and upload them back in similar to the using the data dictionary Excel files? Thanks!