Records showing several times
Hi
I ahave a view showing only cust ID/name/telephone/email of customers,
trouble is, I get as many times the same cust ID listed as the number of times we opened a ticket for him.
ie I have a view like this:
Cust A - Name A - Tel A - Email A
Cust A - Name A - Tel A - Email A
Cust A - Name A - Tel A - Email A
Cust A - Name A - Tel A - Email A
Cust B - Name B - Tel B - Email B
Cust B - Name B - Tel B - Email B
Cust B - Name B - Tel B - Email B
Cust B - Name B - Tel B - Email B
and so on....
How can I restrict that particular view to show only one record per customer?
Tried the filters and criterias but no luck.
And if I input a script directly in the view I'm missing the "view only" argument:
count(input_form[cust_id ....?
Or with a if command?
If count(input_form[cust_id > 1] == "don't display?"