REDCap

The code block below illustrates how one might use # and // as comments in your logic and calculations.

# Text can be put here to explain what the logic/calculation does and why.
if ([field1] = '1' and [field2] > 7,

	// This comment can explain what the next line does.
	[score] * [factor],

	// Return '0' if the condition is False.
	0
)

Working …

This value you provided is not a number. Please try again.

This value you provided is not an integer. Please try again.

The value entered is not a valid Vanderbilt Medical Record Number (i.e. 4- to 9-digit number, excluding leading zeros). Please try again.

The value you provided must be within the suggested range

The value you provided is outside the suggested range

This value is admissible, but you may wish to double check it.

The value entered must be a time value in the following format HH:MM within the range 00:00-23:59 (e.g., 04:32 or 23:19).

This field must be a 5 or 9 digit U.S. ZIP Code (like 94043). Please re-enter it now.

This field must be a 10 digit North American phone number (like 415 555 1212). Please re-enter it now.

This field must be a valid email address (like joe@user.com). Please re-enter it now.

The value you provided could not be validated because it does not follow the expected format. Please try again.

Required format:

Database Query Tool

This page allows administrators to directly query REDCap's MySQL/MariaDB database. You may enter an SQL query into the text box below to execute it. Since only read-only queries are supported (i.e., show, select, explain), this tool is not able to modify database tables in any way. You may also save custom queries on the left via a popup dialog. Saving a custom query allows you to easily run the query at any time by simply clicking a link on this page's left-hand menu.

NOTICE: This tool is currently DISABLED and cannot be used until someone with special privileges enables it. Because the page allows you to view data directly from the back-end MySQL/MariaDB database, this tool can only be enabled by someone with direct database access, in which they must execute the query below in the MySQL/MariaDB database where the REDCap tables are stored. Once the query has been run, reload this page.

UPDATE redcap_config SET value = '1' WHERE field_name = 'database_query_tool_enabled';

Notifications

System Notifications

General Notifications

Conversations

Create new conversation