Ask(condition)

Ask the user for input for the parameter and evaluate the condition. This function is used in conjunction with the Parameter function.

Parameters

condition

The conditional expression with one or several parameters to prompt the user.

Returns

Boolean

Remarks

The Ask function calculates the condition only if all parameter values are supplied by the user. Otherwise, it evaluates to true, allowing all records to be returned when the condition is omitted. You can use several Ask functions within a single formula to create the filtering logic you need. This function works only in filter formulas and is used for the Ask the User option.

Examples

• Ask([State]=[?State]) - This formula requires the user to input a State value, which will then be used as a filter condition.
• Ask(Between([Date], Parameter([Date], "Date (from)", Date), Parameter([Date], "Date (to)", Date))) - This formula requires the user to input From and To date values, which will then be used as a filter condition to check the Date column.