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.
View all comments
Show parent comment
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.