emptyfill
emptyfill
VALUE

The emptyfill statement fills every empty visible cell in the active field with the specified value.

Parameters

This statement has one parameter:

value – the value you wish to put into the empty cells of the current field. The resulting value must match the type and format (if any) of the field you are placing it in.

Description

This statement fills every empty visible cell in the active field with the specified value. Non-empty cells will not be touched.

This example fills all the empty selected cells in the active field with the text string `n/a` . Therefore, the active field should be a text or choice type field.

    emptyfill "n/a"

This example uses a formula to fill the empty cells in the field Date to Renew with a date that is one year beyond the current date. The final date will be the 1st of the month.

    field  «Date to Renew»
    emptyfill month1st(today() + 365)

The emptyfill statement fills every non-empty cell with a specified value. If you want cells in different records to have different values, use the formulafill statement, like this:

    formulafill ?(sizeof(info("fieldname"))>0,«»,SOME FORMULA HERE)

See Also

- change -- replaces text with new text in the current field (selected records only).
- changeword -- replaces one word with another in the current field (selected records only).
- changewordexact -- replaces one word with another in the current field (selected records only).
- fill -- fills every visible cell in the active field with the specified value.
- fillall -- modifies the operation of the following *fill* statement so that all records are modified, not just visible records.
- formulafill -- fills every visible cell in the active field with the result of the specified formula.
- formulafillallfields -- fills every visible cell in all fields with the result of the specified formula.
- outlinelevel -- expands or collapses the entire database to show a specific level of data or summary level.
- propagate -- fills all the empty cells in the current field. Each empty cell is filled with the value of the first non-empty cell above it.
- propagateup -- fills all the empty cells in the current field. Each empty cell is filled with the value of the first non-empty cell below it.
- resetallrecordidts -- resets the internal record id and time stamps for every record in the current database.
- runmodifyfill -- runs the .ModifyFill procedure (if it exists).
- runningdifference -- calculates the running difference for the current field.
- runningtotal -- calculates the running total for the current field.
- sequence -- fills every visible cell in the current field with a numeric sequence.
- slidedata -- slides the columns at and to the right of the current column.
- speedcopy -- copies multiple adjacent fields from a record in one database to a record in another.
- summarylevel -- changes the summary level of the current line.
- unpropagate -- removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the first (top) value.
- unpropagateup -- removes repeating data from the currently selected field. If several records in a row contain the same data, this statement erases all but the last (bottom) value.

History

Version | Status | Notes
10.0 | Updated | Carried over from Panorama 6.0, but no longer supports the DIALOG parameter.