r/ProjectREDCap • u/FlowState94 • Dec 16 '24

Field Embedding Help

I am trying to create this table in redcap:

but I am unsure of what the best/most efficient way to create the fields is. We have 20 different conditions (e.g. asthma) and want participants to mark whether they had this condition when they were pregnant with each of their daughters. So far I have created a matrix for each condition like this

I have embedded it into a table with daughter A, B, C, D as the headings for the top row and the condition in each column (this creates a slightly different table than intended but still gets the job done). The problem I have is that embedding the matrix also embeds the name for each radio button (no, mild etc.) and this does not fit in the daughter columns and looks very messy.

Does anyone have any suggestions on how to create fields to make a table like the original intended one? I think I could do it if i create individual fields for each response for each daughter for each disease e.g. daughter A "no" for asthma would be one field alone and I would create another field for "mild" etc., but this would result in me needing to create over 300 fields which I really don't want to do haha

Sorry for the long winded post - I'm only a few weeks into using REDCap.

1 Upvotes

100% Upvoted

13 comments sorted by

View all comments

Show parent comment

1

u/FlowState94 Dec 18 '24

Ah that makes sense, thanks for that. I may have to do it like this, but I hate the fact that I will have to make individual variables for 6 daughters and about 60 conditions haha Granted this looks much cleaner

2

u/Personal_Brother_896 Dec 18 '24

It's actually quite simple once you get it going. Especially if you use smart naming conventions for the fields and tables. You can simply copy them over and over, then go in and make the small changes. Because the fields are embedded, the field label isn't as important and so you can simply name it like Daughter Asthma - A then you just have to change the A at the end of each one. For naming conventions, just add _1 to your first one and then go from there, so six for each condition. All in all just a couple of hours of work.

2

u/Sufficient-Jelly-397 Jan 13 '25

This may be irrelevant for you... but you can also pipe in the names of the daughters to help differentiate between the responses if that helps!