# Actions **URL:** \ **Category:** Ask for Help\ **Created:** [November 28, 2022, 8:37pm UTC](https://community.glideapps.com/t/actions/55114 "2022-11-28T20:37:28Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\ **Post date:** [November 28, 2022, 8:37pm UTC](https://community.glideapps.com/t/actions/55114/1 "2022-11-28T20:37:29Z")
From an open form I would like to put the members id in cell F2 for later use in Google script. I cannot find an action for that, is there an other way? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fc3ae7774c1c95035811396fb2b1d72c1ee01189.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 28, 2022, 9:06pm UTC](https://community.glideapps.com/t/actions/55114/2 "2022-11-28T21:06:35Z")
you need to create a relation to the first row, and use set column action… i.e: create a column named X, enter the value in the first row “X”, then another column let’s call it XXX, use a single value column, and copy X to all rows… then relate XXX to X… then create action to set values using that relation ---
**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\ **Post date:** [November 29, 2022, 8:56am UTC](https://community.glideapps.com/t/actions/55114/3 "2022-11-29T08:56:16Z")
> [@Uzo](#): > > enter the value in the first row “X” ??? ---
**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:** [November 30, 2022, 12:25am UTC](https://community.glideapps.com/t/actions/55114/4 "2022-11-30T00:25:57Z")
What do you mean by “put the member’s ID in cell F2”? Do you mean when you create a new row it should be added there? ---
**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\ **Post date:** [November 30, 2022, 7:01am UTC](https://community.glideapps.com/t/actions/55114/5 "2022-11-30T07:01:17Z")
No, when I open Kalle Anka form and click Member, the value should be placed in F2. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 30, 2022, 7:05am UTC](https://community.glideapps.com/t/actions/55114/6 "2022-11-30T07:05:54Z")
F2 is the second row of MembersID column… you need to create a relation to that row… i showed you how to do it using X and XXX column… you type X in that row and relate column XXX to the column X ![Screen Shot 2022-11-30 at 2.09.41 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ce10de79b44a276eb2ee91331eec6fb6be1b9c57.png) ![Screen Shot 2022-11-30 at 2.14.09 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/613d25adb5b6f9881ae3dc6f091ef25172e21f8a.png) ---
**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:** [November 30, 2022, 7:13am UTC](https://community.glideapps.com/t/actions/55114/7 "2022-11-30T07:13:45Z")
In Glide it’s actually the first row in his table. @Ralf - here is what I would suggest. - in that table, create a Single Value → First → Whole row column, that targets the first row of the same table. This essentially gives you a single relation to the first row in the table from every other row. (The same as Uzo suggested, except it requires one column instead of two) - on the action that’s triggered when you view a Member, add an extra step. This should be a Set Column Values, via the previous column, setting the MemberID in the MembersID column. This should give you what you want. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 30, 2022, 7:17am UTC](https://community.glideapps.com/t/actions/55114/8 "2022-11-30T07:17:26Z")
@Darren_Murphy is right… you can save 1 column… but when you deal with many tables and columns… is better to have some standard names and methods for easy finding and editing… also is easier to change the row, manually or dynamically… simply by placing X somewhere else instead of editing single value column in the editor… you can do that from glide app, glide editor, google sheet or google script 😉 ---
**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\ **Post date:** [November 30, 2022, 7:33am UTC](https://community.glideapps.com/t/actions/55114/9 "2022-11-30T07:33:05Z")
Thank you guys! 🤓 ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [November 30, 2022, 7:09pm UTC](https://community.glideapps.com/t/actions/55114/10 "2022-11-30T19:09:44Z")
When you marking solution, you need to check the answer that solved your problem. ---
**Author:** ![Ralf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ralf/32/492_2.png) [@Ralf](https://community.glideapps.com/u/Ralf)\ **Post date:** [December 1, 2022, 4:12pm UTC](https://community.glideapps.com/t/actions/55114/11 "2022-12-01T16:12:00Z")
OK, I thought this was taking care of by AI! 🤓 ---
**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:** [December 2, 2022, 4:12pm UTC](https://community.glideapps.com/t/actions/55114/12 "2022-12-02T16:12:55Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.