Create a calc field in Stamps as
Case ( status = "Awaiting" and action = "sign" ; 1 )
In PO Forms 1 (is there a 2?), use
Count ( Stamps::calcField )
as your CF calculation.
There is a PO forms 2
Sorry erolst, could you give slightly more info, in addition, the condition is based on the stamp that is related to the current record of PO forms 1
Many thanks man , i am very much a beginner at this and am not too familiar with the functions
Sorry erolst, could you give slightly more info
I'm not sure what other information there is to give …?
• create a field of type calculation in that table , specifying that exact formula
• use the other exact expression (calculation) to conditionally format your object/field (select Formula is)
in addition, the condition is based on the stamp that is related to the current record of PO forms 1
Looking at you relationship diagram, there could be many (multiple) related Stamps records.
If you are positive that there is only one (the) related Stamps record, then you could do without the calc field in Stamp and directly use
Stamps::status = "Awaiting" and Stamps::action = "sign"
as the Conditional Formatting calculation for your PO Forms 1.
thanks very much i will give it a try,
sorry for not being too clear when i posted the question.
what if i only want the field on PO Forms 1 to be true, when the stamp if for that particular record on PO Forms 1 (which is related by Registers form_ID = id of current??
Have you even tried what I suggested?
i have but it just turned every particular field of the records True. I think its because i still have given calculations to take into the fact that it has to find the stamps for that particular record only ( related by Register::form_ID and the ID for PO Forms 1)
take into the fact that it has to find the stamps for that particular record only ( related by Register::form_ID and the ID for PO Forms 1)
No, FM relationships work cumulatively; in
Parent --< Child --< Grandchild
a parent will only see their on grandchildren; by the same token, looking at your relationships, a Form record will only “see” its own Stamp records.
For your calculation, the crucial difference is that if there can only be one stamp, you can examine that record directly, because both predicates belong to the same (only) record.
If there could be multiple records, you can only do it in a very complicated way (except for ExecuteSQL), because you only ask the first record directly, and if you examine two lists – List ( Stamp::status ) and List ( Stamp::action ) – on whether the respective flag appears, you won't know if positive answers belongs to the same record (which you also could examine, but that is the complication I mentioned above).
The suggested calculation in the Stamp table will have a result of 0 or 1; so if you take a Sum() of all the related Stamp records, and that is > 0, then for at least one of those records your condition is true.
Hope that helps you better understand the suggested strategy.
thanks so much for your detailed explanation. This filemaker is so complicated and as my database gets more complex the more i feel uncertain about my whole database.
it really is confusing me so much because my database knowledge is already very bad. btw In this Stamps and Po forms relationship i had a portal set up and seems working find and showing the stamps correctly , i hope.
So i wonder if i were to push the PO Forms ID to the Stamps table when a stamp is created then the method u suggested would work right ? but that would mean i will have PO Forms ID in three different tables, which is crazy.