"If""IsEmpty""IsValid"

[max ny]

Dear FileMaker Guru:

I was asked to revise a FileMaker v.6 Report Tracking DB, hosted on v.5.5 Server.

On the "Entry" Layout, users can enter "projected" total page number to the "Page Count" Field. The value will be replicated to the "TotalPageNo" Field in the "Tracking" Layout, where all sorts of information of the report are monitored.

Now, I have received a request: Create a new "Finalized Page Count" Field for the manager, only, to enter the "Finalized" total page number into.

If the "Finalized Page Count" Field is empty, current replication stays. If the manager enters, in this field, an "final" number, which will updates and locks, beyond modification, the "TotalPageNo" Field in the "Tracking" Layout.

Help, please! How to utilize "If""IsEmpty""IsValid" Logical Functions to implement the new replication?

regards,

Max NY

[Søren Dyhr]

Put all the field names into a calc'field containing this equation Count(field1;field2;field3;field4)=4 as number ...if say the record holds 4 fields, then make a summaryfield summing this calcfield's result which is either 0 or 1. Where all the the completed records obviously shows 1 in the logical statement.

Since your profile exhibits access to fm7, could you investigate this template - and then transfere the approach to the fm6 solution.

--sd

voidance.zip

[max ny]

Dear SD:

I have not quiet understood the correlations between my asking about The Logical Function""IsEmpty"" and your "Voidance." Please elaborate!

Thanks!

Max NY

[Søren Dyhr]

Perhaps I havn't understood your question right? I admittingly grasped for a straw in it! Explain a little more of what you wish to achieve. That is rephrase it sligthly....

--sd

[comment]

I don't understand the question either - especially the "replication" thing.

[dazlunn]

Are you saying that if the FinalizedPageCount field has no value populated in it by the manager that further modification of the TotalPageCount is allowed, but when the manager enters a final page count into the FinalizedPageCount field that nobody can be allowed to further modify the other fields?

I think it's a calculated field validation that you are looking for? So that when someone tries to enter a new record after the 'Finalized' field is populated the system prompts an error... Am I close??

[max ny]

Dear SD:

Thanks for your reply! It is a v.6 DB.

I talked about "replication." I meant: On the "Entry" Layout, users can enter "estimated" total page number to the "Page Count" Field. The value will be propagated to the "TotalPageNo" Field in the "Tracking" Layout, where all sorts of information and progress of the report are monitored.

You are right=>=>

"I think it's a calculated field validation that you are looking for? So that when someone tries to enter a new record after the 'Finalized' field is populated the system prompts an error... Am I close??

"

Thanks!

Max NY

[comment]

I am afraid it still doesn't make sense to me. Is this in the same file? If yes, what's the point in "replicating/propagating" data from one field to another? Couldn't you just put the same field on both layouts?

Here's an idea: two fields, Value and Status. User enters a value and selects a status of "Estimate". Another user changes the value, and switches the status to "Final".

[Søren Dyhr]

I'm still trying - perhaps this way:

http://www.filemakerpros.com/LOKFIELD.zip

--sd

[max ny]

Dear Veteran:

The “Entry” Layout is for data entry. The “Tracking” Layout is geared toward offering a quick glance at all of the aspects of the status and progress of the project: more like for display and read only.

Thanks!

Max NY

[dazlunn]

That's a great tip! I never thought of using current time to validate a field and prevent mod.. I'll definately be using using that one.. thanks!

[comment]

Dear Newbie: what you have there is a non sequitur. You can have as many layouts as you want, and they can all use the same fields. There's no need to "replicate" or "propagate" data into another field, just because you want to put it on another layout.

[max ny]

Dear SD:

I do appreciate you effort!

regards,

Max NY

[Søren Dyhr]

Is this an invitation to give it yet another stab, since I havn't been hitting particular well - or??

--sd

[max ny]

Dear SD:

You are great! Your formula works on v.7 or higher!

Not on v.6 or older!

Awesome!

Max NY

[Ender]

Dear SD:

You are great!

Let's not get carried away here! :)