Does "Create a web page" mean that you are using instant web publishing?
The format you have specified is not easy to produce in FileMaker, but can be done. If you could use a layout that produces a single column of this data, it's much simpler.
What you describe is often called a "cross tab" report. Instead of just performing a find on your database, you'd use relationships and portal filters to pull up data in a list view layout where all or most of the data is displayed in one row filtered portals. The relationships and filters would use the criteria specified by the user to produce this report.
How exactly you might do that would require detailed knowledge of how you have currently structured your data in tables and relationships.
Thanks for the quick reply.
Instant web publishing would be best. I need to post the page and keep it current so students can see which classes are full and which are not.
I can uderstand that a single column of data would be easier to produce but it would not be as easy for the students find their workshop and see which classes are available. I only have to set it up once so I think it would be worth the effort. I'm the only user. The report would always do the same thing. But the number of workshops and classes for each workshop would vary.
Is there documentation somewhere on how to do this? I can't find cross tab reports in the FM help file. While I'm new to FM I'm familiar with relational database concepts and understand the idea of portals. I just need to learn the terms like "cross tab reports" so I know what to look for in the resource material.
I wouldn't mind paying someone to do this if that's a reasonable option.
You can search this forum for a number of threads that discuss cross tab reports.
A number of us take on consulting projects for $$ you can Private message someone (Click their icon), if you want.
If a student is looking for their workshop, wouldn't this layout work for that?
Class1 Time Teacher
Class2 Time Teacher
Class3 Time teacher
In other words, a student enters their id info and the system lists all classes, teachers and times for that one student. There doesn't seem to be a need to see all the students listed in each class and if so, that greatly simplifies the details you need to list.
A Lightweight Cross-Tabular Data Entry Method February 21, 2011
Shifting Columns in Cross Tab Reports
Fiscal Year Invoice Totals In A FileMaker Crosstab Report
Do not know if this download is useful.
Thanks but this is before the students have signed up for a class. At this point the students are looking to see which workshops are offered, what their schedule is, who's teaching it and whether it's full yet or not. So they need to be able to see the whole schedule or at least all the classes for the workshop they're planning to take.
But it looks like what I had in mind is more trouble than it may be worth. So I think I've come up with a way to handle it that won't require a cross tab report and should simplify it considerably. If that turns out to be harder than I thought I'll look for someone to take on a consultig project and help me out.
But do they need to see the individual students listed? Why not just a number showing how many are enrolled or a status indication that the session is or is not "full"?
That's part of the new solution I came up with.
Now I just have to list all the workshops with their teachers and times and a number of vacancies.
Although the students do like to see what class their friends are in to get into the same class but they'll have to work that out between themselves.