We have an applicant tracking system. Some applicants apply for multiple positions and may reapply months or years later after we have reviewed them. I want to create a count field that would show the number of occurrences of each applicant’s email address. For example, if applicant X with the email address “person@mail.com” applied six months ago and then applies again today, I want both the original entry and today’s entry to show a count of two. Any ideas?
That can be completed very easily. In your Applicant Table you can create a SUM field that would be able to calculate the number of times “person@mail.com” has a record in the Applicant Table as long as there is a connection between the Data Tables.
We are happy to provide a complimentary 30 minute project review. Please reach out here via message you you can email us at connect@rmelas.com
Adrian S. | VP of Development
RMELAS Technology Group
Tadabase Partner
Hi Adrian,
The email addresses are in the same table with the other applicant information, so I can’t run a SUM on a connected table.
Henry
Send me an email with your contact details connect@rmelas.com. We can jump on a quick zoom call and I can see your backend. (DataBuilder)