# Action: open Detail page for the next item that has Boolean=0

**URL:** <https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272>\
**Category:** Ask for Help\
**Created:** [January 16, 2022, 6:25pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272 "2022-01-16T18:25:43Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tamara\_Didenko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tamara_didenko/32/42215_2.png) [@Tamara\_Didenko](https://community.glideapps.com/u/Tamara_Didenko)\
**Post date:** [January 16, 2022, 6:25pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/1 "2022-01-16T18:25:43Z")

</div>

Hi there,

I’m building a crochet companion app [https://stitchease.glideapp.io/](https://stitchease.glideapp.io/). It combines step-by-step instructions (those are separate details screens) with a progress tracker (through a boolean checkbox). Sometimes the instructions can get lengthy.

Currently, the users would have to scroll the list all the way down to the last checked item and manually select the next item.  
 ![CleanShot 2022-01-16 at 11.21.29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/0/b0630f961065f1fe8fd767cddbd80f01348bdc07.gif)

I’d love to be able to use **the Floating button (FAB) to jump to the next row that is not yet completed.** Is there a way to do that?

Thank you in advance =)

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [January 16, 2022, 6:46pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/2 "2022-01-16T18:46:03Z")

</div>

Sorry what is FAB ?  
It seems you just added for FAB, ok let me see if I can help…

---

<div class="post-metadata">

**Author:** ![Tamara\_Didenko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tamara_didenko/32/42215_2.png) [@Tamara\_Didenko](https://community.glideapps.com/u/Tamara_Didenko)\
**Post date:** [January 16, 2022, 6:48pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/3 "2022-01-16T18:48:06Z")

</div>

Apologies =) UX terms 🤣

FAB = [Floating Action Button](https://material.io/components/buttons-floating-action-button) AKA Floating button in Glide =)

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [January 16, 2022, 6:51pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/4 "2022-01-16T18:51:49Z")

</div>

Entendu, je viens de me connecter.  
Il semble que ce que vous souhaitez faire soit assez simple, mais c’est de mon côté que çà bute: je ne connais strictement rien au crochet et je suis en train d’essayer de comprendre déjà çà 😄 😄

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [January 16, 2022, 6:54pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/5 "2022-01-16T18:54:56Z")

</div>

If you could just do a more detailed text on the app…

---

<div class="post-metadata">

**Author:** ![Tamara\_Didenko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tamara_didenko/32/42215_2.png) [@Tamara\_Didenko](https://community.glideapps.com/u/Tamara_Didenko)\
**Post date:** [January 16, 2022, 6:59pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/6 "2022-01-16T18:59:54Z")

</div>

Jabid,  
Thank you for checking it out!

I don’t think you need to understand crochet, per se =) Here’s the behavior I’m looking for:

- User lands on the detail screen
- Clicks Floating button
- It opens the next “Unchecked” item from the related list  
 ![CleanShot 2022-01-16 at 11.57.01@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/9/39f88aef98b5e5a397e80ea34a299d8145674d08.png)

I guess, you can think of it as an easy way to “Open next task”

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [January 16, 2022, 7:04pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/7 "2022-01-16T19:04:37Z")

</div>

Just thinking quickly one thing you could try… in your inline list and under options use ‘group by’

Something like ‘To-do’ & ‘Completed’

---

<div class="post-metadata">

**Author:** ![Tamara\_Didenko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tamara_didenko/32/42215_2.png) [@Tamara\_Didenko](https://community.glideapps.com/u/Tamara_Didenko)\
**Post date:** [January 16, 2022, 7:07pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/8 "2022-01-16T19:07:19Z")

</div>

Yes, I was thinking about it in case I can’t find a solution for the floating button. I think I’d prefer the button solution but I’m keeping this in mind for sure!

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [January 16, 2022, 7:08pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/9 "2022-01-16T19:08:13Z")

</div>

Ok. You create a FAB.  
Then you go to Custom Action, it’s at the top of the list, you click, you choose as Action “open Detail page”, you click. You have to play with it yourself, tell me if it works. Don’t forget to name and save your custom action at the top right.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 16, 2022, 7:14pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/10 "2022-01-16T19:14:55Z")

</div>

Would it be better to instead create two inline lists, each filtered by Unchecked or checked? Always show your unchecked items list first, and then once an item is checked, it moves to the second inline list of completed items.

There is no button action that would allow you to scroll to a certain point on the screen.

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [January 16, 2022, 7:20pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/11 "2022-01-16T19:20:18Z")

</div>

What if we had an ITE column with either ‘To-Do’ or ‘Completed’ in it and then we put a template column with just ‘To-Do’ in the same sheet. Next build a single relation from the template to the ITE To-Do/Completed column and then use that relation as the data for a show details screen?

@Jeff_Hager could that work?

---

<div class="post-metadata">

**Author:** ![Tamara\_Didenko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tamara_didenko/32/42215_2.png) [@Tamara\_Didenko](https://community.glideapps.com/u/Tamara_Didenko)\
**Post date:** [January 16, 2022, 7:20pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/12 "2022-01-16T19:20:33Z")

</div>

Thank you, Jeff. As I mentioned earlier, two inline lists is a solution I’m considering but want to see if what I have in mind is possible.

> [@Jeff\_Hager](#):
>
> There is no button action that would allow you to scroll to a certain point on the screen.

It doesn’t need to scroll to that page, it needs to open the **Detail** screen for that item =)

> [@jabid](#):
>
> Then you go to Custom Action, it’s at the top of the list, you click, you choose as Action “open Detail page”, you click. You have to play with it yourself, tell me if it works. Don’t forget to name and save your custom action at the top right.

I see what you mean. For whatever reason though, the column that is a source of data for the in-line list is not showing up for me in Action builder. Why could that be?

Apologies if it’s a silly question, a blond designer conquering tables here 🤣

 ![CleanShot 2022-01-16 at 12.18.02@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cdc0b85a1c8d18afed9cc06d6048eb4cbb0b353f.png)  
 ![CleanShot 2022-01-16 at 12.17.38@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b1b27f222a8bd42e332145c07678c9495b01dddf.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 16, 2022, 7:25pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/13 "2022-01-16T19:25:13Z")

</div>

Got it. Now I understand. I think @Eric_Penn’s solution should work for you.

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [January 16, 2022, 7:26pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/14 "2022-01-16T19:26:13Z")

</div>

> [@Tamara\_Didenko](#):
>
> Apologies if it’s a silly question, a blond designer conquering tables here

🤣 🤣 🤣

Let me check again… Ask what you want…

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [January 16, 2022, 7:32pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/15 "2022-01-16T19:32:03Z")

</div>

Hey @Tamara_Didenko if you are happy with my answer please help me and mark it a solution. I have a lot of catching up to-do with [Chuck](https://community.glideapps.com/t/chuck-norris-aka-jeff/26818) 😉

---

<div class="post-metadata">

**Author:** ![jabid](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jabid/32/33391_2.png) [@jabid](https://community.glideapps.com/u/jabid)\
**Post date:** [January 16, 2022, 7:38pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/16 "2022-01-16T19:38:30Z")

</div>

Hi @Tamara_Didenko  
If @Jeff_Hager Jeff said @Eric_Penn solution is good, you can go with it, for sure… 😆

---

<div class="post-metadata">

**Author:** ![Tamara\_Didenko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tamara_didenko/32/42215_2.png) [@Tamara\_Didenko](https://community.glideapps.com/u/Tamara_Didenko)\
**Post date:** [January 16, 2022, 7:41pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/17 "2022-01-16T19:41:18Z")

</div>

> [@Eric\_Penn](#):
>
> What if we had a column with either ‘To-Do’ or ‘Completed’ in it and then we put a template column with just ‘To-Do’ in the same sheet. Next build a single relation from the template to the To-Do/Completed column and then use that relation as the data for a show details screen?

Thank you, Eric!

I’m not 100% sure if I’m following you here. Let me try it hands-on and see if it works.

> [@Tamara\_Didenko](#):
>
> I see what you mean. For whatever reason though, the column that is a source of data for the in-line list is not showing up for me in Action builder. Why could that be?
> 
> Apologies if it’s a silly question, a blond designer conquering tables here 🤣
> 
> ![CleanShot 2022-01-16 at 12.18.02@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cdc0b85a1c8d18afed9cc06d6048eb4cbb0b353f.png)
> 
> ![CleanShot 2022-01-16 at 12.17.38@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b1b27f222a8bd42e332145c07678c9495b01dddf.png)

Any chance there’s an explanation for why this column doesn’t show up in actions though?

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [January 16, 2022, 7:46pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/18 "2022-01-16T19:46:36Z")

</div>

Probably because the relation is multiple. In the data editor uncheck match multiple on relPattern\_instructions

If you need that multiple relation for some other computations then just right click on relPattern\_Instructions, choose duplicate column and uncheck match multiple in the new copy.

I hope that helps!

---

<div class="post-metadata">

**Author:** ![Tamara\_Didenko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tamara_didenko/32/42215_2.png) [@Tamara\_Didenko](https://community.glideapps.com/u/Tamara_Didenko)\
**Post date:** [January 16, 2022, 7:50pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/19 "2022-01-16T19:50:23Z")

</div>

> [@Eric\_Penn](#):
>
> Probably because the relation is multiple. In the data editor uncheck match multiple on relPattern\_instructions

Oh, I see. Makes a lot of sense! Thank you!

> [@Eric\_Penn](#):
>
> What if we had a column with either ‘To-Do’ or ‘Completed’ in it and then we put a template column with just ‘To-Do’ in the same sheet. Next build a single relation from the template to the To-Do/Completed column and then use that relation as the data for a show details screen?

Ok, can I ask for further explanation?  
So I created an If/Then column that watches my boolean and assigns To-do/Completed status as necessary. I’m kind of lost after that 🤣 What should the template column do? Single relation to what? I’m so lost, lol =)

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [January 16, 2022, 7:55pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/20 "2022-01-16T19:55:14Z")

</div>

In the template column under template put the exact wording you used in your ite column and leave the replacements field empty

 ![Screen Shot 2022-01-16 at 2.52.34 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/8/b827dd3e3b41510e269a7c6941c7d5cde6e7e3b3.jpeg)

As you can see the template column has populated the same word for every row.

> [@Tamara\_Didenko](#):
>
> So I created an If/Then column that watches my boolean and assigns To-do/Completed status as necessary.

Now we want to build our ‘single’ relation from that template column to the ite column you already have

When our relations are single it will stop at the very first match which is what I assume you want.

[Next page](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272.md?page=2)
