Jump to content

1FilemakerMan

Members
  • Content Count

    59
  • Joined

  • Last visited

Community Reputation

0 Neutral

About 1FilemakerMan

  • Rank
    member

FileMaker Experience

  • Skill Level
    Novice
  • FM Application
    16 Client

Platform Environment

  • OS Platform
    Mac
  • OS Version
    macOS Mojave, 10.14.6

FileMaker Partner

  • Certification
    Not Certified
  • Membership
    FileMaker TechNet

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. WHere do I put the Get (FoundCount) at ? I am searching on the internet and not finding any good examples.
  2. OK, I found a way to display/count the number of males and females without any duplicate records! Now how can I take that number and store it as a $$Global_field, so that I can display the results in a report. Ok, to get the number I simply created a Script that does the "Perform Find" function. Inside the perform find function I can filter out what I need to, to get the amount of males and females. Question is, can I take that total and put it into a Global field and display it? Right now I have a button to push in the report to activate the script and it then displays it, but I would like to display both totals, for male and females, on the same page at once. Thanks again gentlemen πŸ™‚
  3. So I did some googling and found the "Set Field" command. I am trying to push the numbers from the global variables over to the set field areas. Not quite working yet. I put them at the bottom of the script. When I click on my shortcut block to execute the script I get a strange square like icon that pops up, and nothing happens. I have a Macintosh machine, I don't know if that is supposed to be like an hourglass or what, but I seem to get nothing. 😑 I tried to capture how it looks, but I obviously can't. I feel like I am so close to getting the ******* count of how many Male and Females there is. After that, boom it opens up the door for me to understand how to do all of these ******* queries!
  4. Ok, I did that, and thanks for clarifying it by the way!!, and nothing is popping up. I was hoping to click the button, run the script, and it would count the numbers for me of how many males and females we have. the $males and $Females total. Could I make $males and $females global and just show their numbers?? πŸ˜‰
  5. ?? Thanks for your help first of all!!! But could you please be more precise? Remember, I am a rookie, πŸ™‚ . I don't see where it says to go to the last record, and where I would put "Exit after Last" turned on . SORRY, could you give example, or tell me where to put that?? I am google searching now..
  6. It is supposed to go through that WordForceData table and count how many times when the field Gender = Male and the field Question_ID =q-000631 WorkForceData::Gender = "Male" and WorkForceData::Quesiton_ID = "Q-000631" I just ran it and It looks like it is locked up, won't stop running.
  7. If [WorkForceData::Gender = "Male" and WorkForceData::Quesiton_ID = "Q-000631"] $Male + 1 ^^ Could that work, $Male of course being a variable. I am going to give this a try πŸ™‚
  8. Can you use & when doing and IF statement? If WorkForceData::Gender = "Male" & WorkforceData::Question_ID = "Q-000631"
  9. I have a database that was imported from an Excel spreadsheet. It has rows of repetitive data in it. I simply need to do some query searches in it to pull the data out. Users where asked questions, and obviously there are answers. Each question has a unique label on it πŸ˜€, and each user has a unique ID NumberπŸ˜€! So my question(s) is, how do I get both fields, QUESTION_ID and RN_NUMBER to both come up to show me the question and answer? Do I create a script that has in "IF" statement and then another "IF" statement inside of that ??
  10. I want to get a count/total for each of the questions these people were asked. One of them just happens to be what Gender are they, what Ethnicity are they, etc.... I just need to take that data and create pie charts. All of this data is imported from an Excel file into FileMaker Pro, roughly 50 questions per person, and about 1,500 people. 1. Each question has a unique question ID. 2. Each person has a Unique ID So I need to find a way to take each person's answer to each question and get total. For Example: This gets me the total number of times "Male" appears, but I need to make it unique to the field of RN_Answers::QUESTION_ID = Q-034496. ValueCount ( FilterValues ( RN_Answers::sListGender ; "Male" ) )
  11. Sorry that I am losing you!!!!! Each question has a unique ID number. So basically under filtered values I would like to add a third value, which it won't let me, or I just can't figure it out. (RN_Answers::QuestionID; "Q-034496") is What I need to add, so it is referring to this quesiton_ID. didn't work either. ValueCount ( FilterValues ( ( FilterValues (RN_Answers::sListGender & RN_Answers::QuestionID ; "Q-034496") & (RN_Answers::sListofAllQuestions; "Male" ) ) )
  12. I don't understand your reply? They have Unique Id's, but they appear several times over in the rows for each question they asked. I found that each question has a unique ID and that is what I need to use to help with the totals. Unique_Question_ID per each RN_Number
  13. The only problem is that the ID field has the same ID in it for however many questions they answered. It is a mess how they did this. Ok I found one way to filter out the questions!!! Each question has it's own unique question ID! RN_Answers::RN_NUMBER And RN_Answers::Gender AND QUESTION_ID So if I take the RN_Number and make it Unique to the Question_ID, we should be able to do it. Now my mind is going crazy on how to add the field Question_ID in there to separate out the answers.
  14. OK, I was out sick for a few days and now I am back. Basically I have rows of data that I need to get the answers from. I need to narrow the answers down to only getting one answer per person I need to narrow the data from RN_Number and then field I want the data from. Example: Find out how many male nurses their are. RN_Answers::RN_NUMBER And RN_Answers::Gender I am not sure if I need to somehow put UniqueValues ( values {; datatype ; locale } ) Into my valuecount formula or what???? This is what I am currently using, but it doesn't stop duplicates from coming in to the count. ValueCount ( FilterValues ( RN_Answers::sListGender ; "Male" ) ) So again, PLEASE HELP πŸ™‚
Γ—
Γ—
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.