Howto: Data from last month through a condition

Hi all there.
I have a table with amongst others a field, which is a date.

In the left card I would like to show the number of records in the current month. in the right card I would like to show the number of records in the previous month.

So the condition for the current month (in this case July) is:

  • “created on” is during the current month

and that works fine.

For the previous month (in this case June) I used:

  • “created on” is during the previous 1 month.

And that is not working, as I get the number of records in both previous month (june) and the current month (July) returned.

A workaround is to hard-code the dates for June, but that would mean changing the coding every 1st of the month: I would like it to be dynamic for sure.

I think I might misunderstand “is during the previous x month”, but then my question:
How do I get all the records created on a date in the month of June (= the previous month)

its a tricky one isnt it? I tried adding a new equation field to simply hold the month number of year using MONTH([datefield]) which does return 6 for June and 7 for July. But got still got stuck after that… ::slight_smile:

I use the following from TB support.

Date is before the previous 0 months
AND
Date is after the next -2 months

@mdykstra Marc I see your logic, although far sought :smiley: , but alas you cannot put -2 in the input field for the condition (not in the card component), only 0 or positive.

So still stuck in getting data from the previous month.

PS - I tried this also in the data builder and there -2 works.

I see that now. TB must have changed this. Maybe @moe or @tim.young can chime in here as it was allowed previously. I have a card that is still working with those parameters.


Screenshot 2024-07-25 at 6.19.00 AM

1 Like

Hi Peter,

The solution from @mdykstra does work, screenshot of result is shown below. Copy -2 from notepad and paste it into Card condition to get around that restriction you mentioned.

Nice one Marc ! thanks

Thanks and yes that does work. but not with Ctrl-C and Ctrl-V.
Use the right-click of your mouse to copy-paste.

I think I must agree with a lot this person says about UI/UX…

By the way: Tim Young left Tadabase

That is bad news, Tim was very helpful.
Do you know if Chem is still around?

We certainly have more work to do with UI/UX, and it has been a recent focus, as you can see from our latest login/layouts. We have amazing new updates coming for other aspects like components. The focus hasn’t been as strong on the builder since most of our users care more about the output for their users vs how they build it.

This review is personally painful to watch but still accurate. It feels like watching a review on a high-performance sports car that only talks about the cup holders. While it’s important, it misses out on the incredible engine, the top-notch handling, and the overall driving experience that sets it apart. I read a great article by you (thank you btw!!!) that felt much more accurate.

The good part though is UI/UX is easy when compared to building a platform that can scale to hundreds of million of record updates every minute.

1 Like

Indeed. Huge loss for Tadabase.

We started as an in-person and since Covid went semi-remote. I’m beyond excited about our growing in person team out of Miami Florida. You can’t build an incredible company with a remote team.

Chem works with our Enterprise customers.

Yes, I agree, a lot of the great things of Tadabase is not in the review. Personally I made a comment there that he looked at the wrong thing.

But it was a first impression, and there are many more people who have a first impression, which probably are alike. You have only one chance to make a first impression.

And see above: UX-wise - I don’t think I would have reached the conclusion myself, I should put minus numbers, through a copy-paste action with a Notepad as intermediary.

So yes, UX-wise, much must be done. Please, take it as a motivation to improve.

@moe one of the apps shared by Tim has stopped working. He put a copy of the shared app into my apps list which i edited and the app was working for a while but now has stopped working properly. I noticed he made further updates to the original shared app currently sitting in the ‘shared’ apps folder which seems to be working fine but i dont know how to take a copy of this latest version. Please can you put a copy in my app list folder so i can redo my edits and have another go at getting up running. link to tims shared app https://timyoung.tadabase.io/orgchart#!/demo-for-dan.

ideally if you could integrate it with app named ISO 31000 that would be appreciated because I am trying to explore the idea of displaying Users as an org chart for use within admin panel. Also please confirm if there is likely to be any issues in the future, for example what happens if the balkan licensing expires? many thanks in advance.