I have a table called 'projects' that has a field called 'schools' . I want to be able to display the number of unique schools in this field using the Number element in Interfaces.
I can count the record easy enough but the records in the project table may contact multiple instances of the schools so I'd like to display a count of how many unique records there are.
Hope that makes sense
Hey Dominic, I have moved on from the project and no longer have access to the base. I managed to work around it by finding other unique fields on the record that worked (email address).
I need to replicate the scenario and play around to determine what can and can't be rolled up with unique records. I'll post back if I find anything but I really appreciate you help.