Script Workspace and Script Triggers

Hello Fellow/Female Datamates, I am looking for some help on a print script, heres the idea… ——————— Go to layout, new window enter preview mode window adjust to fit pause script, indefinitely - User option CANCEL close window go to original layout enter edit mode window size to fit - User option PRINT print close window go to original layout enter edit mode window size to fit ——————— Basically, I'm looking for HOW-TO run script with IF option this do that, and IF option that do this. The two options I will need in this script is CANCEL or PRINT. Thank you for any help!

Is it possible to copy the contents of the clipboard to a script variable? I need to copy a record from one table into another table. However, I need to retain the contents of the clipboard prior to copying a record onto the clipboard. Any clues ? Thanks

Hi, I have a database containing records with fields for "serialID", "patient", "sample", and "time collected". Often, several records share the same values for patient and "time collected". I would like to have a field that calculates "IntervalTime" for each record. This would be the elapsed time between when the sample from that record was collected and the time when the first sample from the same patient was collected. (Obviously, the entry for IntervalTime would always be = 0 for the first sample collected for any patient, and all subsequent samples from that patient would have values > 0) I think this is crying out for a script, but I am not sure h…

We have found a flaw in the design we have been working on for almost 3 months or so. Currently I have a people table , a contract table and a job assignment table. (along with various referential tables). There is one person that can have multiple job assignments and multiple contracts. So I have relationships from people to contracts and people to job assignments. We just encountered that we need a relationship between jobs and contracts. For example, Person John Smith Active jobs: Lecturer for English dept Lecturer for Philosophy dept A contract should be for English and another one for Philosophy. How would I do that? I could …

Hi This is a bit of a strange request, but does anyone know of any way I can get one runtime to determine if another runtime is running? Thanks

Can anyone tell me how to get a script to execute on a set time interval, such as every 10 minutes. I need a script that will automatically import records from a predetermined location every 10 minutes with out a user physically executung it by clicking a button. Is this possible? Thanks, Ron

If this is in the wrong place I appolgize. I am trying to set up a calculated field using the CASE fucntion. My goal is to automate the calculation of the payment date. Payments received after 3pm go two business days out, prior to 3pm they go 1 business day. I am running into problems with the issue of the weekend. Here is what I tried to put together, but it is not working: Case ( cDAY OF WEEK = "7" and CREATION TIME ≤ "3:00:00 PM" ; CREATION DATE + 3; cPAYMENT DATE = "7" and CREATION TIME ≥ "3:00:00 PM";CREATION DATE + 3) or Case ( cDAY OF WEEK = "2" or "3" or "4" and CREATION TIME ≤ "3:00:00 PM" ;CREATION DATE + 1; cDAY OF WEEK = …

I have users that are in kiosk mode with a touch screen. Is there a way to tell FM8 where to zoom when a button is click? I have a floorplan with several rooms. I would like a button in each room that would zoom them in and out.

Hi - Is it possible to activate a script in a related dbase from the first dbase?

Hello, Not sure if this is the correct place to post this: I will be hiring people to help me with database entry, but I would like to do it remotely. Is it best to put my database on the web, or is it better to load up FM on the helper's computer? Basic database entry and bulk letter printing. Thanks! Michael

Hi all I would like to create a script to calculate the time of day in order to display a "good morning," "good evening," "good afternoon" message. Has anyone seen a similar script out there?

I'm having another brain cramp. I'm writing a "merge" script... idea is to take several contact records that really are the same person and merge them into one record. Without going into a whole lot of detail... if I have two records in the same source table and record B has some fields empty that record A has data in, what's the best way to get the data from A into just the empty fields in B? Thought about setting a bunch of variables then going to B and checking, field by field, to see which are empty, then SetFielding them to the appropriate variable if empty and moving on if not empty. But something tells me there is a better way. ... or is that wishful th…

Help please... I need a script statement on the end of this script that will keep the field, "Work hours", blank if the field, "End Time" is still empty. Work hours= Round(Hour( End Time - Start Time ) + Minute( End Time - Start Time ) / 60 - Total break time,2)+If(End Time <= Start Time,24,0)

I am trying to re-initialize a variable within a loop in a script. Basically I want to save several pdf files with different file names that relate to each record. Everything works fine except the variable "$pdf_file" retains the first value it is assigned first time through the loop - the pdf is saved but written over by each successive loop. I have spent a couple of hours scouring the net for a solution but no luck - can anyone offer an explanation or another possible solution? Thanks Here is the test script I have been working with. Go to Layout [ “test” (Listing Data) ] Enter Preview Mode Go to Record/Request/Page [ First ] Loop Set Variable [ …

Hi, I'm having some trouble stopping my script from dropping out into the wrong window because I can't seem to capture the error code. I have the Set Error Capture On script step right before the Close Window script step. Right after that step I set a $$Error variable with Get (LastError). The problem is that unless valid data is entered, I don't want the window to close or the script to continue, as it is doing now. Help or an example or two would be much appreciated. Best wishes, Dave.

Hi Gang, This one has got me stumped . I am trying to create a Send Event script that uses a command line application that will turn a pdf into a jpg. I want the ability to do this for every record in my table. This is the script calculation that I am using. "c:/Progra~1/PDFtoJPG/pdftojpg.exe -i " & Items::PDF Path & " -o " & Items::Folder Path & " -r 150 -q 100" The first part that calls the program works fine as my "Program Files" folder has been shortened to "Progra~1". Where I get into trouble is in the path for the input and output files. These are typically long name files and folders. When I execute the script, I get back an error tha…

Dear All, I'm looking for a way to change the name of a field within a script. The database is a CRM contact management system, with several user-definable fields. Currently, I have to make the changes to field names myself, a users do not have admin rights, but I was wondering if there is any way to automate this process. Many thanks in advance for any suggestions, which are greatly appreciated. Regards, Dan Stuchbury

I'm trying to set up a FM database in order to store medical lab results of patients and hand them over a print out of their blood test results. How can I manage to have the font change automatically from normal to bold when a value is outside the normal range of values? One more question: I have a calculated variable A, p.ex A = B-C-D, which is calculated after I give the values of B,C,D. I would like to have a message shown as value of the variable A p.ex. "not applicable calculation" in case the value of variable D falls outside a given range of values. Any ideas? Thank you.

Hi, does anyone know if there is a simple function to return a number with a fixed number of decimal places? I'm having trouble working with mail.it in getting a text string together with price numbers properly lined up. $2.10 for example is coming out $2.1. I know how to set the number of decimals from the formatting menu but need to work with a text string. Help appreciated. Cheers, Dave

I have a script that adds new records. The layout that is used to enter the new record is different for different users (one type of physician uses one form and another type of physician uses a different form). Within the "add new record" script step, I want to determine who the user is and then send them to the appropriate form. I tried the following script step: Go To Layout [Case (Get (AccountName); "admin"; LayoutNames ("EP INVOICE"); Get (AccountName); "cohen"; LayoutNames ("CATH INVOICE"))] where admin and cohen are two different users and EP INVOICE and CATH INVOICE are the desired destination layouts. I get no error messages from this calculation, ho…

This is probably a simple step, but I can’t seem to figure it out. From the main menu, there are buttons that navigate to different layouts, but the last viewed record is on the screen. How do I script the navigation to go to a blank screen so then the user can decide if they want to find or enter a new record etc? Thanks in advance

Hi I would like IWP users to log into a particular layout. Using Web as the loging name i have in the login script; if Get ( AccountName )="Web" goto layout etc but it doesnt change layouts. The permissions do change but the layout doesnt. is there another way to detect access is via web & to automatically login in Any ideas? thanks

There is no error code generated when the user cancels a print, is there any way to detect it? FM version 5.5

We're running FM8Pro on a PC network of 6 users with FM Server 8. When we open one of our many a solutions (5 small files)we encounter a 50 second delay. The Opener file opens with the file name in the border but a white screen. After the delay, the files open normally. The same hapens when we use remote desktop over terminal services. I have even stopped the server and used FM8Pro Advanced to open the solution directly on the (stopped) server. We get the same delay. This is a new problem with FM 8 not with FM6. Anybody got any ideas?

I have created a report that prints and need help with some calculations. The fields are in the database, but should only print out on the report if a certain condition is met. For instance, if employee status = FERP, then print Date of Birth. (I don't want the dob printed for all employees- just those with FERP status). I don't want a button to do this, this logic needs to be on the report somewhere. I don't know where to start. Any assistance is greatly appreciated.

I am a novice FMP user, and have a question about creating a script for sorting. In FMP6, there is a database template for Personnel Records. In "List" view, there are column headers for several fields that, when clicked on, toggle between sorting the column alphabetically ascending/descending. I have tried following the Sorting scripts in the template to make columns for additional fields, to no avail. I seem to be missing a way to define a value in the Sort Ascending and Descending scripts (for example, in the Set Field line, there is reference to the term "departmentA" in the Sort Department Ascending script) and I don't know how to define this value for other fields. …

For my membership database, I would like to take member photos (using an isight camera) and have the photo automatically inserted into a container field. I realize Troi Grabber is a bit dated for version 7 and 8. Are there any scripts or other third party plugins out there? Stefan A. Schwarze clubevolution.com

I have a Contacts database and have used Applescript to Dial Telephone Numbers and use Skype Names to call directly from the computer its great Is there any way of scripting Skype on a pc ? Any ideas would be great...

I have a script that uses if get(activemodifierkeys) = 1 perform script endif to check if the shift key has been used. I have just noticed that if the caps lock key is in use this 'if' test fails even if one does press the shift key. Does anyone know of a change that I can make to the script that would work wether or not the caps lock key is in operation? TIA Phil

Hi Everyone, Our Orders are our Invoices. They become an invoice the day they ship at which time they are frozen and can't be changed or deleted. Invoice serial is text similar to 096248. Management decision when we started using FM was to allow deletion of an Invoice if not frozen (before shipped). They have recently decided to change that policy and instead flag them as void. However, I now have the task of 'recreating' the deleted invoices by identifying the holes in the number sequence. I can then go to a backup from that day and pull the 'voided' invoice back in. I need a quick way to find the holes in our text-number series. I could sort by Invoice …

We have a tenant ledger that on the first of the month we have to go through each one and enter the amount of rent that is due. Time consuming to say the least when you have 200 properties. We are looking for a way to do this automatically on the first day of the month. We already have a tenant ledger (that is a portal from the journal line items) and would like it to fill in there. Any suggestions would be appreaciated Thanks Shorty

I need the simple loop syntax to loop through a found set of records and simply add a few characters to each record until the script reaches the end of the found set, then the loop ends. I just need to control the loop with a counter and I have forgotten how to do it. Help, Daryl

Our Invoices pre-fill ScheduledShipDate with the next allowed shipping date (Auto-Enter, Do Not Replace). Staff is allowed to change this date if customer requests it be held (two weeks, for instance). But when they change the date and enter an INVALID date, the process fails. FM allowed a ScheduledShipDate of 5/9 /2006. And FM could never identify which day portal it belonged to so it never displayed in any date-related portals and was never identified as needing to be shipped (since I use GTRR instead of a Find)!! Attached is a sample. Invoice window is locked in place until script validations all pass. If any validation fails, script tells User the problem …

I have attempted to auto fill a customer ID field (pK_memberID) in a new record layout for recording taxi trip details once I select the customer from a drop down list from the member table. On creating a new trip record, I select the member and then I select the assigned driver. I can create finds based on customer or driver name but I would like to have the member or driver ID on the layour as well, although it's not necessary. I know that FM8 has an auto complete function built in but I would like to know how to build a script that would auto fill the customer or driver ID field or for that matter any relaited data on the form from the selected member record, such…

I have hex fields (such as "U+33DA" etc.) in FM 7 and I want to paste this as the corresponding Unicode character in another field. (I 'calculated' the hex from the decimal number) I haven't been able to use Applescript to do this in FileMaker, although this works as a stand-alone Applescript: run script ("«data utxt0395» as Unicode text") I can't figure out how to turn that into a ScriptMaker script to populate the field. Should it be a calculation field, a calculated Applescript, a script that calls an Applescript. I'm just confused, this should be possible using the native ScriptMaker functions but I'm not finding anything close. Any help is appreciate…

Why is it that when I do a find (not a multiple search) on 2 fields that are set up as checkboxes, it pulls the wrong data? I thought that a single search meant find all records including "this" AND "that". My results include a mix of both boxes checked and one box checked. help? Thanks

Hey, I am new to FM and I want to calculate some fields and am COMPLETELY lost. I have a value list of Yes NO and "_". I need to know how many people said YES, how do I go about creating a calculation to accomplish this task and every time I run the report for it to update on its own? I know this is trivial but I am learning....

I am creating a script to email customers some information out of the database, and I'd like to wrap it to make it easier to read. Is there a command or applescript or something I can call on the contents of my field to have the text wrap? Thanks.

This seems so simple, but I am obviously missing something. I need to copy a number field from one database and paste it into a releated field in another database. I set-up a script to copy the original field and the paste into the related field, but nothing is happening. Any help would be great. Thanks Image_Database.zip

I'm new here, so please forgive my double post. I will try again and hope that I'm descriptive enough so that it makes sense. I would like to control access to data either by way of the found set, or controling the printing of a found set utilizing some sort of key. I have 2 tables. 1 table, (business table), displays alot of static data, a primary key serial number ID tied to a specific business, and some other business information fields. The other table, (Prospect table), holds the mailing list data to be merged with the business table. I would like to control the access to the mailing list merge data by some sort of key to unlock a predetermined number …

Within FileMaker Pro 8 (not Advanced), is it possible to determine if the user is connecting to a database via IWP versus sitting at the host computer? I want to deny some activities to users connecting via IWP. Thanks in advance.

Greetings, Environment...Mac OS X 10.3 with FM 5.5 server with clients Mac 7.0. I need help with the following task. I have a DateField that the user enters date manually. Based on this field date, I want to create a script that will go to "layout 1" if DateField is > (greater) than "June 1, 2006", otherwise, go to layout 2.

Hi guys, I have a DB where I have it set to login using a guest account. I also have it set to launch an opening script. It may seem odd but the opening script checks the privilege set. The idea is that I can hold down shift key and log in as the admin with full access and when the opening script checks for full access it will not impliment some other security steps. The problem is that if I close the file while logged in as the admin, when I open the file again without holding the shift key, it still skips the security as if I am the admin. Does this make any sense? If so why would it do that. Doesn't it log in as a guest before running the start script? What could …

I need to put text that contains quotation marks into a field from a script. Can anyone tell me how? Thanks, Kay

I am looking to pass the Pause state as a script parameter. Any ideas on how to tell if the current window is paused?

Im stuck, again. I know there is a solution but i just can't grasp it. I've been close but close is not good enough in this case. I hope you understand despite my lack of "correct words". In my current application a user can book items from DateOut to DateIn. An item for example a speaker can have any number in stock ex. ArtNumber1 10 pieces. So to continue the example. A user can book 4 of "ArtNumber1" between 8/7/2005 (DateOut) to 8/10/2005 (DateIn). Then a second use can book 2 of "ArtNumber1" between 8/8/2005 (DateOut) to 8/12/2005 (DateIn). This will lead to the following information. 8/6/2005 -> 10 (in stock) 8/7/2005 -> 10 - 4 = 6 (in st…

wondering if there's any way to do this? I have a fairly simple script that needs to run on record being commited due to the fact that my users are too stupid to click a button (even if when a warning popup occurs). Hence I need to automate this occurance for them when they leave the record or make a change to the record. Solutions?

Does anyone know of a way to lock multiple records? The only way I know of is to open a separate window for each record I want to lock. I'd love to find out if anyone else has found a more elegant, less intensive method or if I am overlooking something obvious.

I'd like to create a script that creates a new related record in a different layout. Is there a way to do this without using a portal? I tried creating a script that copy/pasted the related field, however I saw that this is not a good idea because it pollutes the user's clipboard. I also had trouble getting this to work because my script kept selecting-all, instead of just the contents of the field in question. Am I missing something? Any advice would be really appreciated.

Hi, I have a number of simple find scripts defined for automated reports from an invoicing system and then a sort and display script to show summaries. When I add to the find script the Perform Script, Sort, the find is not performed. The script steps are: Go to Layout["Line items"](Line items) Perform Script["Change to Landscape] Enter Find Mode[] Insert Calculated Result[select;Line items::Week;WeekOfYear(Get(CurrentDate))] Insert Calculated Result[select;Line items::Year;Year(Get(CurrentDate))] Perform Find/Replace(No dialog) The Invoice No Sort steps are; Sort Records[Restore;No dialog] Enter Preview Mode[Pause] Enter Browse Mode[] Can someone…

I'm trying to get a field repetition value (actually setting another field based on that value) when a user clicks on a line (repetition) of a field, but have not figured this one out. It seems when I make a (repeating) field a button, there is no way to determine what line (repetition) the user clicked on. Am I missing anything? Thanks. Ken

Hi All, what i want to do sounds simple enough but for some reason i just cannot find a solution. I have set a layout "calls log" with scripted buttons for the user to press corresponding to the received call. All i wish to do is stop a user leaving that layout until they have entered data into the field, with pop up text appearing if the user tries to do so. Help will be gratefully received. Thanks.

Hi, I am new to filemaker and database. I want to make a database which give me auto notification pop up which display names of people who did not pay on certain date. For example, person A need to pay for product after 30 days. I want to know this person's name so I can contact that person. Is it possible to do that?

I am attempting to import a spreadsheet that has a field consisting of 1s (representing true) and 0s (representing false) seperated by commas that indicate if the company as a specific feature or not. I would like for the check box to be checked if it is a 1 and unchecked if it is a 0. Is that possibe? Thanks.

I'm trying to construct a simple script to clear a text field in the last 10 records of a 20-record table, but the script always clears the field in all of the records. Enter Browse Mode [] Go to Record/Request/Page [No dialog; 11] Loop Replace Field Contents [No dialog; Table::Field; ""] Go to Record/Request/Page [Next; Exit after last] End Loop This is my first attempt to use looping in a script, so I've obviously missed something very basic. I just haven't been able to locate a relevant example to get me on the right track.

I took FMs template Contact Management and added several Email fields and built scripts for them to open Apple's Mail. They were all copied from the original Send Email script, but they aren't working properly for a reason I can't figure out. Here's a brief description of what's happening and not happening. I'm attaching the file as well. Any help will be deeply appreciated. Thanks, ajnhlr Clicking Script button for Spouse Work Email with [email protected] gives me the message “There is no email address for this record. Please try again after entering an address.” If I change the address to [email protected] it works, but shows the message be…

lets say i have two tables, the first is [color:green]TEMPLATE and the second is [color:green][color:green]PATIENT, TEMPLATE has two filds where i store the templates for pathology reporting first field is [color:red]template name, the second field is [color:red]gross description. i would like to have a pull down menu on the [color:green]PATIENT lay out that will display the templates names and when i choose one i would like the gross description field from the [color:green]TEMPLATE table to be inserted in the gross description field in [color:green]PATIENT table(patient layout). is there any thread or referal to an article that can help me with this type of automa…

My first post, so be gentle! He's my issue. I'm trying to get data in a single field from one table to another. I need to move a number from one table into a global number field in another table for a comparison test later in the process. I've used the Copy and Paste commands with good luck to date, but this time it isn't working. ..mostly. ...sometimes. Sorta. But not really. I'll explain it in generic terms, but would be happy to go into detail if it will help. In table A I do a find and start looping through the found set. for each, if data exists in table B, I run the external script (In Table B ) to copy the duration field and paste it into…

I'm trying to open a filemaker file from within from a script. since variables don't work when opening files I'm trying other options. THe file being opened was just created by a previous script step so therefore doesn't exist at the time of writing the script so I can't define or add the file. Oddly enough the Automatically Open file option after saving doesn't open the file either. Any thoughts?

Hey All, big issue here trying to figure out. I have a program i created to convert a pdf file to an earlier version (compatible with version 4.0) The way my program works is the user enters the directory and filename at the command line. For example, to convert pdf named testing.pdf you would run this: c:programspdfconverter.exe c:pdfstesting.pdf I originally required quote's around the directoryfilename.pdf so that it knew it was one parameter, but now i just pull the entire command line and get it that way, i figured it would be easier on filemaker pro The problem is, that i want this to be automated, i have my script right now save the…

Greetings all! This forum is getting huge, so I hope I'm posting this in the appropriate place. : I am trying to create a purchase order with multiple line items from work orders that each have multiple line items and at the end have a relationship between the two so that if the purchase order needs to be changed or canceled it would be reflected in the work order line items. Let's say there are several work orders and two call for the purchase of routered pieces to be outsourced. I would check a box on both that signifies they are to be collected for the same purchase order. What I have so far is a looping script that starts in the purchase order table and go…

Is there a way to capture the data entered in Find mode to be displayed in browse mode? Here are the steps There are 6 search fields: 1. User performs a find request 2. The find data that is entered for each field is captured 3. Perform find is executed 4. In browse mode the found records are displayed "list view". 5. Also displayed is "Your last search was:" for each field

Can anyone tell me how to perform an unattended backup on an open file using Filemaker 8 Advance? We run a small peer to peer network and would like to perform automatic backups at night without “manually” opening and closing the file. Is this possible and what would be the best approach?

I am creating a quiz from a db in which each record has the following fields: 1- street names (question) 2- location (answer) 3- hint 4- map (container) I have created layouts displaying: 1-street name only (question) 2-street name & hint 3-street name & map 4-street name, location & map (answer) I need to display each next question (street name) in a random order and I cannot seem to create a script that will do this. Is a script the way to do this or do I need a different approach ? Any help would be appreciated, I have firefighters who need to learn their streets and this will help them do it in non-alphebetical order !! …

From within the main file I have a script that creates a new file with it's name based on a variable. In the next step I want to open that file but no attempts I've tried seem to work. I've tried the Automatically open upon completion check box, Send Event, DDE execute,etc. but nothing will open the file that was just created. Any thoughts?

All UK mobile numbers are as follows:- XXXXX XXX XXX (11 digits) e.g 07747 340 147 (11 digits) Can someone help me so that when i put in XXXXXXXXXX this gives me a result of (XXXXX) XXX XXX or XXXXX XXX XXX Thanks in advance.

Greetings, This one should be simple, and yet... What I would like to do is a button that resets the date fields I use to filter the data displayed in a portal to the minimum and maximum date values of the table, so that all entries are visible and so that I can know what the date range is. I tried this: (btw the Filter fields are global of course) Go to layout ["LayoutName"(TableName)] Show all records Set Field [OtherTableName::FilterFromDate; Min(TableName::Date)] Set Field [OtherTableName::FilterToDate; Max(TableName::Date)] Go to layout [Original Layout] ...but it sets the filter fields to the active record's date instead of the minim…

When writing a script (lets say to find all records with a reminder date of today), is there any advantage to using one of the two methods below over the other? I could use: Enter Find Mode Set Field [History::Reminder Date; "//"] Perform Find or, I could just use Perform Find and Specify the Find Request. Is there any instance when using one method would be preferred over the other? Thank you.

Hi, New here... hope I'm in the right place and would appreciate redirection or additional resource/list/forum suggestions. Have a set of 6 files in a relational db (my first) running my biz/life, and have become addicted to fm, but so far have been going it alone and will appreciate any and all help/advice. Problem is between a master file which displays the correct, recently updated, data from a field in the related file, but exports an older version of the data. The same relationship, based on the same key field, works fine with the other related fields. I have deleted the troublesome field and reassigned relationships several times on the master (S_db), but a…

Hi everyone, I want to run tests across our network. I want 10 simultaneous Users. I don't have 10 Users in my office at any given time (they work various hours) and even when at work, they want to work (make money) and then go immediately home. They don't want to stay and help me beta test. I want to script these Users. I want all systems to fire scripts simultaneously at my command. And I want to time different loads across the network. I want to test globals versus unstored calculations; I want to test various packet-handling issues. But I need to use robot users. Robots (script-fire each client on command) will also allow for precision testing. AND …

I've inserted a pdf (of a powerpoint presentation) into a container field. It works fine if I choose "store only a reference to the file". But I want the file to upload to the server, so I've deselected "store only a reference to the file". The file takes some time to (presumably) upload, but if I double click on it, it does not open. Any suggestions? Thanks!

Hi Guys, This might be really easy to solve but I have been awake for 36 hrs and cant seem to picture the solution. I have a marketing database in which I input orders for customers with all normal related fields, such as order date, products ordered, what store, coupon used and so forth. I am now creating automatic mailing lists and got stuck on one criteria, "number of orders" for a particular customer. How can I create a scheme where when I create a new order for a customore it gives it an order number relvant to the # of times previously ordered. For example if its a brand new customer, the counter will start at zero. If its a customer already in the databa…

I have a single field that contains a lot of text (its an output log from a computer system) I want to set up a database that has several tables: 1 - output log (single field) 2 - table of lookup values (the actual text to count up in the log, and the part number that output refers to) 3 - Final list of part numbers and count of them I want to do a loop for the table of lookup values - starting at the top - look for the specified text in the output log, and count up the number of times that text occurs in the log, if not move on to next part number how would i do this?

I'm working on a database that tracks the ads placed in a publication. Some of the advertisers place ads in multiple editions, so I created an "edition" field to track which ones they appear in. But I would like all of the fields for listings that are older than 2 editions to appear in red so that I can easily distinguish at a glance which ones are old and which ones are still pending. This is the script that I wrote using the text color function. Then I created a button for each record and set it to run this script. I know I would have to add the other fields to it, but I can't even get it to work on the one field. If (Database::Edition ≠ "May" or "June" ; Tex…

I currently use an auto entry serial # as follows: 0506-01 (1st job of May) 0506-02 (2nd job of May) etc. The auto enter function has worked fine until this point, but now I need to handle some additional functions. I need to have multiple records with the same # followed by a letter. Example: #0506-01a #0506-01b #0506-01c then the #0506-02 I thought I had it figured out, but then it started removing the hyphen so it entered #050602. Can this be done so sometimes it keeps the same number, but adds a letter, & other times it enters the next serial value?

Hello Forum Hope you can help me on this one. I have to copy and paste about 200 contacts and whenever I do this the address line places the text into the address fields with a space which I have to then delete. E.G 123 the Avenue is pasted as _123 the Avenue _ = space Is there a function that will automatically delete the space? Hope you understand. Thanks Martin

Hello all, Making an attempt to open a window and having a problem moving it to where I would like to appear. I have a script that works, but the window keeps opening in the top left corner. No matter how I adjust the distance from top or from left, it still opens in the corner. Am I forgetting something? Thanks.

Well here is the story. I have two databases: Orders.fp7 and Invoices.fp7 In Invoices.fp7 I have a Table called: "Portal line items" wich contains records based upon the field: "Invoice number". Orders.fp7 <-Fields-> Order number Description Order status and Invoices.fp7 <-Field-> Invoice number Portal line items <-Fields-> Invoice number Ordernumber Description When I finish creating a Invoice with multiple portal line items that correspond with the multiple orders from the same (single!)customer, I want to press…

Hi Everyone, I'm new here so be gentle...I have created the script to print multiple layouts and loop through all my records. I have also scipted to perform a find before doing so but I can't seem to get the find step right. It prints all the records. Can someone help? What step am I missing? Thanks... :

I'm scripting a find using Perform Find. If no records are found, I get the following dialog box: "No records match this set of find requests" followed by Cancel, Continue, and Modify Find buttons. I would like to have a custom dialog box appear which says, "No records found", and the script then stops. I don't like the standard dialog box above, primarily because if the user selects cancel, the script stops at a bad step in my particular script, and if they select continue they end up in the wrong layout. I have tried: Perform find If (Get (found count) = 0) Show custom dialog ["No records found"] Halt script End if But I still get …

I need to attach a script that will reduce the price by .25 between the hours of 10:00am and 6:00pm. I have tried using an "if" function to no avail. I am just not clever enuf to fiqure it out. Thank you in advance for any help.

Head ... ready to ... explode ... Okay, my company bills clients in 15-minute increments. (If we work 8 minutes on the project, the customer gets billed for 15 minutes. If we work 17 minutes on the project, the customer gets billed for 30 minutes, and so on.) I've created a Duration field that calculates (EndTime - StartTime) and tells me how long we *actually* worked on the project. But the Cost field is set to calculate (Rate*Duration), which gives me a total billing amount that isn't right. I've been pounding my head all day trying to figure out how to calculate this, and am just about ready to have a meltdown! I started with this: ((( …

Ok here's the deal. I need to be able to hit the key and it creates a new record. I have done it before but been away from FM for a while. Can anyone assist really quickly? The screen. I will be inputting number, enter, number, enter, number with no set limit on the number of numbers. Then there will be a few other navigational buttons that have to be functional. email directly if you can after you post. [email protected]

What am I doing wrong? I want to compare the value in an Address field to the value in the same Address field in the previous record. I've created a calc field- GetNthRecord(Address;Get(RecordNumber) - 1) This works at first, but if I change the Address in the first record, the calculation in the next record does not update until I click in it. I've tried both storing the calc results and not storing but it seems to make no difference. Any ideas? Thanks.

I have been adding a delete script for some images that my users in the shp will be adding & deleting. But I don't just want any Tom, Dick, & Harry deleting the images. I have just thought about giving a few supervisors the responsiblity of deleting any content from the containers. And I will probably do this, but I would like to track who deleted what, with a timestamp, etc. And if at all possible actually store the object that got deleted for a period of time if possible. Are there any examples of this kind of a log out there? TIA, Nate

Anyone know if there's a way to automatically cancel a running script by initiating another script? Example: I have a Find script that takes users to a new layout. While there, I want them to have the option to cancel their find. So I created a button labeled "Cancel and Return to Tracker." That button runs a little script that takes the user back to the main layout and switches back to Browse Mode. The trouble is, once that little Return script is finished, the user is still hanging in the original Find Script. What's the best way to tell filemaker that running the Return script should cancel the current Find script? Or perhaps I'm approaching this all wro…

Hi there, I have a database of recruits that contain personal information and tournament and recruiting contact tables accessed by portals. I have written a script to detect duplicates based on name, high school, and state. The problem that I am having is writing a script to merge the duplicate records. I want to merge them because the first record might have one tournament and the other record might have another, if something happened during import. I can't seem to find a way to have access to the fields for both at the same time. Does anyone have any ideas? Thank you. -Cam

Hi all, I'm trying to figure out a way to imitate the behavior of the "Contact Photo" field in MS Outlook (Windows). When the field doesn't contain an image, a single-click opens the dialog for selecting an image. When the field does contain an image, a double-click is required to bring up the same dialog. I've been trying to figure this out for a while now by timing the script from beginning to end while having a pause somewhere between that's resumed by the second click... Is this even possible? Any ideas? Thanks in advance for any help offerred!

I have the following. Category......StartPage# Jazz..........1 Jazz..........1 Blues.........2 Blues.........3 Rock..........4 Rock..........5 I need to populate a new field that will contain the ending page number of the category. I’m not sure whether this requires a script that populates a global field or just a calculation field. The end result would look like this. Category....StartPage#....EndPage# Jazz........1.............1 Jazz........1.............1 Blues.......2.............3 Blues.......3.............3 Rock........4.............6 Rock........5.............6 Rock........6.............6 Thanks in adva…

I'm fairly new to FileMaker and am attempting to have one of my scripts run once a date field is changed. I can't use a standard button, because actions happen on mouse down, I'm looking for an on change style event. It's currently the pull down calender, so basically when you click a date perform this script. Can anyone suggest a solution? Thanks in advance -RW

Hello all! Need some advice from a Master Scriptmeister. I'm creating a database for use by people who are not to be trusted with my data. : (See image #1 attached) I've created a find button which switches to Find Mode and takes the user to a new "S=earch for Project" layout. (See image #2 attached) When the user enters their search terms and hits "Enter," the script then takes them to a "Results" report. (See image #3 attached). Once there, the user can click on the record they want, and the script takes them back to main layout and returns them to browse mode. This all works pretty slick, and the user never knows anything about Find Mode or Browse Mo…

Has anyone had any luck using the "Send DDE Execute" script step to place text into a Microsoft Word document? I've been able to get Microsoft Word to open and create a new document and have the entire contents of a field placed into the document. The issue is that sometimes the script will fail with no changes whatsoever to anything in the FileMaker field. Microsoft Visual Basic will open a debugging window when the script fails. It appears that on occasion an underscore is being added to the inserted text which is causing the DDE to crash. (The underscore is added without quotes.) It looks to me look a bug with FileMaker. I’m currently using FileMaker P…

(my apologoes for the noob question...) I have a database of related tables. For simplicity of this example I'll look at two of the tables: 1 - Customers 2 - Markets I have a layout with customer data that has a portal to the list of markets. I also have a "Add New Market" button that runs a script that: - goes to layout AddNewMarket - adds a New Record. I would like it if the script would also automatically fill in the Customer field in the new record (with the customer that we are currently viewing). I have tried the various script functions (ad hoc) with no success. Is there a way to do this ? Thanks in advance.

I’ve researched some of the other posts on creating an Index and Table of Contents specifically #145320 I’m confused after reading the post and am not sure whether I need a global field, a new layout a script or all of the above. I’m interested in creating only a Table of Contents Let’s say I have a very simple database with some records and only two fields, categories and items. Category Item Hammers Large Hammer Hammers Small Hammer Saws Large Saw Saws Small Saw Pliers Large Pliers Pliers Small Pliers I have a layout which page breaks by the Category so the data appears as below when printed. H…

Hi all, I'm stumped as to how to do the following in an elegant manner: When I am on a full-screen layout that shows the details of a company, I can click a button that will open a small window on top of the current one that shows a "business card" of a contact who's related to that company. I use the GTRR step with "open in new window" to achieve this. No problem. One of the button options on the "business card" layout is to go to the detail layout of that contact. What I'd like to do is use the GTRR step to show that record/layout in the original window and close the little "business card" window. It seems that there should be a way to do this in a…

Does anyone know the answer to this-- I need to figure a solution that would download print files from a server (along with job details), and then automatically print them. Picture: Files uploaded to web server via FTP, with print details stored in mysql DB, files go to FM from web somehow, then script prints files in order. In this case, printing them from FM would really mean sending them to a printserver until the printer is ready for them to be released. Has anyone ever done anything like this?

I am running a database that generates a new, unique serial number each time a new record (invoice) is created. The value comes from FM's auto-enter serial number feature, and is incremented +1 with each new record. Recently (within the past week) the program has failed twice as a result of the serial number next value defaulting back to 1; this causes a duplicate to be entered (serial #1 already exists) and the record is unable to be created (due to validation). Any suggestions on why the next value gets lost? Is there an upper limit? I'm running at about 10,000 records. NOTE: this problem never occurred during the first 10,000 or so records being created, and …

Hi, I'm trying to write a script that will create several new records in one table based on crieria in another table. Here's the simplest explanation I can come up with: Table has field (name) and field (type). The type field is a radio button set(pulls from value list ) with 2 options. I've made a button in Table Layout1 to create related records in Table Layout2 based on the value of . If the value is "1" then 3 new records will be created in Table . Each new record will 'copy' the data in and 'paste' into . In addition, each new record will get 1 of 3 values from value list to be placed in field . has a total of 11 values. Still with me? …

I need to be able to run to separate scripts on checkboxes that reside in the same value list. Is it as easy as creating a transparent button the size of the checkbox and placing it on top. Then make the first step in my script "set field" so that I can make sure the box gets checked? If that's all I have to do when someone wants to check the box, what would I need to do if the clicking of that box was an accident and they needed it unchecked. I'm envisioning my users going crazy trying to unclick a box when there is a button on top that is set to do otherwise. For some more information, the checkboxes are actions that need to be taken on a set of constru…

I have a found set and want to use the Go to Record script to go to the nth record as defined by a value in a global (whole number). How do I enter the calc in the Go to Record script step? Thanks!