# Form container problem

**URL:** <https://community.glideapps.com/t/form-container-problem/77016>\
**Category:** Ask for Help\
**Created:** [October 12, 2024, 3:18pm UTC](https://community.glideapps.com/t/form-container-problem/77016 "2024-10-12T15:18:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_Joshua](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_joshua/32/62084_2.png) [@Michael\_Joshua](https://community.glideapps.com/u/Michael_Joshua)\
**Post date:** [October 12, 2024, 3:18pm UTC](https://community.glideapps.com/t/form-container-problem/77016/1 "2024-10-12T15:18:27Z")

</div>

Hi Guys !  
Maybe someone can solve the problem that when I send ,the presence of athletes” via form container + date, it sends the whole, separated by a comma, but never jumps to the field ,ALL PRESENCES ” and for example OCTOBER ATTENDANCE. Maybe someone knows how to do that even if I select about 50 people, it will still be assigned without such gaps / errors in the database ? Thank you in advance and best regards

 ![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/403886ecadca5730677f67e4277681e0ba1ccc65.png)  
 ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/52f61eb0b8d44cfd60cc2ed1548d0b89d710691c.png)  
 ![3](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/7/87db159277d6ab61b2c9e2a3a56e70cf0cb79821.png)  
 ![4](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/e/3edbbd5e3da7da2de35e4804147e1090ce18adc5.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:** [October 12, 2024, 3:47pm UTC](https://community.glideapps.com/t/form-container-problem/77016/2 "2024-10-12T15:47:31Z")

</div>

You are trying to match a date to text. The underlying value of that date column is probably something like 2024-10-12… which is not the same as the pretty formatted version you see.

…but, this is not a stable solution for many reasons. Underlying dates could be stored in a different format and the date formatting you actually see is not always the same as the date I might see because we live in different regions and we read dates differently, so it can be different for each user.

I highly recommend creating a math column next to your date column to extract the month.

`Month(Date)`

Then change your query to look for the number 10 only in that math column.

---

<div class="post-metadata">

**Author:** ![Michael\_Joshua](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_joshua/32/62084_2.png) [@Michael\_Joshua](https://community.glideapps.com/u/Michael_Joshua)\
**Post date:** [October 13, 2024, 9:08am UTC](https://community.glideapps.com/t/form-container-problem/77016/3 "2024-10-13T09:08:19Z")

</div>

Thank You so much @Jeff_Hager !  
Now It Works 😉

---

<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:** [October 20, 2024, 9:08am UTC](https://community.glideapps.com/t/form-container-problem/77016/4 "2024-10-20T09:08:45Z")

</div>

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