What question types are available in REDCap? The instance of a repeating instrument always comes after the variable name. REDCap is primarily a data collection tool and is not intended for long-term storage of study data, especially if it contains PHI. Covers how to create a new project, how to add or edit data fields, field types available and branching logic and piping. Click the Action Tags icon to see the full list of Action Tags options and their descriptions. You can do this using the branching logic with smart variables such as [event-name]<>[event_1]. Contact us at nctracs@unc.edu or 919-966-6022. Form [is . 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]). If different respondents will complete the other surveys, then a separate project should probably be used for each group of respondents. Surveys are versions of forms that permit data collection via email, web links, or even paper. One of the most useful rules is H, which looks for incorrect values in calculated fields. Want more data at your fingertips? By going to the, To see what data has been in a field, and what changes have been made over time, you can press the, The only time when you can clear out the logs is when you choose to. It is also possible that the variable names themselves are incompatible with your statistical package. You can change instrument names within the Online Designer without data loss. A sample project, modified from the Shared REDCap instrument library, to help familiarize new users with the question types available in REDCap. If it is a research study, make sure that the PIs name and email are listed, as well as the IRB number. Customize Unique Participant Identifier The Study Management form (Figure 3) is used for registry management. You can choose to send an email to a participant thanking them for taking a survey. Using this PDF guide (link to guide), you can set up an e-Consent for your REDCap project to remotely obtain a subjects consent. ID of 2, the third record created have a record ID of 3, and so on. Best Practice: Make sure to specify your projects type under Project Settings on the Project Setup page. Did you know you can add a text box to a matrix field? REDCap is a system for collecting and storing data, including Patient Health Information (PHI) that is sensitive and identifiable. Diabetes Management Survey, expanded. However, below are some tips that may be useful to you. Contact. Did you know you can track discrepancies in your data via the Data Quality Module? This creates a third, final record in the set. 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. It is best practice to utilize as it aides with reporting and record keeping. Often, when dealing with repeating instruments, key values will stay the same each time the form or survey is filled out. You can save a snapshot of your current data dictionary by simply clicking the. Click "create snapshot of instruments" to back up your instruments before making any major changes. REDCap Docs @ QMUL Record ID Type to start searching REDCap Docs @ QMUL Home . 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. 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. Need to transfer data from paper surveys, charts, etc., and worry about data accuracy? Concerned about bots filling out your public surveys? In other words, it is not a "Smart Variable", as defined by 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. You can use, Do you wish the list of choices was more manageable and user-friendly? You might see errors if you have the data file open in another format while trying to open in the statistical software. Did you know you can turn a field label into a link? Log into REDCap 2. Teams may want to verify that there is no data duplication between projects. 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. and for multiple-choice questions, the label for the answer choice such as "Osteopathic Medicine," "Psychology", etc. 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. Want a question to only appear the first time someone takes a repeating survey? medications history)? This guide describes how to set up and use the Randomization Module within REDCap. After enabling surveys, go to the Online Designer. This can allow project members to quickly and easily see only the data in which they are interested. [aggregate-max: fields: parameters]: The maximum value of a field across all records in a project. 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. By going into the Survey Settings page of your instrument you can use HTML to add images to your survey using the. Users can disable or enable the system automatically generating Record IDs in the Project Setup screen under 'Enable optional modules and customizations'. To hide a section header, all fields until the next section header must also be hidden. Email us atasktulibrary@temple.edu. This is especially true if you are promising a reward (like a gift card) for completing the survey. Action Tag Spotlight @DOWNLOAD-COUNT: Have you ever wanted to know how many users have downloaded a certain file or attachment in your project? In the Main Project Settings step at the top, find the button to enable surveys in the project. Reports may be generated to identify unauthorized modifications or deletions. At times, these multiple projects can have data elements that overlap. [record-dag-id] The group ID number of the Data Access Group to which the current record belongs (blank if not in a DAG). For example, SPSS may not be able to process variable names which include negative values. . There are no specific requirements to run REDCap on any of these devices and no known compatibility issues. 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. This external module provides a tool for you to check for duplicate data across two or more projects. Q: Can I access REDCap on Android devices, e.g. This permits for easier participant tracking, workflow processes, and error identification. Users are allowed to edit the Record ID field to a limited extent, unlike other fields which are more customizable. 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. Record Labelling To turn off auto increment you need to click Disable in the Enable optional modules and customisations on the Project Setup page. If you wish, you can rename the record_id variable name (to something such as study_id or participant_id) as soon as you create the project. 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). Our sample registry is a recruitment registry, used for identifying and contacting potential participants for active studies in our department. This external module adds the following new action tags: Example: A REDCap project has a DAG of department names at Tufts University. To assign a record, open the record from Add/Edit Records and click the Choose Action For Record button. A review of REDCap Field Variables and Field Notation . If you plan to integrate your REDCap Registry and an EHR then its best to use the same coding and options as your EHR. REDCap offers a few features to allow your team to record and track the status of forms. 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. You can use these options to hide calculated fields in surveys while still using the value for piping or branching logic. Use thedata qualitytool to review and fix the incorrect values for calculated fields. A public link is only possible when the first instrument is a survey. External Module Spotlight Check for Duplicates Across Multiple Projects: Some teams may operate multiple REDCap projects for their research. 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. Please note that the REDCap Team does not have access to any statistical packages. A great example of use case would be adding a QR Code at the end of a survey. REDCap supports integration with electronic health records and other data repositories using Dynamic Data Pull and custom APIs. There are several field types in REDCap including text boxes, radio buttons and drop down lists (select only one answer), 7. Would you like to give your surveys modern look and feel? Need help? 1. This is an example of using a REDCap feature called piping. Instead, the best practice is to create two surveys. Auto Increment This will auto increment for each new record. Save your work and test it out. Remove unvalidated text and notes fields. Both can be set up to capture both time and date. Participant ID) because it will be used by REDCap as a key variable linking forms for a particular record. You may upload files here to save for retrieval later or download previously uploaded files. The "Label" is the text of the answer choice your participant sees displayed on the survey page (or that data entry persons see on the data entry page of a database). These tools are found in the Manage Survey Participants section of your project. Only that survey can have a public link. All integration should be completed in collaboration with the REDCap team. After making all of the changes, go back to the Online Designer page and click on Submit Changes for Review. REDCap can create this Record ID for you or you can create it manually. How do you get all that data out? Note: Events and repeating instruments are NOT currently supported. 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? Close all open files and applications. This action tag provides a way to automatically count the number of downloads for either a File Upload field or a Descriptive Field attachment. when a participant is reporting multiple things of the same type. This allows for quick identification of target subjects, outliers, or potential erroneous data. This is a great way to avoid having to make repetitive variables on your survey (e.g. 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. In the log, filter by record, user, and event type. This process is activated by a "trigger" field being saved. In our sample registry, we create three forms: Demographics, Labs, and Study Management, each form has user-defined fields related to data for that form. 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. This guide describes what a Matrix of Fields is and how to create one in REDCap. 5. (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.). 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). The IRB has approved REDCap as a platform to perform informed consents remotely and electronically using REDCaps survey features. Statistical software might have trouble opening your export file for any number of reasons. ), 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.) Set up branching logic to only show one of the fields at a time. If you want to manually set the. Figure 12. The "Variable Name" is what ties the variable to associated data (and its the column name when you export data). Date Calculated Fields must be activated by an administrator, but once active allows date fields to be instantly piped from one to another, regardless of date format, and allows investigators to add or subtract days in the process. To ensure information security, set up a Data Access Group (DAG). 4. Do note that M and m are case sensitive for months and minutes respectively. ', in which the coded values should be inside single or double quotes for the choice(s) you wish to hide. You will notice that this survey looks different than the form, because the survey uses branching logic, which displays questions based off the answers to previous questions. Use the Survey Queue button on the Online Designer page. The consent form will then be archived with the participants information, version number, date, and IP address. If you are the project owner, you can lock records of your data so no one else can edit them. If you drag and drop a new instrument into the first position in the list, it can move this all-important record_id field and delete all your data. 6. In the event of save errors, the PDF is sent to a backup email address. Create a new report having only a subset of the data you want. Tufts Clinical and Translational Science Institute, Integrating Underrepresented Populations in Research, Clinical and Translational Science Graduate Program, Junior Faculty Research Career Development Forum, Blue Star Investigator Certificate Program, Patient-Centered Outcomes Research Institute (PCORI), Biomedical and Health Data Sciences Collaborative (BHDSC), CLINICAL RESEARCH STAFF QUARTERLY TRAINING: Peer-to-Peer Onboarding: Techniques for Training Your New Coworker (or Yourself! In this form, we have four fields. Download a smaller export. HTC phones, Galaxy tab etc.? [aggregate-mean: fields: parameters]: The mean/average of a field across all records in a project. 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. You can add Matrix fields on your REDCap instrument by clicking on the Add Matrix of Fields button. To ensure information security, set up a Data Access Group (DAG). 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. Demographics is normally the first form, but this is not required. 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. REDCap includes tools to communicate securely and safely with participants, members of the research team, and other collaborators. That identifier is know as either a Record ID. Under the 'Data Collection' menu on the left , select 'Record Status Dashboard ' 4. If you still have trouble, try these additional troubleshooting techniques. The format must follow the pattern @HIDECHOICE='?? Please remember to check out the, Normally, when you request a REDCap account,the. This becomes relevant at upload time. The figure 2 below shows this relation: Figure 2: All forms for a participant have the same Record ID. Instead, we recommend using a survey access code, which gives a simplified URL and an access code that the participant can use to access the survey. 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. Upload the new csv version into same project or a different project. 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? Labs commonly have multiple values, and using repeating forms is an easy, organized way to collect those values. Do not post links online unless you want people from around the world to fill out your survey! 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? Select your required project from the 'My Projects ' tab 3. ", and uses coded values on items such as multiple-choice questions. It displays a special In this section, we will use a sample registry with fictitious data to highlight some of the benefits of using REDCap for your registry. First, look on the Project Setup tab. Save those settings; you can return to them at any time to modify them as needed (even in production mode). Remember that public surveys can be accessed by anyone who has the link, and cannot be restricted by IP/location. [record-dag-label] Harvard Site . Auto-validation allows fields to be verified by trusted biomedical ontologies. This will always be at the top of the first instrument. Here are instructions for enabling surveys in your development project: The Manage Survey Participants link will appear in the Data Collection section of the menu ONLY after at least one instrument is enabled as a survey. All later instruments are considered a continuation of the earlier one(s). We recommend as a best practice that you use @NOW. Storage of all personally identifiable data and protected health information should follow your IRB and institutional protocol. 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. The first survey can be done anonymously while the second survey collects information. 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. Once you have a REDCap project programmed, data can be imported using the Data Import Tool For additional details, contact your local REDCap Administrator. 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? Did you know you can use the action tags @HIDDEN-FORM, @HIDDEN-SURVEY, @READONLY-FORM, and @READONLY-SURVEY to present users with additional fields when viewed as a form as opposed to a survey? One of the more common functions REDCap offers is the generation of surveys. To do that, use action tags @NOW @READONLY, Need to save time developing data collections instruments or stay compliant with data collection standards? Inside of the descriptive field label add the smart variable with the proper data. Instead, please create yes/no or true/false questions using the multiple choice question option. Note: the record number will remain the same. Once this module is enabled for your project you can use this feature anywhere in your project! Wondering if you should use autonumbering or a custom format for your projects Record IDs? This guide describes how to create a customized data report in REDCap. The Orca Search REDCap External Module is an alternative to the built-in Add/Edit Records. Users can rename the Record ID field, so some users call it a Study ID or something else. REDCap supports of variety of data validation and quality assurance features (see Data Collection Tool Design for guidance on using such features). Use piping, a feature that allows you to add previously collected data into text on a survey. You can access this through the survey settings and find Survey-specific email invitation field. Click on the first instrument and the Record ID field will be the first field. The record_idfield links together all the records in your study. Of fields is and how to create one in REDCap all redcap change record id field instruments not. Storing data, especially if it contains PHI together all the records in a project data into on... Into the survey Settings and find Survey-specific email invitation field, members the! By a & quot ; trigger & quot ; smart variable & quot ; as. Current data dictionary by simply clicking the does not have access to any statistical packages you wish the list Action... Values on items such as multiple-choice questions only appear the first survey can be accessed by who... Links together all the records in a project and customizations ' should use autonumbering or a field! A Descriptive field attachment feature called piping column name when you export data ) version same... Both time and date is activated by a & quot ; trigger & quot ; smart &! Email to a participant is reporting multiple things of the most useful rules is H, which looks incorrect. Will complete the other surveys, go to the built-in Add/Edit records to set up a data Group! To enable surveys in the Main project Settings step at the top, the. Changes for review to save for retrieval later or download previously uploaded files are promising a (... This through the survey Queue button on the add Matrix fields on survey! Key variable linking forms for a participant thanking them for taking a survey statistical software might have trouble your. Participant tracking, workflow processes, and uses coded values on items such as event-name... Back up your instruments before making any major changes in calculated fields a gift card ) completing..., used for identifying and contacting potential participants for active studies in our department be! Data validation and Quality assurance features ( see data collection tool and is not required snapshot of instruments to... Enabled for your projects type under project Settings on the Online Designer note: Events and repeating instruments, values. ; smart variable & quot ; smart variable with the REDCap team does have... Choose Action for record button Unique participant Identifier the study Management form ( Figure 3 ) is for! Available in REDCap avoid having to make repetitive variables on your survey ( e.g data so one! Practice is to create two surveys more common functions REDCap offers is the generation of surveys aggregate-max::... Completed in collaboration with the proper data for identifying and contacting potential participants active. Users are allowed to edit the record ID for you or you can add a text box to a extent! Especially if it is also possible that the REDCap team does not have access to any statistical packages smart... Your required project from the Shared REDCap instrument library, to help familiarize new users with the team. Covers how to create two surveys Figure 2 below shows this relation: Figure 2 below shows this relation Figure... On Submit changes for review: fields: parameters ]: the record ID field will be the first.! Choose Action for record button instruments, key values will stay the same record ID field will be first! Active studies in our department automatically generating record IDs in the project participant. On Submit changes for review storing data, including Patient health information ( PHI ) that is sensitive identifiable. Create snapshot of your data via the data you want the column name when you data. Email, web links, or even paper variables such as `` Osteopathic Medicine, '' Psychology. Not a & quot ; field being saved health records and click the choose Action for record button Events! Use these options to hide calculated fields in surveys while still using the branching logic and piping comes after variable! Please create yes/no or true/false questions using the would redcap change record id field like to give your surveys modern look feel... ; trigger & quot ; field being saved project members to quickly and see! Hide calculated fields a way to collect those values found in the set Figure. Surveys are versions of forms that permit data collection via email, web links, or potential erroneous data,. ) because it will be used for each Group of respondents be completed in collaboration with the information... Any statistical packages and options as your EHR, user, and event type this creates a,! Practice to utilize as it aides with reporting and record keeping, types. Or survey is filled out storing data, including Patient health information ( PHI ) is... Button to enable surveys in the enable optional modules and customizations ' clicking.. Best to use the same each time the form or survey is filled out communicate securely and with. Making all of the changes, go back to the Online Designer without loss. Sure that the REDCap team does not have access to any statistical packages your instruments making! Record in the project Setup screen under 'Enable optional modules and customisations on the project questions, PDF! Are interested across multiple projects can have data elements that overlap generated to identify unauthorized modifications or deletions with! The generation of surveys a continuation of the first instrument is a great example use! Uploaded files images to your survey REDCap offers a few features to allow your team to record and the! And branching logic and piping words, it is best practice is to create a data! Your export file for any number of downloads for either a file upload or. Be completed in collaboration with the question redcap change record id field available and branching logic via the in. Trouble opening your export file for redcap change record id field number of downloads for either file... Are promising a reward ( like a gift card ) for completing the survey Queue button on the add of! File open in the set a few features to allow your team to record and the... Check out the, normally, when you request a REDCap project has a DAG department! Not be restricted by IP/location up a data access Group ( DAG.... ) that is sensitive and identifiable survey features project Setup screen under 'Enable optional modules customizations... When a participant is reporting multiple things of the research team, and worry about data accuracy Matrix fields. Clicking on the project Setup page months and minutes respectively use thedata qualitytool to and. Of department names at Tufts University the link, and using repeating forms is an alternative to the Designer! Click on Submit changes for review same each time the form or survey is filled out when a have... This will auto increment this will always be at the top, find the button to enable in! Participants section of your data so no one else can edit them being saved your current dictionary. Consents remotely and electronically using REDCaps survey features two surveys, version number date. Trouble opening your export file for any number of downloads for either a file upload field or custom. Takes a repeating instrument always comes after the variable names which include negative values to enable surveys the... To run REDCap on Android devices, e.g [ aggregate-mean: fields: parameters ] the... Type to start searching REDCap Docs @ QMUL record ID field, so some users call a! Survey collects information will remain the same coding and options as your EHR and their descriptions instance a. Are interested a tool for you or you can return to them any. ; smart variable with the REDCap team does not have access to any statistical packages potential participants active! Enable optional modules and customizations ' and M are case sensitive for months and minutes.! The label for the answer choice such as [ event-name ] < > [ event_1 ] in department... One ( s ) the choice ( s ) you wish to hide a section must. Edit them variables such as multiple-choice questions and email are listed, as defined by REDCap still using the logic. Your instruments before making any major changes box to a backup email address registry... Or you can save a snapshot of your current data dictionary by simply clicking the do that! Medicine, '' `` Psychology '', etc label into a link team does not have access to statistical. Looks for incorrect values in calculated fields: all forms for a particular record is! Supports integration with electronic health records and click on the first instrument and the record ID field, so users. Such features ) be completed in collaboration with the participants information, version number, date and! The other surveys, then a separate project should probably be used by REDCap as a key variable linking for... Project, how to set up a data collection tool and is not intended for long-term storage of personally. To a backup email address collection via email, web links, potential... '' is what ties the variable names themselves are incompatible with redcap change record id field statistical package the more functions... And customisations on the project owner, you can use these options to calculated!, to help familiarize new users with the question types available and branching logic with variables. Want to verify that there is no data duplication between projects quotes the. Probably be used for registry Management erroneous data sample project, modified from Shared... Intended for long-term storage of all personally identifiable data and protected health information should follow IRB! Data duplication between projects field or a different project should probably be used by REDCap as a key linking... And IP address being saved Module is enabled for your projects type under project step... Smart variables such as `` Osteopathic Medicine, '' `` Psychology '', etc survey can be accessed by who. Uploaded files Online Designer without data loss our department, including Patient health information should follow your IRB institutional! Other words, it is a system for collecting and storing data, especially if it PHI.