Select Distinct Or...?

[aam82]

I would like to report every other week on staff who worked. Each staff might have worked more than 1 hour, and each hour is booked individually.

 

report of who worked and how much:

staffname1 date hours

staffname1 date hours

staffname2 date hours

staffname3 date hours

staffname3 date hours

staffname3 date hours

etc

 

My ultimate goal is to email each staff once, by generating a report of just the staff person's email address IF they worked.

 

1. I don't know how to get a report that lists each staffperson *just once*.

 

2. Even if I did, I don't know a way to email them other than copy-pasting the names into email. Looking for automation here.

[aam82]

Anybody?

 

In other words, how do I report on:

 

unique email addresses

FROM

table of all worker activity (where each likely appears more than once)

 

Thanks

[aam82]

If I use Group By... then it will show each address just once, but each occurence gets a blank row, so that addresses are separated by many blank rows.

[GoCubbies]

Do you have a table that just contains the staff information where email is unique?  If so, base a report off that table, then use a calculated field along the lines of the following to get a sum of hours by that unique email. You could also place this in the details page of a report to get the hours from just that employee whose record you are in.

SELECT SUM(Hours) FROM Hourstable WHERE Email = target.[@field:Email]

[aam82]

I like it, thank you!

[Kurumi]

Hi everyone! Just an update: Caspio has finally released a feature to show DISTINCT records on Reports (Tabular/List/Gallery).

It is available in R30 version: https://howto.caspio.com/release-notes/caspio-30-0/