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 🙂