Count Pax in 1 Record

[Dani Rubenstein]

hi

if i have a filed of male name and a female name.

in a calculation filed i want to count if there is two name i will get the number 2 & if 1 of the files is empty i will get the number 1 ?

how can i do this

thank you

[E.J. Sexton]

If the names are on the same line, try WordCount():

Let(

filed="Male Female";

WordCount(filed)

)

If the names are on different lines, try ValueCount():

Let(

filed="Male¶Female";

ValueCount(filed)

)

If the names are in different repetitions, try Count():

Count(Table::filed)

Finally, if the names are in two places, try Not IsEmpty():

Let([

filed1="Male";

filed2="Female"

];

Not IsEmpty(filed1) + Not IsEmpty(filed2)

)

[comment]

Huh? 3 out of 4 answers do not have an input...

Assuming there is a field named MaleName and another field named FemaleName, how about =

Count ( MaleName ; FemaleName )

[Dani Rubenstein]

hi

i am trying to make a report of people that are coming to may wedding that will tell me how menny are coming how menny that are not.....

in the report the summery is not counting the people .

Thank You

wed.fmp12.zip

[LaRetta]

Hi Dani, welcome to FMForums!

Two different people should probably be two different records under normal structures. Can you describe the purpose of the table? In looking up Pax, nothing explains it. :^)

UPDATE. I hadn't seen your last post ... I can't currently download - no computer but invitations to a wedding would qualify as standard structure so they should ideally be two records. Oh, your last post WASN'T there ... I thought I was losing my mind, LOL.

Sent from ipad

[Lee Smith]

I merged your two topics. Please don't multiple post your questions.

BTW, the topic Advanced & Developer Features Topic is reserved for the discussion of the tools that are unique to those editions of FileMaker.

Lee

[LaRetta]

Hi Dani,

I've reviewed your file and, as suspected, you would greatly benefit from a structure change but it is a very easy one. If you create one person per record (and include a Gender field), you will go from Snap Before to Snap After (screen shots below) in complexity and also generate your report Snap Report using (single) summary field to count the RSVPs. Please notice that the report must be sorted by the break field (the field which appears in the leading part, in this case RSVP).

I'm returning your file with these changes and some example records to see how it works. I hope this is useful. You can now also create a report grouping by Gender (how many favors to order etc).

And oh a wedding would be so exciting!! :yep:

wed2.zip

Edited June 3, 2012 by LaRetta

[Dani Rubenstein]

Thank you very motch .

I think that the best way is to go bay family that in the portal there is the children .

is it posable ?

[LaRetta]

Yes, it is possible. But if children in a family can go to the wedding then they should be in the same table as the parents so they can be properly summarized. You can flag each person as either child or adult and assign them to the Household (which would hold the address for invitations or?).

I do not know how much information you are gathering (I am missing requirements). I do not want to provide another demo until I am sure we are heading in same direction. Notice I use word Household instead of Family? Sometimes children live elsewhere from the family so their 'address' might be different; sometimes members who are NOT family live in a household and might attend ... just some things to consider.

Once you can provide me a few clarifications on what you would like, now that you see what is possible, I will put together a suggested approach to move you forward. :^)

[Dani Rubenstein]

Thank you For your help.

i see the wedding planing is hard.

what you recommend sounds the right way to do it.

that every attend will have a record.

The question is who do i mange the invitations the children live with the parents so i what to send 1 invitation for etch household.

Thank you for your help

Dani

[LaRetta]

Hi Dani,

Then you would want a Households table which holds the address and another table for the people (adults and children). Then assign the people to a Household when they are added. You can include field called Type which would indicate whether they are an adult living in the house or a child.

In this way, you can send invitations to the Household but receive RSVPs per person (whether yes, no or maybe). Please see screen shot of fields in each table and how they would relate. If you get stuck, just post ... there are many wonderful developers here willing to assist.

You can also design a layout to fit an ipad or iphone and carry your wedding around with you, using FMGo. It is free. :^)

[Dani Rubenstein]

Thank you very match.

in the report how can i add a count for children attending?

[LaRetta]

Create report in the table where RSVP exists (see example in post #7). If you only want to count children then perform a find for children first or include Type (Adult or Child) as a leading part.