Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 6245 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted (edited)

hello everyone, I need to display the current number of active members..

i have a field "Estado" where it displays if the members is active or not...

If ( Fin de Membresia ≥ Get ( CurrentDate ) ; TextColor("OK";RGB(0;128;0)) ; TextColor("NO";RGB(255;0;0)) )

i dont know if the "Socios Activos" (Active Members) can be calculated by looking up the word OK.. and then display the total number that the word OK appears on member profiles in the Estado field?

all help is greatly appreciated!

Edited by Guest
tried to explain myself a little better
Posted

I prefer to create what I call a flag field for these kind of record qualifications. So, I'd change your field to:

flag_StatusActive = if ( MemExpireDT >= get (currentdate); 1)

this must be an unstored calc, bcs you need get (currentdate) to update.

Now, create a summary field in members,

TTLActive = Total of flag_ActiveStatus

Unfortunately, this will be slow, because it is an unstored calc.

You also can create a selfjoin relationship from members to members (cartesian) and then create an unstored calc = sum ( selfjoin::flag_ActiveStatus).

  • 3 weeks later...
Posted

I'll need some more detail to help. When you say, nothing shows up on the fields, which fields? What did you create? Any of the fields that I recommended? Can you post a copy?

This topic is 6245 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.