Skip to content

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
  • Email
  • 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 and ListRows.
  • 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

Merge request reports