Hi, I've just created some scripts that are ran from our 'dashboard', so they allow all our job sheets to be assigned to a 'queue' from a drop-down list, then I run a script to perform a find which shows all the job sheets that have a been assigned to that particular queue. This works great.
However, I now want to show a total on the dashboard next to each of the buttons used to run the scripts. So an example would be a queue called 'to invoice' would have a number next to it, to show how many records currently have 'to invoice' selected within the 'queue' field on the record.
I've tried to do this with a calculation field and a summary field, however, it's not giving the correct results.
Queue = "to invoice" (calculation field in the table of job sheets)
Total of the above field (as a summary field) - which is then shown on dashboard
So this would allow you to see at a glance how many job sheets are in a queue without the need to click the button and run the script.