Please help 🙏 - App crashing on repeating group with filter & grouped by functions

As a user. when I land on the page, I want to see my transactions grouped by their transaction date, SO THAT all transactions on a given day, are displayed according to that date group

As a User, I want to toggle the number of transactions that I see on the page SO that the number of transactions displayed is according to the timeframe that I have selected

As a User. I want to filter the transactions displayed by the account they belong in SO that the transactions displayed are only those that are in the accounts I’ve selected

AC1:

GIVEN a user lands on the page

THEN by default, the last 7 days of transactions are displayed

AC2:

WHEN a user taps last 30 days

THEN the last 30 days of transactions AND their respective date groups should be displayed

AC3:

GIVEN a user has transactions on any given date

THEN the date group for that transaction should be visible

AC4:

GIVEN a user has multiple transactions on any given date

THEN all transactions on that given date should be grouped under the respective date group

AC5:

GIVEN a user does not have any transactions on any given date

THEN the date group with no transactions should not appear

AC6:

GIVEN the user clicks the filter to display the sheet

WHEN a user selects account(s) from Sheet > selectable list accounts

THEN only transactions whose transaction account is in the selected choices account name are displayed

Current Result:

AC2 is failing - result is the app crashes when user selects a different date

AC6 is failing - result is app crashes when user selects the account

Here is a summary of my front-end logic and workflows:

I have a page called ‘New Transactions’

On Page load the page receives a state ‘Should_Refresh’ (Yes/No) = Yes

State of Yes triggers a workflow to set state of Page ‘New Transactions’ to ‘All TXs’ - value of All TXs is Do a Search for Transactions with the transaction date constraint being determined by the workflow and the Yes/No state of 3 elements (7 Days, 30 Days and This Month)

Inside the page there is a ShortList called ‘ShortList Date’ which is set to data type grouping, and data source is the page’s state ‘All TX’s, filtered: account is in selectable list accounts and grouped by Transaction Date’

Inside the ShortList Date there is a text field which is Current Item Grouping’s Transaction Date - this provides me with a list of relevant transaction dates

Further inside the ShortList Date there is another Shortlist ‘All Transactions’ whose date source is New Transactions (the page) All TXs filtered: Account is in Selectable List Accounts, This transaction’s transaction date is Current Item’s Groupings Transaction date - this gives me the respective transactions that fall on the date of the date grouping

In the view, there is also a sheet which is displayed when the user taps the Filter icon in the top right, in the sheet there is a menu of Accounts (pulled from the database) that the user can select - the selection of accounts is what the filter in the shortlist aboves is filtering by

Whenever the User either taps on the different 7 Day, 30 Day or This Month toggles, or selects an account from the Sheet, the bubblego app crashes - just displays a blank screen - everything works fine until these specific actions

I’m trying to create a page so that the transactions are displayed to a user, grouped by transaction date, but then when they filter by the date toggles on the view, or by the accounts in the sheet, then only the transactions meeting the criteria are displayed, and all the dates that don’t have any transactions in them when applying any of the (or a comibination of) the filters then also don’t display

I’m fairly new to bubble (less than 3 months part time) but feel like I’m picking it up fairly swiftly with the help of YouTube and googline, but can’t seem to get to the bottom of this one - Please help as this problem is driving me nuts!

Many Thanks in advance!

From what I experienced myself, ShortLists are buggy atm and can result in page crashes.

Instead, use a VerticalList and I’m 99% sure your app won’t crash :slight_smile:

1 Like