# Combining Public & Private data **URL:** \ **Category:** Ask for Help\ **Created:** [May 4, 2026, 11:59am UTC](https://community.glideapps.com/t/combining-public-private-data/87008 "2026-05-04T11:59:11Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![SpyrosTsouk](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@SpyrosTsouk](https://community.glideapps.com/u/SpyrosTsouk)\ **Post date:** [May 4, 2026, 11:59am UTC](https://community.glideapps.com/t/combining-public-private-data/87008/1 "2026-05-04T11:59:12Z")
Hi Team I’d appreciate your help. Context: - I’m trying to combine a mix of public and private data in a flow. Imagine private recipes, and public recipes, with each user being able to add public recipes to their private (without editing them) - I’m considering some type of table combination with relations etc, but I’m looking for a more optimal & smooth setup, to avoid duplicating the rows in the private tables when a user adds a public recipe to their private ones Any hints? Thank you very much! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 4, 2026, 12:02pm UTC](https://community.glideapps.com/t/combining-public-private-data/87008/2 "2026-05-04T12:02:15Z")
My initial thought is that you might be overcomplicating this. If a user can’t edit a recipe that’s been added to their “private” collection, how is that different from simply marking it as a favourite? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 4, 2026, 12:04pm UTC](https://community.glideapps.com/t/combining-public-private-data/87008/3 "2026-05-04T12:04:40Z")
I’ve used row owners here before. Works well if you’re using multiple roles. Give every user a role of “public”. In the recipes table, create two row owner columns: a public column with the “public” value if the recipe is public and an email column for the recipes if they’re private. Then, if a user wants to make their private recipe public, you only need an action to write the “public” role in the public column. ---
**Author:** ![SpyrosTsouk](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@SpyrosTsouk](https://community.glideapps.com/u/SpyrosTsouk)\ **Post date:** [May 4, 2026, 1:17pm UTC](https://community.glideapps.com/t/combining-public-private-data/87008/4 "2026-05-04T13:17:50Z")
Thanks Robert. I tried smth like this: - User Table includes row ownership per email, and role (no row ownership) - Table with data under examination: - Row ownership per email - Row ownership per role But it didn’t work at the builder level. I will try again! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 4, 2026, 1:23pm UTC](https://community.glideapps.com/t/combining-public-private-data/87008/5 "2026-05-04T13:23:27Z")
> [@SpyrosTsouk](#): > > - ser Table includes row ownership per email, and role (no row ownership) > - Table with data under examination: > - Row ownership per email > - Row ownership per role > > But it didn’t work at the builder level. I will try again! Did you configure the Role column in your User Profiles? ---
**Author:** ![SpyrosTsouk](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@SpyrosTsouk](https://community.glideapps.com/u/SpyrosTsouk)\ **Post date:** [May 4, 2026, 2:09pm UTC](https://community.glideapps.com/t/combining-public-private-data/87008/6 "2026-05-04T14:09:49Z")
If by this you mean, going to the profile and assigning role to a column, then yes I did. ---
**Author:** ![SpyrosTsouk](https://avatars.discourse-cdn.com/v4/letter/s/c0e974/32.png) [@SpyrosTsouk](https://community.glideapps.com/u/SpyrosTsouk)\ **Post date:** [May 4, 2026, 3:48pm UTC](https://community.glideapps.com/t/combining-public-private-data/87008/7 "2026-05-04T15:48:07Z")
It worked! @Robert_Petitto , thank you very much! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [May 11, 2026, 3:48pm UTC](https://community.glideapps.com/t/combining-public-private-data/87008/8 "2026-05-11T15:48:44Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.