Creating reports with repeating instruments

75 views
Skip to first unread message

Shreenidhi Sharma

unread,
Jun 25, 2024, 9:11:42 AM6/25/24
to Redcap Open
Hi all, 

I need to create a report where only people who have not had any repeated form filled out populates. We are using the repeated forms as a way to report contact attempts per participant, ultimately, I want to only include people we haven't contacted. 

When I try to build in the logic, I end up getting people who have 1 repeated form completed but since they don't have the second completed, they are included in the report. 

I don't think my redcap is updated enough to use [current-instance] etc. 

Thanks so much for all your help in advance! 

Amit Tandon

unread,
Sep 12, 2024, 12:01:56 PM9/12/24
to Redcap Open
When you say "who have not had any repeated form", do you imply that not even a single repeating instrument is filled? If this i so, you can check any auto filled, suffixed with [1] as suffice and test that it is blank. So for example, [form_date] is a filled which will always have vale then you can check [form_date][first-instance] = "" or isblankormissingcode( [form_date][first-instance]). If the condition is true then you have no instance of the repeat form
Reply all
Reply to author
Forward
0 new messages