Script Workspace and Script Triggers

Here's my situation. We have a DB or items listed on ebay. If you're familiar with e-bay, then you know that each item is given an ID number, and this is how we do the majority of the tracking in our database. When an item doesn't sell, the record is set as "completed" (for tracking refrence), and is duplicated and set to "pending repost", etc, etc. The ID number from the completed auction is copied into an "old id" field in the pending repost record. I'd like a way to essentially see how many times an auction has been posted w/out selling. The idea is to take the old Id number, look up the previous, if there's a number in that old id field, repeat the number of…

Hi I have a large database which will be broken into many many files eventually, I know that in the scriptmaker you can prename a file for saving . I would like to know if there is a plug-in or another way to name the new file with a field name so it could be done automatically and accurately. Thanks Dave

Hi I am having a problem breaking up and address field that was pasted into filemaker. I want the field to be broken up into city , state and zip but here is the way the data is: Oneida, NY 13421 Massapequa, NY 11758-6026 New York, NY 10019-1022 New Hyde Park, NY, 10001 So I can't do it by middle words, , I can't do the zips by right words, because sometimes the zip is zip +4 which constitutes another word. How can I consistently break up the address line into the three fields with a script? Thanks in Advance Dave

Thanks to everyone here I am getting my text calculation right The last thing I don't understand is how to remove something extra I ended up with a field in my address calculations that contains the county name and the county code. I want to eliminate the county code which is always 7 characters including the parenthesis in the front and back . for example Orleans (36073) I want to remove the county code at the end only I am not sure how to do this Thanks Dave

Some nimwit user has created an excel spreadsheet that i am now trying to import into filemaker. My problem is this... they have a cell for the name of client i.e Joe Bloggs, but for data manipulation, when i import, i want to separate this into two fields i.e. first name Joe and surname Bloggs. even if i could bring it into one field, and then from that field perhaps extract the first name / surname using the "-1" type function??? otherwise I am sending the user back to their excel spreadsheet to manually fix.. hehehe

I have put a portal in my customer dr that showes the names from by contact db. When i press button on name it goes to that person name in my contact db. great! The problem is that when i go back to customer db it always show the first person in that account db. I would like to be able to show appox 3portals on dbcustomer and be able to select a different person from the contact db and the names in the portal would stay has selected. 1-portal - aaaaaaa 2-portal - bbbbbbb 3-portal - ccccccc hope this helps, so if i select portal 2 i would go to bbbbbb in my contact db and when i finish and reture to customer de. portal 2 will still be the same bbbb…

Hi - this is from a previous thread "script to change Y/N fields" - to clarify: Properties file has a portal which displays images for that property based on the relationship propertyID::IPropertyID. The ::Image (s) displays in the portal. What I would like to do is be able to script a "set as default" button next to the image(s) in the portal so that the user can see all the images for that property and set one of them as the default image, and have the changes recorded in the images file (default image?=Yes, all other images for that PropID show default image?= No). I already have rlnshps (and fields) in both files (maybe it is unnecessary to have them in both…

Alright - here is my situation. I've set up a small table that has two columns, one that has a field name, and the 2nd to tell what data to set the field to (usually from a separate main database or a calculation of such). How would I write a script to do the following - 1) find the first field on the page (layout), find the corresponding field name in the above mentioned table, and set the field on the layout to the data (2nd column) in the corresponding table. 2) find the next field on the layout, and do the same thing as #1 3) loop this process until it sets the last field on the page, then stop. I know there is a way to do this , but haven't been able …

Hello everyone I am having a problem with a counter see example below Set Field ["Count Field", "Count Field +1"] If ["Count Field >5"] Perform Scripts [sub-scripts,"run today"] Set Field ["Count Field", "0" End if All it does is set the count field to "0" and nothing else if i look in the global field count field it does not go up in number 1,2,3,4,5 it is just set to '0" All i really want to do is execute a script after the file has been opened a number of times on shut down based on if a certain number has been reached am i on the right track Thanks for any help i may receive in advance

What i would like to do is copy certain fields from 1db to another db, and from the second db those fields that were copy to, the db's are related by account#, i then would like to be able to sort by the different account# and pring only info for that perticular account#. It would be nice to be also be able to sort by date and time, like print report for account# from date (what ever date i would put in to the present date and time. Any suggestions would be greatly appricated. thanks, jim

I am using a series of ten layouts. In the first layout the user is to fill in the basic information such as customers name and phone number. In the second field the information from the first layout is displayed but entry to the field is denied so that it cant be changed from what the original information was. For security reasons the average user can't access the second layout, but anyone can access the first layout to fill in basic information. In the second layoout there are fields that are not available in the first layout and this is also the case in the third layout where there are fields that are not available in the second layout. At the end of each layout I …

Hi all, I would like to show records in a portal that fall between a user definable date (month) range. The start date would always be the current date and end date would be a user definable month. The related file does have a date field called "end date". ie. Show me the records between now and 3 months. Could this also work in reverse ie. Show me the records between now and the last 3 months. Thanks in advance Ian

Hey Folks! Looking to this killer resource for some more info. Is there a way to get a reprt of scripts that are currently in use in a FM file? My scriptmaker window is so full of testers, etc.. and as I clean up, I don't want delete some forgotten but vital scripts. Anyone?

In table view I have similar information sorted by ID#. I need a script that will identify the first record of each set of similiar ID numbers. Those identified records will become a "found" set. ID #-------- Name-----------Field3 234567--- John Smith---blah..blah

I have a script IF statement that if a numeric fields contents is between two specified values it performs a calculation, should be easy but cannot figure it! I.E If value is >10 and <=20.

Hi All, I'm a newbie working on a past due script. What I would like to do is to set it up so that when I perform the script it finds all records that have an invoice date from 18 months ago to the present. How do I do this without have to restore the find each time? Thanks! Sarah

Please help, I have still have 2 db's, customer and contacts, I need a list of my contacts to appear on customer db, so I can select the right contact person to go to, and when i push button it will go to that contact person only. Custmer db account# is related to contact account#, to keep the different customers seperate, only showing their contacts. I think I am still missing something someplace. thanks

I apologize for being a newbie. I am learning so much so fast - and I KNOW I saw a solution to this somewhere but can't remember where for the life of me ... I have a "find" button which walks my users through a script and places the found records in a list report. I've placed a "go to" button on the report but cannot figure out/remember how to script it so they can go to that record from the list report. Should I be using a one line portal (??) on the report for this? What global fields should I be using? Also, there is sometimes a need for them to select just a few records from the report to use as a new found set, placing them either in a new list report (als…

I have a relational FMP database that creates monthly and YTD reports. In the YTD reporting I need to omit records that have duplicate values for one particular field and only count the most recent record with that field. I created a counter and used the duplicate function in FMP, but that works the exact opposite of me needs...meaning it calls every record after the first iteration a duplicate. I need a process that will call the prior records duplicates and identify the last record as unique. Any help is greatly appreciated. Thanks

I need to duplicate a set of found records and replace a field in the new duplicate set of records with a certain value. I'm a little confused on how my logic would be to approach this. I do a find that will give me all the records that I need to duplicate. Begin a loop that starts at the first found record, duplicate this record and then change the required field of the new record. However in my loop, if I say next record, there is no record to go to next since I'm already at the last record (the newly duplicated record).... Below is my script: Enter Find Mode[] Set Field["nl_refnum" "NC:g_nlrefnum"] Perform Find [Replace Found Set] Go to Record Rec…

Ok i have a closing script that loops twice for some reason it should only run once i have type it below when i say loops twice i mean it goes to the About screen then the Thank You screen,back to the About screen and again to the Thank You screen then it closes the template Allow User Abort [Off] Allow User Abort [Off] Close[Codes] Close[Large] Close[Pub] Close[sheet] Sort {Restore,No Dialog] Show All Records Go To Layout[About] Pause/Resume Script[0:00:02] Go To Layout[Thank You] Pause/Resume Script[0:00:02] Close[Main Menu] if it is the second pause resume script then how should it be written any help would be appreciated

pardonnez moi for being such a boring newbie, but is there ANY way in FM that I can 'Set' the contents of a field, the name of which is constructed while within a loop ? I have defined fields called "printField1", "printField2" etc etc. Now, I can have a field called "fieldName", which I can set up to be, say, "printField" & NumToText(indexNumber). As I go through a loop, "fieldName" becomes progressively 'printField1', printField2', 'printfield3' etc etc. Can I now actually SET the defined fields called 'printField1', 'printField2' etc using a script step which accesses whatever "fieldName" contains ? If so, whoopee ! If not, pretty damned restrict…

Hey, I'm putting together a solution that I compile into a runtime using FM Developer. I'm always tweaking it. I've got a few users of the runtime solution scattered around. When I create a new tweaked version I want to distribute it to them. So I run a script that deletes all of my records and resets the auto-entered serial number to 1. They should then be able to import records from their old file into this empty file. The problem is on the serial numbers. If they import 250 records into the empty file, the next serial number for the next record is set to 251. However, it is possible that they have a record that already has the serial number 251. (For …

Dear all, I have a problem with doing a script to open a selected layout from another file. I can only open another file, not a layout I want to open. For example I have a choice field in main file, and I use custom list in this field including theory, plant name and I want to open the related layout from another file (datasource file). Data file has 2 layout theory and plant layouts. I can open the data file but not the related layout at all. Can you help me solve this problem? I attach 2 files which I made some scripts but they cannot perform what I need is opening the layout I want in another file. Thanks and wait for your help. Snow myfile.zip

I have a simple database that has a field name "status". This field has three options on a pop up menu "out, low, completed". What I am trying to do is tally all the "outs" and place in a field, as well as "lows" and "completed" in their separate fields. I tried using using a "find" function and tallying but I think that a summary field or maybe a script would actually work. Any ideas?

I have a portal in one file which displays photos (in another file) for the record, also whether or not they are the "default" photo - in the images file (where they are added) there is a "default" (Y/N) field to select the default photo. How can I make sure that (in the images file) the default field can be "Yes" for only one photo for the (related) record in the main file? I would like to add a button beside the portal in the main file which says "select as default" ... I know I need a script to go through the related images for that record and change the default field for that image to yes and all the others in the portal to No ... need some global fields somewhere (in…

Hi all, I would like to format a number field that is storing a currency amount in a text calculation, but how do I add the number formatting in a script? I use NumToText(Total), but it just appears without decimal places like this: 2000 I want it to appear as follows: $2000.00 I guess I can add the "$" char manually, but how do I get 2 decimal values to always print?

Hello everyone i am looking for a way to have a dialog box or screen that users can choose to not see again after the first time they vew it either by check box or button. any help or ideas would be greatly appreciated thanks.

Hello I have a range of numbers for streets. The fields are called lo and high. If the field called "oddeven" says "o" i would like to get a random number in the range that is an odd number , but if the field "oddeven" says "e" I would like to get an even number in the range . Is this possible? Thanks Dave

Hello everyone. I have a small project i am working on for a local police agency. I have created a simple database that has 6 text fields and 1 photo container. Fields are: FirstName, MiddleIntial, Lastname, SSN, and a AutoNumber field. What i want to do is put a button under the persons photo that says "add to do list". And when they click on the button it will add there photo to a report layout i have setup that has there name and photo on the report. When they do a mugshot list it needs to have 6 photos added to the list and then can print this out for witness identification. Is this done by script. Thanks for any help you can give me. I attached what i am wo…

I need a script to check all container fields if the image inserted is stored as a reference because I'm using the exportFM plugin to export all images to a different size and tumbnail also the database would be to big if the enduser is including the pictures (500 records * 2MB picture)

I have 2db's, one is customer with all the normal info except I have fields for first oncall, second oncall and so forth. The second db are my contact lise for the different people who are my on call. The problems is I need to insert the contact name from the contact db into the customer db first oncal or second oncall field. then when i click button to go from customer db to related record in contact db, i will go to the correct contact record. Sounds simple to me, but i just cannot get it to work like it should. Any help would be greatly appricated, thanks

I have created a relationship so that when a user clicks on a button a "new window" (actually another file which through relationships has the same fields as the "original file") opens. The user can then update fields in the "new window" while the original DB stays open in the background... The problem I am having is that in one area I have several buttons (8) which, when clicked, add a letter to a field in succession (i.e. T,F,L,B,D). In the "new window" file, every time the user clicks on a button it calls an external script and adds the letter- but goes to the original file.. Is there a way when calling an external script that it will do the job in the origi…

I have a text field. Each field has a single entry with varied numbers of leading zeros..."00345", "01025. These numbers are house numbers in an address. I need to remove the leading zeros from the data. Is there a function available that would trim the zeros out?

I'm using FileMaker Pro 6 for my computer assignment - creating a test. After entering the data, I need to have a script that randomly select 15 records. But I don't even know how to use all the script functions. Please help me.

On my cost form I have 50 fields to place an item. If I wanted to I could put the same item or any of a 1000+. Having said that, I have now been asked to generate a report counting the individual items and total cost for those and a grand total of the total costs.. If this doesn't make sense let me know and ill try and clarify.

I work in a store, and we use FM to create bridal registry lists. I would like to add pictures to this list. But I want to create it so that every time I type in the product number, the photo pops up. However I can't just attach the photo directly to the product number, because each week that information is purged and then an excel file is imported into it so that the list remains current. So I would have to recreate the photo's each time. Is there anyway I can create another file that can attach itself through a relationship instead?

Hello folks, How can I Automate record creation in related database (related only after records are created). I seem to remember that it's possible to script with Oazium events acting as trigger, but don't recall if it's possible without plug-in. As soon as new record with new ID is created in db1 I want it to be created in db2 30 times, for instance. Then db1 will be related to db2 on this ID. I can script this, but need to bind this to the event of creating a record in db1. If worst comes to worst, I can pre-create the records in db2, (say 3000 records ahead), but this is an awkward way to do things. Thank you for your thoughts

I wish I knew I am running a script that populates a field with a picture according to another field's value from a value list. My problem is that it will only do one record at a time. I need to run the script from each record then all is fine. My teachers will be using only records associated with their class (another field) Is there a way to get the script to populate all records without compromising the fact that they are working with a specific group?:? Any thoughts would be greatly appreciated Many thanx Poida

Am I missing something? Is there a trick to editing scripts? Why does a script not function after I remove an IF statement that worked before I put the IF satement in the script?::??

This is a problem with a calculation, but it originated in this section of the forum, so I thought i'd ask here. I am just using the Users and Groups database now, for those who have been helping me, I got rid of the memberships database. The problem I have is with the attachment I was given. In the Groups.fp5 database, there is a field, UserIDs with this calculation: ValueListItems(Status(CurrentFileName); "membership") When I take this line, and use it in mine, it wont let me use the semicolon. i have to use a coma, and then the calculation does not work. Does anyone know why this is happening? Secondly, membership, in this case is refering to the value …

I'm trying to create a script that will take the user to a startup "message" screen for a few seconds while the four related files open in the background. I thought if I went to the layout and used freeze window that I wouldn't see the other files opening. It's not that big of a deal with four files, but in a solution with 20 or 30 related files, that could be quite annoying. Right now, I never even see my "_Startup" layout, just a white screen with the "Opening..." boxes popping up one after the other. Is it possible to do what I'm trying to do? Here's my script: Allow User Abort [ Off ] Go to Layout [ Main ] Perform Script [

Hello, I have a field called "notes", it contains text "enter your note here". If a user adds something they'll change "enter your note here" to "blah blah". What I'd like to have is a script that looks at field "notes" and if it contains "enter your note here" it will changes it to " ", and if contains anything other than "enter your note here" it leaves it alone. This sounds easy enough in my mind, but I can't seem to write it out to work. Thanks in advance. Paul Perry

My memberships/groups/user script is almost done. It creates the new record in the memberships database and fills out 2 of the 3 fields needed. I need help filling out the third field, because it is much more complex. In the user's database, the user selects a value from a pulldown menu. These value's are from the field Name_F in the groups database. Once the user clicks the create user button, it calls a script that opens the memberships database calls a script in that database that creates a new record, and does the rest of this. One field is filled in with auto-fill, and one is filled in using copy/paste. The third field I need to fill in is a value from the…

Hi all! I think I know the answer to this question, but I thought I would see if anyone as found a way to do this. Basically, I have a text field that I allow people to enter a short key(#123#) and then I replace that key with stored text from a related file based on the short key using a script. This is pretty simple using the Substitute function. The problem with using the Substitute function, much like using the SetField function, is that any formatting(bold, italics,etc) that was done to the stored text in the related file gets removed. The only way I know how to preserve the formatting is by using copy and paste. The problem with that is that to paste into…

copying a record to another data file #63960 - 04/18/03 12:39 AM Edit Reply Quote Quick Reply I have created 2 different data files: <***> = a button to edit field (***) = the field heres what they look like: #1 COMPLAINT FORM <Complaint#> (5477) <Date> (4/12/03) <customer#> (131316) <customer name> (John Doe Co.) <address> (576 East Ave.) <complaint> (discription) <date recieved> (4/11/03) <send Info to new investigation form> #2 INVESTIGATION FORM <inestigation results> (type in details) <date> (date) <perfo…

This is related to my other post. I am setting a field in one database, using a value from another field, in another database. These 2 fields have a relationship. It wont work though, do I have to perform a find first? If you could explain how to do this, I would be very greatful. --Mark

Hi, I've got a script that finds records based on a field value. The problem is that when the find is executed, the way that the records were sorted is undone, and the records always end up sorted by their creation order. I'd like to perform the find but leave the records sorted in the way that they had been sorted before the find was executed. Is this normal? Does finding always undo the sort order? If it isn't normal, then what is going wrong? If it is normal, then how do I fix the problem so that the sort order that was in place before the find stays in place after the find. Thanks, Dan

I am not new to programming or scripting, but I am new to filemaker, and this script seems over my head. I am hoping someone out there will be nice enough to help me create it. This is the basics of what it must do. The database is of Users, the other databases used are a Groups database, and a Memberships database. The script will run in the users database, and use the other 2. In the Users database, you select what groups you belong too, then in the memberships database, i need it to create a record for each group you select. the record consists of an auto-enter number, User_Number, and Group_Number. To further complicate things, in the user databas…

I use Filemaker in my medical office and would like to make my lab results more readable. It would be great to change the color of all the flags of abnormal labs. If I could change the text style of just the (H) and (L)'s to be in red it would be great. Any suggestions?

I amusing FMP 5, or I should say my client is, and it will remain that way, so please direct all solutions with this in mind. I need to export a set of records and ftp them to a remote server. I found MondoMail would do this, but it has a problem, you can export once, and then ftp, and then MondoMail locks the exported file as in use by the hidden MondoMail Daemon. I am stuck at this point, the only way to get the MondoMail Daemon to die, is to reboot. This wont work. How can I take a scripted export from FMP and get it ftp'd to a remote server? Are there any other options other tham MondoMail, I tihnk it is a bug and I have a feeling I will not be able to g…

Hi guys, I am working on a database for my school which contains a field for the scholastic year of each child. (As opposed to the class which may be 3/4J for example) The scholastic year must be upgraded each year when the kids start back at school. What I am after is a script that will upgrade each scholastic year when I run it. ie K will become 1 1 will become 2 2 will become 3 3 will become 4 4 will become 5 5 will become 6 Any help would be greatly appreciated. Many thanx

Filemaker has a great function that allows you to recover a file when it is corrupted etc. It checks all the file and compresses the data and any glitches it repairs but it then creates a new file for this recovered file to be saved as. I am using a file that is storing a lot of data and includes a lot of pictures, the file is very big but as I define feels and tweak the database I often feel that the databse is not as compact and efficient as it could be at the moment I can resolve this by recovering the file but it is a bit of a pain. Microsoft Access has a function that allows you to compact the database and I was wondering if Filemaker has a similar function th…

Is it possible to delete found records within a script. I am importing a file into Filemaker that has a header and footer file, I am writing a script to automate this process so that the relevant department can import the record and delete the header and footer. I can find header and footer files as I have created a field that contains a code taken from the main record, header and footer files have a specific codes within the main record. I have set my script to find all Header and Footer files as there will be up to 20 files imported at once and I want to have a script that searches the whole file and deletes any Header or Footers. I hope this makes sense (…

I'm wondering if its possible to generate graphs in FileMaker Pro. I'm hoping there is a way to generate graphs/reports such as those created with Excel. Thanks.

Hi, Would anyone know how to capture find criteria for a Number or Date type field when >, <, <>, etc. operators are used. My users want to see search criteria before they perform a search, and want to be able to print them for future references. I created a gSearchCriteria global field, which is populated by a script which is looping through all filelds on a layout (they are in a FIND mode). If Status(CurrentFieldContent) is not empty, it appends Status(CurrentFieldName) and Status(CurrentFieldContents) to a gSearchCriteria global field. It works fine except when the Field Type is Date or Number, and they enter ">", "<", or other o…

i'm pretty sure this can be done, but i can't figure it out, and i can't find it in the forums or in fm help. i have a script that needs to be run every day. i'd like to tell filemaker to run it every day at the same time, like 4 pm or so. is there a way (workarounds--that don't include me manually running a script daily--ncluded) to do this? the only auto-run script options i'm able to find are the start-up and close options. any help is greatly appreciated. thanks. josh

I am writing a script to populate dates and time of day. They need to be filled in to serve as a basis for the rest of the layout (to duplicate the form the customer already uses). 4/21/2003 7:00-7:30 4/21/2003 7:30-8:00 """"""""" """"""""" 4/21/2003 3:00-3:30 4/22/2003 7:00-7:30 I wrote the inner time loop and tested it. It works well and breaks as it should. I added the outer date advance loop and it refuses to work. The global counter I used for the date break point advances once and the time loop never stops. The result is I have to break into the script and I have the correct dates and times for the first date and …

i need the date when one certain field in a record is changed when other fields are changed, the date may not change

i need the location of a picture in a container so i can use this in the FTPit plugin to upload the picture to a server

On a form that a user will enter a date range for a report, I have provided 2 convenience buttons to pre-fill the start/end dates for the current month and the current week. I had no problems with the month, but I am having trouble with the week. I'm sure somebody has done this before. I just need to calculate the dates (mm/dd/yyy) for the first and last day of the current week (Sun and Sat). Does anyone have this handy?

I want to run a looping filemaker script on the host computer that sends my email and then pauses for 1 hour before sending email again. I also want run a looping script on every computer that sets a global time fied as current time and then pauses for 3 minutes before continuing with loop. Both scripts would need to run permanently. Will this effect overall performance? is this a bad idea? Also, should I rather send my email from a user machine and not the host ? Thanks

in redesigning an app, i'd like to concatenate some scripts into one in several places. there's no way to do this with copy/paste, but i seem to remember hearing about a technique to do this with applescript. any pointers appreciated.

Hi all, Can anyone tell me if there is a script that will allow me to just export one or possibly two records from a database. Many thanx

Hi, I've made a big mistake, creating some repeating fields in a related file, I've after reading and wanting to make use of that data I entered, I've found that I should have created a portal on my main layout, and just put in the fields on the portal with any repeating. My related file is called Job Notes, and is used to hold each job history about a customer, for each visit, that is why i created the repeating field, but after reading these forums and a book that I bought, I know know this is not how I should have set it up for my needs. So I would like if possible to create a one-time script that will search the related file for each of my 600+ customers…

Ok, I'll have to explain this in very basic terms as I am not very versed in FileMaker or Scripting terminology, so please bear with me: We have been using FM for 6 years now in our Videostore, my colleague created a snazzy little database solution for films, members and ordering which works just fine, there's just one little thing we've ben trying to find a solution for... The layout for rentals contains 8 fields for entering the number of the film, a seperate button assigned to each of these fields triggers the various scripts needed for statistics, entering today's date, etc. Up until now we've had to press each button by mouse, i.e. enter film number in fiel…

Hiya all, I've got a problem when using the set field command in FMP that has got me stumped! When i want to set data to a related field I can do it, but only if i have pauses in it. If i take the pauses out, the system ignores the set field lines of the script... I've attached the file so you can take a look, Thanks in advance, John

I have 2 fields (Pickup Dest) and (Transport Dest) When a record is first generated the use puts the infor into the pickup and the transport fields. What I am trying to do is when they generate another call I wnat the information form the Transport Dest fiels to go into the Pickup Dest Field and the pickup Dest Field to go inot the transport Dest field. I made a script the cuts the info from the pickup field and paste it in a field called temp field1 and then I do it again for the dest field to paste it in a field called temp field2. I then cont the script and have it cut the info in temp field 1 and paste it in Pcikup and vice versa ( I hope I haven't confused anyone to …

Hi all - I'm trying to create a script that will perform a find, then look to see if any records were returned and if so then send off an email. The trick is that I want this to repeat automaticly say once an hour. The problem I have is when I do the search and if it can not find any records it brings up a dialog box asking to if I'd like to modify the find or continue and of course halts the script until I click continue. How can I get rid of that stupid dialog box : I'm sure there is an easy way around this I just can't figure it out. Thanks for your help...

Hi gang, I want to date / time stamp a big scrolling text field with a script and then have the cursor taken to the end of the field. I know how to insert the date and time but can't figure out how to make a script take the cursor to the very end. How's it done? Thanks, -Ted

Is there a script that can create a record for each date in the Week of Year. In orther words, today's date falls within the 14th week of the this year. I would like to be able to put a start date, such as 4/1/03, into a field, and then run a script that would create a record for each date 4-1-03 to 4-15-03 (inclusive), for each employee. Does this make sense? Is there a better way to approach this? TIA Lee

Hi everyone, Is it possible to open the contents of a container with a script? (auto open a file from another program)

Guys, could you explain to me how I would want to use the above script step? It somehow doesn't make sense to me, and the manual is not very clear about this. Would you mind explaining the "Specify by Number" step, too? Any help greatly appreciated!

Hi, Can I reset an auto-entering serial number back to 1 with a script? Thanks, Dan

I have a couple of related dbs - one containing a list of classes (this is for a horse show) with various info including day of the week & session time; one containing participants entered in each class. (there's also another related db containing participant info). I need to generate a report on a daily basis that will show each class scheduled for that day & session time (two session times per day) and the number of participants entered in each class. I want those classes that have no participants entered to show as '0'. I have played w/the count(field) but have not come up with anything that gives me what I want. I bet it's really simple & I have…

I'm new to Filemaker, and ANY help would be greatly appreciated, Police Officer by trade, and I've been assigned to upgrade our in-house computer system. I've created two files, #1, an arrest pedigree, #2, a mugshot file. I've created a relationship between the two, by lookup, whereby making an entry into the pedigree file pulls in the mugshots, jpeg's, via matching case #'s. Works great, providing the mugshot exists. Here's my problem. Most times, the pedigree is created prior to the mugshots being entered. What I'm attempting to do is create a startup script that will update the pedigrees once the mugshots exist. I'm having a difficult time getting the relooku…

is there a way to impliment multiple finds in a script like i do in find mode eg 1) field1>0 2) fileld 2 <100 3) omit field3 = 0

How do you write a script to find all records within a certain range of a value in a field in the current record.

i am trying to find a range of a field that is modular values 0-11 i want to find records with values in this field that are within a certain range eg if the value in the current record is 1 i want to find all records that have values from 11

I'm trying to make a script that copies data from one database to another. Specifically, I've got a contact manager database that I'd like to be able to hit a button and copy the relevant contact information (name, company, fax number) into a new record in my fax database. Any help would be appreciated!

I have created 2 different data files: <***> = a button to edit field (***) = the field heres what they look like: #1 COMPLAINT FORM <Complaint#> (5477) <Date> (4/12/03) <customer#> (131316) <customer name> (John Doe Co.) <address> (576 East Ave.) <complaint> (discription) <date recieved> (4/11/03) <send Info to new investigation form> #2 INVESTIGATION FORM <inestigation results> (type in details) <date> (date) <performed By> (john doe) …

I run a telephone answering service. I answere for appox. 150 coustomers, doctors, plumber. lawn care and heating and air customers. I am trying to write a program in filemaker 5.5 and having some luck. But, i realy need help, I must be able to pull up my customer information, take messages for the office or email messsage to cell phone and a copy to the customer company also. Or if a person responds to a page to view message and deliver the message. they must be time/date stamped when i take the message and time/date stampted when i deliver the message. I also need to be able to fax messages taken to the customer each day so they have a printout of what messages we…

Not sure how to go about this one. I would like to set up a script attached to a button that will go to the layout "Terminated" then only display the people who are terminated. It is a value list (Active,Inactive,Terminated) I don't think there is much to this one, im sure it's some kind of flag or somthing that will look at the value list and then decide etc. I will continue trying to get this to work, and checking here with a solution lol. Thanks much, Cheers.

What function would i use if i want to perform an if statement thats says if["thisfield = "anything"] by anything i do not mean the word i mean anything at all, any info.

when i import my records from an excel file, the info gets split into different records. The file lists the info like this: Order Number Sku # Title Author Print PN Condition So when it imports it imports three lines as three records. The first record has the order number, sku, and title in their correct fields. The second record only has the author in the title field. And the Third record has "Print PN" in the order number field and condition in the Title field. I can easily move the author name by using a script like this: Goto Layout ordermanager show all records go to first loop If ["ordernumber = """]…

I am writing an applescript that will auto print two layout pages in Filemaker (the applescript does way more than this, but this is the part that matters for this part). The print window comes up and I have to save the postscript files to the desktop. The prompt window comes up requesting what I want the name of the postscript file name to be. I want the name to be the database name_1.ps for one and _2.ps for the other. How can I have that auto populate?

I have the following script setup and I cannot not get it to multiply when it is needed. If (rate_code = "2") Set Field Commission, Case(Price <= 400, "50", Price > 400 and Price <= 1000, "100", "150") Else If (rate_code = "3") Set Field Commission, Case (Price < 200, " Price * .50", Price >= 200 and Price < 1000, "100", Price >= 1000 and Price <= 2000, " Price * .10",

I would like to create a checkbox for various categories. Eg. category a, category b, category c, category d etc. Now, the user can choose more than one category at the same time and I will need to issue a report as follows. All records containing category a or all records containing category d. I am very new to Filemaker and need to learn how to create a checkbox.Thank you.

I need to write a script using a search for a particular sale and show all sellers that participated in that sell. Then I need to perform another script over and over again, but check to make sure that I don't use the same seller number more than once in the script. ie.. enter find mode go to field [db1_pro_sale_date] show custom dialog [Title: ""; Message: "Enter Sale Date"; Buttons: "OK", "Cancel", ""; Input #1: (db_pro_sale_date)] Peform Find sort by: [db1_seller_number] The result would be all records for the [pro_sale_date] sorted by the seller number. The second script would be: go to db2 enter find mode set field [db2_seller_numb…

I am interested in opening two databases right away when FMP starts. How do I do that? I read the script maker options and they didn't have what I wanted. Please advice. Evan

I like the script option "Show Custom Dialog", but I'm not sure I'm using it correctly. I put in the option to show the message "Put In The Sale Date" and I want it to go into the sale_date field, but don't know quite sure how to make that happen. As I have it written right now: enter find mode set field "sale date" custom message: "Enter Sale Date"; field entry: "Sale Date" perform find The find is not performing correctly. What am I doing wrong?

I'm developing a rather complex training solution for a client. One database includes the employee info (names, department, etc.), fields for training dates and status of each class (about 100 classes). The second database has one field for each class where they put in the number of days between trainings ["training frequency"] (for example, annual training would be 365 days). This information is used to calculate the training status in the first database (ok, training required). I would like to create a list (I have the layout all set; same layout no matter which class they want a list for.) where it would look for who needs the training. It sounds simple but he…

Thanks guys for your help on my last "Reporting 101" question. Here's a new one for ya. I am trying to create a simple report, but this time using data from a child file to display in the parent file. Somehow, I can't make this work. I have a parent.fp5 file, and a child.fp5 file. In the child.fp5 file I have 3 fields: Task - [Text] Hours - [Number] TotalHours - [summary, Total of Hours, Number] Now I create a relationship between parent and child tied on a 4th field, a constant "1" (that's "one") to make sure that all files get related. I use a sub-summary part by Task and put the Summaryfield "TotalHours" as well as description "Task" in my p…

I am trying to take an applescript and export two files. One file is from one field and another is from another field. Both of these files go to different people and have very different uses, so they can't be exported together. I have done an applescript that automatically exports based on the export spec. How do you export one field once and then export a different field the second time? I was thinking I could write a internal script to export, but I don't know if it will keep the export order JUST for that script. Please help!

I am creating a new library database and i need to be able to select a category from a pop-up list which will then bring up a pop-up list with the relevant sub-categories for the category selected. I also want the database to automatically generate a call number (serial number) based on the category/subcategory when a new record is being entered. Is this possible? And if so how? Thank you for your anticipated reply.

Hello guys, I'm trying to figure out this whole reporting stuff and I'm ready to cut a hole into these big glass windows and leap into 53 story freedom. But before that, let me make one last attempt out here to see if there's someone that can explain this thing to me. My problem: How do reports work in Filemaker? What makes those sub-summary and grand total parts tick? I think if someone can explain to me what these things do and what their basic building blocks are (summary fields? Why?) I could make more sense out of this. My setup: I have two fields: Hours - [Number] Date - [Date] WeekOfYear - [Calculation, Number] TotalHours - [summary…

I Have posted the beginnings of my problems in the Define Fields Section (Photo Catalog Template Mutilation), But I think I posted in the wrong section. In the Photo Catalog DB, I have changed the Keywords Field from a check box to a pop up list, using value list *Keyword Choices* and in the Define fields I have created 2 new fields Keywords2 and Keywords3 and have made these to act the same as the original Keywords field with pop up list. When I select info from the pop up list on Keywords2 and 3, It displays the info fine on Photo Catalog DB, but the Keywords DB does not update to show the matches. On the Keywords DB the only script assigned to the 'Mat…

Will Set Field [repeating field, repeating field] work? I want to copy all repetitions at once. Thanks. Peter

I need to compare a master list with a secondary list to find which names are missing from the secondary list. I have created two files that sit side by side. The master list is imported into one file and the secondary list is imported into the second file. The files are alphabetized, and then I scroll down each file looking for a missing name. Can anyone suggest an automated process to do this? Thanks.

I have used the ScriptMaker to clear 4 fields in a layout using the "Clear" script. This is working fine but I need a way to press a button to clear the four fields for ALL records, not just the current record being browsed. Any ideas?