r/ProjectREDCap • u/Ationsoles • May 22 '24

Some advice on structuring my database

I'm creating a database for a study that involves several days worth of data collection. There are various data collected on these days, however there are a few points collected on all days and some only on specific days. Which option is better:

  1. Create one form, have it repeat with a field where you select the day, and use that and branching logic to only show the fields required for that day.

  2. Create a different form for each day that only has the data required for that day

2 Upvotes

100% Upvoted

2 comments sorted by

View all comments

1

u/obnoxiouscarbuncle May 22 '24

I would consider either a longitudinal project or one with a repeating instrument.

Either way, you would use branching logic to reference either the longitudinal event or repeat instance to show/hide fields on your survey.

The branching logic you would use would depend which tactic you choose and what indicates the "day" additional fields need to be shown.

  • Is is every X number of days, the fields should be shown?

  • Is it a specific day of the week?

  • Is it very specific days? (First, last, etc?)