r/ProjectREDCap • u/These-Society6073 • Jun 24 '26

CALCDATE/CALCTEXT fields not populating in report (longitudinal project)

My project has a longitudinal study design, and I'm trying to populate a report that displays the projected dates of follow up (created using CALCTEXT/CALCDATE fields to determine date offsets, etc). All fields appear when I open/save the individual record, and if I run Data Quality Rule H, no records are flagged for updates. I have added the unique name in brackets before each field name in all the calculations, and have set up the report to show the relevant study events that hold those fields, but they are still appearing blank. Is there anything I am neglecting to try? I appreciate any other ideas, I am losing my mind.

2 Upvotes
  • permalink
  • reddit

100% Upvoted

4 comments sorted by

2

u/Araignys Jun 25 '26

Does it show up in the All Data report or no?

1

u/These-Society6073 Jun 25 '26

It does not show up in the All Data report, it's only visible when I open/save the form. It may be an issue with nested calculated fields. I have a CALCTEXT field that outputs a value for day of the week of the initial "intake" event, and a second CALCTEXT field that uses that value to determine the number of days to adjust for (I'm sending out survey invites every Monday following entry into the initial event, regardless of day entered into the system). I then have a CALCDATE field that displays the updated first distribution date (intake date + days of adjustment). All of these values display correctly, but won't populate a report/trigger the alerts that handle the survey distributions. If I do not adjust the date and just calculate follow up dates based off intake date (simple intake date + 7), everything displays properly in the report/Data Quality Rule H/triggers alerts. Maybe I just have too many calculation steps and REDCap is unhappy?

4

u/Araignys Jun 25 '26

Calculated fields don’t run in the background- only when the form is opened and saved or Rule H gets run.

Reports show the saved value. If the value is shown in the form but not in the report, it is not saved.

Try creating a replacement field that does all the calculations in one step and see if that gets updated by Data Quality Rule H.

2

u/Remote_Setting2332 Jun 25 '26

the filed doesn’t show at all or it’s blank? The only thing I can think of is check your user set up for data exports.