Sorting repeating group of transaction by month dropdown

benp · 2024-07-18T20:52:44.098Z

Hey everyone,
I have been at this for hours I just don’t understand why the dropdown menu of the static options (months) is ‘incompatible type’ when I try to add it as constraint.

I have a repeating group with list of transactions, I wanted to add dropdown for the different months, I had it as ‘January’ , ‘February’ etc. I also tried to do it just as number like ‘1’, ‘2’ etc. but every time i go to the repeating group ‘Do a search for’ → ‘transactions’ → ‘Transaction date’ = ‘dropdown month’ but it is greyed out and its labeled at the bottom of it ‘incompatible type’.

What am i missing, how can i fix this?

georgecollier · 2024-07-19T02:07:48.638Z

benp:

dropdown menu of the static options

That’s a list of texts.

benp:

Transaction date

This is a date.

You will need a hidden group / expression that takes the month and calculates the start date and end date for that month. That could look like:

Current date time:rounded down to year:+months Dropdown Month’s number (where Month is an option set with each option having a number attribute for the month’s number) for the start date.

system · 2024-09-26T20:53:06.051Z

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