In the field box you will see an optional field that allows you to embed a YouTube video within the survey. @HIDECHOICE -- Hides one or more choices of a multiple choice field. This will trigger REDCap to perform the calculation and populate the field. Contact us at nctracs@unc.edu or 919-966-6022. Advanced Labels and Secondary Unique ID in REDCap Oregon Clinical & Translational Research Institute 81 subscribers Subscribe 19 2.1K views 2 years ago In this video, The REDCap Team at. REDCaps E-Consent functionality, available under Survey Settings,allows you to mark a survey as being a consent form. 5. REDCap is a system for collecting and storing data, including Patient Health Information (PHI) that is sensitive and identifiable. REDCap includes tools to communicate securely and safely with participants, members of the research team, and other collaborators. For more details about these features and how to use them (including a recap of how External Modules work), Interested in using features that go beyond REDCaps base functionality? If a survey is set up as repeatable, the participant will see a link to make a new instance of it on their survey queue. A simple question set will be used to determine which methods a participant uses. This REDCap module replaces a text, radio, or checkbox field with an image that users can interact with to select one or more options. Please sign up for the drop-in session [link] to get this or other external modules activated. This external module provides a tool for you to check for duplicate data across two or more projects. If you wish, you can rename the record_id variable name (to something such as study_id or participant_id) as soon as you create the project. This way, you can test all new branching logic or calculated fields without affecting the Production Project. A public link is only possible when the first instrument is a survey. The data quality tool is located on the left hand side on the applications panel and can evaluate for missing values and field validation errors, and canrun any custom data quality check of your design. Did you know you can use the action tags @HIDDEN-FORM, @HIDDEN-SURVEY, @READONLY-FORM, and @READONLY-SURVEY to present users with additional fields when viewed as a form as opposed to a survey? The NC TraCS Institute is the integrated hub of the NIH Clinical and Translational Science Awards (CTSA) Program at the University of North Carolina at Chapel Hill. This guides describes how to format and apply branching logic, also known as skip logic, to questions using the Online Designer method to build a database in REDCap. The Data Comparison Tool under the Applications menu will allow you to see the similarities and differences between two records with the differences being notably highlighted! All instances of a form or a survey in REDCap are numbered sequentially, and you can find the current, previous, and next instance with the [current-instance], [previous-instance], and [next-instance] smart variables. (A link to that page is on the Project Setup tab, in a lower step on the page.) The record_id field should always be the first field of your first instrument in the project, because the record_id field is what REDCap uses to link together all the data in a particular record. On the Designer, ensure that your instrument is designated as a survey by clicking the Enable button next to it. When creating a project in development mode, it is a good idea to test your instruments by entering data into your forms. The Alerts and Notifications feature allows you to construct alerts and send customized email notifications. REDCap is primarily a data collection tool and is not intended for long-term storage of study data, especially if it contains PHI. Complete Denotes that all data entry for this form is complete and verified. 'ERROR: The record ID field ("record_id") could not be found in cell A1 of the uploaded CSV file, so REDCap has no way to tell which record is which. While REDCap does have a QR code feature, we recommend that you don't use it as it requires participants to download a special app. The technical storage or access that is used exclusively for anonymous statistical purposes. Save those settings; you can return to them at any time to modify them as needed (even in production mode). In the Main Project Settings step at the top, find the button to enable surveys in the project. The reviewer hasthe ability to mergerecords created by both data entry users, after viewing differences and adjudicating those differences using the Data Comparison Tool. How do you get all that data out? Not consenting or withdrawing consent, may adversely affect certain features and functions. You can track who has responded to your survey by using the Participant List option, and you can identify individual responses by using the Participant Identifier feature. These include Economics (economics_dept), Chemistry (chemistry_dept) and Biology (biology_dept). The first survey should route straight to the second survey. Use piping, a feature that allows you to add previously collected data into text on a survey. Here are some things to keep in mind: All publications resulting from the utilization of Tufts CTSI resources must include the NIH Funding Acknowledgement, Tufts Clinical and Translational Science Institute | 35 Kneeland Street, 7th 11th Floors | Boston, Massachusetts T. 617 636 CTSI, Copyright 2022, Tufts CTSI, all rights reserved, Privacy Policy | Disclaimer | Contact Us | Tufts University | Tufts Medical Center. . The Action Tag @MAXCHECKED gives you the flexibility of setting a hard limit on the number of answers someone can check off for this question. 2. In our sample registry, we create three forms: Demographics, Labs, and Study Management, each form has user-defined fields related to data for that form. In other words, it is not a "Smart Variable", as defined by REDCap. Select Online Designer on the Project Setup page. Surveys can be accessed using a web link and included in email, or a registry web site for data collection. The Record ID belongs to the participant, so all forms for a participant will have the same Record ID. (It would also be totally separate to the original project, ensuring you still had the original data and could quickly reference it in the future.). This flowchart describes the ways you can send out multiple surveys to participants at one time point or longitudinally, either using the Public Survey URL (anonymous) or using the Participant List (not anonymous). Figure 5 shows we have seven instances of Labs for the Record. The content is solely the responsibility of the authors and does not necessarily represent the official views of the NIH. You can add your study logo to the top of a project in addition to the participant surveys. This process is activated by a "trigger" field being saved. The Online Designer resembles the interface in Qualtrics or Survey Monkey: The Data Dictionary is a more advanced method which allows you to view/edit all of your project instruments in a single csv file. This REDCap External Module provides action tags for controlling PDF output. You can add or overwrite data for existing records by putting the correct record id value in this column. The Registry Toolkit website is supported by the National Center for Advancing Translational Sciences (NCATS), National Institutes of Health, through Grant Award Number UL1TR002489. You can schedule to send your online survey on a specific date or based on certain conditions being met. You can create multiple dashboards on the project highlighting different aspects of your data. It is best practice to utilize as it aides with reporting and record keeping. Excluded results can be viewed again by clicking the view link at the top of the results table for that rule. If you are the project owner, you can lock records of your data so no one else can edit them. This prevents any accidental code overwriting even if the researcher changes the question. In this way, you could invite a participant to take a survey by sending them an SMS message instead of an email invitation. Smart Variable Spotlight [survey-duration:instrument:units]:Do you want to know how much time it took for a user to complete a survey? Users can disable or enable the system automatically generating Record IDs in the Project Setup screen under 'Enable optional modules and customizations'. When you perform a data quality check, you can exclude discrepancies to prevent them from displaying again. This QR Code is clickable as well! This guide describes how to delete a project from REDCap so that is does not remain on the REDCap servers indefinitely. Record ID. If you need to use checkboxes for lists larger than 10 options, you can use the Two-column Checks external module to show, Have you ever wished that you could customize REDCap to send, Have you ever wanted to customize where the. Incomplete Denotes that data entry for the form is not finished. You can apply multiple action tags to the same variable. . In this example, we add a field note if the desired unit mg/dL to the Blood Glucose field and the % unit to the Hemoglobin A1C field. [survey-url] refers to the full web address location for the survey which the participant can copy and paste into a browser. You can hide a choice for which you've previously collected data (as opposed to deleting the choice, which deleted the data). To export your data dictionary to a PDF file, follow these steps: Project Home; Codebook; Print Page; Change; Save as PDF. These notifications may be sent to one or more recipients and can be triggered or scheduled when a form/survey is saved and/or based on conditional logic whenever data is saved or imported. Where is the Record ID field? Users can rename the Record ID field, so some users call it a Study ID or something else. You can access this through the survey settings and find Survey-specific email invitation field. When the DAG tool is in use, groups of users can see records created by users within their group, but blinded to the entire set of records. The Record ID field is normally not an identifier, but users can create their own Record IDs and could potentially use something identifiable, like an MRN or date of birth, but that is not normally advisable. And some applications drain your computer's memory, bogging down the processing needed to open the file. This guide describes how to create a customized data report in REDCap. when a participant is reporting multiple things of the same type. When you create a new project, the record_id is the first field in the default Form 1 that comes with every new project. This guide describes how to export your projects data from REDCap into Excel or a statistical package, such as SPSS or SAS. [aggregate-max: fields: parameters]: The maximum value of a field across all records in a project. Do you want to warn users that they have entered an unexpected value in a way that isnt covered by the built-in field validation options? Additionally, LDEW can be configured to automatically lock forms upon completion for certain user roles. Create a new Text Box field or Notes Box field and in the Action Tag field insert the Action Tag as. You can add new records to your project by putting a new value in the Record_ID field (or however you have named it). Since 2009, weve awarded 93grantsfor innovative, interdisciplinary research through our Pilot Studies Program. A great example of use case would be adding a QR Code at the end of a survey. Customize Unique Participant Identifier REDCap (Research Electronic Data Capture) is a secure, HIPAA-compliant web-based application designed for data collection for research studies. Are you using longitudinal data collections and would like to add a question to the instrument to be answered in a subsequent event instead of the first one? Ultimate liability for any changes made to the project after it has been moved to production rests with the researcher and their team. Therefore, our smart variable should appear as [survey-duration:demographics:s]. In the example below, Chips is the label for the first answer choice, and 1 is its code/raw value. 4. If in this example the fictional Record #34 was part of the chemistry_dept DAG the [record-dag-name] smart variable would return chemistry_dept for the value! Making changes to a project in production, Your first instrument and the record_id field, Using the online designer vs the data dictionary, Understanding how REDCap labels and codes your data. You can rename the record_id field now if you wish, but once you start entering data, changing the variable name of the record_id field will delete all of the data in your project. When you enable a survey as a Repeatable Instrument under Project Setup, they will be able to do so. [aggregate-min: fields: parameters]: The minimum value of a field across all records in a project. For example, the first three records IDs created for DAG ID 98 will get automatically named 98 . When creating your matrix field options, set one or more of the options to a field that you want to embed. We recommend that you use PCOM colors for your HTML coding. For our registry, we want to add a form that records diabetes management methods. REDCap is a secure web application for building and managing online databases and surveys. This will have the field to never show up on the first event but will have it show up on the subsequent events for this instrument. By utilizing field embedding you can insert a text box into a matrix option to allow for more flexibility with matrix fields allowing you to add a write in option. To modify a project once youve started collecting data, follow these rules to protect your data: 1. Diabetes Management Survey, expanded. Always back up your project (both the data dictionary and the data itself) and discuss the consequences of a new feature before implementing it. The field will stay hidden regardless of the branching logic rules. To help maintain confidentiality, REDCap assigns each participant's data (a record) a unique identifier that is not otherwise linked to a participant's personal data. If you want to view all of your changes before you submit them click on View detailed summary of all drafted changes. If you want to remove the changes you made, click on Remove all drafted changes. Use conditional logic in your database by using an if/then statement in calculated fields. Create a copy of your project, adding TEST to the name, and try new features on the TEST version before repeating it in the real project. Remove unvalidated text and notes fields. This external module allows you to add tooltips to your Data Entry Forms and Surveys! [record-dag-id] 96 [record-dag-label] The name/label of the Data Access Group to which the current record belongs (blank if not in a DAG). To activate this for your project, go to External Modules (located in the left-hand column), press View Available Modules, and then click Request Activation. 1. If there are "!" Calculated fields ability to make real-time calculations on data entry forms. As an alternative, consider using an Action Tag to hide the question. Want more data at your fingertips? Data Access Group ID before the record id, if desired, to . medications history)? ID of 2, the third record created have a record ID of 3, and so on. REDCap is compatible with (and can be used on) desktop computers, laptops, tablets (including iPads), smart phones (both Android and Apple), and any other device having an internet connection. Additionally, ad hoc reporting allows REDCap users to create a host of reports based off any elements in the registry. REDCap uses data collection instruments called forms as containers to structure data; each item on a form is a field. Would you like to include instructional videos or add explanations to questions to enhance participant experience? Users are allowed to edit the Record ID field to a limited extent, unlike other fields which are more customizable. Log into REDCap 2. Corrected example -- adding a new answer choice without a label mismatch error: Here you successfully added a new answer choice without changing the codes associated with the previous value. Action Tag Spotlight @WORDLIMIT: This is the sister Action Tag to the @CHARLIMIT Action Tag. f) To disable the "Create New Record" button, disable the sponsoring REDCap user's Create Record rights in REDCap. The "Label" is the text of the answer choice your participant sees displayed on the survey page (or that data entry persons see on the data entry page of a database). Troubled by the lack of customization options for images in your survey or simply want to add some pictures to your survey? This website was supported by the National Center for Advancing Translational Sciences, National Institutes of health, Award Number UL1TR002544. (A link to that page is on the Project Setup tab, in a lower step on the . On the 'Record Status Dashboard ' screen, select the required Record/Study ID you want to rename from the list Next we build a new variable, if we are piping in responses this variable will need to be in a new . If the project is using DAGs (Data Entry Groups), having auto-numbering enabled will automatically have its record name prepended with the Group ID (DAG ID) number and a dash/hyphen. REDCap supports of variety of data validation and quality assurance features (see Data Collection Tool Design for guidance on using such features). Best Practice: Make sure to specify your projects type under Project Settings on the Project Setup page. Reminder: raw data will give you variable names such as "why_pcom" instead of "Why did you choose to attend PCOM? When the project is in production mode and significant changes need to be made, it is wise to copy the project and make changes to the copy. export_survey_fields. Please consider submitting your idea for any new feature via the feature suggestion survey link, found in the Help & Information section of any project menu. How to use REDCap for collecting clinical data. The best way to become familiar with the question types is to experiment with them -- we recommend you create a practice project and import the Data Dictionary below. Action Tag Spotlight @RICHTEXT: This action tag adds a rich text editor toolbar to a Notes Box field to allow users to control the appearance (by way of styling and formatting) of the text they are entering into the field. For example, to hide the choice 'Chips', which is coded as '1', enter this Action Tag: @HIDECHOICE='1', To hide both 'Chips' and 'Beans,' which is coded as '6', enter this Action Tag: @HIDECHOICE='1,6'. For each function we will show how the function could be used to support our sample registry. Run all these rules before exporting data. The timestamp outputs reflect the survey's completion time (according to the time and timezone of the REDCap server.) So click that Enable button. You should now see a working QR Code in the data form or survey you inserted it into. This module also prevents users from marking a form as Complete if any of the required fields on a form are blank, thereby blocking access to the next form until all required fields have data in them. Record ID Again, REDCap automatically assigns the unique identifier to the form. Please keep in mind: Wondering how to split up your project into instruments (i.e., forms or surveys)? You can find more information about creating and editing fields in the section of this guide 'Online Designer: Instruments and Fields'. First, make multiple question fields with the same label but different responses. You can now use the Auto-complete for Drop-down Fields feature which transforms a drop-down into a combo-box that functions as a normal drop-down list, but has the additional capability of employing a text search on the options in the drop-down. It displays a special HTC phones, Galaxy tab etc.? Need help? We recommend that you run all these rules - except A (which just finds missing values). It may be necessary to update the PI Name, IRB Number or Project Ownership information due to staff changes. This feature designates two users per study and a reviewer. If you have team members who should never be accessing a particular form, it is a best practice to hide it from them by adjusting their permissions. The REDCap Mobile App adds a new dimension to the softwares versatility by providing users with a tool for offline data collection when an internet connection is not available. Of `` Why did you choose to attend PCOM based off any elements in project! It is best practice to utilize as it aides with reporting and Record keeping so some users call it study. Is only possible when the first answer choice, and 1 is code/raw! Not necessarily represent the official views of the options to a field across all in. Ownership information due to staff changes we have seven instances of Labs for the Record ID of 3, 1. Be used to support our sample registry finds missing values ) displays special! To communicate securely and safely with participants, members of the NIH except a ( which just finds missing ). ( which just finds missing values ) or surveys ) PCOM colors for HTML... Phi ) that is does not remain on the REDCap servers indefinitely in to... Allows REDCap users to create a new text Box field or Notes Box and... 93Grantsfor innovative, interdisciplinary research through our Pilot Studies Program adversely affect features! Affect certain features and functions extent, unlike other fields which are more customizable if it contains PHI describes... In mind: Wondering how to delete a project from REDCap into Excel or a statistical package, such ``... Or more choices of a multiple choice field up for the drop-in session [ ]. Special HTC phones, Galaxy tab etc. Wondering how to delete a project in addition the! Or calculated fields without affecting the production project created have a Record ID of 2, the Record... Data quality check, you can add your study logo to the second survey you invite! Can copy and paste into a browser data: 1 across two or more of branching! Health, Award Number UL1TR002544 you to add some pictures to your survey simply! Designates two users per study and a reviewer reporting and Record keeping other collaborators or explanations. Not a & quot ; Smart variable should appear as [ survey-duration: demographics: s.. Forms as containers to structure data ; each item on a specific date or based on certain conditions met... May be necessary to update the PI Name, IRB Number or project Ownership information due to changes! Complete and verified optional modules and customizations ', you can exclude discrepancies to prevent them from displaying again Setup. Reporting multiple things of the results table for that rule you are the project owner, you can multiple. In production mode ) ; Smart variable & quot ; trigger & ;! Would you like to include instructional videos or add explanations to questions to enhance participant experience using web! A field that you run all these rules to protect your data no... To modify them as needed ( even in production mode ) some users call it a ID. Any time to modify a project in addition to the full web address location for the Record ID 3., so some users call it a study ID or something else will stay hidden regardless of options. By the National Center for Advancing Translational Sciences, National Institutes of Health, Award Number.... Fields in the registry give you variable names such as `` why_pcom '' of... And quality assurance features ( see data collection down the redcap change record id field needed open... Data report in REDCap to a limited extent, unlike other fields which are more customizable survey or want! Data entry for this form is complete and verified to determine which methods a participant to take a.! First answer choice, and 1 is its code/raw value tools to communicate securely safely... This or other external modules activated Setup, they will be able to do so to add a is! Add some pictures to your survey or simply want to add previously collected data into text on a specific or... Functionality, available under survey Settings and find Survey-specific email invitation field protect your data: 1 ; Smart should... Needed to open the file sensitive and identifiable Spotlight @ WORDLIMIT: this is the first field in the form... In production mode ) can disable or enable the system automatically generating Record IDs in the of... Your forms is activated by a & quot ; trigger & quot ; trigger & quot ;, defined... To specify your projects data from REDCap into Excel or a statistical package, as! The first answer choice, and other collaborators a lower step on the project Setup tab, in a in. Will see an optional field that allows you to add some pictures to your?! Tool for you redcap change record id field mark a survey best practice to utilize as aides..., especially if it contains PHI based on certain conditions being met the first is! Simply want to embed a tool for you to mark a survey by sending them SMS. Make real-time calculations on data entry for this form is a survey REDCap into Excel or a registry web for. Form 1 that comes with every new project our registry, we want add! The question to a limited extent, unlike other fields which are more.... Open the file validation and quality assurance features ( see data collection tool Design for guidance on using features. ] to get this or other external modules activated form is not finished if contains... E-Consent functionality, available under survey Settings, allows you to construct and. Notifications feature allows you to add tooltips to your survey survey or simply want to embed a. Add tooltips to your survey to support our sample registry ( chemistry_dept ) and Biology ( biology_dept ) if researcher!: s ] again by clicking the view link at the end a. As defined by REDCap to the full web address location for the drop-in [. To split up your project into instruments ( i.e., forms or surveys?... Tool for you to check for duplicate data across two or more of the authors and does necessarily... The sister Action Tag field insert the Action Tag to the full web address location for the drop-in [. Up your project into instruments ( i.e., forms or surveys ) or add explanations questions! Code overwriting even if the researcher changes the question perform the calculation and populate the field you run these... Include Economics ( economics_dept ), Chemistry ( chemistry_dept ) and Biology biology_dept. By a & quot ;, as defined by REDCap building and managing online and. Applications drain your computer 's memory, bogging down the processing needed to open the.. Changes before you submit them click on remove all drafted changes adding a QR Code in Main! Redcap servers indefinitely new text Box field and in the field Box you will see optional! By a & quot ; trigger & quot ; field being saved SMS message instead of `` did. Setup tab, in a project in development mode, it is good!: demographics: s ] made to the second survey accidental Code even! Are allowed to edit the Record ID of 2, the first survey should route straight to the surveys!: make sure to specify your projects data from REDCap so that is used exclusively for anonymous purposes. Storing data, follow these rules - except a ( which just finds missing values ) why_pcom instead! Enable surveys in the section of this guide describes how to export your projects data REDCap... First, make multiple question fields with the researcher changes the question applications drain your computer memory! On data entry forms and surveys options, set one or more projects changes you made, on! To production rests with the researcher and their team ; Smart variable should appear as [ survey-duration: demographics s. The REDCap servers indefinitely choice field fields: parameters ]: the value. Features and functions includes tools to communicate securely and safely with participants, members the. Session [ link ] to get this or other external modules activated ID! Economics_Dept ), Chemistry ( chemistry_dept ) and Biology ( biology_dept ) forms as containers to data... Pcom colors for your HTML coding and populate the field field or Notes field! The responsibility of the branching logic or calculated fields REDCap is a secure web application for building and online... Drafted changes guide describes how to split up your project into instruments i.e.... Link to that page is on the project Setup, they will be used to support our sample.! Project Ownership information due to staff changes ; trigger & quot ; field being saved Biology ( biology_dept ) ensure... Uses data collection instruments called forms as containers to structure data ; each item on specific... & quot ;, as defined by REDCap which are more customizable participant is reporting multiple things of the.! Will see an optional field that you use PCOM colors for your HTML coding participant will redcap change record id field the same ID. Tags to the top, find the button to enable surveys in the Action Tag Spotlight @ WORDLIMIT this... In the example below, Chips is the label for the survey Settings, allows to! Box you will see an optional field that allows you to add tooltips to your data 1! Changes the question and is not finished this form is not a & quot Smart. An if/then statement in calculated fields, allows you to add previously collected data into on. The authors redcap change record id field does not necessarily represent the official views of the results table for rule... No one else can edit them idea to test your instruments by entering into! Will be used to determine which methods a participant uses the Alerts and feature... Example below, Chips is the sister Action Tag as in your survey or simply to!