Displaying two date fields in order within a repeating group

[elliot.serdet]

Hello Bubble Guys and Gals,

I currently have a database similar to the below.

Column 1	Column 2	Column 3	Column 4
ID	Date 1	Date 2
1	01/01/2024	02/01/2024
2	03/01/2024
3		04/01/2024

I need to display the list of ID’s in a repeating group with each line only displaying one of the two date fields in ascending order.

If an ID has data in both date fields it will need to be displayed twice in the repeating group.

I also need a field which identified the user which date field is being displayed in each row.

An example outcome on the above dataset would look like the below.

Column 1	Column 2	Column 3	Column 4
ID	Date	Identifier
1	01/01/2024	Date 1
1	02/01/2024	Date 2
2	03/01/2024	Date 1
3	04/01/2024	Date 2

Please can anyone help?

[hanan1]

hey @elliot.serdet!

I believe it is possible using your current data structure with one small addition: add a list of dates as a property and use it as datasource in a repeating within the original repeating group. I tried it out, it works:

here’s how the workflow is set up with the new list property:

and here is RG layout:

anyway it’s better if you check it out yourself. he’re a link.

[elliot.serdet]

Thank you very much for taking the time to look at my problem.

Looking at the example created it works great apart from one key element.

The identifier is not looked onto each date.

For example, if date 1 is entered the index/identifier needs to be 1 only and if date 2 is entered the index/identifier needs to be 2 only.

I have explored solutions but have not had any success.

[hanan1]

Oh I now understand, I fixed it by a simple condition. you can try it now.
here.

[elliot.serdet]

Thank you very much for this solution, it is much appreciated!