Run all these rules before exporting data. 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. You can change the variable name. Record Labelling To turn off auto increment you need to click Disable in the Enable optional modules and customisations on the Project Setup page. Select Online Designer on the Project Setup page. You can access this through the survey settings and find Survey-specific email invitation field. When cleaning data or reimporting it into REDcap, it must be in the form of raw data. Make a back-up before you start -- download a copy of the current Data Dictionary and a copy of your current data, just in case anything goes wrong. The Registry Toolkit website is supported by the National Center for Advancing Translational Sciences (NCATS), National Institutes of Health, through Grant Award Number UL1TR002489. In REDCap, fields are globally unique among all instruments, and so usually you need to simply indicate the field using the [var] syntax. 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. There are no specific requirements to run REDCap on any of these devices and no known compatibility issues. REDCap is a secure web application for building and managing online databases and surveys. This guide describes how to create a customized data report in REDCap. 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. The Auto Record Generation external module allows data from one REDCap project to be migrated over to another. When creating your matrix field options, set one or more of the options to a field that you want to embed. This module allows users to create a custom record auto-numbering schema for their REDCap project, such as having the first record ID created start at 1000 or 001 instead of 1, append all record IDs with a prefix (ABC-1, ABC-2, ABC-3, etc. and for multiple-choice questions, the label for the answer choice such as "Osteopathic Medicine," "Psychology", etc. 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. REDCap supports the use of HTML tags to format text in question labels and response lists. 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. However, the two surveys cannot be linked, which keeps the first survey's data anonymous. If you need to edit the "Label" of any answer choices during data collection, be sure that the Label stays associated with the same Code -- so, if the answer choice "Chips" had the code value of "1" when you started the project, it should keep the code value of 1 throughout the project. If it is a research study, make sure that the PIs name and email are listed, as well as the IRB number. Did you know you can create a drop-down list using the data inside your projects using the Dynamic Query (SQL)? In the screenshot below the Record ID field would be the first field in the Basic Demography Form. You can add or overwrite data for existing records by putting the correct record id value in this column. While this section highlights several functions of REDCap that can be used to support research registries, this guide is not comprehensive and there are many other features that may be beneficial for your registry, such as: Questions? To ensure information security, set up a Data Access Group (DAG). [aggregate-max: fields: parameters]: The maximum value of a field across all records in a project. In the Main Project Settings step at the top, find the button to enable surveys in the project. 6. Save your work and test it out. On the 'Record Status Dashboard ' screen, select the required Record/Study ID you want to rename from the list Additionally, LDEW can be configured to automatically lock forms upon completion for certain user roles. 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? Customize Unique Participant Identifier The Record ID belongs to the participant, so all forms for a participant will have the same Record ID. Otherwise, it is best to use Repeating Forms. Figure 10: Diabetes Management Methods Form. This guide describes all of the features found in the Optional Modules and Customizations header under the Project Setup page, such as repeatable instruments and events, auto-numbering for records, the randomization module, designating an email field to use for survey invitations and setting a custom record label. Q: Can I access REDCap on Android devices, e.g. Did you know you can turn a field label into a link? 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. @HIDECHOICE -- Hides one or more choices of a multiple choice field. Although DAGs can be created at any time, it is best to set it up before the project goes live. @NOW captures the current time while @TODAY captures the current date. You can use rule H to check your project, and it will let you know if there are any discrepancies. Select your required project from the 'My Projects ' tab 3. 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'. By default, this cannot be duplicated. In this example, we piped [first_name] [last_name] into the survey instructions. Each form has a Delete Data for THIS FORM only button, which does just that. Every action within a REDCap project is logged, including data changes, alerts and survey invites sent out, and even page views. 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. (This feature gets locked down when moving to production. Use the Survey Queue button on the Online Designer page. Users are allowed to edit the Record ID field to a limited extent, unlike other fields which are more customizable. REDCap User Completing the form: We will pull this with the smart variable [user-name] and the default action tag. The format must follow the pattern @HIDECHOICE='?? Would you like to include instructional videos or add explanations to questions to enhance participant experience? 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. export_data_access_groups. Did you know that you can set up REDCap to send surveys to specific emails? This guide describes how to update the Project Owner, PI information and IRB Number in REDCap. Example: 1, {example_field_variable}. If the data within those fields matches across multiple records, a duplicate is reported. export_survey_fields. You can add new records to your project by putting a new value in the Record_ID field (or however you have named it). 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. 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. Where is the Record ID field? Action Tag Spotlight @CHARLIMIT: If you need to restrict the number of character a user can enter into a Text Box or Notes Field the @CHARLIMIT Action Tag can help accomplish this task. For our registry, we want to add a form that records diabetes management methods. You can use piping to allow subject-specific options in a multiple choice or dropdown field. You can schedule to send your online survey on a specific date or based on certain conditions being met. Think of a form as a data collection tool used to capture data elements. A great example of use case would be adding a QR Code at the end of a survey. Looking to track changes in your REDCap data and investigate potential data issues? 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. The "code" is the numeric value of the answer choice selected, whichthe database uses to store/interpret the answer choice. HTC phones, Galaxy tab etc.? Do not post links online unless you want people from around the world to fill out your survey! In the example below, Chips is the label for the first answer choice, and 1 is its code/raw value. 7) Sending Data (otherwise known as Uploading or Syncing Data) There are two ways of adding custom numbering to your REDCap surveys: via the online designer or the data dictionary. Figure 5 shows we have seven instances of Labs for the Record. The field will stay hidden regardless of the branching logic rules. This field will be the leftmost one on the spreadsheet. Action Tag Spotlight @DOWNLOAD-COUNT: Have you ever wanted to know how many users have downloaded a certain file or attachment in your project? You can rename the record_idfield now if you wish, but once you start entering data, changing the variable name of the record_id fieldwill delete all of the data in your project. . This external module adds the following new action tags: Example: A REDCap project has a DAG of department names at Tufts University. Sometimes though, you may want to limit the total number of answers a participant can checkoff. 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. The action tag @HIDEBUTTON will disable those buttons! Users can disable or enable the system automatically generating Record IDs in the Project Setup screen under 'Enable optional modules and customizations'. The Record ID field is a unique field that is always the first field in the project and is mostly not modifiable. REDCap can create this Record ID for you or you can create it manually. Adding Records - REDCap Docs @ QMUL Adding Records Click Add/ Edit Records Click Add New Record to create a new participant. Covers how to create a new project, how to add or edit data fields, field types available and branching logic and piping. The record ID and the REDCap User fields do not need to be created. Smart Variable Spotlight [survey-duration:instrument:units]:Do you want to know how much time it took for a user to complete a survey? Data Quality Tools allows you to execute rules upon your registry data to check for discrepancies in your data. REDCap supports embedded audio and video, with several different options for video under the Descriptive field type, as well as full support for the HTML