# Find from a list from within a form

**URL:** <https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106>\
**Category:** Ask for Help\
**Created:** [June 18, 2021, 4:25am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106 "2021-06-18T04:25:39Z")\
**Posts on this page:** 10\
**Page:** 2

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [June 21, 2021, 4:39am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/22 "2021-06-21T04:39:05Z")

</div>

Bonjour,  
Just a comment.  
Stop using “True” and “False”, I use 0 and 1 for all calculations, ifthen, filter, visibility, … and it works fine.  
“True, False” are just literal expressions of a Boolean value.

---

<div class="post-metadata">

**Author:** ![abe.sherman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abe.sherman/32/11260_2.png) [@abe.sherman](https://community.glideapps.com/u/abe.sherman)\
**Post date:** [June 21, 2021, 4:48am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/23 "2021-06-21T04:48:21Z")

</div>

Thank you for the tip. Using it now. The true issue was that i needed to create checkbox and hide them. I couldn’t get the filter working since checkbox have default items.

---

<div class="post-metadata">

**Author:** ![Manu.n](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manu.n/32/11679_2.png) [@Manu.n](https://community.glideapps.com/u/Manu.n)\
**Post date:** [June 21, 2021, 4:53am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/24 "2021-06-21T04:53:51Z")

</div>

Just a little advice.  
To do an ifthen, filter, visibility test, use the expressions “is 1” or “is Not 1”.  
So you don’t have to worry about the “Empty” value.  
do not use a test with the value “0”.

---

<div class="post-metadata">

**Author:** ![abe.sherman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abe.sherman/32/11260_2.png) [@abe.sherman](https://community.glideapps.com/u/abe.sherman)\
**Post date:** [June 23, 2021, 8:24pm UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/26 "2021-06-23T20:24:46Z")

</div>

Results on something i worked on a simlure project in the app. It wasn’t easy and MY DB was added another 20 rows. Here you go.

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/5/4548b8aacc369bbe9de744fa4982431db66bccec.jpeg "Notification Show off") ](https://www.youtube.com/watch?v=JEQjHLhduIY)

---

<div class="post-metadata">

**Author:** ![abe.sherman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abe.sherman/32/11260_2.png) [@abe.sherman](https://community.glideapps.com/u/abe.sherman)\
**Post date:** [July 5, 2021, 4:29pm UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/27 "2021-07-05T16:29:06Z")

</div>

[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/c/fcdbf6ed0b779e39acfc453b5b645cedace103cf.jpeg "Glide inventory Math challenge in glide") ](https://www.youtube.com/watch?v=9JQeVSu46Pw)

Math needed in glide for fast results.  
Convert this to inglide math.

COUNT/COUNT UPC IN ORDER DOWN   
=ARRAYFORMULA(IF(K2:K\<\>“”,COUNTIFS(K2:K,K2:K,ROW(K2:K),“\<=”&ROW(K2:K)),“”)-1)  
COUNT/COUNT DDNS   
=ARRAYFORMULA(IF($K2:$K\<\>“”,COUNTIFS($B2:$B,$B2:$B,ROW($B2:$B),“\<=”&ROW($B2:$B)),“”))  
COUNT/COUNT UPC On JOB SITE   
=ARRAYFORMULA(if(ISBLANK(B2:B) \<= false,COUNTIFS($K2:$K&B2:B,“”&$K2:$K&B2:B,ROW($B2:$B),“\<=”&ROW($B2:$B)),0))  
COUNT/JOB SITE TOTAL   
=ARRAYFORMULA(if(ISBLANK(B2:B) \<= false,COUNTIFS($K2:$K&B2:B,“”&$K2:$K&B2:B,ROW($B2:$B),“\<\>”&ROW($B2:$B))+1,0))  
COUNT/ALL TOTAL PRODUCT  
=ARRAYFORMULA(IF(K2:K\<\>“”,COUNTIFS(K2:K,K2:K,ROW(K2:K),“\<\>”&ROW(K2:K)),“”))

> [@What are all formula you can use with math?](https://community.glideapps.com/t/what-are-all-formula-you-can-use-with-math/28747):
>
> Hi guys i would like to collect data on what you can do with math. If there is any other way to calculate things besides +,-,\*,/ I feel like this info is missing in glide. Lets say i want to calculate how many times a name is appeared over again. would that be possible? Compare a col to another. If Something = to something? You get the point. Can we share all knowledge if it exist and if we are able to here. Math should be a big subject. And we should be able to do much more then we currently a…

---

<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:** [July 5, 2021, 4:59pm UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/28 "2021-07-05T16:59:04Z")

</div>

I’ll watch your video later, but have you tried creating relations and then create rollups on top of that relation to get your unique counts?

---

<div class="post-metadata">

**Author:** ![abe.sherman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abe.sherman/32/11260_2.png) [@abe.sherman](https://community.glideapps.com/u/abe.sherman)\
**Post date:** [July 5, 2021, 5:01pm UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/29 "2021-07-05T17:01:45Z")

</div>

Nope but guild me a bit, What am i relating to? lets give it a shot.

---

<div class="post-metadata">

**Author:** ![abe.sherman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abe.sherman/32/11260_2.png) [@abe.sherman](https://community.glideapps.com/u/abe.sherman)\
**Post date:** [July 5, 2021, 5:43pm UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/30 "2021-07-05T17:43:37Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/a/dacfff6d8209f04f85f1e8ded612bbb6f450523b.png)  
OK i see what you mean. What about if i want to get the results on the right, Comparing Job Site and Name of item. The right one is the correct one.

---

<div class="post-metadata">

**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:** [July 6, 2021, 1:37am UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/31 "2021-07-06T01:37:39Z")

</div>

> [@What are all formula you can use with math?](https://community.glideapps.com/t/what-are-all-formula-you-can-use-with-math/28747/6):
>
> Yes, there is a solution - templates. Create a template column that concatenates the customer name and product, then relate that template column to itself. Then do a rollup through that relation to get a count. This is bread and butter stuff when it comes to Glide computed columns. Dig out a few of Bob Petitto’s tutorials and watch them. He covers this sort of stuff in many/most of them.

---

<div class="post-metadata">

**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\
**Post date:** [January 17, 2024, 4:51pm UTC](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106/32 "2024-01-17T16:51:37Z")

</div>

Closed on January 17, 2024, 4:51pm UTC



[Previous page](https://community.glideapps.com/t/find-from-a-list-from-within-a-form/28106.md?page=1)