Displaying Parameters

You can insert parameters into your DataPages to dynamically display information directly from your tables.  Parameters can be inserted in headers and footers, HTML blocks, labels, automatic emails, and confirmation messages.

Enable advanced options and parameters

Be sure to enable parameters on every DataPage where they will be used.

Methods to add parameters:

The Insert button

The fastest way to gain access data from your current record is to use the Insert button to add parameters.  This Insert button appears at the bottom right corner of formatting blocks such as headers and footers and HTML blocks.  On the last page of the DataPage wizard you can use the insert button to insert parameters into your confirmation message.  The Insert button will be located at the upper right corner of the confirmation message entry panel.  The Insert button will add a parameter ([@xxxxx] – where xxxxx is replaced with your fieldname and any formatting indicators).  This parameter will be replaced dynamically with data from your table.

Parameters from the Insert button can be used to customize the message displayed after a submission:

The Insert button has two dropdowns.  The first allows you to select the parameter fieldname, and the second allows you to choose the format.   Depending on your field's data type, multiple format options may be available.

Parameter formats (Examples are based on United States English localization):

Format	Explanation	Example
String	Shows info in text format	5
Number	Includes at least two decimal places	5.00
Percentage	Shows two decimal places, 1 = 100%	500.00%
Currency	Includes a dollar sign and two decimal places	$5.00
Short date	Day, month and year separated by slashes	2/24/2010
Long date	Full, spelled out date	Thursday, February 04, 2010
Time	Hour, minutes, seconds and am/pm marker	8:28:05 PM

Parameter data will be formatted automatically based on your DataPage’s localization settings.  Localizations can be changed at any time without updating the parameter syntax.

Custom parameters

You can write parameters directly when the Insert button is unavailable or you are trying to reference data that isn’t included in the current record.

Reference a field in the current record

To reference a field that is in the current record you can use the following syntax.  Parameters must still be enabled for this parameters to function.  Notice that the field prefix and the fieldname are separated by a colon:

example: [@field:Sent_By]

Reference a recently edited field

In Search and Report DataPages you can use parameters to reference data from the most recently edited record.  The referenced data cannot be contained in a display only field.  Parameters that reference a recently edited field are constructed using this syntax:

Inserting authenticated data

Parameters in authenticated DataPages can pull user profile data directly from the authentication table.

Parameters that collect data from the authentication table are constructed as shown in this graphic.  Remember, this type of parameter separates authfield prefix from the fieldname using a colon:

example: [@authfield:First_Name]

Formatting your parameters

By default, parameters appear as text (string format).  You can change the format of a parameter by adding a symbol between the fieldname and the closing bracket.  You can modify these formats through the Localization wizard.  In the Example column below you can see the standard United States English localization.

Format	Symbol	Output	Email Body Syntax	Report Syntax
String	(Nothing)	5	[@InsertRecordFIELDNAME]	[@field:FIELDNAME]
Number	#	5.00	[@InsertRecordFIELDNAME#]	[@field:FIELDNAME#]
Percentage	%	500.00%	[@InsertRecordFIELDNAME%]	[@field:FIELDNAME%]
Currency	$	$5.00	[@InsertRecordFIELDNAME$]	[@field:FIELDNAME$]
Short date	*	2/24/2010	[@InsertRecordFIELDNAME*]	[@field:FIELDNAME*]
Long date	~	Thursday, February 04, 2010	[@InsertRecordFIELDNAME~]	[@field:FIELDNAME~]
Time	@	8:28:05 PM	[@InsertRecordFIELDNAME@]	[@field:FIELDNAME@]

Summary

Parameters are a versatile tool for customizing your DataPages.  You can write your own parameters or add parameters using the Insert button.  You can pull data from the DataPage’s base table or from an authenticated DataPage’s authentication table.