Search and or Filter by Date in Repeating Group

Hi all. I have a repeating group that has a small number of elements in. There is a sheet number , starting hours, fiinishing hours and a log date. The first 3 items are part of one entity (Sheet Running Totals) and the log date is from a related entity (Check Authorisations). The RG populates correctly etc but I now want to search, filter and possibly sort by the log date. As the log date belongs to a different entity I am having trouble using it in a condition statement. I have tried using ‘Which Field’ but I can’t seem to get this to work.

What am I missing please?

Thanks

D

Hey @dunnydf. You don’t miss anything. You can only sort things natively by using fields of the thing itself. This simply means you can’t sort it by using a related entity. Which field is a structure to put the name of the field (again one of the thing’s own fields) dynamically. There are a couple plugins that sorts repeating groups under special circumstances (their claim, not mine). This has been discussed quite some time under the forum, but I guess the end result is most of the time: redesign a little bit. For example, you can move the log date to the original thing as well (or maybe make a copy of it at least whenever check authorizations version of it is updated). In some cases, group by also helps (probably not your case). You can up the idea here. Maybe Bubble will work on it :slight_smile: Ability to sort on a thing's thing | Bubble

1 Like

Thanks Hergin - I managed to get this working the way I need it to. In the end I searched for Entity A and then I look for Entity B by a date that I enter in my form and then convert the records returned to a number and this is what drives the selection of Entity A.