# Segmentation based on boolean

**URL:** https://community.glideapps.com/t/segmentation-based-on-boolean/16489
**Category:** Ask for Help
**Created:** [September 29, 2020, 9:30am UTC](https://community.glideapps.com/t/segmentation-based-on-boolean/16489 "2020-09-29T09:30:28Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![Golf\_Guru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/golf_guru/32/6399_2.png) [@Golf\_Guru](https://community.glideapps.com/u/Golf_Guru)
#### Post date: [September 29, 2020, 9:30am UTC](https://community.glideapps.com/t/segmentation-based-on-boolean/16489/1 "2020-09-29T09:30:28Z")

</div>

Hello there,

Probably quite an easy one. I’ve got a boolean below our audio sessions to track which users are listening to which audio. If a user listens to a session I would like their email added to a new sheet with a boolean for which sessions they have listened to. I’ve created a relation for the booleans but I cant work out how to pull through their email.

So the flow is:

Someone listens to a session  
Switches the ‘has listened’ boolean to true  
They are added with their email to a new sheet with the sessions they listened to in columns.

Thanks in advance!

Andy

---

<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: [September 29, 2020, 10:30am UTC](https://community.glideapps.com/t/segmentation-based-on-boolean/16489/2 "2020-09-29T10:30:28Z")

</div>

You have to catch that via a Zapier because I assume you’re using user-specific column to store the boolean value. The switch will just record the boolean, not the email.

---

<div class="post-metadata">

### Author: ![Golf\_Guru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/golf_guru/32/6399_2.png) [@Golf\_Guru](https://community.glideapps.com/u/Golf_Guru)
#### Post date: [September 29, 2020, 10:55am UTC](https://community.glideapps.com/t/segmentation-based-on-boolean/16489/3 "2020-09-29T10:55:55Z")

</div>

Hm, Surely there is a way to relate a user action with their email in a new sheet?

---

<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: [September 29, 2020, 11:03am UTC](https://community.glideapps.com/t/segmentation-based-on-boolean/16489/4 "2020-09-29T11:03:53Z")

</div>

Only a form would work like that if you don’t want Zapier, but I suppose you don’t want that flow as well. It’s not UX friendly.

---

<div class="post-metadata">

### Author: ![Golf\_Guru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/golf_guru/32/6399_2.png) [@Golf\_Guru](https://community.glideapps.com/u/Golf_Guru)
#### Post date: [September 29, 2020, 11:19am UTC](https://community.glideapps.com/t/segmentation-based-on-boolean/16489/5 "2020-09-29T11:19:10Z")

</div>

If someone checks a boolean and that boolean is user specific, surely you can record the email of the users who check that boolean?

---

<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: [September 29, 2020, 11:42am UTC](https://community.glideapps.com/t/segmentation-based-on-boolean/16489/6 "2020-09-29T11:42:53Z")

</div>

That info is only available internally for Glide and not recorded to the Sheet.

---

<div class="post-metadata">

### Author: ![Golf\_Guru](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/golf_guru/32/6399_2.png) [@Golf\_Guru](https://community.glideapps.com/u/Golf_Guru)
#### Post date: [September 29, 2020, 3:55pm UTC](https://community.glideapps.com/t/segmentation-based-on-boolean/16489/7 "2020-09-29T15:55:22Z")

</div>

So as a workaround if when they check the boolean can it be added to a col in their user sheet?

---

<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: [September 29, 2020, 5:17pm UTC](https://community.glideapps.com/t/segmentation-based-on-boolean/16489/8 "2020-09-29T17:17:53Z")

</div>

I imagine you can create a template column for each video and a boolean for each video but it’s not scalable.
