Raymond Gonzalez Posted February 14, 2007 Share Posted February 14, 2007 Hello! im stuck again, having problems with some parts of a status layout im making. There is one member layout, and in that layout i write in a radio button if the member is a new member or not, and with other radio button if is an active member or not. I want to do a status layout showing how many member we have, how many new members, how many active and how many non active members. Can somebody help me with that?1 thanks! Link to comment Share on other sites More sharing options...
Lee Smith Posted February 14, 2007 Share Posted February 14, 2007 Do you have all of this data broken out into fields now? Link to comment Share on other sites More sharing options...
Raymond Gonzalez Posted February 14, 2007 Author Share Posted February 14, 2007 No. The member layout is all i have. I guess it will be with calculations i get the data i want but i dont really know. Thanks! Link to comment Share on other sites More sharing options...
Lee Smith Posted February 14, 2007 Share Posted February 14, 2007 Planning what kind of things you want the data to keep track of is very important. You should list all of the things that you are asking, and then determin what fields you will need, and how the information will be gathered. Perhaps a type of membership payment and date? Tracking for past due, coming due, etc. Status can be calcualted, or entered or entered by hand. Have you looked at any samples? Lee Link to comment Share on other sites More sharing options...
Raymond Gonzalez Posted February 14, 2007 Author Share Posted February 14, 2007 What i mean by a status is this, maybe i didnt explained it well. This is not the case but let me put the example of a club. Lets say every club member has a personal layout with all his info, but in that info there are two fields if the member is a new member and if the member is an active member. All that i have. What i want is another layout, that will show how many members are in the "club", how many new members, how many active members and how many non active members. Thanks! Link to comment Share on other sites More sharing options...
Lee Smith Posted February 15, 2007 Share Posted February 15, 2007 I want to point out that there is a big difference between Records and Layouts. Records will be holding the individual member's info, and Layouts are where you will be looking at the data. You are using 8.5, and it has Table Occurrences, often referred to here as TOs. The TOs are where you will have Fields, and then you will create your different layouts for data entry, printing, viewing, reports, etc. in the TOs. Unless you have a clear picture of what you want in the database, and the reports that you will want to provide others and yourself, it would be my suggestion that you first research what other have put in theirs. You might end up cherry picking the good things from several examples. I would start be doing a Google search for Club Membership, Non Profit Organization, and Associations software. You could include FileMaker as a Filter, but I keep it broad until you zero in on what you want. HTH Lee Link to comment Share on other sites More sharing options...
Raymond Gonzalez Posted February 15, 2007 Author Share Posted February 15, 2007 Hello! sorry, i have a clear image of what i want; maybe im not saying it correctly. I have in the "member" record, a field in a radio button called "new member", another in a radio button called "active member". I want in a part of the layout to show 1- how many member we have 2 - how many are new 3 - how many are active 4 - how many are not active. The math logic i can imagine it, the part i dont really know is how to get the values. Thanks for any help Link to comment Share on other sites More sharing options...
Lee Smith Posted February 15, 2007 Share Posted February 15, 2007 I made a quick sample of your request, it is not pretty, but it does show the functions you will need. I don't know if I covered everything, but if not, it gives you enough to finish the missing one. HTH Lee RG_Count.fp7.zip Link to comment Share on other sites More sharing options...
Raymond Gonzalez Posted February 15, 2007 Author Share Posted February 15, 2007 thank you very much! it helped me a lot! Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6278 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 accountSign in
Already have an account? Sign in here.
Sign In Now