{"field_name":"record_id","form_name":"baseline_data_start","field_type":"text","field_label":"ID"} {"field_name":"cpr","form_name":"baseline_data_start","field_type":"text","field_label":"CPR (Danish civil registration number)","field_note":"ddmmyyxxxx","identifier":"y","required_field":"y"} {"field_name":"inclusion","form_name":"baseline_data_start","field_type":"text","field_label":"Inclusion date","text_validation_type_or_show_slider_number":"date_ymd"} {"field_name":"inclusion_time","form_name":"baseline_data_start","field_type":"text","field_label":"Inclusion time","text_validation_type_or_show_slider_number":"time_hh_mm_ss"} {"field_name":"dob","form_name":"baseline_data_start","field_type":"text","field_label":"Date of birth (From CPR)","text_validation_type_or_show_slider_number":"date_ymd","field_annotation":"@CALCTEXT(if([cpr]!=\"\", concat(if(mid([cpr], 7, 1)>=0 and mid([cpr], 7, 1)<=3,19, if(mid([cpr], 5, 2)>=0 and mid([cpr], 5, 2)<=36 and mid([cpr], 7, 1)>=4 and mid([cpr], 7, 1)<=4,20, if(mid([cpr], 5, 2)>=37 and mid([cpr], 5, 2)<=99 and mid([cpr], 7, 1)>=4 and mid([cpr], 7, 1)<=4,19, if(mid([cpr], 5, 2)>=0 and mid([cpr], 5, 2)<=57 and mid([cpr], 7, 1)>=5 and mid([cpr], 7, 1)<=5,20, if(mid([cpr], 5, 2)>=58 and mid([cpr], 5, 2)<=99 and mid([cpr], 7, 1)>=5 and mid([cpr], 7, 1)<=5,18, if(mid([cpr], 5, 2)>=0 and mid([cpr], 5, 2)<=57 and mid([cpr], 7, 1)>=6 and mid([cpr], 7, 1)<=6,20, if(mid([cpr], 5, 2)>=58 and mid([cpr], 5, 2)<=99 and mid([cpr], 7, 1)>=6 and mid([cpr], 7, 1)<=6,18, if(mid([cpr], 5, 2)>=0 and mid([cpr], 5, 2)<=57 and mid([cpr], 7, 1)>=7 and mid([cpr], 7, 1)<=7,20, if(mid([cpr], 5, 2)>=58 and mid([cpr], 5, 2)<=99 and mid([cpr], 7, 1)>=7 and mid([cpr], 7, 1)<=7,18, if(mid([cpr], 5, 2)>=0 and mid([cpr], 5, 2)<=57 and mid([cpr], 7, 1)>=8 and mid([cpr], 7, 1)<=8,20, if(mid([cpr], 5, 2)>=58 and mid([cpr], 5, 2)<=99 and mid([cpr], 7, 1)>=8 and mid([cpr], 7, 1)<=8,18, if(mid([cpr], 5, 2)>=0 and mid([cpr], 5, 2)<=36 and mid([cpr], 7, 1)>=9 and mid([cpr], 7, 1)<=9,20, if(mid([cpr], 5, 2)>=37 and mid([cpr], 5, 2)<=99 and mid([cpr], 7, 1)>=9 and mid([cpr], 7, 1)<=9,19,17))))))))))))), mid([cpr], 5, 2), \"-\",mid([cpr],3, 2), \"-\", left([cpr], 2) ), \"\"))"} {"field_name":"age","form_name":"baseline_data_start","field_type":"calc","field_label":"Age\r\nNote: Apparently, the build in datediff() function does not handle counting whole years. This results in wrongly counting age higher around the date of birth.","select_choices_or_calculations":"if([cpr]!=\"\" and [inclusion]!=\"\", datediff([dob], [inclusion], 'y'), \"\")"} {"field_name":"age_integer","form_name":"baseline_data_start","field_type":"calc","field_label":"Age integer\r\nNote: as opposed to the build in datediff() this handles counting years as integers very well. Calculate decimal years in statistical programming software. In R you can use with(ds, stRoke::age_calc(dob, inclusion)).","select_choices_or_calculations":"if([cpr]!=\"\", left([inclusion], 4)-left([dob], 4) - if(mid([dob], 6, 2) < mid([inclusion], 6, 2) or (mid([dob], 6, 2) = mid([inclusion], 6, 2) and mid([dob], 9, 2) <= mid([inclusion], 9, 2)), 0, 1),\"\")"} {"field_name":"sex","form_name":"baseline_data_start","field_type":"text","field_label":"Legal sex","field_annotation":"@CALCTEXT(if([cpr]!=\"\",if((right([cpr],1)=1 or right([cpr],1)=3 or right([cpr],1)=5 or right([cpr],1)=7 or right([cpr],1)=9),\"male\",\"female\"),\"\"))"} {"field_name":"cohabitation","form_name":"baseline_data_start","section_header":"History and social","field_type":"radio","field_label":"Cohabitation","select_choices_or_calculations":"1, Yes | 2, No"} {"field_name":"hypertension","form_name":"baseline_data_start","field_type":"radio","field_label":"Hypertension","select_choices_or_calculations":"1, Yes | 2, No"} {"field_name":"diabetes","form_name":"baseline_data_start","field_type":"radio","field_label":"Diabetes","select_choices_or_calculations":"1, Yes | 2, No"} {"field_name":"region","form_name":"baseline_data_start","section_header":"Area","field_type":"dropdown","field_label":"Region","select_choices_or_calculations":"1, North | 2, East | 3, South | 4, West","text_validation_type_or_show_slider_number":"autocomplete"} {"field_name":"mrs_assessed","form_name":"mrs","field_type":"radio","field_label":"Assesed","select_choices_or_calculations":"1, Yes | 2, No"} {"field_name":"mrs_date","form_name":"mrs","field_type":"text","field_label":"Assessment date","text_validation_type_or_show_slider_number":"date_dmy"} {"field_name":"mrs_score","form_name":"mrs","field_type":"radio","field_label":"mRS score","select_choices_or_calculations":"0, 0 | 1, 1 | 2, 2 | 3, 3 | 4, 4 | 5, 5"} {"field_name":"con_event_note","form_name":"consensus","field_type":"descriptive","field_label":"[follow1_arm_1][event_type][1] : [follow1_arm_1][event_type][2]"} {"field_name":"con_mrs","form_name":"consensus","field_type":"text","field_label":"Same event type","field_annotation":"@IF('[follow1_arm_1][event_type][1]'='[follow1_arm_1][event_type][2]',@DEFAULT='pass',@DEFAULT=\"fail\")"} {"field_name":"con_calc","form_name":"consensus","field_type":"text","field_label":"calc","field_annotation":"@CALCTEXT(if([follow1_arm_1][event_type][1]=[follow1_arm_1][event_type][2],[follow1_arm_1][event_type][1],\"fail\"))"} {"field_name":"event_datetime","form_name":"new_event","field_type":"text","field_label":"Time of event","text_validation_type_or_show_slider_number":"datetime_seconds_ymd"} {"field_name":"event_age","form_name":"new_event","field_type":"calc","field_label":"Age at event","select_choices_or_calculations":"if([event_datetime]!=\"\", left([event_datetime], 4)-left([inclusion_arm_1][dob], 4) - if(mid([inclusion_arm_1][dob], 6, 2) < mid([event_datetime], 6, 2) or (mid([inclusion_arm_1][dob], 6, 2) = mid([event_datetime], 6, 2) and mid([inclusion_arm_1][dob], 9, 2) <= mid([event_datetime], 9, 2)), 0, 1),\"\")"} {"field_name":"event_type","form_name":"new_event","field_type":"radio","field_label":"Neurovascular event","select_choices_or_calculations":"1, TIA | 2, AIS | 3, ICH | 4, SAH | 99, Unknown"}