Script Workspace and Script Triggers

I'm finally looking to upgrade FMP based on the new goodies in FMP7 (multitables, large size limit, and the ability to store files across FMP) -- Here's my question -- is there a way for FMP to automagically pull/copy File Path data and paste it into a text field upon having a file/reference imported into a container field? That is, is there a way to script that? I don't know where i can ask FMP to "look" for the path data for the file/reference in the container. Is there a way i can pull out that text data from the binary file/container? Does this question make sense? Version: v7.x Platform: Mac OS X Panther

Hi I am working for a company that has a weekly auction. There are 120 possible selling slots at this auction , so in the registration process we have those slots empty in the begining of the week. As the week progresses , we assign items to each slot. They are like 'A1" . "A2" . "A3" and are each different fields ( not repetitions) Is there a way with some kind of script to probe and find the next available EMPTY slot and go there? In other words a1, a2, a3 are full of information but field a4 is the first available slot to go to . Can a script be written to somehow find the first empty field? Thanks for your info STAN Version: v6.x Platform: Mac OS …

Hi I need help in cleaning up text edl files. They out put like this 0016 BLK V D 060 00:00:00:00 00:00:02:00 01:06:45;26 01:06:47;26 0017 AUX V C 00:00:00:03 00:00:08:25 01:09:35;29 01:09:44;21 0018 AUX V C 00:00:00:00 00:00:10:17 01:09:47;11 01:09:57;28 0019 AUX V C 00:00:00:00 00:00:10:08 01:09:59;24 01:10:10;02 0020 6408 V C 00:26:26;28 00:26:29;17 01:10:41;07 01:10:57;13 PEG A 016 00:00:00 6408 * REPAIR: FROM SOURCE TRUE SPEED IS 4.869000 FPS 0021 6408 V C 00:26:26;28 00:26:27;29 01:11:00;17 01:11:07;01 PEG A 016 00:00:00 6408 * REPAIR: FROM SOURCE TRUE SPEED IS 4.869000 FPS 0022 6408 V C 00:26:28;00 00:26:28;00 01:11:07;01 01:11:07;01 …

Hi I would like to make a script which would allow me to insert text into a container field for a container field when there is an empty container field. I would like a script to go to each record and determine if the container is empty and if so replace it with text. Is this doable. Thanks STan. Version: v6.x Platform: Mac OS X Panther

I know I've seen threads on this before, but I cannot find it... I have the follwing loop: Go to Record/Request/Page (First) Loop If (cPrimaryRecord="1") Set field (cFamily,"1") else Omit record End if Go to Record/Request/Page (Next, Exit after last) End Loop This loop reuires me to perform it twice to remove all of the duplicates. It seems to leave the last record alone witha "0" in the cPrimaryRecord... thanks Version: v6.x Platform: Mac OS X Jaguar

I have a calculation field that uses length(text) function to display the character count from a text field. But this calculation is only done when you go to another field. My question is what function do I use (or how do I script) so that the the user can see how many characters they have typed in a particular field before proceeding. Cheers Dave

How do I prevent a user from entering a return keystroke or better yet if they enter a return keytroke it sends then to the next field. Cheers Dave Version: v6.x Platform: Mac OS 9

Hi....I have an issue with adding a surrogate key for already existing database. I have crated a treatment key as a surrogate key for all values of medical record number..but am unable to populate it with incrementing numbers. Tha maximum I could get to was...populating the treatment key with same value. Plz help me to change these numbers to incrementing numbers...rather than same vakue. I do not know which category to use in the scriptmaker to initiate a count to increment numbers by one after each loop. Plz help me out with this!!! Version: v6.x Platform: Windows XP

I would like to access an external database via a scripted button. I would appreciate someone giving me the instructions on how to do this. To be more clear, the buttons or tabs would be clicked and layout 1 of the external database would become the active window the user could input to that database and then click another tab or button to return to the previous database. Thanks in advance. Version: v6.x Platform: Mac OS X Panther

what are the commands to create BOLD text in a script... say if i set field to "Joe Blow, AsCE" and wan't the "AsCE" to appear bold and italic. Version: v5.x Platform: Windows XP

I would like to create a script that emails a certain user all the record data every time a record is created - how can I do this? I've been reading the FileMaker Pro User's Guide, and I cannot figure out how to create a script to save my life! thanks for any help!! Version: v6.x

I have a html file that looks like this HTML> <HEAD> <TITLE>Readerware Basic with Comments Image Example</TITLE> </HEAD> <BODY> <CENTER><FONT COLOR=#0000FF><H2>Readerware Basic Image with Comments Example</H2></FONT></CENTER> <TABLE ALIGN=LEFT CELLPADDING=5> ! Start of Book <TR> <TD><BR>default.gif<BR></TD> <TD>100117<BR>Legacy<BR>A. Michener, James<BR>Random House, Incorporated Minimal Wear PresentEdition: First Edition Fine/Fine<BR>Literature & Fiction : Authors, A-Z : ( M ) : Michener, Jame…

This find will probably be obvious but.... I have a popuplist that list various cities. The user selects the city out of the list. All of the contacts for that city then show up. All is well.. The user then selects what they wish to do with this list... one of which is "send a letter". When the user selects this option I have a script to run that will find duplicates based on the found set (the city selected). So far this has not been a problem. (I followed the threads here for marking duplicates as "0" and the unique record with "1")... now here is the problem... It will find the duplicates within this city and show them on screen. But then I am having …

Hi everybody... is it possible to launch a script by checking a check box? I have a "Clients" database with a "Clients type" field being member of a value List and formatted as check box. Now one of the check boxes says " musician" , I have a "musicians" layout and I want to be able to open that layout if i check the Musician check box in the Client Type Field. Thanks for your help in advance! Version: v6.x Platform: Windows XP

I'm trying to set up a script that performs a find and then takes me to a specific layout but I also want to taken to the same record from which I performed the script (which could be in the middle of the found set). Only seem to have options for first, last, next, previous record. Would appreciate any suggested solutions. Version: v6.x Platform: Mac OS X Jaguar

I was looking at the Filemaker Recruiter template and there are some nice parts to it, if I buy it is this completely customisable / edit the scripts or is locked? Thanks Simon

Hello, I want a script which have a fixed sorting order. The problem I have that do I different sort order manually my script is using the last sort order. What I want is as script that goes to the layout "list" and sort first by "customer" and than by "project number" Hopefully there is someone who can help me! Greetings Jukkie Version: v6.x Platform: Windows XP

Is there a way to have one layout window one size and the other 2 layouts the same? My help layout doesn't need to be that big plus I wanted to add a Menu layout. I know about the Minimize/Maximize commands but those are too extreme. Thx

Is it possible to trigger a script to run automatically upon entering a record or adding a new record? Thanks for your help. Version: Developer v6 Platform: Windows XP

Once upon a time I remember reading somewhere that one should always include the ELSE statement in your If / End If even if you don't need it because FileMaker will run the script faster if you do. Here's an example of what I mean: If ["MyName = "Ted""] Show Message ["Hello Ted"] End If This is what I have seen recommended in the past: If ["MyName = "Ted""] Show Message ["Hello Ted"] Else End If Does the ELSE actually speed things up? I personally haven't noticed any difference. Version: v6.x Platform: Windows XP

Hi All I Just recently started writing scripts. I am having trouble with exit loop step. I created a script which exports found records and imports them into another Filemaker document, Ok this worked well. My problem is when I need to delete records found. So I use a loop step to delete found records. the loop continues and won't stop even with the exit loop step. What am I doing wrong Sample Loop Exit loop if Status(current found records=0) go to record/request/page (first record) delete record request/page End loop Do I need a loop step. Thanks in advance Version: v6.x Platform: Mac OS X Panther

what function would i use to test if a given text string appears in a text field. ie. say i have a field that holds the value "THIS STRING IS TO BE TESTED" and I have a function that calls... If FIELDNAME CONTAINTS "STRING" RETURN POSITIVE. any help would be appreciated. cheers!

Ok, here's what I'm having problems with. We have an Inquiry database that when someone calls to inquire about a product, we just type in the company inquiring and the catalog number. Once this happens, the catalog references the product file and it brings up all the information. I need a script that will count the number of times that each different product number comes up and display how many times each product has been inquiried about. I also need to do something like this for our orders, but that's another thread. Our product numbers are 6 digits (all numbers)... THANKS FOR ANY HELP!

Hi, how can Exit Loop when I get to the last record? (see below script step after ***"stars"***) Thanks in advance! Go to Layout [ Form ] Go to Record/Request/Page[ First ] Loop Insert Text [ Package code, "package" ][ Select entire contents ] Go to Record/Request/Page[ Next ] Exit Loop If [***"Next Record = Last Record"***] End Loop

I need an If function for my Print command...When someone clicks the Print button it goes to Dialog then if OK is clicked it prints Layout 1 and then layout 2. Thants fine but if Cancel Print is selected on the Print Dialog Layout 1 is canceled but it continues to print layout 2...I need to stop layout 2 from printing also if Cancel is clicked.. Thx PS...You guys have been a Tremendous help!!!!

Hi, I am a new to script writing in Filemaker and really need some help. I am creating 3 databases that are all related to each other and have a number of common fields. I would like to set it up so that I can enter data into database A and then update database B for the fields the have in common. But I want the data from only that record (say record 1) to be sent to database B. In other words I want to send data from fields x y and z in record 1 of Database A to fields x y and z in a new record in Database B. If a record matching the contents of field x already exists in Database B I want it to update that record and not make a new one. I hope I have made…

I have created a script that will insert a picture in a field depending on the entry into a checkbox field. I need for the user to click on the checkbox and for the checkbox to check (or uncheck)and the script to run. I thought about modifying the script so that it checks the checkbox too, but that doesn't work since I need the script to run based on the entry that is in the checkbox already. I have tried making the checkbox a button, grouping the checkbox and a button but I can't get both actions to occur. Any suggestions on how to get the script to run and check the check box?

Hi I have delibrately taken off add new company from the startup layout on my database so people need to look before adding a company. Is there anyway that after a search reveals no returns that I can offer an option box to add new company, i.e run a script??? Or is there a better way? Thanks Simon

Hey Everyone, I feel real forgetful right now (Brain Fart) cause I know I've seen this somewhere in here. So if this is a repeat question, don't make me feel too bad, but here is my problem. Let's say you have two things that you are selling, the first lets call a "Document" and the other is a "CD". Now each document and CD have their own inventory numbers (all different). But every document inventory number starts with "Two letters" and the rest are numbers, where as the "CD's" are just numbers. Now my database has two fields, one which you chose if it is a Document or CD and the other is two input the inventory number. Also, the first field is a dropdown list to ch…

I have a solution with 10 files and roughly 100 layouts. As you can imagine, a pretty complex navigation system was required. But there is still one thing missing. I'd like to add a "back button" so that the user can return to the previous record and layout in any file from any layout in any file. In other words, I want it to behave like a browser back button. It seems to me that it's such a basic thing that there would be a script command for it in ScriptMaker. I've tried creating a script that calls for "Go to Layout [original layout]" but that does nothing at all. In fact I wonder what this command actually does if it doesn't take you back to the original …

I have 2 layouts that are basically page 1 and page 2 of a lesson plan. I created a button to print the current record but it will only print the layout I am viewing. Is there a way to have it print both layouts at the same time? I really don't want to have to create a new layout if I don't have to. his will be distributed to other teachers and many are not familiar with FM (Heck this is my first REAL database!!) It was not meant to analyze data just store lesson plans and search for them by Unit and/or Lesson. I attached the file to see what you think. Thx Lesson.zip

Hello all, I'm trying to make a db where i can practice greek and english words. For this it is necessary to type sometimes in greek and sometimes in english. I would like to use the "send message" command to make MSWindows change between the two languages. Does anybody know which command I should use? Thanks for the help. Bartjens

I am VERY new to Filemaker Pro and would like to learn more about scripts. I have created 2 very simple databases and would like to see what else I can add to it. I was wondering if there was a place to get scripts premade (kind of like javascripts for websites) so I can try them out and/or edit them for my needs? I am using Windows if that matters. PS. This has to be the BEST FileMaker Pro site I have found yet!! Not many free sites to get info on filemaker Pro!! Thx

I have a list of approximately 10,000 people. Some are part of the same family and some are not. I followed the earlier posted threads to flag the duplicates with a '0" and the unique record with a "1".. it works perfect, I was then able to modify the records so that if a duplicate was found, the unique record would add the word "family" after the lastname and the duplicates were omitted... now I need some help.. I need to have the ability to set it up so that if there is only one duplicate that the modifcation of field would be different than if there was two or more duplicates (i.e. one duplicate would use the first name of the unique record and the first name of …

Greetings, I have been tasked with creating a new mutual fund profile in a relational dbase format and I have completed about 90% of this project. My last problem is dealing with sorting sector data per mutual fund(as you will see in the attachment) and displaying the top 5 sectors. The issue lies in how the data is exported from Principia (financial software). Each sector (from the raw data) is turned into its own field on import. It would be easier if I could just have a generic sector field and then each type of sector (Energy, Utilities, Telecom . . .) be its own record. Sorting would be a snap then. BUT, I am curious to know if there is a way to sort, or rank, the…

Hi all Would anyone know of a book which would help in developing and understanding scripts in Filemaker. I kind of new to the whole script thing. Thanks

I have a portal that has '"create related records" disabled. This is to mitigate data-entry error on the part of the user. So, I have a script that uses a counter and a loop to create the desired number of fields in the related database by calling an external script. This works rather well. What I need to do is have each new field to be visible in the portal from the record that they are created from. I've been trying to do this by: SetField("course_number", :course_number") But, it only works once, and in the second record created by the external script rather than the first. Can anyone suggest how might I apply the "course_number" identifier …

I know I've read a discussion on this here recently but can't find it. How can I modify a script Find step so that it only includes records with today's date in a given field? I have a related db called CurrentDate with one record that is updated daily for same. I have tried in the past to use the copy and paste steps but it has never worked for me. In evitably, it pastes the last copy I did in filemaker, not the new copy asked for by the script.

I have designed a script that will create a payment for a student. Unfortunately the member of staff who generates payments keeps trying to run this script whilst in find mode. I know that at the start of the script I could have the perform find script step but I want to give them a message to remind them to perform the find. Is there any way to do this??? Thanks

I would like to create a script that emails a certain user all the record data every time a record is created - how can I do this?

Hi! I havent using filemaker scripts and I have stumbled to situation where a good script would do a trick. Problem is with contents of field. I have to underline first name. Names with underlining uses 'pointers' example: <u>Johnny<p> and it should become underlined without those 'pointers' I am really a beginner with this Filemaker and Im open to all suggestions how Id get solved that problem.

I have a db set up in 5.5 that generates a web address for sequentially named filenumbers. Is there a way (while connected to the internet) to open the web address in a container field and then save that picture the the hard drive?

I'm having really bad cross-platform problems. A simple script that copies formatted text and pastes it between fields works perfectly on MacOS X, but run the same script in Windows 98 or 2000 and it breaks. The text formatting is lost. If I paste by hand (Ctrl-V) then the test formatting is retained. I'm going crazy. I hate it when stuff like that happens. FMP 6.0v4, tested on several machines.

Hi there, I would like to know if someone can transfer data (number) from the last record to a new one. Let say that I have 3 number fields (A - B - C). By clicking the 'New Record' button, I want to transfer information from the third field of the last record to the first field of the new record. I developed a script to do that but nothing happened. Any help would be great! Bikeman

Apologies if this is in the wrong place but I wasn't sure where to post it. We are currently trialling the oAzium Events plug in, and as one aspect of the plug in we are asking it to open a file which it does fine. The problem is when the file is opening a message stating the Date format is different to system settings comes on the screen and stops the proceedings. How can I get around this?B)

A couple of problems with insert from index 1) if i call up insert from index in a script then hit the cancel of the dialogue, it cancels the paste but continues the script ( which i would like to cancel to)_ I tried the staus(messagechoice) but doesnt seem to recognise FM dialogue boxes 2)I have multiple users and would like the indexed field to show only the files that were created by those users - is that possible? ( I have a work around where the users name shows after the record name but would prefer the user doesnt see in the index list the other users files) thanks

I would like to set the creation and modification dates/times as well as other "assignment" dates/times from the machine on which FMServer is running.

we have a main menu. When somebidy cliks a buttin a file is opened. When he fe hasn t got the psw and fm ask script has canceled to you want to continue. When he clicks continue everything is fin however when they click cancel the next time the button is used an msg says the scrpt is missing. is there a way to protect the script againt it or always continue the script even when psw is incorrect or file is missing ? regards, marco

Forgive my beginner's lack of knowledge. I am trying to automate my fields, so that after I have entered information in one record (ex: Newark) when I input the same info in another record, it recognizes it and fills it in for me. Thanks. B

How is the best way to round time? I need to round time to the nearest 1/10 hour and the nearest 1/4 hour. Can anyone suggest a good way to do this?

Is there any way to sort value lists alphabetically - once some enters a new value into a value list it appears at the bottom regardless of its name is there any script I could run to sort it alphabetically? Thanks S

I need to write a very simple script, however I'm new to this so not sure what to do. All it basically has to do is when First file is updated in any way or a new record is inserted, the Second file needs to be automatically updated. Thanks in advance,

I have two database files. I have created a printing scripts that asking if everything is OK. If they click "Yes" I want FileMaker to take Database-1 fieldA info into database-2 fieldA. Then database-2 will do its job. I need this to happen in two seperate fields. This will allow database-2 to create reports from many different databases. I have set all the scripts up just can't make it copy the info from one to the other. It should only copy the info from the current record in database-1. Thank you.

Hi, well i

Hi All, I am trying to make a field that when you select out of a drop down box a item it will open automated in an other field a picture that belongs to that Item. Do I need to do this true a relation database or can I use a script : Help!! advice needed !! Neenen

Hi, I've been trolling this forum looking for a solution, but so far haven't found it. I'm about to start a project for a small town sheriff's office and they've asked for the following: They want their existing database to be updated and made available to all their patrol cars (which will use laptops). The patrol cars will not be able to access the network all the time, so just serving it up isn't possible. Each car will have to have a copy of the database held locally, but it will also need to add records to the main database. Is there any slick, pre-existent or pre-made solution to accomplish this, or do I need to do all the engineering with tinfoil and chewing…

Are there any add-ins that I can use that can query an access database or vice versa query filemaker in vb? Anyone know of this? Thanks Simon

I am not sure if this should be in the networking section or this section, but here goes: I am still learning FM and need a little direction on how to fix this problem. I have 5 related main files. When I open the first, they all open. It works fine on FM 5 on machine one. On my new machine (FM6) which is a guest networked to the first machine, all of the files open as well but I also get an error message saying that "Line items copy" cannot be found, although the file "line items" has opened. I get this error three times and cancel it three times and then can use the program but some of the relational fields show that the files are missing. I don't know how line items g…

Hi all I have a database that we use to record customer info, sales date ect along with a scan of their contract in a container field. What i am having trouble with is a way to bring the scan, it is currently jpg, up to a viewable size. it is setup as a link to the file. what i need to do is either be able to have the link clickable and pop up a larger image or set up a button or layout to dothe same thing. have looked in help files but don't see what i'm looking for, any one help??

I need to input information into a repeating field based on a counter value. Right now I am using SetField["PurchaseOrders::QTY", GetRepetition ("QTY", "Counter")]. The problem is that I need to make the exact same repeating field in PurchaseOrders reflect the value of "QTY", "Counter". I know that you can specify the repeating field number of "PurchaseOrders::QTY" in script set up so it looks like SetField["PurchaseOrders::QTY"-2, <--- that does it...but I want to say "counter" instead of -2....I want to be able to control this with a variable. Any suggestions would be helpful

I'm working with a relational database and need to perform a search between two of the four. Specifically, I want a script that will take the name of the company, copy it and then go into the second database and perform a search and find the company information. I have something that works; however, if there is more then one company with a similar name (i.e. ABC Inc; ABC and XYZ Corp) they both come up in the result. I, obviously, need it to conduct a "literal" search, but cannot figure out how. Any help will be most appreciated.

Is it possible to calculate the results of 2 summary fields? In any given found set, I need to multiply the sum of all numbers in one field by the sum of the numbers in a second field and then divide the result by the the result of the first number. A = sum of field XYZ B = sum of field ABC (A) (: --------- (A) The easy part is getting the sum, simply use a summary field to total the field in a found set, how do I then plug that number in to a calculation so I can automate the process and have it display in a report? Any help would be greatly appreciated. Thank you very much in advance, Steve

Importing ASCII text date fields, ranging from 1992 through 2004. Dates in the existing text fields are mm/dd/yy. 1-digit month and days always display with a leading zero. I need to import into date fields. I need functioning dates as dates, not text. I created a date field and used a script with Set Field [ DateField, TextToDate(TextDateField)]. But I get 1902 for the year 2002. I don't know how to fix this now in the date field records. And these text files need to be imported regularly so the date conversion will need to happen then. Can I import direcly into the date fields but get the dates right when it does? Pete

I have a script that before doing it's magic, checks to make sure that a specific record exists. Each record has a unique record number. I enter the find mode, set the record number to a global containing the number I am checking, and preform find. It works too well. If my record is 1001, and I enter a 1 in the global, it finds 1001. Any clues?

Im jsut bad with the logic of scripts... I havd DB a and DB b with a relationship betwen the Last_Name field trying to figure out how to make a button in DB a that goes to related record in DB b. This is easy enought to do. However, if there is NO related record it currently does nothing. I would like it to do something. Like if there is no related record go to the first record. thanks!

I am trying to script a find that does the following. Enter Find Mode Set Field, Company, to Client::Company name (the set field is looking to a related database for the company name) But, the set field is not working. When I check the script, it enters find mode, and then stops. It does not set the field Company to anything. Is there something that I am missing?

Hi guys, I have a script that is basically going to export records to a pre-defined file, and then using the send message access DOS CMD prompt to open up ftp and upload the files. I guess my first question is this: with the send message can you only put one line of command, and therefore should I try to create a batch file to execute from that one command? If not, here is pretty much what i want to send... command /c ftp open {site} {login} {password} put g:ftp uploadstransferfilemaker.mer bye exit I can successfully get command/c ftp to work, but am figuring out how to execute the rest of it.

Hi, I'm new to FM and this site so I hope I'm posting in the correct place. I've been using Access some years so I am having difficulty in understanding how to automate FM, as I keep thinking of the Access way. I wish to create a database for storing details of 35mm slides. Each record has a field that holds the page position that the slide is stored in, value 1-20. I wish to have this record auto update, the value being set to 1 more than the previous entry in the database. If the value is greater than 21 then reset to 1 and so on. The simple way to achieve this is to store the value of the previous record in the present record and use a calculated field to set th…

Hello I have an event each week that constitutes the file I am using. The file is called registration and it interacts with several other files for lookups etc. The group used to keep the whole thing in a file and it got so big that the printing was a real time thing. We want to get rid of the big file and just have a little file that we back up to the bigger file/ The little file will be empty at the beginning of the weekly event and then grow to 300 records of so. At the end of the event we want to make a script that will automate the merging of the little file into the archive. Any suggestions on doing this the best way with a script? Thanks STAN

I am having a problem with the simplest of scripts. I have defined a screen just containing buttons which call other screens. I want to set the zoom level and lock it. Of the 8 buttons only one works. They all call the correct screens, but only one sets the correct zoom level. Open["States.fp5"] SetZoom Level[200%, Lock] I'm using version 5.0v3 What am I missing here. Best regards, Brooke Kruger

Hello, all--- Am trying to write a script (in Scriptmaker or AppleScript) that will set a global text field with the contents of the clipboard. Ideas? Thanks much

Hi, I'm developing a new database at my job, and I'm new to how the filemaker scriptmaker works. I would like to have a script that checks the contents of a field and brings up the view that relates to that field. I'm dealing with a database that records technical information about many different types of recorded mediums. I need to be able to display the physical characteristics of each medium, based on the code for that medium. So if in the medium for a filemaker record is "cassette" I would like the database to display the casette characteristics view when the user hits a characteristics view button. basically: on button if medium == cassette go t…

I have read the FM Bible and there is a little info on scripts. I do not do well reading about such things right off. I need a visual teacher of video to get me started. Can anyone recommend a source for script writing instruction or know of someone I am in the Norfolk Va. area. Thank you

After performing a find, how do I capture the data from one field, from all records- (so, for example, I can set a new container to hold a list of NAMEs (the field I want is NAME)

I have a solution with 20 files, using FM 5.5 It is served by FM Server and we have a max of about 15 users at any time. We have freq. locked records issues. Is there a way to force a user out of a field (exiting them from the record) or force them out of the record, but only if they are idle for a period of time? It seems like this would be a built in feature, like disconnecting them when idle from FM Server.

New to Filemaker so would appreciate some advice. Each time I delete a record in the main database I want to write a copy of it to an associated journal file. How should I go about this ? Thanks, Arthur

Hi all I am trying to write a script that will find a specific date depending on the current month. If it is October, November or December I want the find in the script to the 1st October and the current year. If it is the rest of the year I want it to find 1st October and the previous year. My script is currently Enter Find Mode If(month(Today) >= 10 Set Field(Date Of Leaving,TextToDate("<1/10/" &Year(Today)) Else Set Field(Date Of Leaving,TextToDate("<1/10/" & Year(Today) - 1) End If Perform Find What am I doing wrong??? Please Help Thanks

I'm doing software design and developmetn at school and our first task is to make O's and X's using filemaker pro......I have the most functional game in the class (i was the only person who had used the program before) but I have one problem...you can modify the fields more than once eg. you can click on it to place a O in, but then it is possible to click on it again and place an x. My teacher has told me it is possible to make it so a field can only be modified once.....could anyone tell me how this is to be done? thanx

Hi everyone, I have a database which basically tracks the contract status on purchases of units. This data then gets exported and uploaded via ftp to an online settlement calendar for the purchasers to view. I can't have the field validation "not empty" because the contracts are all at various stages, so a lot of fields wont' be completed. However to be uploaded certain fields must contain a value. What I am therefore trying to do, is: Run a script that exports all "valid" records If invalid records exist, go to a layout displaying those records that got rejected. (would be even better if it could display where it stuffed up since there are sooo m…

I have a bookings database with a booking ref auto enter serial,how do i script so i can find a previous record,say booking ref 003 then copy the field entries to the newxt new record say 010,for example mr jones who booked a week ago has rung again and wants to book,i search under his name and find his record which was b.ref 003,the next booking ref will be 010 and i want to copy all his details into that new b.ref???

I have a database that full of phone calls. It has about 13,000 calls per month. Every month I run a script that Loop Copy phone number enter find mode paste phone number perform find export (to get the sub summary info of # of calls and length) Perform script (external import of export info) delete found records show all sort if (Status(current record count) =0) perform next script end loop Now this takes about an hour and a half to perform, and ties up my machine. Can anyone tell me an easier way to accomplish the same thing. there are no constants. Salesman

How can I get information from the newest record in a database to post to another related database record instead of the oldest? We have a new order taking form/database related by phone number to a completed invoice form/database. When a new order is taken, the customer's phone number is entered and his name & address are automatically entered if we have ever been to his home. One customer may have several records with the most current information being on the newest record. Filemaker looks for information on the oldest record instead of the newest. I don't want to make a third data base with customer information because of the volumn of orders we take. …

Is there some way to copy all the values from ONE record and be able to paste just those values into a similar record that is contained in another file? I have tried the COPY RECORD script but it doesn't seem to accomplish anything. What is the purpose of COPY RECORD script? Thanks for your patience, Jarvis

I have a list of tasks. When a worker comes to the screen, I would like them to be able to select a task then click on a button with their name on it. This button would hypothetically copy all the values of a record onto a separate layout (or file) and activate a START TASK button. When the worker returns to the screen they would see that the start button has been replaced with a STOP TASK button. Activating this button would calculate the time invested and signal completion status. What I am trying to accomplish is to have one place to post or pick up tasks. I need the ability to "grey out" the task so that if somebody is already doing the task i…

Hello. I am working at getting a script working. I am going to use this a s a simple log of the path to figure it out as I am new to filemaker pro. If anybody feels like to help I will be glad to hear any help. __________________________________________________________________________________________________ text looks like this ... * xxxx xxxx x x x x xxx.xxx.xx.xx. xxx.x.xx.xx.xxx.xx.x..x xxx xxx x x x xxxx xxx xxx xxx x xx xxxx xxx xxx x x x x x x x xxxx xxx xxx x x xxx x x x x xx The real text is like this * FROM CLIP NAME: OCEAN AND SHORE B-ROLL, JIM AND JIM ON BOAT CUTAWAYS * KEY CLIP NAME: SHORTLY AFTER 1…

Hi- I have inherited a large database with over 1000 scripts. I can find the name of the script by the button but It takes a real long time to locate the script in the scriptmaker window. Is there a faster way to find a script or to alphabetize them. Also- Can a script be reused and exported to another file. I think it can but how to change the fields quickly? to fit the new file? Thanks STAN

I've a job that has given me a heck of a job for my abilities, and not much time to do it. I'd never used FileMaker before and am jump-starting nicely. My question is: In ScriptMaker is it possible to cut and paste the script into a new script like a text-editor. I'm having a little difficulty working with the utility because of this and was wondering if there's a way to edit scripts without dealing with those dialog boxes. Just code... Thanks in advance

what are some ways that people are "freezing" records so that once a user has created one (record) they can hit a button and "freeze" that record so it is non-modifiable in the future. cheers!

I have a workstation & peripheral database. They are related by computername. When we get rid of a workstation, I want to be able to get rid of the relationship between that workstation and any peripherals that were assigned to it. At first I was just deleting the portal row but then realized what I was doing and stopped doing that. I tried writing a script that simply does a clear(related peripheralfile:computername) but that did not work. Any ideas how I can accomplish this? Thanks! John

Hello Is there a way to execute a script anytime a specific layout is selected? Say I have a script called "CalcDates" and I want it to execute everytime I go to a layout called " List of events". Just wondering if this is possible. Thanks

This isn't so much a Filemaker question as a logical question. I distribute employees complimentary tickets to University athletic events. I have been (justly) accused of giving the good seats to friends, so I want to create a system of randomly assigning the tickets. The problem: the tickets come from the athletics box office in a lump, and there are adjacent tickets ranging from 2 together to 8 or more together. Some employees get 2 tickets, some get 4, and some give their tickets to other employees so there can be a request of 8 or more seats together. I started with 2 related databases, Employees, and Tickets. But that's as far as I got before I was …

Hi, I got the following question. We would like to trace for 3 fields in a specific table the last change-date. So I don't want to know the last change date for the complete record, but only the last change date for some specific fields. So let's say that in Table "Customers" I've got 3 fields: City Zipcode Street I've added 3 new fields in the same table: City_change_date Zipcode_change_date Street_change_date Now my question is: how do I get this change date in these new fields? Can I use scripting for this? Hope someone can help me out, thanks in advance for your help! Regards, Robert

I have a large central database on a server running FM server and shared with many clients. Records are entered into this db by clients in batches at irregular intervals. I want the records in the main db to be regularly sorted by date and time in, which sounds easy but it's not. If a client runs the sort, it takes a long time, and does not permanently change the sequence of records in the main db. Ditto for a slave running an automated script. In these circumstances, the client who ran the sort will see the data in the proper order, but the next client will not. The relevant fields in the main db are indexed. How do I write a script that will sort the main db in a way th…

Hi, I've been trying to write OR find in the script for quite a while without any luck...: I know how to do it in simple find and I know how to write a script for AND find. Can anyone help me? Thx

Hello I find it impossible to make that script work, even when I think I got it right. Basically our company stores information on all products sold with pictures (the info alone is sometimes imported but not the pics). I need a script that will automatically link any new record to it's corresponding picture using one of the fields & display it in its place. Picture filename is identical to item number field. Please help ! Thank You very much, A.S.

Hello all, My company is working with an FM developer who is not very responsive to our needs. Unfortunately the politics of the situation are such that we are unable to extract ourselves from this particular developer, so I'm looking for ways around some of the major problems. Our database will be served remotely on FileMaker Server and we would like to run a local backup (in our office) periodically - probably two to three nights a week. Our developer has decided this is absolutely unnecessary so she won't be setting up any scripting to make it happen from her end. Is it possible for us to set up a file with a script that would access the remote database an…

I have a notes field that contains information about our customers that is useful in sales. Our sales people like to apply formatting to the text in this field so important information can be bolded, or red, etc. The problem is, I have a script that is used when a new note is added. So, a user clicks the 'New Note' button, and the script automatically inserts the date and username like in the following example: Set Field["Notes", "DateToText(Status(CurrentDate)) & " (" & Status(CurrentUserName) & "): " & "nn" & Notes"] NOTE: The 'nn' above is really the FM paragraph symbol... This puts the new notes entry at the top of the notes fie…

I happened onto this Show Custom Dialog Script recently and it looks like the perfect solution for passing messages back and forth from my shop. What I would like to include in the pop-up dialog is some kind of radio button or pop-up menu to add a little focus to the message. Is there some way to integrate additional buttons that would show up with the Show Custom Dialog script? Thanks, Jarvis

How should I design my scripts to behave correctly with locked records in multi-user solutions ? Thanks in advance for any suggestion. Paolo

Hi all, I've created a script which basically asks you to type in a filenumber. If the filenumber exists it goes to a layout, if it doesn't, it shows a message and puts you back at square one. Problem - no matter which way I program it , if the person clicks on OK without typing anything in at all it goes to the layout when it should throw up the message and back to square one. So far i have as follows (have switched it around to be a positive response & a negative response to no avail). Enter Find Mode Show Custom Dialog ["File Number", "Insert the file number", "fileno"] Set Error Capture [On] Perform Find [Replace found set] if ["Status…