# Pass values of set columns action (from inline list) to a row in another sheet

**URL:** <https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183>\
**Category:** Ask for Help\
**Created:** [May 24, 2021, 10:36pm UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183 "2021-05-24T22:36:50Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![MikkoJervoso](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikkojervoso/32/7832_2.png) [@MikkoJervoso](https://community.glideapps.com/u/MikkoJervoso)\
**Post date:** [May 24, 2021, 10:36pm UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183/1 "2021-05-24T22:36:50Z")

</div>

Hi all,

Hoping to get some advice from anyone who has done this.

I have an inline list that I’m using as a ‘multiple choice’ component. I have a custom action that sets a column T/F when clicked. This inline list is inside of a details screen of a row from another sheet.

My challenge is, I need to write the T/F values of the inline list to the row (current screen) the user is currently in.

The reason I wanted to do it this way rather than checkboxes or link to screen is because the app will primarily be used in tablet/desktop mode. Having 5 or more checkboxes leaves a ton of empty unused space on the right side of the screen. And link to screen adds a few more clicks for a user and is not ideal if there are only 3 or less checkboxes.

I’m more than happy to use either one but I just want to at least try to see if this is possible.

 ![Screen Shot 2021-05-24 at 6.21.10 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/b/7bcd834af18010d00b10725ca3fdf75952abe7a2.png)

Appreciate everyone in this community!

---

<div class="post-metadata">

**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:** [May 24, 2021, 11:06pm UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183/2 "2021-05-24T23:06:15Z")

</div>

So you only have 5 items here right? When you say writing to the row, do you mean you have 5 boolean columns?

---

<div class="post-metadata">

**Author:** ![MikkoJervoso](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikkojervoso/32/7832_2.png) [@MikkoJervoso](https://community.glideapps.com/u/MikkoJervoso)\
**Post date:** [May 24, 2021, 11:10pm UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183/3 "2021-05-24T23:10:35Z")

</div>

Hi @ThinhDinh. Appreciate the response. Yes I’m trying to update 5 boolean columns for Test1 and so on (whichever screen the user is on) using an inline list.

---

<div class="post-metadata">

**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:** [May 24, 2021, 11:15pm UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183/4 "2021-05-24T23:15:15Z")

</div>

Then I’m thinking of using 5 branches in a custom action, let’s say If item name is Cane, set column to the Cane boolean and do whatever visual changes needed (green background, checkbox filled etc.) to indicate that you have changed the selection to true.

Would it work for your case? Do Test2 & Test3 hold the same columns?

---

<div class="post-metadata">

**Author:** ![MikkoJervoso](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikkojervoso/32/7832_2.png) [@MikkoJervoso](https://community.glideapps.com/u/MikkoJervoso)\
**Post date:** [May 24, 2021, 11:26pm UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183/5 "2021-05-24T23:26:27Z")

</div>

Yes, I have that set up in a different sheet where I have the ‘choices’ in a column displayed as an inline list.

![select](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cc884e41199991c7000459dace4ee4157beac896.gif)

 ![Screen Shot 2021-05-24 at 7.18.47 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/6/96c045980662d1853a2f225c06e34840f874cb8e.png)

I just need the T/F to write to the columns in the other sheet, where Test1, Test2 are in.

 ![Screen Shot 2021-05-24 at 7.21.02 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a6c327dced372fb84b581d5936dc74cf5f6c03a0.png)

---

<div class="post-metadata">

**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:** [May 25, 2021, 12:35am UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183/6 "2021-05-25T00:35:26Z")

</div>

This is pretty complex so let me find time to make a demo for you.

---

<div class="post-metadata">

**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:** [May 25, 2021, 1:26am UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183/7 "2021-05-25T01:26:57Z")

</div>

Here’s a working version. It’s heavily relied on set columns and single value columns. Let me know if you have any questions.

> **[Ambulation Aids](https://ambulationaids.glideapp.io/)**

---

<div class="post-metadata">

**Author:** ![MikkoJervoso](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikkojervoso/32/7832_2.png) [@MikkoJervoso](https://community.glideapps.com/u/MikkoJervoso)\
**Post date:** [May 25, 2021, 2:26am UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183/8 "2021-05-25T02:26:38Z")

</div>

🤯 Thanks so much! I wasn’t expecting for you to recreate the whole thing and have a working sample. That took a lot of time and effort on your end! Really super grateful!

I got it to work but to be honest I’m still studying how you did it. 😅

---

<div class="post-metadata">

**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:** [May 25, 2021, 2:50am UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183/9 "2021-05-25T02:50:39Z")

</div>

Basically the idea was to copy the list of booleans and transpose them to the Selected column in the Ambulations sheet, then for every change in the Selected column upon clicks, we transpose the Selected column and copy 5 columns back to the respective row the user is viewing so the data is the same in both Sheets.

---

<div class="post-metadata">

**Author:** ![MikkoJervoso](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikkojervoso/32/7832_2.png) [@MikkoJervoso](https://community.glideapps.com/u/MikkoJervoso)\
**Post date:** [May 25, 2021, 5:24am UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183/10 "2021-05-25T05:24:33Z")

</div>

I’m really glad I asked because I would’ve never thought of it. I did notice though that sometimes the display stays active (green) for all other Test #'s but the sheet has the right T/F values.

Like in this example, I’ve selected walker and wheelchair for Test1 and the sheet has the right values for the corresponding columns for Test1. Then looking at Test2 and Test3, it looks as if walker and wheelchair is also selected but its only retaining the display from Test1 giving the impression that it has the same value in the Tests sheet. It happens only occasionally. Any ideas why this is happening?

 ![Screen Shot 2021-05-25 at 1.08.17 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8e596e67e2fd22300edc5d734bb5b20add60c687.png)  
 ![Screen Shot 2021-05-25 at 1.08.31 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2e24d2fac0cc8d32f539510a8628a18ed392b2aa.png)  
 ![Screen Shot 2021-05-25 at 1.08.50 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/576d01b2038fb19fbb3ff68fb0e915e49e3c0ace.png)

---

<div class="post-metadata">

**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:** [May 25, 2021, 5:43am UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183/11 "2021-05-25T05:43:49Z")

</div>

Did you have the set column of SI Rel at the top of the chain? I had this behaviour when I first did it, but after moving the set column above to first it fixed the flow.

---

<div class="post-metadata">

**Author:** ![MikkoJervoso](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mikkojervoso/32/7832_2.png) [@MikkoJervoso](https://community.glideapps.com/u/MikkoJervoso)\
**Post date:** [May 25, 2021, 6:19pm UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183/12 "2021-05-25T18:19:38Z")

</div>

Yes, I have it at the top of the chain. I noticed that it only happens on the first time the action is triggered and when I switch over to Test2 or Test3 to ‘deselect’ the ones that retained the display it doesn’t happen again.

I’ve added a few more ‘choices’ on the ambulation column and added corresponding SVs and set columns. I then added another inline list with a filter to only show the ones I’ve added.

It might sound crazy but I’m planning on adding 50+ more ‘choices’ grouped using filtered inline list components. There shouldn’t be any problems with that right? I’m just going to have add a ton of SVs and set columns?

 ![Screen Shot 2021-05-25 at 2.17.29 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/b/bbd994d9fc168186508f123d218011826bb76e8d.png)

Thank you again for all your help!

---

<div class="post-metadata">

**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:** [May 25, 2021, 11:26pm UTC](https://community.glideapps.com/t/pass-values-of-set-columns-action-from-inline-list-to-a-row-in-another-sheet/27183/13 "2021-05-25T23:26:52Z")

</div>

You’re correct about the process of adding more columns to get more choices in but as you might found out, it would require a hell lot of columns, I really do help we can help a better way to do this.

Not sure about the action not triggering on the very first time, I did face that yesterday but since I moved the SI Rel set column to the top it did not happen again.
