Users can disable or enable the system automatically generating Record IDs in the Project Setup screen under 'Enable optional modules and customizations'. Inside of the descriptive field label add the smart variable with the proper data. They are special terms that begin with the @ sign that can be placed inside a fields Field Annotation box when adding or editing a field. If you want to know why the changes did not get automatically approved by REDCap, click on Why werent my changes made automatically?, Making changes to a project in production, How to make changes to a project in production without losing your data, Don't delete questions or answer choices, or change variable names, Avoid label mistmatch errors -- don't change the codes associated with answer labels, Don't drag and drop a new instrument into first position, Steps for Making Changes to a Project in Production. The first field in REDCap is called record_id, you could only rename this field and use it as your unique number. Reports are highly customizable, and can be assigned to be visible to different project members. Action Tag Spotlight @MAXCHECKED: The field type Checkboxes (Multiple Answers) is a very commonly used field type in REDCap projects for obtaining multiple answers to a single question. They can even be printed out and abstracted into REDCap later. Record ID Again, REDCap automatically assigns the unique identifier to the form. This action tag provides a way to automatically count the number of downloads for either a File Upload field or a Descriptive Field attachment. It's fairly common for the researcher to decide partway through the project that the two answer choices are not sufficient. You can use, Do you wish the list of choices was more manageable and user-friendly? (This feature gets locked down when moving to production. 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? 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. The Auto Record Generation external module allows data from one REDCap project to be migrated over to another. It, irreversibly, deletes the current form. Communication is a key component to any successful registry whether between the registry team and the participants or internal communication among the registry team. Remember REDCap automatically assigns a unique record identifier when you create a new record. The content is solely the responsibility of the authors and does not necessarily represent the official views of the NIH. REDCap will ask you to "Commit Changes" once you upload the new Data Dictionary -- the new Data Dictionary will completely overwrite your existing instruments, so you want to be sure you've uploaded the right file. If you need further assistance, ask a colleague who is familiar with the stats . 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. Using this feature you can supplement your survey with video to enhance the experience for your participants. Are you running a collaborative project? 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. Participant ID) because it will be used by REDCap as a key variable linking forms for a particular record. 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. 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. External Module Spotlight Check for Duplicates Across Multiple Projects: Some teams may operate multiple REDCap projects for their research. A similar process is in place for Rename Record rights. 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? Are all of your calculations up to date on your long-term project? However, another type of entity exists called 'Smart Variables' that allow you to reference information other than data fields. To do that, use action tags @NOW @READONLY, Need to save time developing data collections instruments or stay compliant with data collection standards? The format for using this Action Tag is as follows: This action tag can be utilized with a Text Box field or a Notes Box Field. 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? For each function we will show how the function could be used to support our sample registry. Need to transfer data from paper surveys, charts, etc., and worry about data accuracy? Use thedata qualitytool to review and fix the incorrect values for calculated fields. Once you have a REDCap project programmed, data can be imported using the Data Import Tool For additional details, contact your local REDCap Administrator. This prevents any accidental code overwriting even if the researcher changes the question. This external module adds the following new action tags: Example: A REDCap project has a DAG of department names at Tufts University. Make your surveys stand out by making a custom theme in the Survey Settings page. If you need to redirect your participants to submit their survey responses to different DAGs, use the Public Survey Dag URLs External module. You can find more information about creating and editing fields in the section of this guide 'Online Designer: Instruments and Fields'. This permits for easier participant tracking, workflow processes, and error identification. Auto-validation allows fields to be verified by trusted biomedical ontologies. By default, this cannot be duplicated. If more than one choice needs to be hidden, then provide all the coded values separated by commas. Surveys are versions of forms that permit data collection via email, web links, or even paper. The first step is to create the data collection instrument (i.e., the form), as seen in Figure 10. It may be necessary to update the PI Name, IRB Number or Project Ownership information due to staff changes. In addition to forms, there are several functions of REDCap to help you get your research registry off to a great start. On the 'Record Status Dashboard ' screen, select the required Record/Study ID you want to rename from the list That development team considers the input of ~538,000 users across all ~2,400 consortium partner sites worldwide. 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. 5. Figure 12. When you create a new project, the record_id is the first field in the default Form 1 that comes with every new project. @NOW captures the current time while @TODAY captures the current date. To set it up, access Survey Settings and personalize the Survey Completed message by using piping. If it is a research study, make sure that the PIs name and email are listed, as well as the IRB number. Don't delete questions or answer choices, or change variable names (see below for more info), 3. 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? Click "create snapshot of instruments" to back up your instruments before making any major changes. Save your work and test it out. In the User Rights tabyou can create roles with custom permissions, including permissions that are form-specific. 8. 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. 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. REDCaps default configuration doesnt allow for creation of a progress bar, but you can add one using HTML. 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. REDCap has the capability to send SMS text messages to survey respondents by using a third-party web service named Twilio. Interested in modifying the appearance of surveys, or making them information-only? 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. This allows you to send specific surveys to different email address instead of designating only one email field for the whole project. If you were to update a calculation and it doesn't update the values for your entire project or you import incorrect data into a calculated field, then you'll have errors that you may not know about. You can apply multiple action tags to the same variable. 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. REDCap has the ability to repeat a data collection instrument or an entire event of instruments an unlimited number of times without having to specify the amount needed. For instructions, please refer to Automated Invitations in the Online Designer. This will allow you to create a field where users can enter data in a matrix form. Action Tags provide a way to customize the data entry experience for surveys and forms. Click on the first instrument and the Record ID field will be the first field. The Alerts and Notifications feature allows you to construct alerts and send customized email notifications. Contact. When creating a project in development mode, it is a good idea to test your instruments by entering data into your forms. This is especially true if you are promising a reward (like a gift card) for completing the survey. '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. This will help you to find an option more quickly. 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. [record . Action Tag Spotlight @WORDLIMIT: This is the sister Action Tag to the @CHARLIMIT Action Tag. And some applications drain your computer's memory, bogging down the processing needed to open the file. You can build the surveys that use repetitive choices faster by using the copy existing choices option. However, the Global Access User can add the. This is why we strongly recommend you put your project into Production before collecting data in Production mode, any project changes that could result in data loss require administrative approval. This REDCap module replaces a text, radio, or checkbox field with an image that users can interact with to select one or more options. For example, most EHRs capture gender as a multiple-choice field so you would want to capture gender as a multiple choice item in your form. Running a collaborative project? It acts as a status indicator for the form and has the following three options: Note: Form Status Complete? This action tag can be utilized within a Text Field or a Notes Field. ), 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.) Did you know you can turn a field label into a link? This process is activated by a "trigger" field being saved. We recommend that you run all these rules - except A (which just finds missing values). In the Main Project Settings step at the top, find the button to enable surveys in the project. There are several field types in REDCap including text boxes, radio buttons and drop down lists (select only one answer), No, it is not possible to create an anonymous survey while still gathering information for incentives (such as collecting email addressing for a prize lottery). This guide describes how to create a customized data report in REDCap. It provides a means for hiding or displaying entire forms/surveys based upon one or more control fields or conditions. External Module Spotlight Date Validation Action Tags:Many projects have fields such as Date of Birth or Date of Previous Visit in which you may want to setup a strict minimum and or maximum value range to ensure users cannot input dates in the past or future. 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? Do you have multiple different survey questions with the same answer choices? Auto Increment This will auto increment for each new record. 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. That copied version would be in development mode and have no records/data. Set up branching logic to only show one of the fields at a time. Close all open files and applications. DAGs can be created at any time, but it is best to do it before data collection begins. 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. Customize Unique Participant Identifier Then download that smaller chunk and see if the data opens in the package. For more details about how to use this module in your project check, The REDCap 9.5.5 upgrade brought many new features, including, For an in-depth look at more features of the 9.5.5 upgrade, check out the, As part of the REDCap 9.5.5 Upgrade in February 2020, Tufts CTSI has enabled the, For more details about the Mobile App, what its for, and how to use it, please, Do you want to personalize your project for the study team as well as for the participants? Figure 5 shows we have seven instances of Labs for the Record. It is configured at the project level with source instrument (survey) / target field (file upload) pairs. Under the 'Data Collection' menu on the left , select 'Record Status Dashboard ' 4. External Module Spotlight Event Navigation Tweaks: This external module provides additional features that enhance the flow of navigating through events and arms on data entry forms. (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.). 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. 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). REDCap includes tools to communicate securely and safely with participants, members of the research team, and other collaborators. Action Tag Spotlight @FIELD-NOTES-DISPLAY: This action tag allows for additional customization of the Field Note box within the field editor of a REDCap project. 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. For our registry, we want to add a form that records diabetes management methods. 1. Where is the Record ID field? record_id dont change or move this variable name, because doing so will delete all of the data in your project. The format must follow the pattern @HIDECHOICE='?? Specific applications include a body map (the over 70 body regions), a smile scale from 1-7 with facial expressions, and 3 representations of teeth and teeth surfaces. The reviewer hasthe ability to mergerecords created by both data entry users, after viewing differences and adjudicating those differences using the Data Comparison Tool. 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. The first survey should route straight to the second survey. when a participant is reporting multiple things of the same type. The calculations in calculated fields aren't sent to the server until you hit save. Did you know you can track discrepancies in your data via the Data Quality Module? 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? The units portion can be set to one of the following: y representing years, M for months, d for days, h for hours, m for minutes and s for seconds. Create a Descriptive Text field in your instrument and then create the variable name. After enabling surveys, go to the Online Designer. External Module Spotlight QR Code Shortcut: QR Codes are simple and effective methods to provide additional means for participants to access information and allow them to use their smartphones scanning capabilities to easily visit the study website. Incomplete Denotes that data entry for the form is not finished. when utilizing DAGs in a project. 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. Download the Data Dictionary as a csv and make changes to multiple parts of instrument(s) at once. Each of these records is distinct, with its own forms that store data. Using this PDF guide (link to guide), you can set up an e-Consent for your REDCap project to remotely obtain a subjects consent. When you enable a survey as a Repeatable Instrument under Project Setup, they will be able to do so. This external module allows you to add tooltips to your Data Entry Forms and Surveys! [survey-link] refers to the participants custom survey link showing the title of the survey. 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. The most commonly used tags are: Answer choices: don't change the associated numeric code! Ever wish you had an easier way to make a selection out of a long list of choices? [aggregate-mean: fields: parameters]: The mean/average of a field across all records in a project. Since 2009, weve awarded 93grantsfor innovative, interdisciplinary research through our Pilot Studies Program. Use piping, a feature that allows you to add previously collected data into text on a survey. In Figure 13, you will see that the survey addresses Sophia SMITH in the survey instructions. If you are the project owner, you can lock records of your data so no one else can edit them. Best Practice: Make sure to specify your projects type under Project Settings on the Project Setup page. Read the guide nedCAPTCHA The Data Collection Instrument column displays the name of the form, while the Status column displays icons, with a green circle indicating a completed form, a red circle an incomplete form, and a stacked circles icon for repeating forms. @HIDDEN -- Hides the question/field on the survey page, the data entry form, and in the REDCap mobile app. REDCap Data Entry User's Guide & Reference Manual Page 4 Data Entry Fields Figure 4 illustrates an example of a data entry form for a generic database. After a data export, the resulting data and syntax files are stored here also. Did you know you can create a drop-down list using the data inside your projects using the Dynamic Query (SQL)? 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. Within the survey you can set up a descriptive field labeled Survey Elapsed Time. You can save a snapshot of your current data dictionary by simply clicking the. 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. Do you want to applyformatting in your REDCap projects and survey forms? | accessibility. If you add a calculated field after collecting the data used in the calculation, you will need to re-save the form containing the calculation. Although DAGs can be created at any time, it is best to set it up before the project goes live. g) Records and fields are marked either new, modified, or unmodified. This REDCap External Module provides action tags for controlling PDF output. This is known as a label mismatch error. This feature designates two users per study and a reviewer. Labs commonly have multiple values, and using repeating forms is an easy, organized way to collect those values. If you change the numeric code associated with an answer choice label, you'll lose the data for the answer choice and/or get it mixed up with data from other answer choices. You can use these options to hide calculated fields in surveys while still using the value for piping or branching logic. After making all of the changes, go back to the Online Designer page and click on Submit Changes for Review. This guide describes how to create and format calculated fields, such as BMI, using height and weight fields and a subjects age using two date fields. This is the field the REDCap database uses to link the data for a particular record together -- all databases require a unique ID to distinguish between entries in a database. A public link is only possible when the first instrument is a survey. This QR Code is clickable as well! Figure 10: Diabetes Management Methods Form. You can schedule to send your online survey on a specific date or based on certain conditions being met. 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. In REDCap, all fields on data collection instruments will have a corresponding 'field name' or 'variable . The Form Status Complete? field exists on every form. You may upload files here to save for retrieval later or download previously uploaded files. Tufts CTSI has now enabled. 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. This field will be the leftmost one on the spreadsheet. 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. export_data_access_groups. In REDCap Field Notation, variable names always point to data fields in the project. Reminder: raw data will give you variable names such as "why_pcom" instead of "Why did you choose to attend PCOM? 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. This module is especially helpful for those using eConsenting in REDCap. Set its branching logic to be [current-instance]=1! When creating your matrix field options, set one or more of the options to a field that you want to embed. This process is activated by a trigger field being saved. You might see errors if you have the data file open in another format while trying to open in the statistical software. All integration should be completed in collaboration with the REDCap team. You can hide a choice for which you've previously collected data (as opposed to deleting the choice, which deleted the data). Ideal Example -- plan ahead to avoid label mismatch errors! 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. Tufts CTSI's network comprises nearly 40 medical, academic, industry, & community partners and collaborators. To ensure data and information security, set up a Data Access Group (DAG). Each form has a Delete Data for THIS FORM only button, which does just that. 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: , Articles R