Displaying multiple fields from a single table within a repeating group?

tylerborenstein · 2020-10-30T18:04:55.210Z

I’m looking for some advice in my attempt to display different data fields within a single repeating group

For example:

I currently have 3 input fields where users can input (example): ‘breakfast’, ‘lunch’, dinner’.
Each is stored in a table called ‘food’ (containing fields: breakfast, lunch, dinner).

I would like to be able to display this data in a format like:

User 1
Breakfast: eggs
Lunch: sandwich
Dinner: Salad

User 2
Breakfast: oatmeal
Lunch: soup
Dinner: Fish

But i’m having trouble b/c at the moment it seems like I’m only able to bring a single field from my food table into the a repeating group.

tylerborenstein · 2020-11-02T20:17:49.692Z

@NigelG - we haven’t met - but i’ve been impressed with some of your responses - care to take a stab at this if/when you have a moment?

NigelG · 2020-11-03T16:05:06.385Z

Will do.

tobias2 · 2020-12-05T18:21:26.973Z

same problem… any hint?

mikeloc · 2020-12-05T18:47:02.860Z

Hi there, @tylerborenstein and @tobias2… with the structure proposed in the original post (i.e., a data type called food with fields for breakfast, lunch, and dinner), the desired display can be achieved with a repeating group inside of another repeating group. The data source of the first/main repeating group would be a Search for Users with no constraints, and the data source of the nested repeating group (i.e., the repeating group that is placed within the first row of the first/main repeating group) would be a Search for Foods with a constraint of Created By = Current cell's User. Make sense?

Hope this helps.

Best…
Mike

tobias2 · 2020-12-05T18:51:21.754Z

Hi,

I think I figured it out. It’s quite simple and logical.

*) Drag a repeating Group on your site
*) Drag ALL textfields which you want to display in relation to each other in only ONE cell of the repeating group layout (i.e. user, breakfast, lunch, dinner). These cells then get repeated and it should be displayed properly. I guess you would need a repeating group with a lot of rows but just one column.

This makes sense, because you always need the same parameter. And the parameter is defined on the cell. ("Current cell’s …). Hope this helps…

mikeloc · 2020-12-05T18:57:58.253Z

You’re absolutely right, @tobias2… I really overthought that one! A single repeating group that is a search for foods works just fine because each food record has a creator that you can display in a text field. My apologies for overcomplicating things… pretty easy to get in your own way sometimes in Bubble.

Best…
Mike

tobias2 · 2020-12-05T19:09:02.783Z

I could not overcomplicate due to lack of knowledge Your answer was great and gave me some more context. Still learning a lot

mikeloc · 2020-12-05T19:17:56.956Z

The knowledge will come quickly… just keep on goin’. Be careful, though… Bubble is very addictive!

tobias2 · 2020-12-05T19:34:18.957Z

Thanks for this warning, but it came too late. I am already addicted But I think in terms of software that is very positive There is too much frustrating user experience out there…

tylerborenstein · 2020-12-05T23:04:15.036Z

Great solution @mikeloc and @tobias2 - seems fairly obvious once it’s in front of me now…