Hello all

First of all hello to all, new here and new to Filemaker (as you will understand lol)

I would like to ask for an idea on how to make something to work and if its possible.. it might be a bit complicated (or atleast to me it is)

Ok, here's my problem.. I have 3 tabs, on first tab i want to display a text field RANK1 (will get to this). On second tab i have a checkbox (Box1) of 5 values (Val1, Val2, Val3, Val4, Val5) and on 3th tab i have a portal in which i will write some things.

What i want to do is, based on how many lines i have on portal to autocheck Val5. Also some of the Val's will be hand checked.. When all 5 Val's are checked i want to show on the first tab Rank1 and so on.. after the first Box1 is filled will go to Box2 which after its filled will show Rank2.. (i hope i made it understandable, english ain't my language). Portal, checkboxes and text field are in 3 different tables which are connected with a serial id made on creation of record..

I think im way over my head here

Thank you in advance :P

The Rank field could be a calculation field which uses the Case function. It would be something like:

Case(not IsEmpty(Val1) and not IsEmpty(Val2) and not IsEmpty(Val3);"Rank3";

not IsEmpty(Val1) and not IsEmpty(Val2);"Rank2";

not IsEmpty(Val1);"Rank1";

"")

I have left out Val4 and Val5 but you get the idea. Does this help?

No not really (told you im way over my head lol)

Basicly what im trying to do is, tick a checkbox based on a count() number which counts the rows in a portal.. If the count() gives 5 it will check that box.. After that when all the check boxes are filled it will change the rank on another page..

Mayb your code helps but i couldnt make it work (new at programming). And also i think im doing it wrong, maybe i should learn about conditional values.. since all the values i have are custom ones

Thank you for taking the time :

Perhaps you should explain what is the purpose behind all this. The basic flaw in your proposed method (as far as I could understand it) is that counting rows in a portal is a calculation, while ticking checkboxes is a user action. These two do not mix well in the same field.

It may be possible to check the count when user modifies the field, and auto-enter a combined value. However if the count changes (by adding or deleting a related record) nothing will happen to the field, unless it's an unstored calculation field - and users cannot modify a calculation field.