# Counting Unique Input **URL:** \ **Category:** Ask for Help\ **Created:** [August 29, 2024, 10:20am UTC](https://community.glideapps.com/t/counting-unique-input/75968 "2024-08-29T10:20:57Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [August 29, 2024, 10:20am UTC](https://community.glideapps.com/t/counting-unique-input/75968/1 "2024-08-29T10:20:58Z")
I have used “Rollup” to count all rows in a table, but is it possible to count unique data? For example, when a search is made for a specific city, I aim to give a count for City A, City B, City C, etc. Thank you. BSS ---
**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:** [August 29, 2024, 10:22am UTC](https://community.glideapps.com/t/counting-unique-input/75968/2 "2024-08-29T10:22:32Z")
Create a multiple relation column that matches the city name with itself, and then do a rollup through that relation. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [August 29, 2024, 2:40pm UTC](https://community.glideapps.com/t/counting-unique-input/75968/3 "2024-08-29T14:40:08Z")
That did it for me. Thank you so very much. BSS ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [August 31, 2024, 3:32pm UTC](https://community.glideapps.com/t/counting-unique-input/75968/4 "2024-08-31T15:32:32Z")
Hello Darren. If I may, I would like to ask you another question. I have a table with a column name “ **Occurrence Date** ”. I am having two strange problems. When I use the “ **Generate a CSV** ” file the “ **Occurrence Date** ” column is not included in that file. Also, When I click the button to “ **Generate a CSV** ” file the first time, I get an error message but when I click it again thereafter it creates the file. What are these two problems? So to bother you again but thanks. Benjamin ---
**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:** [August 31, 2024, 11:30pm UTC](https://community.glideapps.com/t/counting-unique-input/75968/5 "2024-08-31T23:30:48Z")
Does the Occurrence Date column has any values in your database? Is it set up as a date/time column? ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [August 31, 2024, 11:50pm UTC](https://community.glideapps.com/t/counting-unique-input/75968/6 "2024-08-31T23:50:46Z")
Yes, the column does have data, and the field is set up as “Date Only” and “Medium” ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [September 1, 2024, 12:03am UTC](https://community.glideapps.com/t/counting-unique-input/75968/7 "2024-09-01T00:03:34Z")
Is it necessary for me to re-create the table? ---
**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:** [September 1, 2024, 11:04am UTC](https://community.glideapps.com/t/counting-unique-input/75968/8 "2024-09-01T11:04:37Z")
That’s weird. If it consistently behaves like that I think you should report to support. > [@On a paid plan? Use Support chat in the Glide builder](https://community.glideapps.com/t/on-a-paid-plan-use-support-chat-in-the-glide-builder/75927/1): > > If you’re on a paid Glide plan, the best way to get help is by reaching out to our support team directly from the Glide dashboard and builder. Use the messenger (powered by Intercom) to ask for assistance, report platform issues, or share your feedback while you’re working on your Glide apps. [Opening a support chat] Remember: While the Glide community is a great place to find guidance and advice for building Glide apps, it’s not the place to get help with account-specific issues like billing… ---
**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:** [September 1, 2024, 11:19am UTC](https://community.glideapps.com/t/counting-unique-input/75968/9 "2024-09-01T11:19:13Z")
> [@Benjamin\_Strickland](#): > > “ **Occurrence Date** ” column is not included in that file. Use select columns to decide which columns will be included in the generate csv action. > [@Benjamin\_Strickland](#): > > I get an error message but when I click it again thereafter it creates the file. I’m not sure about this one. Could we see a screenshot of the action? ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [September 1, 2024, 11:39am UTC](https://community.glideapps.com/t/counting-unique-input/75968/10 "2024-09-01T11:39:11Z")
I have discovered the error problem. In my Action to “ **Generate a CSV** ” file for the **Attendance** table, I had a “ **Wait** ” action above the “ **Generate a CSV** ” command and that was causing the error to appear. But I then moved the “ **Wait** ” action below the “ **Generate a CSV** ” command and that stopped the error. I can’t explain why but that error is now gone. Thanks ---
**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:** [September 1, 2024, 12:03pm UTC](https://community.glideapps.com/t/counting-unique-input/75968/11 "2024-09-01T12:03:04Z")
> [@Benjamin\_Strickland](#): > > I had a “ **Wait** ” action above the “ **Generate a CSV** ” There are 2 types of wait actions, one of them is wait for condition. It sounds like you are using “wait for condition” and the condition is not being met. The standard message is “error” if you do not include a custom message for that action. The regular “wait” action will just throw a pause for a desired amount of seconds. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [September 1, 2024, 5:12pm UTC](https://community.glideapps.com/t/counting-unique-input/75968/12 "2024-09-01T17:12:46Z")
I will take another look at that. Thanks. ---
**Author:** ![Benjamin\_Strickland](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/benjamin_strickland/32/68255_2.png) [@Benjamin\_Strickland](https://community.glideapps.com/u/Benjamin_Strickland)\ **Post date:** [September 1, 2024, 5:16pm UTC](https://community.glideapps.com/t/counting-unique-input/75968/13 "2024-09-01T17:16:22Z")
After another look, I am using “Wait”.