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:
- 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”))
)
)
- 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 ?