Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 4469 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I actually got this information a while back from this forum and it works fine. My question is trying to understand how it works. If anyone can help me and explain this in English, I would appreciate it. Let me explain what I have.

In brief, I have two related tables, students and grades. There are multiple grade records per student. My objective is to get a printout by class of the students and their courses and grades. The heading has the names of the courses, the body has the last and first name followed by the grades directly under the course name. In the grades table we have the student_id, course name and grade, one record for each of the students courses that they are taking. In the student record I have the following fields:

Student Last and First Name

Student Class

Course_names = list(grades::course name)

Grades=list(grades::grade)

CourseNameList=getvalue(extend(course_names);Get(CalculationRepetitionNumber))

GradesList=getvalue(extend(Grades);Get(CalculationRepetitionNumber))

My layout:

Subsummary by class - has the class and the listing of courses across the top (each course thinned out into a small area but a few lines worth from top to bottom so you can read the course - this is to match the size that each grade takes up directly below each course name)

Body - last, first and a line of all the grades that correspond to the course names on top

Next class goes to next page.

Now, this all works fine. My question is to understand in English what the calculation for coursenamelist and gradeslist is doing. I read the help files, but I'm just not catching on.

I would appreciate it if someone can help me out. It's a long speech but I only need to know exactly what's taking place in a single fields calculation.

Thanks,

Mike

Posted

My question is to understand in English what the calculation for coursenamelist and gradeslist is doing.

The calculation takes a return-separated list of items, and places each item in a separate repetition of a repeating calculation field.

actually got this information a while back from this forum

A link would be useful. In fact, why don't you ask for clarifications in the same thread?

This topic is 4469 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.