Jump to content

1FilemakerMan

Members
  • Content Count

    66
  • 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. I have a table that I need to push a button on and then it will copy data from a cell on another table. That table only has a signature that I need to copy on to this table. It should be so simple, but I can't get it straight. It keeps moving it, instead of coping it. So then next time I try to add the signature to another file it isn't there to add. Here is the simple script command I am using on the button to copy the signature picture from source "Signature_Director::Directors_Signature" to the destination "Subpoenas::Director_Signature". I simply want it to copy that picture fr
  2. I have a script that is going through data and counting how many times a word shows up. It is then taking that number and storing it to a global field. My question it when I display that field, example $$Masters_degree_nursing , how do I have it display that number with commas in it? This is how I have it showing the script results. I which I new a better way to make it look like a spreadsheet or something with lines in there, like an Excel spreadsheet.
  3. WHere do I put the Get (FoundCount) at ? I am searching on the internet and not finding any good examples.
  4. 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
  5. 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 ******
  6. 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?? πŸ˜‰
  7. ?? 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..
  8. 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.
  9. 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 πŸ™‚
  10. Can you use & when doing and IF statement? If WorkForceData::Gender = "Male" & WorkforceData::Question_ID = "Q-000631"
  11. 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 ??
  12. 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, bu
  13. 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" ) ) )
  14. 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
Γ—
Γ—
  • Create New...

Important Information

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