# 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:** 8\
**Page:** 2

<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:58pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/21 "2022-01-16T19:58:36Z")

</div>

> [@Eric\_Penn](#):
>
> In the template column Under replacements 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 for.
> 
> > [@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

Ok, yes, got there as you were typing.

Next challenge – it loads the next “To-do” for the entire table, but I have multiple patterns per table… So you might end up with “Next to-do” for a different pattern… 🤔

---

<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, 8:05pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/22 "2022-01-16T20:05:01Z")

</div>

Could I please see a screenshot of your setup? Apologies but I am just a mere mortal amongst the many wizards on here. I’m confident that one of us could get you across the finish line though 🕶

---

<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, 8:20pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/23 "2022-01-16T20:20:12Z")

</div>

No, you’re brilliant =)

I figured it out, although I did it in a slightly different way than what you were suggesting. You’ve put me on the right path though! Thank you!

Here’s what I did:  
I have a “Pattern instructions” table that has all row-by-row instructions for all patterns. I’ve already had a column `currentRowID` (needed it for Next/Previous actions).

 ![CleanShot 2022-01-16 at 13.11.38@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a710e3c568a1e0293923ef25c66aee8a131df883.jpeg)

I added If/Then column with the following parameters, but instead of Completed/To-do I made it return `currentRowID`

 ![CleanShot 2022-01-16 at 13.09.17@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0f03d501963ee6e1f8761c65862791daaef7c5cd.png)

Then, I made a relation column that looks at If/Then column and returns the record.

 ![CleanShot 2022-01-16 at 13.09.45@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/0/7055ab9bde6bbda55075e433894720a182077573.png)

Finally, in Patterns table (that feeds the detail screen for the pattern with inline list), I used a lookup column to bring the contents of `condNotComplete` to this table and a relation column to link this new “Find next to-do” to the row in Pattern Instructions.

 ![CleanShot 2022-01-16 at 13.16.07@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/1/11ebc29840cf6cfa223a255c681576b0f389599a.png)

I wonder how many rules of “good table design” I’ve violated, but it works!!!

![CleanShot 2022-01-16 at 13.19.23](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/1/b1bd84e5dcfb3ddd03c55d276f18129ab69a1d88.gif)

Thank you for your help!!!

---

<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, 8:23pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/24 "2022-01-16T20:23:50Z")

</div>

👏 👏

---

<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, 8:28pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/25 "2022-01-16T20:28:35Z")

</div>

Yuup that’s the ticket. I’m glad I could help! Navigation is clean and appears to be how you wanted. I like how you incorporated the previous row and next row button bar in the details screen.

Good luck with the project it looks like a really interesting one!

---

<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, 9:45pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/26 "2022-01-16T21:45:22Z")

</div>

> [@Tamara\_Didenko](#):
>
> ![CleanShot 2022-01-16 at 13.09.17@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/f/0f03d501963ee6e1f8761c65862791daaef7c5cd.png)

Just re-reading your brilliant setup and I wonder if we should make this when User \> Completed is not true (instead of is blank). If someone were to uncheck something that was once completed then I think it would fall into the ELSE branch.

---

<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, 9:49pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/27 "2022-01-16T21:49:52Z")

</div>

> [@Eric\_Penn](#):
>
> Just re-reading your brilliant setup and I wonder if we should make this when User \> Completed is not true (instead of is blank). If someone were to uncheck something that was once completed then I think it would fall into the ELSE branch.

Yes, that’s a great suggestion! Thank you so much!

---

<div class="post-metadata">

**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:** [January 17, 2022, 9:50pm UTC](https://community.glideapps.com/t/action-open-detail-page-for-the-next-item-that-has-boolean-0/37272/28 "2022-01-17T21:50:23Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.

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