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… :
@mdykstra Marc I see your logic, although far sought , 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.
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.
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.
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.
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.
, but alas you cannot put -2 in the input field for the condition (not in the card component), only 0 or positive.
