# How to create a number chart from birthday?

**URL:** <https://community.glideapps.com/t/how-to-create-a-number-chart-from-birthday/21859>\
**Category:** Ask for Help\
**Created:** [January 28, 2021, 5:29am UTC](https://community.glideapps.com/t/how-to-create-a-number-chart-from-birthday/21859 "2021-01-28T05:29:55Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![hieudien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hieudien/32/20654_2.png) [@hieudien](https://community.glideapps.com/u/hieudien)\
**Post date:** [January 28, 2021, 5:29am UTC](https://community.glideapps.com/t/how-to-create-a-number-chart-from-birthday/21859/1 "2021-01-28T05:29:55Z")

</div>

Hi everyone,

I’m new to Glide, I’m bulding a numerology app and want to draw a number chart but don’t know how.  
Chart template, like a tic-tac-toe 3x3 game:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/3/2307b2a65fe0166e4032314ed7113b10951cf971.png)

I want to fill the template by my birthday, example 17/04/1997:  
If the number in birthday match the number in template, fill it. Skip number 0.  
After the chart done, I want to draw an arrow throw fullfill or empty line:  
[https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/91ebba825b1cc5bce0388aeaa8bc2e43f175b6c1.png](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/91ebba825b1cc5bce0388aeaa8bc2e43f175b6c1.png)  
Other example for cross/vertical arrow:  
06/04/2003  
[![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/804461194d5bd25e0d6b8eac303e9696e81b8938.png) ](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/804461194d5bd25e0d6b8eac303e9696e81b8938.png)

Any idea to do this? Thanks a lot.

---

<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:** [January 28, 2021, 6:15am UTC](https://community.glideapps.com/t/how-to-create-a-number-chart-from-birthday/21859/2 "2021-01-28T06:15:08Z")

</div>

I would imagine that something like this would be possible with [Cloudinary](https://cloudinary.com/). I’m not an expert with Cloudinary, so can’t really offer any specific advice, but it sure looks like it would be a fun challenge 👍

---

<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:** [January 28, 2021, 10:22am UTC](https://community.glideapps.com/t/how-to-create-a-number-chart-from-birthday/21859/3 "2021-01-28T10:22:29Z")

</div>

Sounds like this could be very tricky when we consider the template, the logic to “fill” it and all possible combinations of the arrows.

3 rows + 3 columns + 2 diagonals is 8 scenarios, and we have to derive a logic in an If Then Else column, I assume.

---

<div class="post-metadata">

**Author:** ![hieudien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hieudien/32/20654_2.png) [@hieudien](https://community.glideapps.com/u/hieudien)\
**Post date:** [January 28, 2021, 10:50am UTC](https://community.glideapps.com/t/how-to-create-a-number-chart-from-birthday/21859/4 "2021-01-28T10:50:37Z")

</div>

😢  
Can we use AppScript to break the birthday into this?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/e/ee3e26cf899a1ebb91f904e8433a7f48cfd916a2.png)

After that, turn the data to Glide as the chart?

Or can we display HTML/CSS on Glide ?  
Or we create a service to gender chart image 🤣 😂

---

<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:** [January 28, 2021, 11:07am UTC](https://community.glideapps.com/t/how-to-create-a-number-chart-from-birthday/21859/5 "2021-01-28T11:07:50Z")

</div>

> [@hieudien](#):
>
> Can we use AppScript to break the birthday into this?

No need for Apps Script, you could do that with sheet formulas. I’m thinking `REGEXEXTRACT()` will do the job. Although, I reckon @Jeff_Hager could do it using Glide math 😂

---

<div class="post-metadata">

**Author:** ![hieudien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hieudien/32/20654_2.png) [@hieudien](https://community.glideapps.com/u/hieudien)\
**Post date:** [January 28, 2021, 11:19am UTC](https://community.glideapps.com/t/how-to-create-a-number-chart-from-birthday/21859/6 "2021-01-28T11:19:55Z")

</div>

So the hard part is drawing them on Glide 😭

---

<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:** [January 28, 2021, 11:33am UTC](https://community.glideapps.com/t/how-to-create-a-number-chart-from-birthday/21859/7 "2021-01-28T11:33:54Z")

</div>

Here’s a solution for your first step:

 ![Screen Shot 2021-01-28 at 7.32.39 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c188cbba392601b54163f4f170900fdd0c2c0ba2.png)

Formula:

```auto
=IFERROR(REGEXREPLACE(TEXT($B2,"yyyy-mm-dd"), "[^"&C$1&"]", ""),"")

```

---

<div class="post-metadata">

**Author:** ![hieudien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hieudien/32/20654_2.png) [@hieudien](https://community.glideapps.com/u/hieudien)\
**Post date:** [January 28, 2021, 11:35am UTC](https://community.glideapps.com/t/how-to-create-a-number-chart-from-birthday/21859/8 "2021-01-28T11:35:53Z")

</div>

Thank you 😂
