I'm struggling a lot switching from Excel. I do VBA well, and I can build a chart because I can directly access all the parameters. I do see that freedom in Filemaker. I was hoping for some help to translate my skills into Filemaker. I can create a chart manually, but not with a script.
See 3 tables below / ERD. Not shown are two layouts, let's call them View and Chart.
What I want is to enter info in Parameters, then run a script to sort and filter based on the entries in Parameters.
I could adjust to show related records in View. But even if I did, how do I set the x and y-axis or the chart type?
Is there a way to dynamically set those with a script?
(ps. if there's a link or video that walks through something like that, I'd be open to it. I have looked around and haven't been able to find anything. Also, it would make sense to do this with SQL, but then how do I apply that to a layout so the chart will react?)