Counting Unique Input

[Benjamin_Strickland]

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

[Darren_Murphy]

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

[Benjamin_Strickland]

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

BSS

[Benjamin_Strickland]

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

[ThinhDinh]

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

[Benjamin_Strickland]

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

[Benjamin_Strickland]

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

[ThinhDinh]

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

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…

[Eric_Penn]

@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?

[Benjamin_Strickland]

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

[Eric_Penn]

@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.

[Benjamin_Strickland]

I will take another look at that. Thanks.

[Benjamin_Strickland]

After another look, I am using “Wait”.