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

Create a multiple relation column that matches the city name with itself, and then do a rollup through that relation.

That did it for me. Thank you so very much. BSS

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

Does the Occurrence Date column has any values in your database? Is it set up as a date/time column?

Yes, the column does have data, and the field is set up as “Date Only” and “Medium”

Is it necessary for me to re-create the table?

That’s weird. If it consistently behaves like that I think you should report to support. [image] On a paid plan? Use Support chat in the Glide builder Ask for Help 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…

[image] 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. [image] 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?

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

[image] 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.

Counting Unique Input

Ask for Help

ThinhDinh September 1, 2024, 11:04am 8

That’s weird. If it consistently behaves like that I think you should report to support.

Topic		Replies	Views
Generating Report Ask for Help	5	117	September 4, 2024
How to get total of rows based on a column value? Ask for Help	8	1597	March 7, 2021
Display the Count of items matched in a 'Relation' list Ask for Help	28	5230	October 28, 2023
Integration Generate CSV Bugs? Ask for Help	13	732	June 28, 2023
Select data/rows with same date Ask for Help	3	257	June 7, 2023

Counting Unique Input

Related topics