dear helpers i attached a file i want all the male people searched in a table and the found number of males number should be displayed in other table please need help please

OP CLIENT.fmp12

 

tried some scripting in op client 2 my medical brain is heating up please sum1 help me

OP CLIENT 2.fmp12

Edited October 6, 20169 yr by Dr.Gopala krishnam raju AMBATI

I see you have a portal where the field SEX is listed as MALE or FEMALE.

To start with let's get a list of the values:

List ( OP CLIENT::SEX )

Now let's take that list and show just the males:

FilterValues ( List ( OP CLIENT::SEX ); "MALE" )

Now all that's left to do is count them:

ValueCount ( FilterValues ( List ( OP CLIENT::SEX ); "MALE" ) )

 

8 hours ago, Fitch said:

I see you have a portal where the field SEX is listed as MALE or FEMALE.

To start with let's get a list of the values:

List ( OP CLIENT::SEX )

Now let's take that list and show just the males:

FilterValues ( List ( OP CLIENT::SEX ); "MALE" )

Now all that's left to do is count them:

ValueCount ( FilterValues ( List ( OP CLIENT::SEX ); "MALE" ) )

 

hip hip hurray thank a lot sir its working

sir for multi field i did like this working perfectly

ValueCount ( FilterValues ( List ( PRESCRIPTION::N1); "ROSAVE" ) )  +  ValueCount ( FilterValues ( List ( PRESCRIPTION::N1 Copy); "ROSAVE" ) )   +  ValueCount ( FilterValues ( List ( PRESCRIPTION::N1 Copy2); "ROSAVE" ) )+  ValueCount ( FilterValues ( List ( PRESCRIPTION::N1 Copy3); "ROSAVE" ) )+  ValueCount ( FilterValues ( List ( PRESCRIPTION::N1 Copy4); "ROSAVE" ) )+  ValueCount ( FilterValues ( List ( PRESCRIPTION::N1 Copy5); "ROSAVE" ) )+  ValueCount ( FilterValues ( List ( PRESCRIPTION::N1 Copy6); "ROSAVE" ) )+  ValueCount ( FilterValues ( List ( PRESCRIPTION::N1 Copy7); "ROSAVE" ) )+  ValueCount ( FilterValues ( List ( PRESCRIPTION::N1 Copy8); "ROSAVE" ) )+  ValueCount ( FilterValues ( List ( PRESCRIPTION::N1 Copy9); "ROSAVE" ) )

is there any another method

Edited October 7, 20169 yr by Dr.Gopala krishnam raju AMBATI

And there we are again: 

All the impossible to report on, poorly structured fields that make your file such a disaster to work with. N1 Copy 2, N1 Copy 3, etc. 

You were given the answer to that last time.

Build a properly normalized database, most likely by hiring somebody competent.

Edited October 7, 20169 yr by BruceR

i would love to hire u bruce but ur very far to consult

Edited October 7, 20169 yr by Dr.Gopala krishnam raju AMBATI

It doesn't have to be me. I am not offering to do it. I doubt that I would accept.

But remote development CAN be done. Cleaning up your file would not be difficult.

The problem is getting YOU to agree to have somebody fix your problems.

I am sure that there are things in your medical field that would be difficult and overwhelming for amateurs to accomplish.

You are trained, you have experience, you can do those things; even if they are difficult.

Your patients should have YOU fix their broken bones. They should not talk nonsense to you about how it should be done.

You should have somebody who knows what they are doing fix your broken database. 

You should not do it; you should not talk nonsense about the job; you should not argue with a room full of experts all saying the same thing.

 

7 hours ago, Dr.Gopala krishnam raju AMBATI said:

i would love to hire u bruce but ur very far to consult

There are Certified Developers all over the world, perhaps you can locate one using this link.

http://developer.filemaker.com/search/

Lee

Yeah, it's hard to advise you without knowing more about your structure. What are all those copies of N1? Same base table?

12 minutes ago, Fitch said:

What are all those copies of N1?

That's a good question:
http://fmforums.com/topic/100442-multi-field-search/

 

i might be wrong in asking help will be with back with clear question

Edited October 8, 20169 yr by Dr.Gopala krishnam raju AMBATI

You are the confused one. Nobody has recommended renaming them.

You need to COMPLETELY DELETE them and build a properly normalized database.