Force recalculation of formula for clients

1

Hey,

I have booking system for my clients using baserow.
The heart of the system is table v1_klienci ( clients ).
It is connected to v1_booking_sesje ( booking ) , v1_sprzedaz ( sale ).

Based on v1_booking_sesje and v1_sprzedaz I calculate how many specific services are being bought and used by client.

For example:

  1. calculate on how many services client already used up to today:

field: sesje_NK:

count(
filter(
field(‘v1_booking_sesje’),
lookup(‘v1_booking_sesje’, “is_NK”) &&
not(lookup(‘v1_booking_sesje’, “is_FUTURE”)) &&
not(lookup(‘v1_booking_sesje’, “deleted”))
)
)

  1. calculate how many services he bought already:

field: karnety_NK:

sum(lookup(‘v1_sprzedaz’,‘ilosc_NK’))

The problem is that sesje_NK is not updated - i need to update it manually by changing formula ( adding space ) for recalculation.

Clients doesn’t have updated info about their orders and usage of services in real time, but only once per day .

Crazy !

How to fix that ?

2

hey @parhelium

Is the problem happening on baserow.io or self-hosted?

Can you share more what is_FUTURE really is?

Is it possible to share workspace export (structure only is enough) - it could be in private message. That would help finding out what actually happens.

3

hey @Przemek

Self-hosted

Is_FUTURE:
field(‘when’) > now()

TBH, I don’t know how to export workspace without revealing production data. Any hints ?

4

Hey @parhelium, here’s how: Export Baserow workspace data

Just make sure to check Export structure only to export table structures, fields, views, and configurations WITHOUT data rows.