Dr.Gopala krishnam raju AMBATI Posted October 6, 2016 Share Posted October 6, 2016 (edited) 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, 2016 by Dr.Gopala krishnam raju AMBATI Link to comment Share on other sites More sharing options...
Fitch Posted October 6, 2016 Share Posted October 6, 2016 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" ) ) 1 Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 7, 2016 Author Share Posted October 7, 2016 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 More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 7, 2016 Author Share Posted October 7, 2016 (edited) 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, 2016 by Dr.Gopala krishnam raju AMBATI Link to comment Share on other sites More sharing options...
bruceR Posted October 7, 2016 Share Posted October 7, 2016 (edited) 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, 2016 by BruceR Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 7, 2016 Author Share Posted October 7, 2016 (edited) i would love to hire u bruce but ur very far to consult Edited October 7, 2016 by Dr.Gopala krishnam raju AMBATI Link to comment Share on other sites More sharing options...
bruceR Posted October 7, 2016 Share Posted October 7, 2016 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. 1 Link to comment Share on other sites More sharing options...
Lee Smith Posted October 7, 2016 Share Posted October 7, 2016 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 Link to comment Share on other sites More sharing options...
Fitch Posted October 7, 2016 Share Posted October 7, 2016 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 More sharing options...
comment Posted October 7, 2016 Share Posted October 7, 2016 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/ Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 8, 2016 Author Share Posted October 8, 2016 (edited) i might be wrong in asking help will be with back with clear question Edited October 8, 2016 by Dr.Gopala krishnam raju AMBATI Link to comment Share on other sites More sharing options...
bruceR Posted October 8, 2016 Share Posted October 8, 2016 You are the confused one. Nobody has recommended renaming them. You need to COMPLETELY DELETE them and build a properly normalized database. Link to comment Share on other sites More sharing options...
Dr.Gopala krishnam raju AMBATI Posted October 8, 2016 Author Share Posted October 8, 2016 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2849 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