Form container problem

[Michael_Joshua]

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

[Jeff_Hager]

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.

[Michael_Joshua]

Thank You so much @Jeff_Hager !
Now It Works