I am from a programming background and am really missing the availability of for/next loops and indexed arrays in Filemaker scripting.
I want to create a report which has a selectable period of months. Let's say January to June 2015 - 1501 through 1506.
For each line of the report, I have pairs of data arranged as year+month and a value - such as 1503 and 276 / 1509 and 143 / etc..
There may or may not be data for a particular year+month - or any of the selected year+months
What I am struggling with is placing the appropriate data in the appropriate field under the appropriate heading.
I can do it using some very painful and laborious methods but am wondering if anyone more familiar with Filemaker methods can point me in the direction of a more elegant and simple way of doing this.
Many thanks for any suggestions.