The repeating groups are not displaying the correct data for the specified date

kevinleclainche · 2024-09-10T09:35:38.368Z

We have a dashboard, where the user can navigate dates, when the date is modified the data shown in the RG should match the selected date.

One of my customers is telling and showed me that on mobile, and pc, when they navigate trough the dates, the data displayed in the RG does not match the selected date.

i.e when the customer navigates to september 7th the RG displays the data of september 8th. When they navigate to september 19th , it displays the data of the september 20th and so on…

I’m uploading three pictures to give you in idea of the issue, the one that displays data for september 19 is wrong as there are not any record for september 19 in the database, that screenshot was made from one client this morning. The other two screenshots were made by me and they display correctly the data, nothing for september 19 , and several for sept 20th.

Capture d’écran 2024-09-10 à 10.51.33636×1350 124 KB

Capture d’écran 2024-09-10 à 10.52.56620×1214 254 KB

WhatsApp Image 2024-09-10 at 03.23.34485×1080 41 KB

sudsy · 2024-09-10T14:19:49.571Z

kevinleclainche:

when the customer navigates to september 7th the RG displays the data of september 8th

Is the customer in a different timezone?

If so, double check your timezone override controls (Settings → General → Scroll all the way to the bottom). And then also check your logic and timezone override settings on the relevant page, date picker, and backend workflows (if applicable).

Search the Bubble manual for “timezone” for additional information.

kevinleclainche · 2024-09-11T10:11:10.607Z

Thank you Sudsy !

This was the issue indeed.

As the data type I`m collecting is Single Date , and it is saved in the format dd/mm/yyyy 12:00 am , I just realized that the repeating groups where displaying data on Current user timezone.

so basically every record was adapting this data , dd/mm/yyyy 12:00 am to the timezone of where the page was being opened. Meaning that if the reservation was made in France (GMT+2) but the repeating group was opened in i.e Portugal it would adapt to GMT+1 , meaning that the record that was registered in france as dd/mm/yyyy 12:00 am is going to be displayed in Portugal as -1dd/mm/yyyy 11:00 pm

The solution to this was to round down to day (everywhere in the repeating group where this data is used), time zone selection: Static and time zone: Paris

Capture d’écran 2024-09-11 à 12.10.361392×1344 92.4 KB

A bit complex, however it makes sense now and the customer is happy it’s working well now

system · 2024-09-24T09:35:49.410Z

This topic was automatically closed after 14 days. New replies are no longer allowed.