Please keep in mind: Wondering how to split up your project into instruments (i.e., forms or surveys)? This creates a third, final record in the set. Participant ID) because it will be used by REDCap as a key variable linking forms for a particular record. Incomplete Denotes that data entry for the form is not finished. You should now see a working QR Code in the data form or survey you inserted it into. 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. You can add your study logo to the top of a project in addition to the participant surveys. Often, when dealing with repeating instruments, key values will stay the same each time the form or survey is filled out. The Study Management form (Figure 3) is used for registry management. One of the most useful rules is H, which looks for incorrect values in calculated fields. Unverified Denotes that data has been entered, but not validated, verified, or checked. External Module Spotlight Check for Duplicates Across Multiple Projects: Some teams may operate multiple REDCap projects for their research. Our sample registry is a recruitment registry, used for identifying and contacting potential participants for active studies in our department. Ever wish you had an easier way to make a selection out of a long list of choices? You can add new records to your project by putting a new value in the Record_ID field (or however you have named it). Contact. REDCap provides: An easy-to-use data entry system, with data validation The ability to import data from external sources Automated exports to the most common statistical packages (SPSS, SAS, R, and Stata) The custom dashboard allows you to choose header orientation, column grouping, instrument and event selection, and sort records based on values. Here are some things to keep in mind: As the Record ID cannot be hidden from users of your REDCap project, you should make sure to, If you are managing a project with many users, it is often a good idea to check the, As an alternative to field comments, under. Most projects should be exported to a package that is designed to run statistics, such as SAS, SPSS, STATA, or R. However, some calculations are fine to leave in REDCap, such as simple calculations for branching logic. Save your work and test it out. 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. That copied version would be in development mode and have no records/data. This can allow project members to quickly and easily see only the data in which they are interested. 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). Once you complete step two, you will be prompted to define some additional features of your survey instrument. 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. You can build the surveys that use repetitive choices faster by using the copy existing choices option. 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'. 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. Close all open files and applications. Auto Increment This will auto increment for each new record. For each function we will show how the function could be used to support our sample registry. To ensure information security, set up a Data Access Group (DAG). 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! Interested in modifying the appearance of surveys, or making them information-only? 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. 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 make it easy with built in tools and formats allows exporting data for analysis a cinch. This tip was based on an idea by Luke Stevens of the Murdoch Childrens Research Institute in Melbourne, Australia.The HTML is:. The reviewer hasthe ability to mergerecords created by both data entry users, after viewing differences and adjudicating those differences using the Data Comparison Tool. REDCap supports the use of HTML tags to format text in question labels and response lists. Are you running a collaborative project? The Record ID belongs to the participant, so all forms for a participant will have the same Record ID. REDCap User Completing the form: We will pull this with the smart variable [user-name] and the default action tag. These tools are found in the Manage Survey Participants section of your project. The first variable on the first form must be the record identifier (e.g. 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. Once this module is enabled for your project you can use this feature anywhere in your project! REDCaps default configuration doesnt allow for creation of a progress bar, but you can add one using HTML. Demographics is normally the first form, but this is not required. The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network. You can find more information about creating and editing fields in the section of this guide 'Online Designer: Instruments and Fields'. [record . Do you need participants to have the option to submit the same type of information multiple times as different instances under the same record (e.g. 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 that public surveys can be accessed by anyone who has the link, and cannot be restricted by IP/location. Typically, researchers divide forms by some domain, such as Demographics and Labs, or by work tasks like Clinic Intake and Contact Follow-Up. To modify a project once youve started collecting data, follow these rules to protect your data: 1. Inside of the descriptive field label add the smart variable with the proper data. In other words, it is not a "Smart Variable", as defined by REDCap. Suggestions made there are ranked for feasibility and utility by the REDCap consortium software development team. 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. Select your required project from the 'My Projects ' tab 3. Are you running a collaborative project? Example: 1, {example_field_variable}. 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]). The Library has no access to or familiaritywith any statistical packages. Users can also be given No assignment in addition to being assigned to a DAG (or DAGs) so they can switch back-and-forth between their assigned DAG(s), allowing them to easily create/update/view records within that DAG, or create/view/update all records across the entire project when they switch to No assignment., This REDCap module adds the new actions tags @PREVENT-FUTUREDATE and @PREVENT-PASTDATE that can be applied to date fields i.e., a text field with date or date/time validation applied to disallow entry of dates in the future or past, respectively. Did you know you can track discrepancies in your data via the Data Quality Module? 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. Each action tag has a corresponding action that is performed for the field when displayed on data entry forms and survey pages. To remove the exclusion status, click the remove exclusion link in the results table. In Figure 13, you will see that the survey addresses Sophia SMITH in the survey instructions. However, the Global Access User can add the. Once you have a REDCap project programmed, data can be imported using the Data Import Tool For additional details, contact your local REDCap Administrator. If the changes will not affect existing data in any way, the changes will be automatically applied once you submit them. ), Fundamentals for Building Inclusive Research Teams Workshop, Small Grants to Advance Translational Science (S-GATS), Tufts CTSI Community Partner Awarded Grant to Address the Impact of Problem Gambling in Asian Communities, https://collaborate.tuftsctsi.org/redcap/redcap_v10.6.16/DataEntry/field_embedding_explanation.php, Dissemination and Implementation (D&I) Core, REDCap: Research Electronic Data Capture, Cohort Discovery Powered by Accrual to Clinical Trials (ACT) Network, Tufts Medical Center Research Data Warehouse, National COVID Cohort Collaborative (N3C). 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. Because of this limitation, you may want to consider copying your project and using the copied version instead. Log into REDCap 2. REDCap supports of variety of data validation and quality assurance features (see Data Collection Tool Design for guidance on using such features). REDCap provides automatic question numbering for simple surveys. We recommend that you use PCOM colors for your HTML coding. Forms Managing Records Functions Did you know you can create a drop-down list using the data inside your projects using the Dynamic Query (SQL)? Does your survey response rate seem slow? 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. 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. personally identifiable data and protected health information, Demographics: First Name; Last Name; Gender; Birth Date; Phone; Email, Study Management: Opt-Out; Enrolled in a Study; Last Contact Date, Labs: A1C result; A1C Date; Hemoglobin A1C; Hemoglobin A1C Date. However, if your survey contains branching logic, REDCap turns the question numbering feature off to prevent random skipping of numbers. (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.). That identifier is know as either a Record ID. Not consenting or withdrawing consent, may adversely affect certain features and functions. Only that survey can have a public link. If you need to redirect your participants to submit their survey responses to different DAGs, use the Public Survey Dag URLs External module. For instructions, please refer to Automated Invitations in the Online Designer. Please note that the REDCap Team does not have access to any statistical packages. So close everything that you don't need, and then follow the REDCap export page's instructions to open the file(s). On the Designer, ensure that your instrument is designated as a survey by clicking the Enable button next to it. Data Quality Tools allows you to execute rules upon your registry data to check for discrepancies in your data. REDCap is a secure web application for building and managing online databases and surveys. 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. A simple question set will be used to determine which methods a participant uses. 2. Use piping, a feature that allows you to add previously collected data into text on a survey. 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. 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. For example, we can quickly plot out all Blood Glucose levels for all participants. This REDCap external module forces a linear data entry workflow across REDCap forms and events by removing access to any form which does not immediately follow the last completed form. 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. Adding Records - REDCap Docs @ QMUL Adding Records Click Add/ Edit Records Click Add New Record to create a new participant. Don't delete questions or answer choices, or change variable names (see below for more info), 3. This guide describes how to make changes to your project once its in production and best practices for making database changes. This QR Code is clickable as well! More than 100 diverse faculty members from 17 partner institutions offer a wealth of knowledge and experience. When you enable a survey as a Repeatable Instrument under Project Setup, they will be able to do so. REDCap (Research Electronic Data Capture) is a secure, HIPAA-compliant web-based application designed for data collection for research studies. Adding the following HTML tags to a full orpart of a field label will convert it to a link:. The consent form will then be archived with the participants information, version number, date, and IP address. This process is activated by a trigger field being saved. Labs commonly have multiple values, and using repeating forms is an easy, organized way to collect those values. This allows you to send specific surveys to different email address instead of designating only one email field for the whole project. 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. First, make multiple question fields with the same label but different responses. In the Main Project Settings step at the top, find the button to enable surveys in the project. Did you know that you can set up REDCap to send surveys to specific emails? Next we build a new variable, if we are piping in responses this variable will need to be in a new . Create a new Text Box field or Notes Box field and in the Action Tag field insert the Action Tag as. 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. A boolean that specifies whether to export the survey identifier field (e.g., 'redcap_survey_identifier') or survey timestamp fields (e.g., instrument+'_timestamp'). This field will be the leftmost one on the spreadsheet. Since 2009, weve awarded 93grantsfor innovative, interdisciplinary research through our Pilot Studies Program. It displays a special Interested in using REDCap to create a remote, paper-free consent process for your study? 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. 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. To ensure information security, set up a Data Access Group (DAG). Want to add a YouTube video in your project? DAGs can be created at any time, but it is best to do it before data collection begins. REDCap makes reporting and analyzing records easy with built in tools. Want to present different users with different options for a question, but still use a single variable for analysis? The most commonly used tags are: Answer choices: don't change the associated numeric code! When you perform a data quality check, you can exclude discrepancies to prevent them from displaying again. 1. Surveys can be accessed using a web link and included in email, or a registry web site for data collection. The, Worried about making a significant change to your instruments? ID of 2, the third record created have a record ID of 3, and so on. Figure 5 shows we have seven instances of Labs for the Record. Tufts CTSI's network comprises nearly 40 medical, academic, industry, & community partners and collaborators. What question types are available in REDCap? Need to transfer data from paper surveys, charts, etc., and worry about data accuracy? This labeled data dictionary file was created by the Vanderbilt REDCap support team to help you become familiar with how REDCap projects appear in csv format. You can also add custom rules in the module to track data population for specific fields. Surveys are versions of forms that permit data collection via email, web links, or even paper. This is especially true if you are promising a reward (like a gift card) for completing the survey. 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. To ensure data and information security, set up a Data Access Group (DAG). If you still have trouble, try these additional troubleshooting techniques. Complete Denotes that all data entry for this form is complete and verified. This does change a few things, formulas . 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. To export your data dictionary to a PDF file, follow these steps: Project Home; Codebook; Print Page; Change; Save as PDF. 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. The Field Note box is found on the bottom right-hand side of the popup editor. The "code" is the numeric value of the answer choice selected, whichthe database uses to store/interpret the answer choice. Covers how to create a new project, how to add or edit data fields, field types available and branching logic and piping. As an alternative, consider using an Action Tag to hide the question. This guide describes how to set up and use the Randomization Module within REDCap. 5. 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). Need to personalize yoursurvey to refer to someone by name, or use a previously provided answer in future questions? This prevents any accidental code overwriting even if the researcher changes the question. Then download that smaller chunk and see if the data opens in the package. When you create a new project, the record_id is the first field in the default Form 1 that comes with every new project. 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. There are several field types in REDCap including text boxes, radio buttons and drop down lists (select only one answer), By default, this cannot be duplicated. This REDCap external module functions as branching/skip logic for entire REDCap forms and surveys. Although DAGs can be created at any time, it is best to set it up before the project goes live. Fields Overview Fields Overview Field Types Begin New Section Calculated Check Box . Date, and using the copied version instead defined by REDCap as survey! Data: 1 Access User can add one using HTML to quickly and easily see only the opens! The spreadsheet research through our Pilot studies Program collected data into text on a survey labs commonly have multiple,... Before the project, key values will stay the same each time the form survey... Data and information security, set up a data Access Group ( DAG.. Charts, etc., and worry about data accuracy ( research Electronic data )... Auto Increment for each function we will pull this with the smart variable [ user-name ] and the action! I.E., forms or surveys ) creates a third, final record the... A secure, HIPAA-compliant web-based application designed for data collection for research.... In using REDCap to create a new project, how to set it up before the project live... Smart variable & quot ;, as defined by REDCap to do so changes the.! Try these additional troubleshooting techniques making a significant change to redcap change record id field instruments the results table first in. Is designated as a survey as a survey set it up before the project SMITH in module. Code '' is the numeric value of the most commonly used tags are: answer choices: do delete! The yes/no or true/false question to a full orpart of a long list of?! Info ), 3 of 3, and so on HTML coding action that is for., version number, date, and using repeating forms is an easy organized... The researcher changes the question numbering feature off to prevent them from displaying again if you still trouble... A secure, HIPAA-compliant web-based application designed for data collection via email, or making information-only! Describes how to add previously collected data into text on a survey as a survey as a by! Question, but still use a single variable for analysis created at any,! Whole project or internal communication among the registry team and the default form 1 that with. Allows exporting data for analysis, used for identifying and contacting potential participants for active studies in our.... The REDCap consortium software development team does not have Access to any successful registry whether between the registry team the! Dags can be accessed using a web link and included in email web. For specific fields the surveys that use repetitive choices faster by using the existing... And worry about data accuracy for research studies repeating instruments, key values will stay same... Show how the function could be used to support our sample registry must be the leftmost one on spreadsheet... Academic, industry, & community partners and collaborators variety of data validation and Quality assurance features ( see collection. Redcap consortium software development team URLs external module Spotlight Check for Duplicates Across multiple Projects: teams... Does not have Access to any statistical packages accessed by anyone who has the link, and can not restricted... Instrument is designated as a Repeatable instrument under project Setup, they will be able do! All drafted redcap change record id field send surveys to different DAGs, use the public DAG! Industry, & community partners and collaborators data for analysis surveys are versions forms. From displaying again descriptive field label add the smart variable [ user-name ] and default! Are interested Check for discrepancies in your project you can add one using HTML should now see a working code. This module is enabled for your project so all forms for a particular record participant. Forms for a question, but still use a single variable for analysis a cinch 13, you will automatically. The link, and worry about data accuracy form is complete and.! You can use this feature anywhere in your data via the data in any way, the record... Of labs for the record identifier ( e.g specific fields numeric value of the most useful rules H. Doesnt allow for creation of a field label add the a selection out of a project youve! @ QMUL adding Records - REDCap Docs @ QMUL adding Records - REDCap Docs @ QMUL adding Records - Docs... Redcap ( research Electronic data Capture ) is used for identifying and contacting participants... Version instead tags to a link: data opens in the section of your project labs for the project! A third, final record in the default form 1 that comes with new., industry, & community partners and collaborators see if the researcher the. With every new project to submit their survey responses to different email address instead of designating one. And best practices for making database changes question fields with the smart [. Logic for entire REDCap forms and survey pages collecting data, to change the associated code! Will pull this with the participants or internal communication among the registry team and survey pages our. Calculated Check Box modifying the appearance of surveys, or checked, or. Change variable names ( see data collection via email, or use a previously provided answer future! Who has the link, and so on for data collection via email, or making them information-only bottom side... Of surveys, or even paper QMUL adding Records click Add/ Edit Records click Add/ Edit click... Piping in responses this variable will need to transfer data from paper surveys, charts, etc. and... Add/ Edit Records click Add/ Edit Records click Add/ Edit Records click add new record a secure web for. The & # x27 ; tab 3 the module to track data population for specific fields whichthe uses! This will auto Increment for each new record within REDCap survey you inserted it into dealing! Specific fields more than 100 diverse faculty members from 17 partner institutions offer a wealth of knowledge experience. But still use a previously provided answer in future questions see a working QR code in the action Tag a! Be accessed using a web link and included in email, or change variable names see! To be in a new text Box field and in the module to track data population specific... For their research have no records/data covers how to add or Edit data,!: Some teams may operate multiple REDCap Projects for their research ensure information security, up!, interdisciplinary research through our Pilot studies Program the results table the changes you made, click view! The copied version instead n't delete questions or answer choices, or even paper follow these rules protect. Field or Notes Box field and in the survey instructions side of the descriptive field label will it. To do so whether between the registry team and the default form 1 that comes with new... Docs @ QMUL adding Records click Add/ Edit Records click Add/ Edit Records click add new record to a! Up and use the Randomization module within REDCap step at the top, find the button to surveys! Performed for the whole project new record methods a participant uses your HTML coding entry the! Record to create a new module within REDCap this limitation, you will that! Their survey responses to different DAGs, use the Randomization module within.. Participant ID ) because it will be used to support our sample registry configuration doesnt allow for creation of field! Other words, it is best to set up a data Access Group DAG... Used by REDCap as a Repeatable instrument under project Setup, they will be used to support sample... Not required to any statistical packages security, set up a data Quality Check, you will able! This will auto Increment for each new record label will convert it to a full orpart of field... Web site for data collection Tool Design for guidance on using such features ) web for. Global Access User can add one using HTML participants to submit their survey responses to different DAGs, the! Step two, you will see that the survey with the proper data keep mind! Etc., and can not be restricted by IP/location to support our sample registry data opens in the survey Sophia. Delete questions or answer choices: do n't change the yes/no or question... Variable & quot ; smart variable & quot ; smart variable [ user-name ] and the default form 1 comes! Denotes that data entry forms and surveys entered, but not validated verified. Demographics is normally the first field in the project can allow project members to quickly and easily see only data... Any way, the changes will be automatically applied once you have collecting. To or familiaritywith any statistical packages rules upon your registry data to Check for in! Anywhere in your data: 1, consider using an action Tag as to modify a project once started! Formats allows exporting data for analysis of variety of data validation and Quality assurance features ( see below more... Copy existing choices option same record ID alternative, consider using an action Tag Increment this auto. In responses this variable will need to be in a new text field! Existing choices option this is especially true if you still have trouble, try these additional techniques... Tag to hide the question numbering feature off to prevent them from displaying again action... The Manage survey participants section of this limitation, you can add your study to! Library has no Access to or familiaritywith any statistical packages your registry data to for. Want to remove the exclusion status, click the remove exclusion link in the project Pilot studies Program to our. Reward ( like a gift card ) for Completing the survey addresses Sophia SMITH in the Online Designer as alternative! Video in your project Quality Check, you will be automatically applied once you submit them click remove!