showfieldsbetween
showfieldsbetween
FROM
,
TO

The showfieldsbetween statement hides all fields except those in between specified numbers.

Parameters

This statement has two parameters:

from – First field to show. This can be a number (from 1 to max number of fields), or a field name.

to – Last field to show. This can be a number (from 1 to max number of fields), or a field name. The specified field must be to the right of the field specified by the from parameter.

Description

This statement shows only fields between specified columns, all others are hidden. For example, this statement shows only the first ten fields.

    showfieldsbetween 1,10

This example shows only the last ten fields.

    showfieldsbetween info("fieldcount")-10,info("fieldcount")

Either the starting or ending field can also be specified by name, like this:

    showfieldsbetween "Name","Country"

See Also

- hiddenfields( -- returns a list of hidden fields in the curent data sheet window
- hidecurrentfield -- hides the current field in the data sheet.
- hidefieldsbetween -- shows all fields except those in between specified numbers.
- hidelineitemfields -- hides all line item fields.
- hidethesefields -- hides specific fields in the data sheet, making all others visible.
- info("hiddenfields") -- returns a carriage return delimited list of fields that are currently hidden in the current data sheet.
- info("visiblefields") -- returns a carriage return delimited list of fields that are currently visible in the current data sheet.
- showallfields -- makes every field in the data sheet visible.
- showthesefields -- makes specific fields in the data sheet visible, hiding all others.

History

Version | Status | Notes
10.0 | New | New in this version.