Counting values of feilds in one record.

[Sutter's HomeStead]

I'm a longtime user of FM Pro but I must admit I only use it in a limited fashion. I would like to chat with other users of FM Pro to better understand the finer points. I am a teacher in the Detroit Public Schools. (Move to the burbs from the northern part of Michigan.) I have a M.Ed and a BS in Computer Physics. If their are members of your group that would like to share some thoughts and tips/pointers, please pass on my info.

I am looking for information on how to do the following:

1. Count the number of answers T/F, Yes/No (ie: in ten fields on the same record and create a percentage output.) This is so I can create an online test with correct answer feedback. VIA html format.

2. Play sounds and QuickTime movies in FM Pro. (Is this even Possible?)

Thanks in advance if you can help,

Using version 4 right now,

Bernie

[email protected]

[Chuck]

quote:

---

Originally posted by Sutter's HomeStead:

I'm a longtime user of FM Pro but I must admit I only use it in a limited fashion. I would like to chat with other users of FM Pro to better understand the finer points. I am a teacher in the Detroit Public Schools. (Move to the burbs from the northern part of Michigan.) I have a M.Ed and a BS in Computer Physics. If their are members of your group that would like to share some thoughts and tips/pointers, please pass on my info.

I am looking for information on how to do the following:

1. Count the number of answers T/F, Yes/No (ie: in ten fields on the same record and create a percentage output.) This is so I can create an online test with correct answer feedback. VIA html format.

2. Play sounds and QuickTime movies in FM Pro. (Is this even Possible?)

Thanks in advance if you can help,

Using version 4 right now,

Bernie

[email protected]

---

For counting the answers: let's say you have ten fields called Question 1 thru Question 10. It's a long calculation, but you could do the following:

(not IsEmpty( Question 1 )) +(not IsEmpty( Question 2)) + ... + (not IsEmpty( Quesiton 10))

I don't know if this is what you're looking for, but it will give you a total of the number of fields with entries in them.

Regarding sounds and movies, yes, FileMaker can store them. They are stored in container fields, and for movies you import them. For sounds, you copy and paste them. Sounds can be stored within the database itself. Movies will only store a reference to the actual file, so if you move the original file, the field will not be able to find its data.

Chuck