Jump to content

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

Recommended Posts

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 by Dr.Gopala krishnam raju AMBATI
Link to comment
Share on other sites

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" ) )

 

  • Like 1
Link to comment
Share on other sites

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 :)

Link to comment
Share on other sites

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

2016-10-07 09_23_56-FileMaker Pro Advanced - [GKRs-PRESCRIP].png

Edited by Dr.Gopala krishnam raju AMBATI
Link to comment
Share on other sites

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 by BruceR
Link to comment
Share on other sites

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.

 

  • Like 1
Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 2754 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.