Need to understand Airtable with Bubble

eurllausaro · 2024-11-04T16:40:02.081Z

Bonjour Sarah !

Écoute avec plaisir ! ça sera déjà plus simple de se comprendre

En fait mon soucis c’est que j’ai ma table de data sur bubble, et en fait sur le site j’aimerais que ressortent uniquement les 3 dernière ligne de cette table triées par date de création.

En gros j’ai mes soirées de prévu dans ma table, quand une soirée est passé, je crée une nouvelle ligne pour une futur soirée et celle apparait automatiquement en “effaçant” celle qui est passé.
Tu vois le cheminement un peu ?

Merci beaucoup en tout cas !

pattokane · 2024-11-04T18:21:30.769Z

So if this was done with just bubble you could have a date range and once an evening has passed and you add a new one, the evening that has passed will no longer show. It will start be in the DB but just will not show on your RPG.

This issue you are having is purely because bubble and airtable sort data differently and make it hard to talk to each other… this issue is greatly extenuated when it comes to reading large DB’s from airtable.

For example…

We had a platform that I was working on and everything was fine through testing, platform and speed were running decently and we handed it over to the client. The client started uploading data into two different tables and as they did that (table only had about 50-100 entries) the load times of pages and RPG’s was greatly affected.

We spent days trying to fix the speed and performance but unfortunately we just had to bit the bullet and change to bubble. Once in the bubble DB, all issues were gone and everything was much easier to work with.

Airtable is great for what it is, a place to sort huge DB’s for cheap but when it comes to working with the data and doing it quickly, it falls apart.

If you are looking for an external DB then I would recommend looking at Xano

Xano

The Scalable No-Code Backend: Xano

The fastest way to build a powerful, scalable backend for your app without code. Xano is the trusted Backend for over 50,000 SMB and Enterprise applications.

Est. reading time: 6 minutes

But I would recommend sticking with the bubble DB over everything else first

jagdish_bajaj · 2024-11-04T18:54:05.613Z

I have more than one client using Airtable and Bubble. This is such a pain since there is never one single source of truth and we are constantly battling data.

I would strongly recommend that you store all data on one platform. It will take some time to learn how to do things in Bubble, but the investment is well worth it.

eurllausaro · 2024-11-05T08:14:56.552Z

So if this was done with just bubble you could have a date range and once an evening has passed and you add a new one, the evening that has passed will no longer show. It will start be in the DB but just will not show on your RPG.

How do you do that ? I’m now using only bubble, I recreated the table that I had in airtable, and (even if I still need to accommodate a bit) it works great. Well I’m at the same level than before. But for now item#1,2,3 are related to Row#1,2,3. That’s a step for me

Now how could I tell in the data source field that I want :
The first group/Block related to the 3rd last row in the data base
The second group related to the 2nd last row
And the third group to the last row ?

I’ve been trying to understand the data link in the data source field but for now it’s too complex for me.

Thanks !

pattokane · 2024-11-05T18:03:17.288Z

Are your rows always one day per row? @eurllausaro

eurllausaro · 2024-11-06T08:09:09.724Z

Yes, one row represent one event to show.

Capture d’écran 2024-11-06 à 09.00.442512×488 91 KB

And would love to be showing in this order

The first group/Block related to the 3rd last row in the data base
The second group related to the 2nd last row
And the third group to the last row ?

in those blocks

Capture d’écran 2024-11-06 à 09.03.122152×1092 184 KB

Do you think it’s possible ?

pattokane · 2024-11-06T08:44:30.701Z

Yes, if each row has a date to it and only one event per day is showing then this should work…

In the RPG do a search for events that the event date or creation date (however you have them set up) is greater than current time/date +days-3

This should work.

If you cant figure it out, i will set up a demo for you when i get up in the morning

eurllausaro · 2024-11-06T10:20:21.616Z

I see where you’re going, but I think i’ve explained badly. My fault

Capture d’écran 2024-11-06 à 10.51.382510×524 106 KB

My data looks like this. And I have an event per row, but it’s not update every day, maybe every week or 2 weeks it depends. My goal with these data is to be shown and order by “created date” and only show the 3 last created.

So for this exemple just showing row# 2,3 and 4, in this order

Capture d’écran 2024-11-06 à 11.02.062150×1096 192 KB

And then, when I add a new event when the event #2 will be over, the new row of the event #5 will replace (in the front end) #4 in the third block, event #4 will replace #3 in the second block and #3 will replace #2 in the fisrt block. And so on, as I add row in the datasheet.

Hope it’s clearer now

I was thinking of something like that (purely invented but for demo purpose )
For the first block (#2 event in the exemple) in the RPG : search for soirée (name of my data table) last row -2
For the second block : search for soirée last row - 1
For the third block : search for soirée last row

or
search for soirée creation date : last (and last -1, last - 2)

But I keep trying I can’t find the right path for that

jagdish_bajaj · 2024-11-06T15:36:39.444Z

When you search for the data, there is an additional operator “items until#”. I think that should do the job for you. If you set this up to 3, and sort by created date, users will always see the latest 3 events.

So, in the repeating group, expand on the “Do a search for” by clicking on the “more” text and look for “items until”.

eurllausaro · 2024-11-06T16:33:24.563Z

Thanks for helping !

Actually I don’t have repeating group set up, I have each bloc in a independent group, so each group need to target a specific row.

I’ve tried with repeating group (for knowledge purpose haha) and it shows the 3 last rows but in the wrong order, like the order I would like is 2 - 3 - 4 and instead of that it shows 4 - 3 - 2.

Anyways, I don’t use repeating group because I can’t figure out how to have absolutely the same layout parameters than a normal group. Especially on mobile view where repeating group overlap on each other…

jagdish_bajaj · 2024-11-06T22:55:27.623Z

I would suggest using a Repeating Group. You can easily change the order of the items to the right one. Also you can include a group inside the Repeating Group (or even move the one you’ve created already into the RG) and control the layout parameters at the Group level. Also I am quite sure that you can address the issues on mobile view as well.

All I am saying is that the other issues you are facing can be resolved, but fundamentally a Repeating Group is the right element for doing what you want.

pattokane · 2024-11-07T02:02:46.731Z

I would also highly recommend a RPG as they are much easier to work with and filter data the way you want

georgecollier · 2024-11-07T07:22:13.367Z

pattokane:

I would also highly recommend a RPG

That sounds dangerous!

pattokane · 2024-11-07T07:33:39.885Z

Dangerous? I am not following lol i might be missing it

pattokane · 2024-11-07T07:34:05.504Z

Oh hang on lol just got it

eurllausaro · 2024-11-07T08:33:46.721Z

I’m testing it, and yes it is dangerous !

My trouble with RPG is this one, mobile screen size will f*ck all up (like real RPG haha)

non RPG :

Capture d’écran 2024-11-07 à 09.28.31844×1530 94.1 KB

RPG :

Capture d’écran 2024-11-07 à 09.28.21834×1578 199 KB

That’s why I begin with RPG then, when I saw that mess, I came back on stuff I thought I now better but still stuck anyway

georgecollier · 2024-11-07T08:42:28.030Z

Set the minimum column width to 280px on the repeating group appearance settings

eurllausaro · 2024-11-07T08:55:46.562Z

I’ve tried, even higher value, but no change

eurllausaro · 2024-11-07T09:14:16.072Z

Little Update !

The sorting thing that i’ve tried to do, works with RPG
Thanks to all for that.
I’m not sure that I’ve done it the optimal way, but it works !
So :

Capture d’écran 2024-11-07 à 09.57.101306×470 43.5 KB

I’ve added a column “DateBubble” to add the date of the event in a format that bubble can read easily.

Then after fishing the solution out, I’ve come with that for the parameters

Capture d’écran 2024-11-07 à 09.57.251530×992 103 KB

So actually a bit different than the beginning of the post, here rather than trying to show the last 3 rows created, it shows the 3 first event after the today date, so when a event is over, it automatically shows the 3 next (as i’m typing it I’m realizing that it’s even better than my first idea)

So i think this would work just great !

NOW Let’s deal with this RPG thing that drove me crazy

My thought on it is that it can’t success to put the group inside the RPG on top on each other when the screen is too narrow, maybe it’s due to the row parameter of the RPG ? and at a certain screen width need to switch to column parameter ?
But I definitely don’t believe that nobody as this issue before and that is it actually an issue. Due to the number of app created each day with bubble the RPG should be responsive…
I must mess somewhere…

EDIT
There is something else that I don’t understand, why in the RPG my event description is not fully shown ??

Capture d’écran 2024-11-07 à 10.22.32668×1468 112 KB

eurllausaro · 2024-11-08T08:34:50.608Z

Little bit of an update, kind of

I found this post about RPG overlapping and follow the solution
https://forum.bubble.io/t/repeatinggroup-has-overlapping-elements/247505/2?u=eurllausaro

But it didn’t work well, my groups now disappear when resizing… Then I can’t find a way to make the group expand to show the full description…

Still searching