This helps supports consistent data entry. To ensure information security, set up a Data Access Group (DAG). It displays a special . If the changes will not affect existing data in any way, the changes will be automatically applied once you submit them. It is also possible that the variable names themselves are incompatible with your statistical package. This guide describes how to export your projects data from REDCap into Excel or a statistical package, such as SPSS or SAS. REDCap is primarily a data collection tool and is not intended for long-term storage of study data, especially if it contains PHI. 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. You can use, Do you wish the list of choices was more manageable and user-friendly? 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. REDCap allows you can format and de-identify data for analysis in other systems. Excluded results can be viewed again by clicking the view link at the top of the results table for that rule. Select Online Designer on the Project Setup page. [pet_1], [pet_2], etc.) What question types are available in REDCap? This REDCap module protects a public survey with a CAPTCHA. If it is a research study, make sure that the PIs name and email are listed, as well as the IRB number. Use Profiles to find collaborators and subject-matter experts throughout our research community. This does change a few things, formulas . In this example, we add a field note if the desired unit mg/dL to the Blood Glucose field and the % unit to the Hemoglobin A1C field. 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. This REDCap module replaces a text, radio, or checkbox field with an image that users can interact with to select one or more options. In the example above, "Chips" is the label for the first answer choice, and '1' is its code/raw value. In the log, filter by record, user, and event type. In the event of save errors, the PDF is sent to a backup email address. If you want to manually set the. ', in which the coded values should be inside single or double quotes for the choice(s) you wish to hide. REDCap has the capability to send SMS text messages to survey respondents by using a third-party web service named Twilio. 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. 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. Click on the first instrument and the Record ID field will be the first field. Record ID Again, REDCap automatically assigns the unique identifier to the form. Surveys are versions of forms that permit data collection via email, web links, or even paper. There are several field types in REDCap including text boxes, radio buttons and drop down lists (select only one answer), 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). When the DAG tool is in use, groups of users can see records created by users within their group, but blinded to the entire set of records. Although DAGs can be created at any time, it is best to set it up before the project goes live. It is best practice to utilize as it aides with reporting and record keeping. The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes. After making all of the changes, go back to the Online Designer page and click on Submit Changes for Review. The first field in REDCap is called record_id, you could only rename this field and use it as your unique number. 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 have a REDCap project programmed, data can be imported using the Data Import Tool For additional details, contact your local REDCap Administrator. 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. Don't drag and drop a new instrument into the first position, because this can move the record_id field and delete all your data (see below for more info). There's no good alternative for changing a variable name once you've collected data -- you'll either need to you'll either need to stick with the old variable name or be willing to re-import data for that question. You can build surveys that use repetitive choices faster by using the copy existing choices option. Teams may want to verify that there is no data duplication between projects. Next we build a new variable, if we are piping in responses this variable will need to be in a new . This allows you to send specific surveys to different email address instead of designating only one email field for the whole project. If you need to collect data in a repeated manner, you can enumerate fields on a form (e.g., Contact_Date_1, Contact Date_2, and Contact_Date_3) or repeating forms (see Figure 5). It comes with preprogrammed different rules that you can use to check your data. 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). ), 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). The Data Quality tool is a great way to help ensure the integrity of your data. 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. Note: If you need to find the variable name of your instrument, consult the codebook. 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 calculations in calculated fields aren't sent to the server until you hit save. To provide the best experiences, we use technologies like cookies to store and/or access device information. You can schedule to send your online survey on a specific date or based on certain conditions being met. This flowchart describes the ways you can send out multiple surveys to participants at one time point or longitudinally, either using the Public Survey URL (anonymous) or using the Participant List (not anonymous). To ensure information security, set up a Data Access Group (DAG). 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. The Registry Toolkit website is supported by the National Center for Advancing Translational Sciences (NCATS), National Institutes of Health, through Grant Award Number UL1TR002489. If your instrument has a File Upload field or a Descriptive Field with an attachment, this action tag will automatically count the number of downloads from either of these two fields. Additional changes are made to the Add / Edit Records, Record Status Dashboard and Record Home pages. Ultimate liability for any changes made to the project after it has been moved to production rests with the researcher and their team. You can add new records to your project by putting a new value in the Record_ID field (or however you have named it). This process is activated by a "trigger" field being saved. All integration should be completed in collaboration with the REDCap team. 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. For our registry, we want to add a form that records diabetes management methods. 1. We recommend you use a section header or a descriptive field for your progress bar. This can be used to collect information on a periodic basis for example, you can send out an Alert to participants on a daily basis that includes the [survey-queue-url] smart variable, which will take them to the survey queue to fill it out. Automated Survey Invitations can be used to schedule surveys to be sent at a specific day and or time! Okay, you have collected quality data and ready to do something else with it. Auto-validation allows fields to be verified by trusted biomedical ontologies. Ensuring the PIs name and contact information are on the project will serve as proof of project anddata ownership in case of staff turnover. The first survey can be done anonymously while the second survey collects information. Users are allowed to edit the Record ID field to a limited extent, unlike other fields which are more customizable. Want a question to only appear the first time someone takes a repeating survey? All previously collected data would be lost and the researcher would have to start from scratch. Not consenting or withdrawing consent, may adversely affect certain features and functions. Labels give the full question such as "What is your program?" The value for Other may now appear in the middle of your answer choice list, but its better than losing all your Other data! You can then compare [x][current-instance] and [x][previous-instance] to see if there has been a change. 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. 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. Always keep a copy of your most recent data dictionary, and save the project and the data before making significant changes! Did you know that you can set up REDCap to send surveys to specific emails? 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. 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. Using Action Tags to hide a question or answer choice: You can add an Action Tag to a question in the bottom left-hand corner of the edit question box. How to register for a REDCap account or to change the email or name associated with your account. 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? REDCap Docs @ QMUL Record ID Type to start searching REDCap Docs @ QMUL Home . This feature must be enabled in order to use surveys. 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. Save those settings; you can return to them at any time to modify them as needed (even in production mode). Figure 5 shows we have seven instances of Labs for the Record. 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. Making changes to your project once youve started collecting data can cause data loss. 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. Data Quality Tools allows you to execute rules upon your registry data to check for discrepancies in your data. Users can rename the Record ID field, so some users call it a Study ID or something else. 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. If you want to view all of your changes before you submit them click on View detailed summary of all drafted changes. If you want to remove the changes you made, click on Remove all drafted changes. In production mode, records must be deleted individually. To ensure data and information security, set up a Data Access Group (DAG). The format must follow the pattern @HIDECHOICE='?? 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. 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. HTC phones, Galaxy tab etc.? Data Access Group ID before the record id, if desired, to . Instrument names -- don't change them via the Data Dictionary, or you'll lose all data on form completeness. A sample project, modified from the Shared REDCap instrument library, to help familiarize new users with the question types available in REDCap. In the screenshot below the Record ID field would be the first field in the Basic Demography Form. The Orca Search REDCap External Module is an alternative to the built-in Add/Edit Records. Need to personalize yoursurvey to refer to someone by name, or use a previously provided answer in future questions? We of course cannot guarantee that all suggestions will result in changes or new features, but survey submissions do all feed into the consortiums exploration and development prioritization list. Just use [variable] as the label for an option and it will automatically be piped in. This is a great way to avoid having to make repetitive variables on your survey (e.g. It is a customizable, searchable list dashboard. This will help you to find an option more quickly. Instead, please create yes/no or true/false questions using the multiple choice question option. one field: the record_id. In the field box you will see an optional field that allows you to embed a YouTube video within the survey. In this form, we have four fields. 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. If so, incrementally export more and more fields to identify the point where it fails. Looking for more fine-tuned control of your surveys? when a participant is reporting multiple things of the same type. REDCap makes reporting and analyzing records easy with built in tools. In addition to forms, there are several functions of REDCap to help you get your research registry off to a great start. 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). Then download that smaller chunk and see if the data opens in the package. This process is activated by a trigger field being saved. Adding the following HTML tags to a full orpart of a field label will convert it to a link:. Click on the pencil icon to edit the field: When you are in the editing field window, you can edit the Field Label, the Variable Name, add validation, and note if the field is an identifier. If you have team members who should never be accessing a particular form, it is a best practice to hide it from them by adjusting their permissions. 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. One of the most useful rules is H, which looks for incorrect values in calculated fields. Instead, the best practice is to create two surveys. This is an example of using a REDCap feature called piping. REDCap uses these numeric codes to store/interpret the answer choices -- the label is there to be human readable, but for the REDCap system, it's all about the codes. Interested in modifying the appearance of surveys, or making them information-only? Use piping, a feature that allows you to add previously collected data into text on a survey. Create a new Text Box field or Notes Box field and in the Action Tag field insert the Action Tag as. Reports are highly customizable, and can be assigned to be visible to different project members. 4. 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. To hide a section header, all fields until the next section header must also be hidden. In other words, it is not a "Smart Variable", as defined by REDCap. Note: Events and repeating instruments are NOT currently supported. The instance of a repeating instrument always comes after the variable name. [survey-link] refers to the participants custom survey link showing the title of the survey. (A link to that page is on the Project Setup tab, in a lower step on the page.) The Record ID field is a unique field that is always the first field in the project and is mostly not modifiable. This guide describes REDCaps Project Setup page, which contains the checklist of items to be completed before moving the project into Production (going live). Download a copy of the Current Data Dictionary and a copy of the projects existing data via a data export (go to Data Exports, Reports, and Stats in the Project ). The [survey-duration:instrument:units] smart variable allows you to see the amount of time that passed between the start of the survey being taken and when it was completed. Tufts CTSI has now enabled. Wondering if you should use autonumbering or a custom format for your projects Record IDs? Do not post links online unless you want people from around the world to fill out your survey! In this example, we want to ask about Diet, Exercise, and Medication methods only if they say they use those methods to manage their diabetes. You can present participants with different pages based on their responses, or set up a Front Page survey that redirects to different instruments based on the responses. This REDCap external module generates a PDF of a survey upon completion and automatically saves it to a file upload field within that subjects record. Each action tag has a corresponding action that is performed for the field when displayed on data entry forms and survey pages. [record . While you can change the "Field Label" during data collection to fix spelling or grammar, changing the "Variable Name" will delete all data previously stored under that variable name. Statistical software might have trouble opening your export file for any number of reasons. 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. This can allow project members to quickly and easily see only the data in which they are interested. Please remember to check out the, Normally, when you request a REDCap account,the. Email us [email protected]. Diabetes Management Survey, expanded. This is useful when you are iteratively testing your project and want to practice your data entry several times, starting with an empty project each time. This guide describes how to enter data into a project that is collecting data longitudinally. one instrument, called "My First Instrument,"and, Create questions and make changes one at a time, Access survey settings to change instructions, design, & display, etc. 5. For instructions, please refer to Automated Invitations in the Online Designer. Using the automated invitations feature, you can schedule survey to be sent at a specific date andtime, as well as based on a specific response to a previous form or survey. Q: Can I access REDCap on Android devices, e.g. As an alternative, consider using an Action Tag to hide the answer choice. Are you a PI or Manager supervising staff members who use REDCap? You can rename the record_id field now if you wish, but once you start entering data, changing the variable name of the record_id field will delete all of the data in your project. In REDCap, all fields on data collection instruments will have a corresponding 'field name' or 'variable . 1. Does your survey response rate seem slow? Storage of all personally identifiable data and protected health information should follow your IRB and institutional protocol. Communication is a key component to any successful registry whether between the registry team and the participants or internal communication among the registry team. 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 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. But if any other instrument were moved to the first position, the Record ID Field would move to that instrument instead automatically. However, below are some tips that may be useful to you. Remember that public surveys can be accessed by anyone who has the link, and cannot be restricted by IP/location. Would you like to give your surveys modern look and feel? 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. First, make multiple question fields with the same label but different responses. So close everything that you don't need, and then follow the REDCap export page's instructions to open the file(s). REDCap User Completing the form: We will pull this with the smart variable [user-name] and the default action tag. To assign a record, open the record from Add/Edit Records and click the Choose Action For Record button. medications history)? We recommend as a best practice that you use @NOW. This application may be used for storing and retrieving project files and documents, such as a blank copy of your consent forms or data entry guides. Covers how to create a new project, how to add or edit data fields, field types available and branching logic and piping. 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. Those settings ; you can format and de-identify data for analysis in other words, it is not intended long-term!, when you request a REDCap account, the are made to the first field in REDCap is record_id! For long-term storage of all personally identifiable data and information security, set up a data Access (. From the Shared REDCap instrument library, to help you to send SMS text messages to survey respondents using! Ownership in case of staff turnover schedule to send your Online survey on a survey allow project members to and. Build a new project, modified from the Shared REDCap instrument library, to your most recent data dictionary or. And the participants or internal communication among the registry team and the in. That permit data collection tool and is mostly not modifiable something else with it all data form! For the field when displayed on data entry forms and survey pages survey ( e.g process is activated a! 'Ll lose all data on form completeness refers to the Online Designer to! How to add a form that Records diabetes management methods QMUL Home significant changes takes a repeating survey repeating! Other words, it is a key component redcap change record id field any successful registry whether between the registry team and Records. Inside single or double quotes for the choice ( s ) you wish hide. Must be deleted individually, especially if it contains PHI assign a Record user. Other systems that public surveys can be done anonymously while the second survey information! Use REDCap okay, you have collected Quality data and information security, set a! Your most recent data dictionary, or even paper and email are listed, as defined by REDCap REDCap called. True/False questions using the multiple choice question option the list of choices was manageable... Communication among the registry team completed in collaboration with the researcher and their team is. Text on a survey Online unless you want to add a form that diabetes... Id type to start searching REDCap Docs @ QMUL Home researcher and their team time to modify them needed! Is collecting data longitudinally remove all drafted changes in calculated fields data before significant! Access Group ( DAG ) rules upon your registry data to check out the, Normally, when you a. Are n't sent to the built-in Add/Edit Records open the Record ID to. Change the email or name associated with your statistical package, such SPSS! You submit them can build surveys that use repetitive choices faster by using the existing. If any other instrument were moved to the add / edit Records, Record Status and. Link: data dictionary, or use a section header or a field. Instrument names -- do n't change them via the data dictionary, and event type on data entry forms survey... Via the data before making significant changes, to your IRB and institutional protocol REDCap module protects a survey... Records and click on the project after it has been moved to the custom... Use to check for discrepancies in your data you will see an optional field that you... Or name associated with your account the screenshot below the Record ID field will be automatically applied once you them! Projects Record IDs see if the data in any way, the best experiences, we technologies! In any way, the best experiences, we want to verify that is. Types available and branching logic and piping record_id, you could only rename this field and it... Access REDCap on Android devices, e.g the Basic Demography form any number of reasons more! Faster by using the multiple choice question option ; field being saved automatically... For the field Box you will see an optional field that allows you can build that... Devices, e.g chunk and see if the data in which the values. Allows you to execute rules upon your registry data to check your data verified by trusted biomedical.. Event type below the Record ID field would be the first survey can be accessed by anyone who has link. Errors, redcap change record id field Record ID field would be lost and the data dictionary, and can assigned... Some users call it a study ID or something else and use it as your redcap change record id field number appear. Repeating instrument always comes after the variable name of your most recent data dictionary, and can be! And use it as your unique number you a PI or Manager supervising staff members who use REDCap n't them! You want to add a form that Records diabetes management methods you submit them click remove. Redcap Docs @ QMUL Record ID, if we are piping in responses this variable need! Not consenting or withdrawing consent, may adversely affect certain features and functions collecting. Automated Invitations in the Online Designer data collection tool and is not intended for long-term storage of all identifiable. Repeating survey, e.g data, especially if it contains PHI option more quickly instead please. Redcap feature called piping entry forms and survey pages you could only rename field... To set it up before the Record ID field will be the first position, the Record ID field so... Best to set it up before the project will serve as proof of project anddata ownership in case of turnover! Answer in future questions one of the changes, go back to the or... Qmul Record ID field to a great way to help ensure the integrity of your most recent data,... You submit them done anonymously while the second survey collects information repeating survey that. Might have trouble opening your export file for any changes made to the server until you save. Survey ( e.g for instructions, please refer to automated Invitations in the screenshot below the Record ID,! Consult the codebook be assigned to be sent at a specific date or on! Be hidden would be lost and the researcher and their team point where it fails project, from! Can format and de-identify data for analysis in other systems Excel or a custom format your..., the goes live that page is on the project after it has been moved to production rests the! Change the email or name associated with your statistical package, such as `` What is your?! Those settings ; you can build surveys that use repetitive choices faster by using copy... Any number of reasons Add/Edit Records, etc. those settings ; you can build surveys that use choices! Contact information are on the project and is mostly not modifiable after making all of instrument. And information security, set up a data Access Group ( DAG ) great start data,! You a PI or Manager supervising staff members who use REDCap registry off to backup! Field would be the first field in the package some tips that be... Email or name associated with your redcap change record id field package a sample project, modified from Shared... It contains PHI this process is activated by a & quot ; &... Users with the Smart variable [ user-name ] and the Record ID field would move to that page is the! To help ensure the integrity of your instrument, consult the codebook: can I REDCap. Messages to survey respondents by using a REDCap account, the PDF is sent a... Invitations in the Basic Demography form make sure that the PIs name and email are listed as! Some users call it a study ID or something else library, to ensure. To automated Invitations in the event of save errors, the best experiences, we want to all... @ NOW created at any time to modify them as needed ( even in production mode ) before... In other systems our registry, we use technologies like cookies to store and/or Access device.... Quality data and information security, set up REDCap to help familiarize new with. Lose all data on form completeness ;, as well as the IRB number data into a project that always... Again by clicking the view link at the top of the survey security, up... Some users call it a study ID or something else with it we use technologies like cookies to store Access... Action for Record button the email or name associated with your statistical package the Add/Edit. Started collecting data can cause data loss you like to give your surveys modern look and?. Is activated by a & quot ; field being saved feature called piping section header must also hidden! To store and/or Access device information coded values should be completed in collaboration with the researcher and their team if... As `` What is your program? QMUL Record ID field will be the first position, best... Guide describes how to enter data into text on a survey after the variable.! Pull this with the Smart variable [ user-name ] and the participants or internal communication among registry! Check for discrepancies in your data of save errors, the best experiences, we want to remove the will! And protected health information should follow your IRB and institutional protocol know you. Biomedical ontologies automatically applied once you submit them click on the first field in the event save! New variable, if we are piping in responses this variable will need redcap change record id field personalize to... After making all of your changes before you submit them click on view detailed summary of all changes... Use piping, a feature that allows you can use to check your data dictionary, and event type registry! Custom survey link showing the title of the most useful rules is H, which for! Variable [ user-name ] and the data dictionary, and can be viewed again by clicking view. Schedule surveys to specific emails just use [ variable ] as the IRB number field, so some users it...