Ok I see - you want to show a separate row in the repeating group for each Datatype Entry AND each user.
That’s actually quite tricky, as it effectively means having a repeating group that shows 2 different datatypes (which is not something you can do in Bubble).
However, having played around with it for a while now, I’ve managed to find 2 ways to achieve what you’re trying to do.
The first (and probably simplest) way is to create a 3rd datatype, that connects Datatype A to the User, with one entry for each connection.
Then simply set your repeating group to that datatype, then in each cell you can display the Datatype A entry AND the connected User email address.
The second way (which is a little fiddly, but it works fine) is to do another search for Datatype A’s User’s in your ‘email’ text box, in order to match the correct email with the correct Datatype A entry in each cell.
The way to do it is as follows:
-
You need to make sure you have a 2-way many-to-many relationship set up in your database structure (i.e. Datatype A has a field for list of users, and User has a field for list of Datatype As).
-
Your repeating group should have a content type of ‘Datatype A’ and the data source needs to be a ‘search for Users’ (with a constraint to only return users who’s list of Datatype As isn’t empty): 's Datatype As: sorted (however you want the list to be sorted).
That will return a list of ALL the datatype As that are owned by users, including duplicate entries (so if 3 people own entry C, entry C will appear 3 times).
-
In the cell, add a text box to display the current cell’s Entry (i.e. current cell’s entry’s name).
-
For the email text box you need to do a search for Datatype As (with a constraint to only return entries who’s list of owners isn’t empty): sorted exactly the same way as your repeating group data source Datatype As (it’s very important the the sorting is the same, otherwise the emails wont be correctly matched with the entries); list of owners: item# current cell’s index: 's email.
That will return a list of all the User’s who own datatype As (including duplicates), in the same order as the original list (the RG datasource), so by using current cells index to select the item number, it will display the correct email address in the correct cell.
As I said it’s a bit fiddly, but I’ve checked it and it does work. There may be other ways to arrive at the same end - personally I’d probably use the first option (a third ‘connecting’ datatype) as it keeps things simpler but it all depends on your use-case and your app.