(j) Custom Formulas

Custom formulas provide a more flexible interface to let users build their own formulas. Users can use:

• Column references
• Any of our pre-created formulas
• Logical operators (and, or , not)
• Mathematical operators (+, -, *, /, %, !, ^, etc.)
• Comparison operators (>, <, >=, <=, =, !=)

Interface Requirements

We should provide a textual interface for users to enter custom formulas. This should support:

• Autocomplete for column references based on the available columns.
• Autocomplete for our pre-created formulas.
  • Once the user has started entering a formula, we should support autocomplete or dropdowns for formula options.
  • For freeform inputs, we should show placeholders.
• Some sort of help or autocomplete for operators.