# Counting values of feilds in one record.

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

## Recommended Posts

• Newbies

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

##### Share on other sites

quote:

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

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

##### Share on other sites

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

## Create an account

Register a new account

• ### Similar Content

• #### Speeding up FMPServer 3.x

By Jotel,

• 2 replies
• 1,139 views
• #### damaged or access priviledges tampered with

By donwolf93,

• 0 replies
• 1,254 views
• #### Find - Begins With??

By Norbert Wells,

• 1,552 views
• #### 4.1 Database to Web Page w/ find

By Chip Wallace,

• 2 replies
• 1,198 views
• #### FM Crashes

By Kymberlee,

• 2 replies
• 1,477 views
×
×
• Create New...