1FilemakerMan

I am not even sure if scripts is the right way to go, but here is my question. We have a huge database with questions that were asked. Each user has, lets a social security number. We want to put all of their answers together in different columns. So there are about 20 different questions that need to be pull out of that data per person, and then put into a report, or another table so we can view all of the users, vertical, and all of their answers to the questions, horizontally(the columns names). How is this possible? example: One table has all of the names in it with their SS#. Each question has their Name and SS#, so the SS# could be the part that joins the tables together. I now need to bring the data in to the Question fields that they answered. How do I make the question columns pull the data out of the database? Name State Zip Male/Female Education Job Title Question1 Question2 Question3

I have several container fields in my database and I would like to set them up so that when a file is dragged into them it automatically renames it. Each container field will rename the file dragged into it in the accordance of the field it goes into to. Example container field1, renames it to Field1.zip, container 2, Field2.zip, etc..... I have the script set to go off in set script triggers under OnObjectModify. I know the path where the file will be stored. I just can't seem to get it to figure it out. Do I need to use the "rename file" command in a script? I am trying this and it is telling me it Rename File [ : "change.log" ; New name: "change1.log" ]

Ok, will I think I will look into doing it the way you suggested. I could then display the fields in a related table try it that way. You are very much way better at this program than I will ever be. I will work on moving things over to another table.

There has to be a simple way that on click it simply starts to download the contents of the "Container Field" clicked on.

Button or label. They will be clicking one of the four Container Buttons to download the item. I am fooling around with something like this right now. But it is not seeing the object in the container field to download. It just creates a text file.

I would rather keep them in this table, since that is basically what it is. All this FM database does is lets one person upload files from one layout and then other people download files from another layout. I would like to capture the name of the button they click on, and then from there download the file associated with it. I am wondering if the Get ( ActiveFieldTableName ) would work?

Hello! I have written scripts to download when the button is clicked that it will download the file associated with that button. HOWEVER, is there a simple way to write a script to simple download the file associated with a button pushed, instead of writing a script for each button, will be over 50!!! A user can only click on button at a time, and each button has its own container field. I put a screen shot of the menu they will see, and a copy of the script I am using per button. Could I just have a general script to start once the button is pushed to get the name of the button and then download that file associated with it????? Thanks a million!!!

Thank you for the link, I have never done this before. It takes it about 30 seconds to go through and remove the checkmarks, but it does work. Thanks.

Sorry but I am not understanding what you are saying, I am still new to FM. I have a query that takes all records that have been checked and then writes them to a PDF file which is then emailed out, which is awesome :-)! Then I simply need to uncheck the checked records, how is this not some simple line in a script?

It is not a global field. I could easily do that and make it a global field it that will work. There will be less than records in the inventory field. So it is not a big database. When I make it a global field all of the records in that database become checked at once, so I DO NOT want global field. So how do I just clear all the records from being selected? I don't want to have to manually uncheck them each time.

I have a script to email a list of selected items, which works great! But the check boxes stay checked after I run the query, how do I clear them?? With my other fields I simply do a Set field [inventory::Email_Info ; "" ] and it clears out the data, that doesn't appear to work with my checkbox field. This must be a simple fix to clear out all checks, but I can't figure it out, please help 😉 THANKS!!!!

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 from one table to another. What is wrong????? It seems to only happen now when I exit the program and go back into it. I am totally lost!!!!! 😞

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.

WHere do I put the Get (FoundCount) at ? I am searching on the internet and not finding any good examples.

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 🙂

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!

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?? 😉

?? 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..

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.

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 🙂

Can you use & when doing and IF statement? If WorkForceData::Gender = "Male" & WorkforceData::Question_ID = "Q-000631"

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 ??

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

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