Text display < checkbox set < portal lines?

[Daemon]

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

[Digital Life]

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?

[Daemon]

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 :

[comment]

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.