FileMaker Question

[mcarnes]

Is there a way to create a field that does not need to be present in every record? I want the user to be able to input a value, then have FM use that value in a calculation that affects all records.

I know I can just make a field to hold the value, but it seems redundant to have that value in every single record (because it is the same value every time).

I'm using FMv8. Any help appreciated.

 

[BWhaler]

I don't believe so.

 

[ahunter3]

Is there a way to create a field that does not need to be present in every record? I want the user to be able to input a value, then have FM use that value in a calculation that affects all records.

I know I can just make a field to hold the value, but it seems redundant to have that value in every single record (because it is the same value every time).

I'm using FMv8. Any help appreciated.

Do you mean that, let's say you have a table of Students that you teach, where each record is a different student {John Jones, Cindy Reynolds, Virginia Smith, etc}, and you want to be able to enter just once into a field some value, let's say the name of today's exam {"Exam of 6.20.06"} and then have a calculation field calculate a value for each record based in part on that one value — e.g., "John Jones | Exam of 6.20.06" for John Jones, "Cindy Reynolds | Exam of 6.20.06" for Cindy Reynolds, etc. ...?

Yes, the first field is set to be stored as a GLOBAL value (see the Storage tab in field defs). The second field would be a calc field that references that global field as one of its parameters.

 

[ahunter3]

I should add that you can also have the calculation exist as a global value — Let's say you want a calculation based on the exam name and the professor's name (your name) and those things are identical at the moment for all occurrences of your students and their taking of the exam. Both the text globals (for your name and exam name) and the calc field (which concatenates the two) are stored as global values, one value per the table instead of one per record.