Docs: SpeedGen: Field Marker Reference

Guidelines

Field Markers can be inserted into any cell in the Source Workbook
Field Markers are not case-sensitive.
>> is used in the Examples but you can also use [%Field] instead.
You can format Field Markers by formatting the cell in the Source Workbook or using the Dynamic Formatting methods

RecordSource Field Markers

All RecordSource Field Markers must be in the following format: >>rs^Field

The rs^ is optional. This is a RecordSource reference. If no RecordSource is specified, then the RecordSource is assumed to be 1 (the first RecordSource). rs can be a RecordSource Number or the name of a RecordSource. Field can be a Field Name or Index (position of the Field in the RecordSource)

Examples

>>TotalSales means Insert the data of the "TotalSales" field of the 1st RecordSource into this cell.
>>3 means Insert the data for the 3rd field of RecordSource 1 into this cell.

>>2^TotalSales means Insert the data of the "TotalSales" field of RecordSource 2 into this cell.
>>2^3 means Insert the data for the 3rd field of RecordSource 2 into this cell.

>>SalesReport^TotalSales means Insert the data of the "TotalSales" field of the "SalesReport" RecordSource into this cell.
>>SalesReport^3 means Insert the data for the 3rd field of the "SalesReport" RecordSource into this cell.

>>3^Sales#across means Insert the data for the "Sales" field of RecordSource 3 across the spreadsheet, from left to right. See #across

Fieldname Markers

All Fieldname Markers must be in the following format: >>$rs_number^field_number

Unlike RecordSource Field Markers, the rs_number^ is not optional. This number is a RecordSource reference.

Example

>>$1^3 means Insert the name of the 3rd field of the 1st RecordSource into this cell.

Variable Field Markers

All Variable Field Markers are prefixed with >>$

>>$AmountDue means Insert the value of the AmountDue variable into this cell ( if the "AmountDue" variable was defined with the AddVariable method )
>>$Customers means Insert the contents of the 1D Customers Array into this cell ( if the "Customers" array was defined with the AddArray method ) ( for 2D Arrays use RecordSource Field Markers )

Standard Field Markers

>>$ItemNumber means Insert the Number of the current RecordSource Row into this cell. This only works when placed on a Field Marker Row
>>$now means Insert the Current Date & Time into this cell.
>>$tomorrow means Insert Tomorrow's Date into this cell.
>>$yesterday means Insert Yesterday's Date into this cell.
>>$nextweekday means Insert the Next Weekday into this cell. ( skips over weekends but is not "holiday-aware" )
>>$lastday means Insert the Last Day of the Current Month into this cell.
>>$firstday means Insert the First Day of the Current Month into this cell.
>>$nextmonth means Insert the First Day of the Next Month into this cell.
>>$prevmonth means Insert the Last Day of the Previous Month into this cell.
>>$nextyear means Insert the First Day of the Next Year into this cell.
>>$prevyear means Insert the First Day of the Previous Year into this cell.

Note: You can format the cell to the degree of precision you need. e.g. $nextmonth inserts the First Day of the Next Month but you can format it to only display the Month value.

Aliases

You can use Field Marker Aliases to isolate the Source Workbook from the structure of the underlying data.

>>TheTotalSales means Insert the data of the Field Marker represented by "TheTotalSales" alias into this cell ( if "TheTotalSales" was defined with the Alias method )