(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 (
- Mathematical operators (
- Comparison operators (
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.