# Setting column values from newly created row in another sheet **URL:** \ **Category:** Ask for Help\ **Tags:** actions\ **Created:** [March 24, 2024, 12:26pm UTC](https://community.glideapps.com/t/setting-column-values-from-newly-created-row-in-another-sheet/71987 "2024-03-24T12:26:46Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![MikeFox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikefox/32/72381_2.png) [@MikeFox](https://community.glideapps.com/u/MikeFox)\ **Post date:** [March 24, 2024, 12:26pm UTC](https://community.glideapps.com/t/setting-column-values-from-newly-created-row-in-another-sheet/71987/1 "2024-03-24T12:26:46Z")
[ Meshi · Update Name Template of Families to User Family - Watch Video ](https://www.loom.com/share/264a8a42d6654d0ab8fa22cd819c58f5)[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c0a29457e0a285dc358f6a3f613b0639625ad6af.gif)](https://www.loom.com/share/264a8a42d6654d0ab8fa22cd819c58f5) //_NO AUDIO_// Hey there, I have a use case where I want to onboard a user: 1. They sign up 2. They enter their first and last name 3. They create their family unit (which I can then use as a “role”/“row owner”, so they can invite their family in) 4. Upon creating their family unit, a new row in family is created where the last name of the user is used, along with a formula to create a “Name Template”. 5. I then want to take that name template and push it back to the User Table into the Family field. I feel like I’m so close but can’t quite get it. At the moment, it’s doing step 1-4 but step 5 it’s taking the name template of a different family, not of the one that was just created. ---
**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:** [March 24, 2024, 12:33pm UTC](https://community.glideapps.com/t/setting-column-values-from-newly-created-row-in-another-sheet/71987/2 "2024-03-24T12:33:57Z")
Regarding the below: ![CleanShot 2024-03-24 at 20.30.47@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/527c4541fc11be73653a47bc4fad7a0dbf64717c.png) Is that Family column configured as the Role column in your User Profile configuration? If yes, then that will be why you can’t set it with an action. Roles can only be set via the Data Editor, or via the API. So to do what you are trying to do, you would need to use the Glide API. ---
**Author:** ![MikeFox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikefox/32/72381_2.png) [@MikeFox](https://community.glideapps.com/u/MikeFox)\ **Post date:** [March 24, 2024, 12:35pm UTC](https://community.glideapps.com/t/setting-column-values-from-newly-created-row-in-another-sheet/71987/3 "2024-03-24T12:35:00Z")
Ohhh! Thanks Darren. I’m yet to play around with the API. Guess that’s the next step for me. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 25, 2024, 12:00am UTC](https://community.glideapps.com/t/setting-column-values-from-newly-created-row-in-another-sheet/71987/4 "2024-03-25T00:00:59Z")
Let us know if you have any problems with using the API. Here’s a documentation link. > **[Using Glide API | Glide Docs](https://www.glideapps.com/docs/using-glide-tables-api)** > > Explore what you can do with the Glide Advanced API ---
**Author:** ![MikeFox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikefox/32/72381_2.png) [@MikeFox](https://community.glideapps.com/u/MikeFox)\ **Post date:** [March 25, 2024, 12:13am UTC](https://community.glideapps.com/t/setting-column-values-from-newly-created-row-in-another-sheet/71987/5 "2024-03-25T00:13:42Z")
Thanks @ThinhDinh I’m wondering if there is a better way of doing this. If the initial user signs up is there a way to assign a unique value to the Family field (acting as a role) by default, then when they add family members for that value to be assigned to those users? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 25, 2024, 12:16am UTC](https://community.glideapps.com/t/setting-column-values-from-newly-created-row-in-another-sheet/71987/6 "2024-03-25T00:16:55Z")
If you have an onboarding flow, you can add a unique ID for the “family creator” when they finish their onboarding. For every person that is added by that user later on to the family, you can use a user profile value in the form to add that unique ID to the new rows. But talking about that, you seem to already have a flow to generate the “Family” text? Maybe you can just use that? Or do you still want to keep that column in your role setup? ---
**Author:** ![MikeFox](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikefox/32/72381_2.png) [@MikeFox](https://community.glideapps.com/u/MikeFox)\ **Post date:** [March 25, 2024, 12:40am UTC](https://community.glideapps.com/t/setting-column-values-from-newly-created-row-in-another-sheet/71987/7 "2024-03-25T00:40:13Z")
Is a way to make sure it’s unique is to just pull across the row id for that user? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [March 25, 2024, 12:49am UTC](https://community.glideapps.com/t/setting-column-values-from-newly-created-row-in-another-sheet/71987/8 "2024-03-25T00:49:24Z")
That’s also a way to do it. The unique ID flow above also creates a unique string for you. ---
**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:** [March 25, 2024, 1:03am UTC](https://community.glideapps.com/t/setting-column-values-from-newly-created-row-in-another-sheet/71987/9 "2024-03-25T01:03:45Z")
> [@MikeFox](#): > > If the initial user signs up is there a way to assign a unique value to the Family field (acting as a role) by default, then when they add family members for that value to be assigned to those users? It is possible to assign a Role when a user is created, but only if the User adding the new row already has the role being assigned. For example, if you have the role “FamilyX”, then you can add new users and assign that same role. But it can _only_ be done when the new row is created, and it cannot be changed (via the UI or an action) afterwards. So it would need to be done as part of an Add Row action, or passed as a user profile value with a form submission. It could not be done as a Set Column values action (as you were trying to do in your video). ---
**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:** [April 1, 2024, 1:04am UTC](https://community.glideapps.com/t/setting-column-values-from-newly-created-row-in-another-sheet/71987/10 "2024-04-01T01:04:42Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.