Script Workspace and Script Triggers

I am trying to write a script that will calculate the difference between a date enter into a date field and the current date then return the result as a text string (Xyrs Xmos). I cannot get the month part to calculate correctly because the months do not occur in the same year always. Example: 9-1-03 comparison date 11-1-04 current date 1yrs 2mos desired result 1-1-04 comparison date 11-1-04 current date 0yrs 10mos desired result I am new to scripting in filemaker but not to scripting in general but have never work with dates before. Any help is greatly appreciated. -REM

I have a Find script that switches to a layout and then has Enter Find Mode[pause]. While the script is paused here, the user may click certain buttons. One of them is labeled Show All, which runs the Show All script that basically just does "Show All Records" followed by Exit Script. When this is clicked, the found set is forgotten and the Find script remains paused in Enter Find Mode[pause], just as I would expect. However, the fields in the layout, which were blank before, are now filled in with data from the current record. Why is this? Thanks for any insights! Chap

Hi All, I just locked myself out of my file I built a Quit script that closes all open files & should ask if the user also wants to close FileMaker. i must have messed-up something. Is it possible that this script sent my file in some sort of loop, bacause now my Starting script (that just displayed a splash screen & went to the Main Menu) opens & closes my file. Is there a way to perform or abort an opening script??? Thanks --Dan

Hey, I'm trying to trigger a script whenever a user chooses a specific layout in FMP. For example, when the user picks the layout 'Participants', a script will perfom a find of all the participants and display them in the 'Participants' layout. Is there a way to do this? Trigger a script when 'entering' a layout? Thanks, Adrien

I just made the jump to 7 and my new Custom Dialogs do not work as I would have expected. I simplified my script down to: Set Error Capture [ On ] New Record/Request Show Custom Dialog [ Title: "TITLE"; Buttons: "OK", "not OK"; Input #1: records::name record fill out, "test" ] If [ Get ( LastMessageChoice ) = 1 ] Beep End If Commit Records/Requests gives me only the value in my target field (+ the beep) when I push button 1. By contrast, when I push button 2, no beep (correct) but the target field remains empty

I am new to Filemaker and am using Business Tracker to develop a customer management DB for my business. I would like to add the capability of scheduling an appointment, with a displayed contact , from within FM, that would use iCal as the calendar program. (Much like the Email script included with Business Tracker uses Mail) Can anyone point me in the right direction of how to do this? Is there a plug-in that would make this easier? Thanks much!

Is there a way to log when a user played a quicktime movie? Also, is there a way to play the movie automatically, without waiting for the user to hit play? -thanks guys!

Hi to all, How can i make a script to get my db monthly report with i simple touch in a button (wirh a script) I'm new in Filemaker so, please help me! Thanks in advance for your help!

Hi, FM5.5 and WinXP/2000 I was wondering if there was a way to perform a certain script on record change? Would a plugin be required? Thanks Ben

I am migrating a moderately complex database (18 tables, 104 layouts, etc.) to version 7, and am practically ecstatic over the improvements in FM7. In the process of building my new structure (and applying the ideas of the Separation Model discussed elsewhere), it occurred to me that it would be really cool if I could allow my end clients to modify some of the reports *without* giving them the ability to change the core UI. This can be relatively easily achieved by creating a separate Reports file, and giving my clients full access to THAT file, while locking down the basic UI database. Problem is, if my clients modify a layout that I distributed, their changes will…

I am trying to write a script to do the following: Find all employee records with expiration dates (drivers license, car registration, car insurance, etc.) within the next month or so. I would like to make the expiration date a user defined input (can I use a dialog box for the user to input a date?). Then print a report that lists each employee's name with upcoming expirations and whichever fields and expiration dates meet the criteria. I have experience w/ other programming and database design, but I'm really having a hard time with Filemaker (and the books I'm using don't have good examples to follow.) These forums have better information than the books, bu…

Hi everyone, I am using FM7 with a list of booking system for a small community newspaper. I want to make a script from FM7 to: - tell InDesign CS - make a new document with a filename associate with the booking number, say 1234 - save it in a directory I want Please help me on this script. All I could do now is opening InDesign, I am stuck from here. Thanks for every help. Remi

Have just started to upgrade an old solution of mine to FM7. Liked the idea to be able to use the same script for many different things through the new scriptparameter? option. Can anyone explain to me why this script ain't working (manusparameter=scriptparameter=?). The scriptparameters are correctly written and the layoutnames too. Case( Get(Manusparameter)="training"; "evaluation training"; Get(Manusparameter)="food"; "evaluation food"; Get(Manusparameter)="education"; "evaluation education"; Get(Manusparameter)="economy"; "evaluation economy"; Get(Manusparameter)="social"; "evaluation social"; Get(Manusparameter)="material"; "evaluation mate…

I need a way to stop a script from running if a certain value in a value list is selected. For example I have a list that shows customer status - active, inactive, caution, and cancelled. I want a script to halt of the status "cancelled" is selected. I am a novice, so please really spell it out. Thanks.

I've almost finished my custom database, I'm running the final version in kiosk with a home-made skin. I've made 2 arrow buttons so the user can scroll up and down records in the database, the problem is it doesn't work, it scrolls through fields and not records. Does anyone knows what would be the script for this? Secondly, is it possible to "lock" all the records in my database so that the user cannot change the field's data? Thanks in advance!

I have just deployed 13 FMPro 5.5 databases onto a FMServer 5.5 (server running on OS 9). The clients run on both OS X and OS 9. I have set up various scripts throughout all 13 DBs that take the user to and fro between related DBs by using external scripts. These external scripts basically call a script in the related DB to go to a particular Layout. I call these scripts "Go To Related Layout ..." or something to that effect. The originating script will also perform a Toggle Window (hide) function on the first database to clean up the user experience. The problem I have now is, that when the user clicks on a button that executes one of these "Go To Related Layou…

Every time someone dials we want to know if they made significant contact (as compared to getting an answering machine or talking to an assistant etc.). So I put the script as: Dial [] Message "Did you make significant contact? Yes or No" If message choice = 2 (yes) Set Field LastReach Get Current Date Exit script End If That's it roughly I forget now because I had to take it off. I liked it. They didn't. Seems when they dial, the message appeared and it stopped them from flipping back and forth through the layouts while they waited for the person to answer. They use this 'in-between time' to review a contact history and orders on 4 different layouts…

Newbie here trying to set up a database of orders that we ship out with UPS. I plan to import the tracking numbers into the database and then I want a button next to the tracking number that I can press to go to UPS's website and lookiup the tracking number without re-entering the tracking number. The url I need to use is "http://wwwapps.ups.com/etracking/tracking.cgi?tracknums_displayed=5&TypeOfInquiryNumber=T&HTMLVersion=4.0&sort_by=status&InquiryNumber1=&InquiryNumber2=&InquiryNumber3=&InquiryNumber4=&InquiryNumber5=&track.x=24&track.y=9" I need to somehow insert the tracking number that is in each field into the url ab…

I'm trying to script a find command that searches a table to see if a record has already been created and if so tell the user. I've got the script to work, but when the Find finishes, and there are no matches, it keeps putting up a dialog to say that no records have been found. Is there any way I can stop this happening?

I'm working on a simple quote and invoice database. I create a quote record and then add items to the quote, by adding records from a quote_item table. The layout has a portal to show the appropriate items associated with the quote. I also have an invoice section set up identically. What I want to do, when a quote is accepted, it to create a new invoice record (easy) and then copy all the associated quote_item records to the invoice_items table. This is where I'm stuck, as I can't work out how to copy the data across. Sometime a quote will only have one item, sometimes more. Can any please help, as I can't figure out how to write a script to perform this 'dynamic c…

Is there a way to script checking if a file is already open, in a startup file? So if a user opens the starter file, it can perform the check, and then bypass normal startup proceedures etc etc.

Help from the Forum, please. With all options FM7 has for getting the current date & time, you wouldn't think I would be concerned ... but I am. None of the clocks through our small network stay consistent. Do all of yours? I use Auto-Enter Creation TimeStamp, Creation Time, etc. and I use Get(CurrentTime) or Get(CurrentTimeStamp) when scripting. But Get(CurrentHostTime)? That has opened up questions and uneasiness. We are networked so each User accesses the host file. So if records are created, does it use the host file creation & modification time or the User's? It must be the User's time because otherwise why is there a Host time? But sin…

How can I make a Perform Find script step find only a certain amount of records, say, the most recent 1000 records that otherwise fit the find criteria. I have started down this path for a solution: I made a Show Dialog step that asks for the user to enter the number of records to find...lets say they enter 1000. That number 1000 goes into a global field to be used during the part of the script which says how many records to find. thats as far as I get :-)

Is there a script function that will minimize FM 6 to the taskbar, when running under Windows (2000 or XP)? The Toggle Window function will minimize the window associated with the file being opened, but I'd like to have FM itself, the software, end up on the taskbar when running a specialized opener file. Steve Brown

I have script to create new window. Its like this which I read here on forums Perform script (move/resize window go to layout [little window ] Pause indefinitely It works well to keep window on top. The DONE button is a close wndow. But now I added a copy/paste button on it and that releases the lock somehow. It is just script Paste() and another script Copy(). Can I force it to stay on top? I though that is what pause indefinetly does. Wehn the window unfreezes, they end up opening many identical windows and getting 'can't modify this record stuff'. Very bad and I get in trouble.

I notice that FileMaker installs a "tlb" file for filemaker which should mean I can access it thru VB. I've tried every combination I can think of for: GetObject or CreateObject in VB. Has anyone done this or know how?

I'm having a problem with users interrupting a loop in a running script, by clicking other buttons (activating other scripts). (It's a navigation script to select the destination from a pop-up list WITHOUT having to click a further button to run a "Go to Layout" script.) The loop has to include the step "Pause/Resume script ["0:00:00"]" to make the pop-up list stay open on screen (MacOS). Go to Field - (makes pop-up list appear) Loop Pause/Resume script ["0:00:00"] - (keeps pop-up list open during loop) Exit Loop If - (exits loop when user selects a value from pop-up list ) End Loop Go to Layout - [Layout number from field] - (= selected value from pop…

A little something that's been givine me a headache... I have a database full of records. The field active keeps track of which records are active, and automatically updates itself once a record passes its expiration date. I would like to know when any record goes sour so I can assess whether it needs to be renewed. I want to setup a script that runs at login(no problem there) that will check if any records have expired since the last time I logged in, and hopefully tell me which one (although that can be found out with minimal detective work if it cannot be scripted). Any takers on this one? I know how to setup a script to run at login but I don't know what…

Is there a way to script keybord functions. i.e. make buttons for ctr+r etc. Thanks

I'm trying to make Filemaker tab to a different field depending on the data entered in one field. Example: Field one has two options Yes No. If the person enters Yes in field one auto tab to field 3. If the person enters No in field one auto tab to field 4. I don't want to create a related database. Any suggestions? Thank you.

Hi Can someone clue me in as to alphabetizing a list in FM ina single field. The list is seperated by returns and may contain multiple words per line. This would be the contents of an example field: Fred Abby & Joe 2Happy ToCare Ancient Aztec Ruins are amazing Lettuce Pray Thanks in advance! Chas

I have created a script that calls for an import of data from another database. I put in the information about which file to import the data from, and which fields should be imported, but the next time I enter the database, and run the script, FileMaker seems not to have saved the information. Under V6 you used to 'save' the updates, but under 7 this dialog does not come up. Is there some other way I should 'save' the changes to this import script? The files are both served from FMServer7. Thanks!

Hi! Database A (master file) is related to Database B. I want to write a script that will allow me to enter a customer number into DB A and then have the script validate/check that there is a related record in DB B. If there is a related record I want to continue entering data in DB A but if there is no related record then I want to be able to enter a new record in DB B then go back to DB A and continue entering data. Can anyone help me with some suggestions? Cheers

I'm almost done with my project but there is 1 thing that is still bugging me. My database will run in kiosk mode but I don't want the status bar (the grey bar on the left). How can I hide it?

I am using the Set Field for a global field --- I would like to format the text - use carriage returns to format the text in the field - is there a way to do this?

I have a file which uses a script to write ids to a list like 07437 09325 04462 this works fine. but sometimes i need to remove one of them. I figured out how to grab the id as script parameter. but I don't know what to do from there. I tried using the script line and 'reversng it' using minus (-) but that didn't work. - carriage return I even tried using exact to find it. In calculation I can identify it using exact but I can't use it in script to remove the exact line. Any help please?

Is there any way to set a field that a Set Field[ ] or Insert Calculated Result [ ] script step can use for the specified field? I built a calendar file today. I want to be able to create about 111 scripts to Copy, Copy/Paste, and Set Field. Copy is too easy. Copy/Paste is easy enough, but I have to go in and respecify the Paste field and Go To Layout steps of the script when I import them into another file. Similar changes are necessay for the Set Field based scripts. I want to create a global field on a developer layout to set the field for my Set Field and Paste steps similar to how I would use GetField( ) set up a quassi-dymanic lookup field. In my P…

Hi All: I have a "customer information" db that has 2 layouts. Layout 1 contains the basic customer information (name, address etc) and Layout 2 will contain special info about a customer (also contains a name field [different field] from basic]. I've created an internal link from the basic layout "basic customer name" (unique fieled) to the customer information layout field "customer name". Setting this field to a combo box I can select any of the customers in the basic layout. Here's what I'd like to do: When selecting the customer field in layout 2 from the name combo box field, I'd like to search and find the record number that, that customer's record is …

Hello All, I'm using FM6 on Mac OS10.3. I have defined a calculation field, type Container, Do not evaluate is not checked, to grab the proper color for each record depending upon the status of the record. I'm pulling the color from a repeating Container field in my one record preferences file. The container field is defined with 10 repetitions, but I am currently only using 7 of them. All is well until I need repetition 6. I have a dark grey color at present (but have tried many other colors). The records which should show dark grey do not show any color at all, no matter what I change the color to. All other status entries grab the proper color. I have check t…

Hi Guys I have two fields in my invoice database, the 'invoice due date' and the 'invoice paid date'. I would like to find out, on average, how good a client is at paying on time. So I need a script that works out the difference, as a number, between the two dates. But what I have doen doesn't work!!! For example, an invoice due on September 25th but paid on September 20th would return the value of '5'. But an invoice paid on September 30th would return the value of '-5'. My calculation below is completely wrong and I don't know what I should be doing! If ( not IsEmpty ( invoice paid date ); Int ( invoice due date - invoice paid date ) ; "" ) Can anyon…

Hi All, I'm new at using the Send Message script step. I want to use it to open a Word document, but the specific path may vary. It will always be in the same directory as the current solution. Is there any FMP function that will tell me the current directory of the database I am running? Thanks, Susie

I'm new to the software, and haven't found any posts so far that could help, so hopefully one of those more advanced can give some help... I need to create a script that will email one of my callers when the next contact date arrives so they can be reminded to follow up with customers. Any suggestions?

Hello All, I'm scripting a date field to allow for an undo, however, a question is left in the date field after using a set field with result being "". Any suggestions as to how I can keep the ? from showing up in my now empty date field? Thanks, Lisa

Hi, I'm attempting to Parse out a Price List which was sent to me on a Pdf Format. I know some of you are just as fond as me with these parsing scripts and techniques, so I would be grateful of any help you could provide. I'm wondering which of FM7 new text tools you'd be using here. Attached is a sampler of the pdf document (70 pages in the final one), and below is part of the text returned from a first copy/paste to a global field. Text Copied : AGORA PriceList.pdf

I calculate a URL (complicated string concatenation) and use the 'Open URL' script step to display the resulting web page in a browser. Is there a way to force a new browser window? In html, you would add target="blank" to an <a href="... sequence. Any way to do that in FileMaker? Thanks,

Hi to everyone, I have a script that uses the funktion search/replace, and I am trying to use the skriptparameter for the search query. For some reason "get (skriptparameter)" does not work as a funktion for the search, maybe I'm using the wrong synthax? Does anyone know how to solve my problem? I'm a bloody beginner when it comes to fmp, I'm sorry! Thanks for your help Sebastian

I don't know why I can't figure this out, but HELP. I'm trying to create a simple script step to open an external pdf file that will be linked to each record by a field that is set with file path, etc. So when a record is linked to a specific pdf, that file will be launched when the script is activated. This has to be simple, but I've tried "open file" and "send event" with no success....the pdfs will be stored on a server and the whole solution eventually run under FMP server. I'm running WinXP. When I try to send an event via a calculation to open the path set by a second field, I get the error:"Cannot open the file C:Documents"...as though it's not reading the wh…

Hi, I am migrating from FMP3 to FMP7 and I love the new features. There is one thing I am trying to do that is making my noggin' hurt and I would appreciate any suggestions for a way to do this. I have a form which I want to be multifunction. A button at the top is clicked to toggle the form between 'Ordering Mode' to 'Stock Control Mode'. When the button is clicked, all the button labels etc on the layout change to reflect the new mode and so on. However, if the user is in 'Ordering Mode' they need a drop down list of our suppliers (which would point at a global field) so they can select which one they want to work with. But if they are in 'Stock Cont…

Hey what's up? You guessed it, another filemaker question. I'm not fully understanding Pause/Resume? I have a Pause/Resume in one script and that script brings me to another layout to do some stuff. Then I click a button that has a script and then I want it to resume back to my last script. Instead the script just sits there and I have to click the script:continue button. Is it possible to run a different script while another script is running and then resume back to that previous script? I tried debugging but the Pause/Resume is confusing me. Please let me know if want to see my code. Thanks, Galen

I would like to enter the results of a "Insert Calculated Result" into a field in all records. In the script I have made it only calculates in the first record. What instruction do I need to enter the data in all the records. Many Thanks Steve

Is there any way to get FM to go to the next five records from the found set in list view? P.

I posted this on another forum and haven't gotten a response. I am hoping someone on this forum will have some ideas for me. Situation: User is presented with a popup menu (set to not allow entry) which has the following script attached. This popup lists sort criteria. Script worked fine in the following format (without the bold I added later). But

Good Morning List, I need a script that when I click a button will find orders due for the next 5 days. I would base this search off of the "DATE DUE" date field that is on my table. Ideally it would be intuitive enough to leave out saturdays and sundays. I had this functionality in FMP 6 but when I upgraded the script no longer works and I cannot figure out why. Can any of you helpful souls out there provide a solution for me? I would greatly appreciate any help. Thanks Steve PS Also, is there a preference I can set on this forum that will notify me if anyone responds to a post? I thught there was, but am unable to find that now.

I am trying to set up a way to GTRR (go to related record) from a series of repeating fields. This doesn't work... clicking on a repeating field always acts like you clicked on the first repetition. To get around this, I thought I would do something clever... create a set of fields, each containing a number (1-the number of repeating fields). Clicking on it will check whatever number was in that field, go to that repetition, and do the GTRR functions from there. Unfortunately, there doesn't seem to be a way for a script to know the contents of the field that was clicked to call it. True? Is there an easy way to solve this (GTRR from a repeating field)? I am really stuck o…

I have a main DB where a sequential job/serial number is assigned every time a new record is created. This DB is related to three other DBs that each might use the job number field. Buttons are used to transfer data, including the job number, to any of the related DBs as necessary. I do not want the Job number to be transferred more than once to each related DB. When a "transfer data" button is selected I would like a script to verify if the job number already exists in the selected DB. If it does exist, the user should be prompted of the match and kept in the main DB. I'm a FMPro 6 user. Somewhat of a rookie too. Please help! Thx

Just upgraded to FMP 7 from 5.5. One of my scripts has a Loop/Exit Loop If... The Exit Lopp If statement looks like this: Exit Loop If [${filename04-05}::PIN = 0] When I enter "0", (zero) into the PIN field it is supposed to exit the loop but it doesn't. Does the hyphen in the Tablename cause this problem and if it does is there a way to change the Tablename? Thanks

I have set up a simple script to add line items to an invoice. The script is as follows: Copy [select; invoices::order_number] New Record/Request Paste [select; invoices::order_number] Commit Records/Requests[] Refresh Window The record information is being pulled from a related table, but does not show up until you add info ie. quantity_billed and description_billed and then you flip to a previous record and back again. I cannot get this to refresh for anything. It would be ok if it just left the info from the previous record, but it goes blank as soon as you activate the script. HELP! TIA, .sly

I need to automate a process by which I archive the reports my solution generates. Does anyone know how I might approach this using pdf's? Right now i produce reports, but periodically they need to be amended. When that happens, I need to have a record or the original report.

I have my accountant export a list of invoices in a spreadsheet and would like to use this info to perform separate find requests in order to printout the related invoices to send to the client - any suggestions how to automate ?

Hello, i am trying to send an open application apple event to a selfmade xCode application on 10.3.5 with FM 6 and/or FM 7. Everytime i select my program FileMaker tells me that it is unknown. My program shares data with FileMaker per specialized apple events. Is there any solution?

I am trying to set up a script step that will import a selection of information from one table in the same file to another, and every time I type in the file path, it crashes my Filemaker... Any thoughts? I am doing this on a served file, being hosted by FM 7 Server. Thank you, Rebecca

Any script to create a new folder on a network volume available? I would appreciate any help.

I have 2 layouts using the same TO. Layout A is list view and Layout B is form view. I made the fields on Layout A buttons to switch to Layout B. What happens is when I click a field in the list, the record actually gets selected before the button kicks in to switch the layout, so I get a desired result. I get to view Layout B on the record I clicked on when viewing Layout A. OK. So I want to do the same thing, but instead of just switching layouts, I want to open a new window for Layout B. I can get this done, but it does not go to the selected record. I have tried related records, but it doesnt work because both layouts are from the same TO. I …

OK, this may be a newb question, but since I'm a newb I guess I'll ask it: Can scriptmaker adjust the options in a field definition? I have 3 files, 2 of which have similar "head" information (ie: book title, publisher, etc.) with each book having a unique title ID. My 3rd file currently does the lookup from file "1", based on TitleID, but because of the age of some of the records, it would be better to lookup from file "2". Ideally, I would like to create a script that changes the lookup definition for each field from "1" to "2" and grabs that information. is this possible for FM Pro 5.5?

I have a csv file of several hundred bad email addresses which I want to purge from my database, but I can't figure out how to create a script which draws on a file outside of the database. Any help is greatly appreciated. Thanks!

I have a script broken in 2 parts. The first one performs a Go to related record step showin only related records The second one picks a record and passes the information to another TO. and then closes the current window. The problem is that if there is no information to show, no window will be generated and then the scrpit closes the only available window. This new version of FileMaker is very powerful, but there is a lot to learn while developing your new solutions.

I am trying to perform a find in various fields and I would like to be able to select the options through a value list consisting of "Name" and "Month" I would like to be able to select a "Name" then a "Month" then click (for example) a find button, and the relavent results returned. Is this possible? Regards Dave

I have a field from which I make a selection from a value list which consists of 4 names. What im trying to do is count how many records there are for each name. EXAMPLE If I had a hundred 15 records broken down as follows John Doe = 3 David Atkinson = 5 John Smith = 6 David Smith = 1 I want to automatically displaly in a field that John Doe has 3 records, David Atkinson has 5 records and so forth. I know what I need to do in my head, but I just can't get it to work in practice, and I have tried and tried. Hope this makes sense.

When sending mail thru the SEND MAIL script and including a field as the body copy the email opens up using Outlook 2003 and the user cannot see the body copy. (it seems empty) If the email is sent anyway the recipient receives it properly with the correct body, however if the recipient types in a body (thinking the body is empty anyway) the new message overides the original one. Anyone seeing this problem? What can be done to fix it? HELP ME PLEASE!!! Why isn't the body appearing in the window?

Hi, We need to port an application from PHP/MySQL to FM7. I'm a newbie developer in FM but I know other languages (C, PHP, JAVA...). I looked at the capabilities of ScriptMaker but I'm afraid to have difficulties to port an OO application easily. For example, I use a lot arrays in PHP but there's nothing like this in the variable types in FM7. Has anybody already done such a port?

hi - i hope i'm in the right forum? i was wondering whether the scroll bar in one field can be made to scroll an adjacent field as well? the scrolling field is a very long "transcription field" and the adjacent field is a "visual log" field which describes what is happening in that particular section of the transcription. so can the visual log field be made to scroll in synchronization with the transcription field? and is this an ez thing for a newbie like me to perform? the reason i have both fields seperated is because both fields need to be independent of each other. thanks in advance! edgaroso

I have a value list (radio buttons) that contains three values (in the same field). I would like to make a script that when a user checks one certain value, send an alert email to someone. So far, I made the whole value list field connect to the script. So no matter which button to check, the script is activated, which is not what I want. Please help. I am totally new to FileMaker Pro. Thank you.

Hi, I'm using the Send Mail script step and have made a calculation for the message of the email. I'd like to email something like this: Contact # 50777 --------------------- Information: --------------------- Name: Scott Bobcat Address: 72 Marietta Street NW Phone: 322-526-5673 Email: [email protected] My calculation looks like this: "Contact #: " & " " & contact ID &

I need to parse this line of text with script maker into different fields. Text: 9/30/2004|6:59:35 PM|Test Co.|Test Co. 111 to Date = 9/30/2004 Time =6:59:35 PM text1 = Test Co. text2 = Test Co. 111 I used pipes "|" instead of the return character (for separators) as I thought it may interferer with the data in some the fields that may have returns. Thanks FM7

I'm trying to script a Find. Nothing elaborate - you click a button labeled "Find" and it runs a script which goes to a layout, enters Find mode with Pause, and performs the Find when you hit <Return>. Error capture is on, and if there is an error I put up a dialog and then (recursively) perform this script. The layout for entering find criteria has a "Cancel" button which, if pressed, runs a script that deletes the request, does a Show All, and goes to the default layout. When I run the Cancel script, I return to the default layout, but the Status Area still shows Script: Continue / Cancel. What is strange is that I have a nearly identical procedure in…

I know you can trigger a ScriptMaker script by defining it so it appears in your Script menu, or by tying it into a button, but are there other ways of triggering scripts? In particular I'd like to run a script that affects various fields in an entry whenever any of those entries has been modified. There must be a way to make it run by perhaps linking it to a modification date, but I can't see it. And if that's not possible, is there a way to run a maintenance script upon opening or closing that will perform itself on each and every entry in the database? I'm running FM 3.1 on mac OS 9.2.2 but will soon be upgrading to FM 6.1. Please let me know if I'm not…

I need help writing a script (if possible) to convert telephone numbers. I often import data and number may come in as: 2128542583 (212) 854-2583 etc. I want script to change to 212-854-2583 I'm willing to edit script as necessary depending on what format I'm importing. Since this same phone field may contain international, etc. I would rather handle with script than calc field: find all entries with xxxxxxxxxx (10 characters) and replace with xxx-xxx-xxxx for example. Hope this makes sense.

Hi I'm having a problem to which the answer probably is quite obvious - I'm just stuck: I have a small script like this: Go to first record loop perform subscript go to next record end loop But how do I get the ******* thing to exit when the last record is processed?? I tried creating a running serial, but even coding it "exit when serial=the last value" does'nt stop it.

I have a main database (A) that's related to a demographic database (. The demographic database gets its data from an excel spreadsheet. The two databases are hosted by filemaker server and accessed through FMP6 desktops. I've written a script that imports the records into B from the excel spreadsheet, and I'm trying to determine the best way to trigger the script. Right now when A opens, it also opens B and triggers the import. Database B will have well over 2000 records, but the script will only be synchronizing the data. On my desktop this approach works beautifully. I'm concerned that it will be slow as sin in a multiuser environment. Has anyone done something li…

I am having a hard time figuring out how to do something which I'm sure is pretty easy (if you know what your doing). I have an table called DesignLineItem and I need to make a script that searches out and deletes all blank records (from the entire table, whether 1 record or 100) , being records which are blank in 2 specific of 5 fields (productmodel_fk & productqty_fk). If it came down to blows, just deleting the records which show no value in the productmodel_fk field would probably do just fine as well. Could someone help me with this? Thanks.!! Joe

Is there a date function that returns the last day of a month that results from a calculation, given that this could be 28, 30 or 31? Alternatively, How can I write an expression that returns the first day of the month following any given date, remembering that December dates will have to return Jan 1 of the following year? I've made a few clunky attempts at this, but none has got off the ground. I use European date format, dd/mm/yyyy. Cheers.

Has anybody got any ideas as to how I might go about doing this? Thanks Giles

Hi! I have a problem with adding new records and data. I have one table with records of dates (valid from and valid to) and prices. Exmpl.: 1.1.2000 / 10.1.2000 / 100$ In other table I want to add record with current date and also the price for that date. I need something that will pull out the correct price for current date. Should I write a script that goes in other layout and searches for date or is there a different way to accomplish this? Thanks for any help Dean

Probably another silly question, but.... here's the scenario A technician is filling out the trouble report, and needs to create a requisition for parts. He hits the "New Req" buttion, which sets a global with the form # he is currently in, and auto sets that information in the new req form. After the Req form is filled in, he commits it for approval which sets a global with the req # and returns to the trouble report he was in. When he returns to the trouble report, I would like the po req # he just created to autofill back into the trouble form. I can figure out how to do this if the technician is always on the last or first record, but I am stuck if he is in so…

Ok I'm trying to write a script that will do the following :- i have a table for Quotes and a table for invoices, Both of these have Qty, cost, Details ... etc .... that repeat 10 times (so i have a 10 item quote or invoice) What i want to do ,is make a quote.....The customer accepts the quote...then run a script that will move all required data from quote to invovice I can get it to do one line, but thats where it stops! attached a screen shot of said script so far.... Any takers!!

My department recently purchased a room booking database for classroom scheduling from a developer. However he neglected to tell us that the database doesn't prevent double-booking, and he wants to charge us an exorbitant amount to make the database do this. I'd like to sort this out myself if possible but it seems to be quite a difficult process. I've had a look through similar posts but I'm not sure which solution is best. Classes can be booked at 15 min intervals between 9am-6pm. They're usually booked for up to 2 hours at a time, but bookings can be for more or less time. The booking fields are Activity, Date, TimeStart, TimeEnd and Room. What I would like to do …

Anyone else experince general weirdness when you call new record request from a file while it is in preview mode? I'm not sure if this is a known issue, and having inherited this database I'm not responsible for having not made the print scripts leave the file they are printing enter back to browse mode before completing themselves. But now I'm making sure all the print scripts do this. Been pulling my hair out for about a month on this one. The thing is, the file that was being left in preview mode, was the basis for a relation that showed up in a portal where data was entered, not the file itself. I decided to not use the portal for entering data, and tha…

Can you please suggest the easiest/best way to disable a menu command (in this case Duplicate Record). Will this require a script? And could it be based upon a Log-in Password? Many thanks.

I have a date field (invoices::payment due) included in a portal on another layout called 'update'. I'm trying to devise a script that will apply a text style (such as a different RGB value) to all dates in 'invoices::payment due' that are less than the current date, in other words invoices that are overdue. I have a 'current date' field in my 'update' layout, which is updated every time the file is opened, if it's needed, but I can't figure out how to phrase the changing of the text colour. If style changes can only be applied to text fields then I can apply it to the invoice title instead (invoices::job title) Any pointers would be appreciated.

Hi everyone, I'm posting this pesky cross-tab conversion script because I can't seem to accomplish what I need and I hope you Script Magicians will help me identify what I have wrong in my script thinking. This runs through the fields and creates records out of every field/record combination. I decided this should be a new post because it involves only the script-loop problem I can't solve ... If (after landing on a field) the contents (text) is empty, I want that field skipped and the script to jump to the next. I thought I needed another loop. Script 1 works (without the IsEmpty() test. Script 2 shows my 'logic' of where I would have thought the new …

Can a script be written that would allow a user to go to the previous screen they were looking at, even if the previous screen is in a different file? I've written a program where upwards of 20 files could be open at the same time. As it is now, the user has to click buttons or tabs to go back or forward. It would be neat if they could just click a button to return to the previous screen.

Greetings, I would like to be able to delete a file using the dos command line. I can use the send message script and get it to work one level deep: Ex. cmd /c DEL c:myfile.txt But when I try to go multiple levels down I cannot get it to work EX. cmd /c DEL c:Program FilesFileMakerFileMaker Pro 7Web logsmyfile.txt How do I escape the empty spaces between the directory names? Thank you for any assistance with this. Joe Mele

Is there any way I can use a Set Field[ ] and insert: Get ( ActiveFieldTableName ) & "::" & Get ( ActiveFieldName ) I keep getting errors on it which is unfortunate. Any ideas? Same question about Go To Field [ ] ... any way at all to specify that via global text, script parameter or ? I guess I want to insert the table/field without having to select it from the Specify Field dialog box. I'm hoping vs. 7 has a hidden miracle somewhere.

Hi, I'm purchased a calendar solution which I've been changing to reflect the UK date format (day/month/year). The only problem is in various scripts which navigate to a certain selected month. As part of these scripts, the selected year is inserted into the Day_1 field: Insert Calculated Result [ Calendar::Day_1; Calendar::Go_Year ] but what happens then is that for some strange reason it also inserts :00:00 at the end of the date so the result is Day/Month/Year:00:00, which of course is not accepted by the field validation and stalls the script. I can't see why this is inserted into the field as the Go_Year field is just a global text field. Can any…

I

I am a new user. I have an address database (one table with names & one table with address data). Each time I change the address of a friend, the old address is gone for good. Kindly inform me how I can build a database system so that I can keep a record of the past addresses of each person while the address main table shows the current address of that particular person in FileMaker 7 (i.e. the screen window always shows the current address; but the records of old addresses are saved in another table). I would appreciate it very much if someone can help in this topic.

Not sure where this goes. sorry if in wrong place. I attached a script to a button for closing the file. It looks like this, set error capture on Allow user abort Off Show custom dialog: "Session Termination" ... and it has 3 choices. Default = Terminate, button 2 = Relogin and button 3 = Cancel If Get ( LastMessageChoice ) = 3 Halt Else If Get(LastMessageChoice) = 2 Re Login Halt Endif Endif Exit Application Two problems im having ... 1) if they enter their stuff wrong it doesn't tell them. It just stays on the previous persons login but they don't notice that and they start working under the wrong person. I would like it to tel…

if I have a selection criteria that requires 5 values of field A (out of 10 possible values) 2 values of field B (out of 4 possible values) and 3 values of field C (out of 6 possible values) How many find requests do I need?

I've just started using Filemaker Pro 7 and I'm wondering if it is possible to create invoices automaticly. I will try to clarify what I want. I'm selling products and with those products people can take advantage of my support. For this support I'm charging a fee of let's say 50 dollars a month. Now I'm willing to generate a new invoice for this client every month automaticly, cause entering this manually will take to much time. Is this possible to script? If so is their anyone willing to point me out in the direction I should be looking for??? Thank you in advance,

Hi everyone, I'm attempting to correct a set of (160,000) records. The table consists only of two text fields (an import). The data looks like this: Each Company Name may have 0-'unknown' date/time entries belonging to (under) it. I used the "M" in AM/PM (F3) to identify a date/time record because it was unique. But the logic of the loop is escaping me because the following script is setting only some date/time entries correctly through the set (well actually, it's skipping a BUNCH of records altogether and I can not establish a pattern on why it doesn't work!). I LOVE looping scripts and really tried to figure this out myself but I'm stuck. I have…