- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2019 02:45 PM
Hi there,
how can I get the Head_count field in the Departments table to be calculated based on the total of users with that department selected. This needs to be updated perhaps once every 24 hours.
Script examples would be very much appreciated 🙂
regards
Paul
Solved! Go to Solution.
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2019 05:53 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-02-2020 04:59 PM
I can't imagine why not. You could write an on Submit business rule that updates the headcount everything a department record is updated and store the headcount at that point, that way its no longer a calculated value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2019 05:53 PM
Brilliant! thank you Aidan 🙂
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-25-2019 05:57 PM
Not sure why you marked your reply as the correct answer instead of my solution haha, but glad I could help.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-12-2025 07:28 AM
Hi @Community Alums - sorry for bringing up an old post. I implemented your solution and it's calculating correctly.
The only issue I'm seeing is when trying to sort the Department list view by Head count - for some reason it won't order them from lowest to highest or vice versa. Did you encounter this problem?
