The technical storage or access that is used exclusively for anonymous statistical purposes. export_data_access_groups. REDCap allows some customization of form appearance using HTML code. When you enable a survey as a Repeatable Instrument under Project Setup, they will be able to do so. Additionally, LDEW can be configured to automatically lock forms upon completion for certain user roles. The module is designed to migrate any or every data field in the source project that matches a data field in the destination project by both name and type. Add the @HIDDEN-SURVEY action tag to this field so that it is not visible to participants taking the survey and only appears when checking the form itself in the Record Status Dashboard. The module is designed to migrate any or every data field in the source project that matches a data field in the destination project by both name and type. To ensure data and information security, set up a Data Access Group (DAG). medications history)? 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. Then, create a calculated field to be used as the variable for analysis, which you can set to be hidden with the @HIDDEN action tag. Every action within a REDCap project is logged, including data changes, alerts and survey invites sent out, and even page views. That identifier is know as either a Record ID. Click the exclude link for a result in the table of discrepancies for a rule, and that result will not be counted next time in the number of discrepancies for that rule, nor will it be displayed in the table of results. . Once this module is enabled for your project you can use this feature anywhere in your project! 5. The Registry Toolkit website is supported by the National Center for Advancing Translational Sciences (NCATS), National Institutes of Health, through Grant Award Number UL1TR002489. [record-dag-label] Harvard Site . So click that 'Enable' button. records in your project). Create a Descriptive Text field in your instrument and then create the variable name. It is also possible that the variable names themselves are incompatible with your statistical package. Action Tag Spotlight @DOWNLOAD-COUNT: Have you ever wanted to know how many users have downloaded a certain file or attachment in your project? Later surveys capture different data, but are completed by the same people. However, below are some tips that may be useful to you. 1. But once you start entering data, changing the variable name of the record_id field will delete all of the data in your project, because youve essentially deleted the key that allows REDCap to understand where the data belongs. Example: Suppose you have an instrument Demographics and you want to find out how long it took for your users to complete this survey when looking at the records in the Record Status Dashboard. Excluded results can be viewed again by clicking the view link at the top of the results table for that rule. 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. This application may be used for storing and retrieving project files and documents, such as a blank copy of your consent forms or data entry guides. The mobile app securely stores the information on the mobile device; once internet service is available, the information can be uploaded to the research project. If you need to redirect your participants to submit their survey responses to different DAGs, use the Public Survey Dag URLs External module. Action Tags provide a way to customize the data entry experience for surveys and forms. On the 'Record Status Dashboard ' screen, select the required Record/Study ID you want to rename from the list Concerned about bots filling out your public surveys? This guide describes how to delete a project from REDCap so that is does not remain on the REDCap servers indefinitely. @HIDECHOICE -- Hides one or more choices of a multiple choice field. You can also add custom rules in the module to track data population for specific fields. If there are "!" click on the "Hash the Record ID field." 5) Click on "Export Data." Data Exports - How-To Guide 3/31/2017 3 If using Excel, click on the data file to download the data. If you do not want to use PCOM colors for HTML coding, you can find HTML color generators here: As a general rule, we recommend that you download all data from REDCap as raw data because raw data is used for project analysis. 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. 7. It displays a special Please see the attachment below for more information on other Action Tags. Example of change where you will lose data this is known as a label mismatch error: Because the new code of Other is now 5, any data that was entered as 4, Other will now be given the value of 4, White Cheese because REDCap only looks at the numeric codes and not the text-based answer labels after the codes. We recommend that you don't use the yes/no or the true/false fields when creating a survey because the choices are hardcoded in the metadata. REDCap is a system for collecting and storing data, including Patient Health Information (PHI) that is sensitive and identifiable. Once you have a REDCap project programmed, data can be imported using the Data Import Tool For additional details, contact your local REDCap Administrator. The action tags allow you to suppress data in text fields, the enumerations in radio and checkbox fields, hide field notes and add whitespace to a field label to push down the next field on the PDF page. Did you know you can turn a field label into a link? You can build surveys that use repetitive choices faster by using the copy existing choices option. '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. If more than one choice needs to be hidden, then provide all the coded values separated by commas. Users are allowed to edit the Record ID field to a limited extent, unlike other fields which are more customizable. 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. The Record ID field is a unique field that is always the first field in the project and is mostly not modifiable. Making changes to your project once youve started collecting data can cause data loss. How to add new users to our study or change the permissions of an existing user. REDCap makes reporting and analyzing records easy with built in tools. You can use the logging tool to troubleshoot issues that arise due to a change in data value, calculations and branching logic that are no longer working, etc. Additionally, ad hoc reporting allows REDCap users to create a host of reports based off any elements in the registry. Would you like to give your surveys modern look and feel? [aggregate-max: fields: parameters]: The maximum value of a field across all records in a project. If you need to collect data in a repeated manner, you can enumerate fields on a form (e.g., Contact_Date_1, Contact Date_2, and Contact_Date_3) or repeating forms (see Figure 5). This will allow you to create a field where users can enter data in a matrix form. Using this Action Tag will not only restrict the character limit to your desired amount but it will also display the number of characters remaining to the user as well. Inside of the descriptive field label add the smart variable with the proper data. 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. Use thedata qualitytool to review and fix the incorrect values for calculated fields. And some applications drain your computer's memory, bogging down the processing needed to open the file. Want to add a YouTube video in your project? The value for Other may now appear in the middle of your answer choice list, but its better than losing all your Other data! @HIDDEN -- Hides the question/field on the survey page, the data entry form, and in the REDCap mobile app. In the User Rights tabyou can create roles with custom permissions, including permissions that are form-specific. So the later instruments can only ever be distributed via Participant List. However, you do choose to make the record ID field the identifier, you can hash it so that the record ID is an unrecognizable value. Need to personalize yoursurvey to refer to someone by name, or use a previously provided answer in future questions? This external module allows you to add tooltips to your Data Entry Forms and Surveys! This permits for easier participant tracking, workflow processes, and error identification. Date Validation Action Tagsis an external module designed to remedy this problem, as it will fully prevent the user from moving onto the next question if the value they input into the date field is in the future or in the past of the current date! Click on the first instrument and the Record ID field will be the first field. This becomes relevant at upload time. The Auto Record Generation external module allows data from one REDCap project to be migrated over to another. | accessibility. Remember that public surveys can be accessed by anyone who has the link, and cannot be restricted by IP/location. The Alerts and Notifications feature allows you to construct alerts and send customized email notifications. When the Data Access Group tool is in use, groups of users (DAGs) are blinded to the entire set of records, but can see records created by users within their group. Make your surveys stand out by making a custom theme in the Survey Settings page. Examples of HTML tags in REDcap can be found, Would you like to see the date and time a respondent took a survey before the report is run? (A link to that page is on the Project Setup tab, in a lower step on the . 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. We recommend that the record ID field not be used as an identifier. [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). Once you have completed the projects instruments, you can then move the project to Production status and have the option to delete all test data. Any form could become a survey, although some forms make more sense than others do, for example, a survey could be used to collect demographics for participants, whereas a study management survey is less practical. Let us review each item in figure 4, the Labs form: REDCap allows the user to define Field Notes for fields which is small reminder text displayed underneath the field. [aggregate-mean: fields: parameters]: The mean/average of a field across all records in a project. You can choose to add this field and click on how to use this for more information. You can then compare [x][current-instance] and [x][previous-instance] to see if there has been a change. This website was supported by the National Center for Advancing Translational Sciences, National Institutes of health, Award Number UL1TR002544. These tools are found in the Manage Survey Participants section of your project. Repeating fields work best if you know exactly how many iterations of a field you will have and that it will not change. The IRB has approved REDCap as a platform to perform informed consents remotely and electronically using REDCaps survey features. There's no good alternative for changing a variable name once you've collected data -- you'll either need to you'll either need to stick with the old variable name or be willing to re-import data for that question. The Library has no access to or familiaritywith any statistical packages. Contact. Record Labelling To turn off auto increment you need to click Disable in the Enable optional modules and customisations on the Project Setup page. It's fairly common for the researcher to decide partway through the project that the two answer choices are not sufficient. To ensure information security, set up a Data Access Group (DAG). Did you know that annotation tags correspond to action that is performed for the field when it is displayed on the forms or data entry fields and not visible anywhere on the page? This feature must be enabled in order to use surveys. You can save a snapshot of your current data dictionary by simply clicking the. All REDCap surveys and data collection instruments can be downloaded as PDFs and printed for manual offline data collection. Additionally, REDCap offers a mobile application accessible via a smartphone or tablet that permits offline data collection for scenarios where reliable internet service is not available. The technical storage or access that is used exclusively for statistical purposes. It, irreversibly, deletes the current form. REDCap is a secure web application for building and managing online databases and surveys. one field: the record_id. The calculated field can be made to equal the value of the question seen by the user with an if statement, which uses the syntax if([variant_a_shown], [variant_a], [variant_b]). There is a Protect the public survey using the Google reCAPTCHA feature button on the Public Survey page that can help protect public survey links from being clicked automatically. Use the Survey Queue button on the Online Designer page. You can apply multiple action tags to the same variable. To get the most out of REDCap, please refer to these helpful hints: External Module Spotlight Auto Record Generation: Do you have multiple REDCap projects where youd like to migrate some specific data from one project to another? Both can be set up to capture both time and date. By default, this cannot be duplicated. You can create a descriptive field as a warning, explaining the issue and expectations and use branching logic to show it only when the parameters are true/false. Using the automated invitations feature, you can schedule survey to be sent at a specific date andtime, as well as based on a specific response to a previous form or survey. Use conditional logic in your database by using an if/then statement in calculated fields. This can allow project members to quickly and easily see only the data in which they are interested. Are you a PI or Manager supervising staff members who use REDCap? 3. Form [is . Demographics is normally the first form, but this is not required. This option will allow users to add protection to their public survey using Googles CAPTCHA functionality, which can prevent bots from entering trash data into a public survey. If different respondents will complete the other surveys, then a separate project should probably be used for each group of respondents. You can access this through the survey settings and find Survey-specific email invitation field. In the screenshot below the Record ID field would be the first field in the Basic Demography Form. Reminder: raw data will give you variable names such as "why_pcom" instead of "Why did you choose to attend PCOM? To modify a project once youve started collecting data, follow these rules to protect your data: 1. The randomization module in REDCap will help you implement a pre-defined randomization model within your project, allowing you to randomize your subjects (i.e. Here are some steps to help you troubleshoot. These include Economics (economics_dept), Chemistry (chemistry_dept) and Biology (biology_dept). It is best practice to utilize as it aides with reporting and record keeping. This REDCap module replaces a text, radio, or checkbox field with an image that users can interact with to select one or more options. REDCap is primarily a data collection tool and is not intended for long-term storage of study data, especially if it contains PHI. Want to present different users with different options for a question, but still use a single variable for analysis? Instead, the best practice is to create two surveys. 6. From guidance on how to register for a REDCap account to more comprehensive guides on how to navigate the platform to meet your research needs, this page contains information for all stages of the REDCap project management process. Once you begin data collection, moving your project to Productionensures youre maintaining data accuracy and integrity. This guide describes how to export your projects data from REDCap into Excel or a statistical package, such as SPSS or SAS. This will trigger REDCap to perform the calculation and populate the field. This is an example of using a REDCap feature called piping. You can request to activate a Double Data Entry featurebefore you begin your data collection. Record ID. 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? Just use [variable] as the label for an option and it will automatically be piped in. This QR Code is clickable as well! You can add your study logo to the top of a project in addition to the participant surveys. How to use REDCap for collecting clinical data. For example, SPSS may not be able to process variable names which include negative values. 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? From the drop-down select Assign to Data Access Group and select the appropriate group. (A link to that page is on the Project Setup tab, in a lower step on the page.) Using Send-It, you can upload and send files, including existing project documents, that are too large for email attachments or that contain sensitive data to multiple recipients. Our sample registry is a recruitment registry, used for identifying and contacting potential participants for active studies in our department. 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. When building forms where you are using the same set of choices for different multiple choice fields, click on the copy existing choices link (above the Choice dialogue box in the Add New Field pop-up). Piping allows you to use the value of any form in that record in a field or value of another form. 2. Download a smaller export. REDCap supports integration with electronic health records and other data repositories using Dynamic Data Pull and custom APIs. Otherwise, it is best to use Repeating Forms. The outline of what we want our registry to collect is as follows: Let us quickly review each field in the Demographics form (see Figure 1). 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. This field will be the leftmost one on the spreadsheet. 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! ), or having the DAG name appear in the record ID (UF-1, UF-2, UF-3) instead of the DAG ID (98-1, 98-2, 98-3, etc.) But once you have started collecting data, to change the yes/no or true/false question to a multiple choice would result in corrupted data. Note: Events and repeating instruments are NOT currently supported. [survey-link] refers to the participants custom survey link showing the title of the survey. is an optional form element and is not required for data entry or collection. In REDCap Field Notation, variable names always point to data fields in the project. ', in which the coded values should be inside single or double quotes for the choice(s) you wish to hide. It acts as a status indicator for the form and has the following three options: Note: Form Status Complete? Do not post links online unless you want people from around the world to fill out your survey! In a longitudinal study however, a single instrument can exist in multiple events, and to correctly identify the field, you need to first indicate the event name. This external module allows you to quickly and easily create QR codes to be displayed right in your survey! The [survey-duration:instrument:units] smart variable allows you to see the amount of time that passed between the start of the survey being taken and when it was completed. In the log, filter by record, user, and event type. Select your required project from the 'My Projects ' tab 3. Enhanced radio and checkboxes is an option in REDCaps survey settings to make radio buttons and checkboxes more user friendly by adjusting the button sizes and layout. A similar process is in place for Rename Record rights. Surveys can be enabled at any time in development mode. 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. In the field box you will see an optional field that allows you to embed a YouTube video within the survey. General Tips User-Friendly Survey Buttons: Often times, it can be unnecessarily cumbersome for participants to answer radio or checkbox questions where the buttons appear too small on their screen or is too difficult to click on mobile phones. Storage of all personally identifiable data and protected health information should follow your IRB and institutional protocol. You can use rule H to check your project, and it will let you know if there are any discrepancies. If enabled, the system will create the Record ID when a record is created, if disabled the user will need to enter a value when creating a record. This action tag provides a way to automatically count the number of downloads for either a File Upload field or a Descriptive Field attachment. Contact us at nctracs@unc.edu or 919-966-6022. When creating a project in development mode, it is a good idea to test your instruments by entering data into your forms. Upload the new csv version into same project or a different project. After enabling surveys, go to the Online Designer. The instance of a repeating instrument always comes after the variable name. Within the survey you can set up a descriptive field labeled Survey Elapsed Time. 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. Adding Records - REDCap Docs @ QMUL Adding Records Click Add/ Edit Records Click Add New Record to create a new participant. To hide a section header, all fields until the next section header must also be hidden. 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. REDCap offers a few features to allow your team to record and track the status of forms. However, the two surveys cannot be linked, which keeps the first survey's data anonymous. First, make multiple question fields with the same label but different responses. For instructions, please refer to Automated Invitations in the Online Designer. This guide describes how to create and distribute a single survey, methods for collecting anonymous and non-anonymous survey data, how to set up longitudinal survey collection and how to get notified when a participant submits a survey. For example, you can make a field automatically capture todays date and make that same field read-only so that your survey participants cant change that value. You can use the same approach in longitudinal projects with defined events, where the syntax is [previous-event-name][x] and [event-name][x].NOTE: when piping, event names always go before the variable name. 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. when a participant is reporting multiple things of the same type. 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. and for multiple-choice questions, the label for the answer choice such as "Osteopathic Medicine," "Psychology", etc. Using REDCap for Registries In this section, we will use a sample registry with fictitious data to highlight some of the benefits of using REDCap for your registry. Surveys are versions of forms that permit data collection via email, web links, or even paper. You can find more information about creating and editing fields in the section of this guide 'Online Designer: Instruments and Fields'. Example: 1, {example_field_variable}. The Auto Record Generation external module allows data from one REDCap project to be migrated over to another. Download a copy of the Current Data Dictionary and a copy of the projects existing data via a data export (go to Data Exports, Reports, and Stats in the Project ). 1. The default field name is Study_ID. Fields Overview Fields Overview Field Types Begin New Section Calculated Check Box . The post-production change control process provides an additional check to ensure that data that was alreadycollected is not deleted, re-coded or overwritten unintentionally. In REDCap, fields are globally unique among all instruments, and so usually you need to simply indicate the field using the [var] syntax. Figure 10: Diabetes Management Methods Form. Q: Can I access REDCap on Android devices, e.g. In the example above, "Chips" is the label for the first answer choice, and '1' is its code/raw value. DAGs can be created at any time, but it is best to do it before data collection begins. This allows for quick identification of target subjects, outliers, or potential erroneous data. The first survey can be done anonymously while the second survey collects information. This guide describes how to enter data into a project that is collecting data longitudinally. You can choose to send an email to a participant thanking them for taking a survey. The calculations in calculated fields aren't sent to the server until you hit save. External Module Spotlight Form Field Tooltip: Do you want to keep your survey clean and user friendly but want to include additional information or instructions for your participants without overwhelming them? Always keep a copy of your most recent data dictionary, and save the project and the data before making significant changes! It is a customizable, searchable list dashboard. The variable name for REDCap's optional Participant Identifier is [redcap_survey_identifier], and it does not capture imported data when using the data import tool, nor can the data inputted be pulled into a form/survey field. You can use piping to allow subject-specific options in a multiple choice or dropdown field. The Record ID field is a unique field that is always the first field in the project and is mostly not modifiable. 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. External Module Spotlight Check for Duplicates Across Multiple Projects: Some teams may operate multiple REDCap projects for their research. The Lock this record for this form? checkbox enables a technical constraint in REDCap that protects the form from being modified or deleted. Ultimate liability for any changes made to the project after it has been moved to production rests with the researcher and their team. Once you're familiar with how REDCap formats csv files, you can: The "Field Label" is the text of the question your participants see displayed on the survey page (or that data entry persons see on the data entry page of a database). 2. So click that Enable button. You can save this theme and apply it to any of your surveys. You can change instrument names within the Online Designer without data loss. If you need further assistance, ask a colleague who is familiar with the stats . So close everything that you don't need, and then follow the REDCap export page's instructions to open the file(s). REDCap supports of variety of data validation and quality assurance features (see Data Collection Tool Design for guidance on using such features). For example: If you want to find out how many downloads the Descriptive Field with the variable name pdf_download has had, you would write the following: To create a standalone QR Code link, create a new field with the, Alternatively, you can copy the HTML template code below, paste it into your project and then modify the link: