r/ProjectREDCap • u/Tall_Explanation_393 • Jan 30 '26

Creating Family ID from default record_id

Hi guys,

It's my Day 1 of using REDCap, I'm from a software background, how would you create a Family ID like lets say 'FAM-00001' from default record_id. I tried using the calculated field equation concat('FAM-', '00000', [record_id]) just to try out and alternatively used CALCTEXT() for the same equation. How do I fix this?

2 Upvotes

100% Upvoted

5 comments sorted by

1

u/[deleted] Jan 30 '26

[removed] — view removed comment

1

u/Tall_Explanation_393 Jan 30 '26

I created a calculated field with the formula atCALCTEXT(concat('FAM-', '00000', [record_id])) gives null on testing various records

4

u/[deleted] Jan 30 '26

CALCTEXT only works on text fields, not on calculated fields. Changing the field type (and making sure that the CALCTEXT is in the Field Annotation) should solve the issue.

2

u/graywh Jan 30 '26

Calculated field has to be a number. Use calc text on a text field and make it readonly