LookUp with conditions

Feature Ideas
3

@moonday For now you can use the filter formula function to achieve the same effect. For example you could create a formula field with the formula:

filter(
  lookup('Assets in Room', 'Price'), 
  or(
      totext(lookup('Assets in Room', 'Asset Type')) = "Chair", 
      totext(lookup('Assets in Room', 'Asset Type')) = "Desk")
)

Its more complex unfortunately than the filter builder method suggested which we do want to add, but hopefully helps for now. I also invited you to a Baserow workspace I made showing the above formula in action.

One advantage of the formula way is you can then aggregate the results like so:

sum(filter(
  lookup('Assets in Room', 'Price'), 
  or(
      totext(lookup('Assets in Room', 'Asset Type')) = "Chair", 
      totext(lookup('Assets in Room', 'Asset Type')) = "Desk")
))
3 Likes