Resolve "Allow formulas in data source field filter values"
What is in this MR
This merge request makes it possible to use page_parameter
formulas in "Local Baserow" GetRow
and ListRows
services. The formulas can be added in filters (see filterable fields below) and the search query.
Filterable fields
Not all fields can use a formula, only those which have an getInputComponent
that returns either ViewFilterTypeText
or ViewFilterTypeNumber
.
This makes the filterable field types you can add a page_parameter
on:
- Single text
- Long text
- URL
- File
- Single select
- Multiple select
- Number
- Rating
- Duration
- Phone number
- Formula (assuming the formula results in an integer/string)
- Count
- Rollup
How to test this MR
- Create two data sources, for both
GetRow
andListRows
. - Apply formula filters to the table fields, and/or search query.
- Use the data source on an element, and visit Preview to try out URL parameter permutations.
Merge Request Checklist
-
changelog.md has been updated if required. -
New/updated Premium/Enterprise features are separated correctly in the premium or enterprise folder -
The latest Chrome and Firefox have been used to test any new frontend features -
Documentation has been updated -
Quality Standards are met -
Performance: tables are still fast with 100k+ rows, 100+ field tables -
The redoc API pages have been updated for any REST API changes -
Our custom API docs are updated for changes to endpoints accessed via api tokens -
The UI/UX has been updated following UI Style Guide
Closes #2223 (closed)
Edited by Peter Evans