redcap change record id fieldredcap change record id field

Dr Duncan George Psychiatrist, Articles R

[record . It provides a means for hiding or displaying entire forms/surveys based upon one or more control fields or conditions. You can schedule to send your online survey on a specific date or based on certain conditions being met. This allows you to send specific surveys to different email address instead of designating only one email field for the whole project. 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. records in your project). Using this feature you can supplement your survey with video to enhance the experience for your participants. Surveys can be enabled at any time in development mode. First, make multiple question fields with the same label but different responses. You can use piping to allow subject-specific options in a multiple choice or dropdown field. 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. You can build the surveys that use repetitive choices faster by using the copy existing choices option. You can also add custom rules in the module to track data population for specific fields. Remember REDCap automatically assigns a unique record identifier when you create a new record. So the later instruments can only ever be distributed via Participant List. In this example, we piped [first_name] [last_name] into the survey instructions. 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. REDCap includes tools to communicate securely and safely with participants, members of the research team, and other collaborators. This process is activated by a trigger field being saved. To set it up, access Survey Settings and personalize the Survey Completed message by using piping. The record status dashboard (a feature that allows you to get a quick, high-level overview of the current state of data entry in your records) can be customized. Unverified Denotes that data has been entered, but not validated, verified, or checked. 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. Select Online Designer on the Project Setup page. 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. and for multiple-choice questions, the label for the answer choice such as "Osteopathic Medicine," "Psychology", etc. The content is solely the responsibility of the authors and does not necessarily represent the official views of the NIH. 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. Download a smaller export. Therefore, once those options are selected, other options appear, as illustrated in Figure 11. Typically, researchers divide forms by some domain, such as Demographics and Labs, or by work tasks like Clinic Intake and Contact Follow-Up. 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. Create a new Text Box field or Notes Box field and in the Action Tag field insert the Action Tag as. REDCap can create this Record ID for you or you can create it manually. REDCap supports of variety of data validation and quality assurance features (see Data Collection Tool Design for guidance on using such features). Each of these records is distinct, with its own forms that store data. ), 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.) Want a question to only appear the first time someone takes a repeating survey? ', in which the coded values should be inside single or double quotes for the choice(s) you wish to hide. The record_id field links together all the records in your study. Did you know you can easily compare and contrast information between two records in REDCap in real time? Making changes to your project once youve started collecting data can cause data loss. [record-dag-label] Harvard Site . Covers how to create a new project, how to add or edit data fields, field types available and branching logic and piping. In this section, we will use a sample registry with fictitious data to highlight some of the benefits of using REDCap for your registry. Read the guide nedCAPTCHA 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. 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. Interested in modifying the appearance of surveys, or making them information-only? Click on the form(s) that need changes made and make the changes just as you would while in Development mode. However, the Global Access User can add the. Surveys can be accessed using a web link and included in email, or a registry web site for data collection. Only that survey can have a public link. The technical storage or access that is used exclusively for statistical purposes. This website was supported by the National Center for Advancing Translational Sciences, National Institutes of health, Award Number UL1TR002544. f) To disable the "Create New Record" button, disable the sponsoring REDCap user's Create Record rights in REDCap. 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. Tufts CTSI's network comprises nearly 40 medical, academic, industry, & community partners and collaborators. Here are some steps to help you troubleshoot. REDCap supports embedded audio and video, with several different options for video under the Descriptive field type, as well as full support for the HTML tag in any field type, which allows you to play a recording with a question. Piping allows you to use the value of any form in that record in a field or value of another form. You can now use the Auto-complete for Drop-down Fields feature which transforms a drop-down into a combo-box that functions as a normal drop-down list, but has the additional capability of employing a text search on the options in the drop-down. REDCap supports the use of HTML tags to format text in question labels and response lists. when a participant is reporting multiple things of the same type. This way, you can test all new branching logic or calculated fields without affecting the Production Project. Don't delete questions or answer choices, or change variable names (see below for more info), 3. 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. To have a variable appear as its previous value automatically, you can set the Field Annotation to @DEFAULT=[x][previous-instance] for the variable x. General Tips User-Friendly Survey Buttons: Often times, it can be unnecessarily cumbersome for participants to answer radio or checkbox questions where the buttons appear too small on their screen or is too difficult to click on mobile phones. They can even be printed out and abstracted into REDCap later. However, you do choose to make the record ID field the identifier, you can hash it so that the record ID is an unrecognizable value. Please sign up for the drop-in session [link] to get this or other external modules activated. REDCap is a secure web application for building and managing online databases and surveys. This tip was based on an idea by Luke Stevens of the Murdoch Childrens Research Institute in Melbourne, Australia.The HTML is:
.
. Are you conducting a project that will need a different public survey for different types of participants. For example, we can quickly plot out all Blood Glucose levels for all participants. Having a progress bar on survey pages can help boost survey response rate. Often, when dealing with repeating instruments, key values will stay the same each time the form or survey is filled out. Ever wish you had an easier way to make a selection out of a long list of choices? For our registry, we want to add a form that records diabetes management methods. (A link to that page is on the Project Setup tab, in a lower step on the page.) (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.). Labels give the full question such as "What is your program?" The instance of a repeating instrument always comes after the variable name. In the Main Project Settings step at the top, find the button to enable surveys in the project. 'ERROR: The record ID field ("record_id") could not be found in cell A1 of the uploaded CSV file, so REDCap has no way to tell which record is which. Interested in using REDCap to create a remote, paper-free consent process for your study? These include font size, font color, and spacing/indentation of field label text. REDCap now has the Survey UI Tweaks external module available for use: Features include Renaming Buttons, Randomizing Matrix Questions, and Measuring Survey Duration. 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). ), 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). Because of this limitation, you may want to consider copying your project and using the copied version instead. The variable name for REDCap's optional Participant Identifier is [redcap_survey_identifier], and it does not capture imported data when using the data import tool, nor can the data inputted be pulled into a form/survey field. It functions similarly to @CHARLIMIT but limits the number of words rather than characters. Adding the following HTML tags to a full orpart of a field label will convert it to a link:. REDCap makes reporting and analyzing records easy with built in tools. Okay, you have collected quality data and ready to do something else with it. 2. 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? In REDCap Field Notation, variable names always point to data fields in the project. The first field in REDCap is called record_id, you could only rename this field and use it as your unique number. 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. The, Worried about making a significant change to your instruments? The format must follow the pattern @HIDECHOICE='?? At times, these multiple projects can have data elements that overlap. External Module Spotlight Form Field Tooltip: Do you want to keep your survey clean and user friendly but want to include additional information or instructions for your participants without overwhelming them? 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. The record_idfield links together all the records in your study. 6. Once you complete step two, you will be prompted to define some additional features of your survey instrument. After a project has been moved to production and data has begun to be gathered, any change to the survey can affect the data that has already been gathered, rendering it useless. 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'. 1. 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. Do not post links online unless you want people from around the world to fill out your survey! 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. You can use these options to hide calculated fields in surveys while still using the value for piping or branching logic. However, another type of entity exists called 'Smart Variables' that allow you to reference information other than data fields. From the drop-down select Assign to Data Access Group and select the appropriate group. REDCaps E-Consent functionality, available under Survey Settings,allows you to mark a survey as being a consent form. 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 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. If the project is using DAGs (Data Entry Groups), having auto-numbering enabled will automatically have its record name prepended with the Group ID (DAG ID) number and a dash/hyphen. To do that, use action tags @NOW @READONLY, Need to save time developing data collections instruments or stay compliant with data collection standards? The Orca Search REDCap External Module is an alternative to the built-in Add/Edit Records. Create a new report having only a subset of the data you want. In addition to forms, there are several functions of REDCap to help you get your research registry off to a great start. 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. Additionally, LDEW can be configured to automatically lock forms upon completion for certain user roles. 7) Sending Data (otherwise known as Uploading or Syncing Data) Looking to track changes in your REDCap data and investigate potential data issues? If you need to edit the "Label" of any answer choices during data collection, be sure that the Label stays associated with the same Code -- so, if the answer choice "Chips" had the code value of "1" when you started the project, it should keep the code value of 1 throughout the project. In the Main Project Settings step at the top, find the button to enable surveys in the project. 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. 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. After making all of the changes, go back to the Online Designer page and click on Submit Changes for Review. In Figure 13, you will see that the survey addresses Sophia SMITH in the survey instructions. 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. Repeating fields work best if you know exactly how many iterations of a field you will have and that it will not change. REDCap can create this Record ID for you or you can create it manually. Once you begin data collection, moving your project to Productionensures youre maintaining data accuracy and integrity. This guide describes all of the features found in the Optional Modules and Customizations header under the Project Setup page, such as repeatable instruments and events, auto-numbering for records, the randomization module, designating an email field to use for survey invitations and setting a custom record label. Double-check the dataset to see if that is interfering with the reading of the file. To hide a section header, all fields until the next section header must also be hidden. Running a collaborative project? Want to present different users with different options for a question, but still use a single variable for analysis? 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). Once this module is enabled for your project you can use this feature anywhere in your project! Smart Variable Spotlight [survey-duration:instrument:units]:Do you want to know how much time it took for a user to complete a survey? The units portion can be set to one of the following: y representing years, M for months, d for days, h for hours, m for minutes and s for seconds. Inside of the descriptive field label add the smart variable with the proper data. You can then compare [x][current-instance] and [x][previous-instance] to see if there has been a change. REDCap is compatible with (and can be used on) desktop computers, laptops, tablets (including iPads), smart phones (both Android and Apple), and any other device having an internet connection. A boolean that specifies whether to export the survey identifier field (e.g., 'redcap_survey_identifier') or survey timestamp fields (e.g., instrument+'_timestamp'). You can request to activate a Double Data Entry featurebefore you begin your data collection. 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. 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. REDCap supports integration with electronic health records and other data repositories using Dynamic Data Pull and custom APIs. To ensure data and information security, set up a Data Access Group (DAG). But if any other instrument were moved to the first position, the Record ID Field would move to that instrument instead automatically. This QR Code is clickable as well! The value for Other may now appear in the middle of your answer choice list, but its better than losing all your Other data! export_survey_fields. You can do this using the branching logic with smart variables such as [event-name]<>[event_1]. Did you know you can track discrepancies in your data via the Data Quality Module? A simple question set will be used to determine which methods a participant uses. 5. Action Tag Spotlight @FIELD-NOTES-DISPLAY: This action tag allows for additional customization of the Field Note box within the field editor of a REDCap project. This guide describes how to set up and use the Randomization Module within REDCap. This permits for easier participant tracking, workflow processes, and error identification. For example, you can make a field automatically capture todays date and make that same field read-only so that your survey participants cant change that value. REDCap uses data collection instruments called forms as containers to structure data; each item on a form is a field. By default, this cannot be duplicated. Click the Action Tags icon to see the full list of Action Tags options and their descriptions. 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). Please see the attachment below for more information on other Action Tags. How to use REDCap for collecting clinical data. One of the most useful rules is H, which looks for incorrect values in calculated fields. The field will stay hidden regardless of the branching logic rules. 8. The REDCap Mobile App adds a new dimension to the softwares versatility by providing users with a tool for offline data collection when an internet connection is not available. This REDCap external module functions as branching/skip logic for entire REDCap forms and surveys. We recommend that you use PCOM colors for your HTML coding. 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. Under the 'Data Collection' menu on the left , select 'Record Status Dashboard ' 4. 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]). 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. This helps supports consistent data entry. 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. External Module Spotlight QR Code Shortcut: QR Codes are simple and effective methods to provide additional means for participants to access information and allow them to use their smartphones scanning capabilities to easily visit the study website.

redcap change record id field