Here's the setup. I have a table of employees. A table of projects. I currently have a script that goes through and finds projects each employee submitted during the week, the script emails a PDF summary of their individual submissions, like a receipt, to each employee.
I could duplicate the script 14 times and change the criteria... but i'd like to use a loop.
How can i set up a loop to go through the list of employees and perform the script? There's about 14 employees and that won't change for a very long time.
i know the logic behind "For Loops" just no idea how that translates in filemaker world