Script Workspace and Script Triggers

New solution in Dev7. The script goes to a layout with the correct records in a portal then loops through the rows setting fields and is supposed to exit after last row, but does not. Script portion as follows: Go to Portal Row [select; First] Loop Go to Field [select/Perform; GAMES::weekNumber] SetField [GAMES::someField; value] ... Go to Portal Row [Next; Exit after last] End Loop ... rest of script It never exits when it gets to the last portal row number. It makes new records. Running this in debug mode. I expect I am doing something silly, but this seems pretty straight forward.

Is thier anyway to change the size or position of a field with either applescript or scriptmaker?

This should be simple, but... The scenario is this: I launch an external script from a script in db1 that presents a list of values in db2. The user then either selects an item from the list and hits the found button or hits the not found button. Based on which is selected, information or "Not found" is put into a global field available to the original db and the external script exits. At the moment, the script in db2 does a find to present the list of choices and then Pause/Resume Script to allow the user time to make his choice. How do I make the scripts attached to the Found/Not Found buttons resume the original script so that the user gets back to the o…

I use Quickeys to do some automation outside of Filemaker. I want to have Filemaker send a command that will run a Quickey script, and haven't been able to solve it. I'm thinking that writing a VBscript is my only solution. Has anyone had any experience with using them together? Any suggested programs that can be used to write a VBscript? Thanks for any help!

Some XP machines run the 'send email' script fine - others cause the email client to launch and then filemaker to crash. filemaker version 5.5 on clients - running filemaker 5.5 on a dedicated host machine, but the database was updated in version 6. I have reinstalled windows messaging and this has fixed it on some machines but not all. We are using GroupWise 6.5 email client. If anyone can advise, please let me know. Thanks

Hi all: I think this should be easy but I must be missing something. I grab all open window names (knowing only 2 should be open), remove the name of one constant window and what's left should be the window I want to act on. That all works. I can return the resultant window name and it is correct. I have tries then using 'Set Field' to poulate a global with the indow name so I can use it in a case or If...Then script. But while the global field shows it is being populated with the window name, the script won't act on it. I have also tried passing the window name directly to the script, as in the attached screenshot, but that also fails. (The 'Else' clause …

I've done a script which is supposed to exclude some of my records but it doesn't work properly, what am I doing wrong? (I'm using a swedish version so I don't know if I translate the steps correctly) Go to layout (year) Sort records (no dialog) Go to record (first) Loop If (Year::user "overwritten =" global::user) hide record End if Go to next record (exit after last) End Loop Go to layout (month) Sort records (no dialog) Go to record (first) Loop If (month::user "overwritten =" global::user) hide record End if Go to next record (exit after last) End Loop The relation to the table "global" is an "op…

Hi All This my little problem. I have a time code field which has a colon then two digits follow, something of this nature ":30". I need to and a zero in front of the colon which would be this "0:30". The two digits following are random from 0 to 60 seconds. I am at a loss on trying scripts I wrote. I am new at script writing. I have about 100,000 records which need to be converted. Thanks for the help!!

Help. I am trying to create a script which would find a duplicate record and mark as a duplicate. All my trying has ended in failure. Each record has a unique ID number and their is also a field which would be marked with a "X" if it was a duplicate record. Their about 80,000 records which I must sift through. Thanks in advance.

What script would I use to print the record being viewed. This record would be in a found set and the print page would be a different layout than the one used to select the record. I would like the print command to execute automatically without dialog and it would need to be cross-platform. This seems so simple but I just can't seem to get the script to work!

I've done some interesting things with the Database that I've built. However, I STILL don't understand the difference between <> and NOT. I've got a script that says this: IF[EX PI Lock <> "Yes" and (EX Note = "Do PI 1" or EX Note = "Do Dup PI" or EX Note = "Do PI/Accounts" or EX Note = "Do PI w/Docs")] If I do it this way, it processes rest of the if statment even when EX PI Lock is "Yes". If I use NOT, it never processes the If statement, no matter what EX PI Lock says. What am I missing?? Thanks!

I have a database that runs my company's timesheets. Is there a way to do a search to find people who have entered less than 8 hours of time, and then have the results emailed to our HR department? Any ideas? I may be way over my head with this idea. And how would I run an accurate find for people who have entered less than 8 hours of time?

Hi guys, anyone knows any resources with more information on DDE execute commands? I want to send commands to MS Outlook, to enter appointments into the calendar. I know the DDE commands are specific to the receiving application but it seems to be a thing a lot of FM Pro people are interested in and I thought I'l ask anyway. Many thanks in advance George

Hello...I need some help please with changes to scripting methods from FM5 to FM7. I've created a special layout form for doing a find and want to create a script attached to a button that will navigate the user to the "Find Record" layout and enter the find mode. I've done this successfully before in FM5 but in FM 7 when I assign the "Find Record" layout I want in the script with Go to Layout, when the script is run it is actually going to one of the main table layouts created previously. What am I doing wrong or what should I be doing differently . Thanks! Jana

How can I send an email using Open URL and include a message. I know that I am supposed to use the syntax mailto:[email protected], but what else do I add to string so I can send the email and a message? Thank you for your help!

Hi, I've created a runtime solution with Dev6. The solution opens another application to download/process/export data from flash memory cards into a folder (runtime opens the application using "Open..." script command). The download application opens a separate window on top of FM solution, from which the download process is managed. After the download process is finished, I'd like the download application to run a script within the FM runtime - is this somehow possible with runtimes (v6)? Thanks in advance, Jari V.

Hi everybody, in my application (CalamarBilling) i have created a few layouts with portal. In the corresponding table, i have 3 special fields for sorting sort_criterion (a number, global storage), sort_field_text (a text) and sort_field_number (number). In the definition of sort_field_text and sort_field_number, i calculate the content depending on the sort_criterion. In the portal definition, i sort first by sort_field_number and then sort_fiel_text. I have a script that is executed with a parameter that automatically fills the field sort_criterion and calls the function replace field content in order to activate the calculation of the sort_field_xx. This works per…

Strange behaviour of a script which in general works fine after activating it directly in FM Pro (script performs a number of subscripts which themselves are generating a number of reports for export). This "main" script is usually triggered via the scheduled tasks-Service and it worked fine _before_ installing SP4 for Win2k-Servers. Now, basically the script is launched via scheduled tasks (that's OK: no error of _this_ service), but only a few of the subscripts are working properly creating the daily reports I need, the others are just missing :-0 ... Any known problems with SP4 I should know about?

Hi there, anyone know why the Status(currentMessageChoice) function is no longer valid in FM7 as it was in FM5? Thanks

If I have a field which is 1 2 3 4 (Paragraph separated) How can I use scripting to get a value from the list? say 1, 2, 3, 4 Any help would be great!?

In my old FMP 5.5 files. I used the "go to related records" script step and the Current found count function to trigger a message when no related record is found. The message appears if the current found count =0 after the "go to related records" step. I converted the files to Version 7. It seems that if no related record is found, the found set in the related file will not change. the found set would be the same as if the "go to related records" script step didn't run. The found cout would not change to 0 accordingly; therefore, I could not trigger the message. I think I can re-write my scripts, use find script to achive the same result. If you know that i…

Hello, I have two databases and I want to enter from one into the other. When I open the first, it automatically opens the other as it is used for relational stuff and I didn't want to bother the user with garble. Anyways, I want to switch from the first to the second and switch INTO find mode. This is actually from being in find mode. I don't want to use a portal either, I actually want to switch into the other database in that mode. Is there any way to do this? Thanks a lot, Jim

Hi Guys, Im hoping someone can help me. Im trying to develop a solution in FileMaker Pro 6, on a Mac OS10.3 machine. Is there a way to to determine whether a user, is using a standalone database, or whether the database is on a lan, and the user is acting as a client. Note the database (both single and networked version) will have the sharing preference set as multiuser. Is there a single command that will allow for this? Thanks Jalz

What is the key command shortcut to zoom in and out, and what are some other commands?

Is there a way to validate a find request? I have a script which adds a request (beyond the first one) and enters some criteria in by itself. However, it keeps failing because sometimes I don't enter any criteria on the first one, and subsequently it doesn't work. If not, is there a way for FM to change the request to an omit request, even if FM generated the request? Thanks a lot! -Jim

Hi everyone, I'm in need of auto entering a greater than or equal symbol in Filemaker. I need it to constrain all the results to a date range. Unfortunately, the date range is calculated by another field. Subsequently, I need to have it do something like inserting a calculation along the lines of ">=" & Field 1 & " <=" Field 2 Suggestions? Thanks! -Jim

Beginner Here. Basically I need to create a script which will assign a unique ID number to 40,000 existing records. Thanks in advance

I had a database in FM6, converted now to 7. There's a script in it where, somewhere in the middle another script is called in another database. Problem is that it seems that filemaker doesn't want to return to the original script, but keeps 'hanging' at the last line of the other script.

Using FM7 I have a field for the email address in the database of individuals. I perform a find and I select in the "send email" script step to get the address from that field and to "Get valuses from every record." But for the subject, I need to say "TO " & [field name] Full_Name. However, with this approach, it will send all the emails with the name of the First Record in the subject line. Is there any way to somehow personalize each email -- either in the subject line or the message -- with the contents of a field? Thanks!

Is there a way to trigger a script to run as soon as a user makes a selection in a field formatted as a pop-up menu? I know in access there's a way to set up a field to run a particular action any time the data in it is updated... is there a similar Filemaker function? Thanks!

I have a script that I use to import records from one table to another. When the file is shared by other useres, the script will not work. I have to go back to the host and run the script from there. It's a big pain. Anyone have any ideas as to why, and what I can do to resolve.

Hi guys. I'm back with a problem. I'm still using FMP 6. Can't find a thing on it in the Knowledge Base. Hope you can help me. Since upgrading to OSX on the Macs in our office, and having had trouble with the networked printers we've tried, we now have dedicated USB-connected printers to each of the computers. Hewlett Packards. That may or may not be the problem. Or, it could be my print scripts - they are down to the simplest they can be: allow user abort (off) page setup (Restore, no dialog) Print (no dialog) go to Layout (original) enter Browse Mode (and print set to current record or records being browsed.... ) What has been happening is w…

Hello, Does anyone know what the scripting is for multiple choice Show Dialogs? In earlier filemaker you would simply script something like this show message "Are you sure you want to delete?" option 1 "yes", 2 "no" if(status(currentchoice) = 1 delete record # or whatever # else end if or something like that - you get the zist - not accurate scripting above, just a vibe The point is - what has happened to status functions in FM7? What do I do? thanks

Hi Everyone: I was hoping automate a search for the user, but I wasn't sure of the most appropriate way to go about it. Basically, i want them to search on a range of dates, and I don't want to have to have the user memorize the fact they have to type ... I tried creating two global fields (for when the user goes into find mode), where they could enter the first date, and then the second date. However, when I copy it into the actual date field (for actual searching) it just created a question mark (I tried to enter a concatenation of the first global + "..." + the second global). What am I doing wrong? Thanks a bundle! Jim

I have been trying to figure out how to extract negative values (or values with a "-" in it) from a repeating text field. i found this script on the FileMaker TechInfo site, which was able to create a text box and input all the values on separate lines - I am not sure if I can use/alter this script for what I need to do. Basically this repeating text box has positive and negative numbers and I want to create a report that only reflects the negative numbers, and a sum of those numbers at that. I cannot figure out how to modify this script from the link above, for what I need, or if there is a better way to do it. Is there, maybe, a quick calculation for thi…

Hi All, How can I make a script to run automatically as soon as a user login into the database with a password. I created a calendar and I wanted to hide/ omit the old dates and show only the current and future dates, when the user login, by running a script that would do this. Thanks 4 all ur help.

Many of you will of seen the java web pages that let text scroll in a region. Is there a way to do this in filemaker? maybe with a button beside the text box that you wish to scroll through? Any ideas?

FM7 can not set fields across tables. This answers my question in previous thread. Not a good deal. You have to set up a relationship to do what I wanted to do. Ivan

That's all. Just thought I would share that with everyone.

I am using "Goto Related Record; Show Only Related Records" in a scipt to bring me to related records in another table and layout. With FM6, if there were no related records the script would bring you to the specified layout with no found records. FM7 only takes you to the specified layout when there are related records. Can anyone offer a way to get to the specified layout when there are no related records?

I occasionally use the "Open URL" script step to submit a "GET" request from FileMaker, for example, to determine the shipping cost with canada post given the postal code, weight and dimensions. For example, here is a URL I created with a calculation field: http://www.canadapost.ca/scripts/RateNew.dll?MfcIsApiCommand=ParcelRate&language=english&service=Small+Bus&referrer=CPCBus&rateType=serv&choice=All+Services&when=urgent&srccode=L6J6M1&destcode=V2X3N6&type=Parcel&weight=1&wtoption=kg&length=49&width=32&depth=15&dimension=cm&insurance= Now the problem... I want to be able to look up a pos…

Hi all: I am getting some weird script results and was wondering if anyone can spot my error. I have a scripr that asks the user if they want to print some records. If they choose 'Yes' it prints fine then asks if they want to mark these records as sent. Here's where it breaks down. If user chooses 'No' to print but 'Yes' to mark as sent, it works fine.) The block that is vexing me is marked in red in the attached .gif. No matter what I do, the script just seems to skip the Replace Contents step. I placed a DEBUG to prove that this portion of the script is firing, and it is. I return the DEBUG. But the next step, Replace, doesn't fire or offer a d…

Having played with FM7 and do think it is a lot better than Access, I seem to have hit a block with the scripting. I understand using Scriptmaker for the basic things that it does. But when I see script lines like - Set Field[Trips::gWindowName; Middle(WindowNames; Position(WindowNames; "Menu Right"; 1; 1); 10)] I am lost. I am not the smartest kid on the block, since this is gibberish to me. I have had wonderful help from you all here, but I am looking for a book, tutorial CD or whatever that will explain in detail the proper grammer and puncuation needed to produce wonderful tasks. I just work better trying things when I have a hard copy to work from. …

I have two related databases, Summary and Data. I want to write a script that does two things: 1) Uses the contents of the key field of the Summary database and finds the contents of that key in both the Summary database and the Data database. (This will yield 1 record in Summary and many records in the Data database.) 2) Performs the Relookup function in Summary so that its fields are populated with data from the Data database. Can anyone help me? Thanks, Thomas

I'm trying to figure out how to remove the first line of a text field. I was thinking maybe MiddleValues ( myField ; 2 ; 99999999999999999999 ) but I thought there might be a better way!

I want to do the following: copy part no from layout A goto layout B paste partno into layout B do find layout B quit find layout B This sounds easy, but I am having trouble with it. Ivan

So can this be done? What I'm aiming for is a script step that positions a window relative to the *right* edge of the screen--a position which would vary depending on the size of monitor being used. I know how to position and size from the left using either FM7's move/resize script or Apple Script's position or bounds. But those don't help if I want the window to always be positioned near the right edge, whether on a laptop screen or a large monitor. Since the ScriptMaker move/resize dialogue allows for calculated results rather than fixed bounds, can somebody get me started with an If, or maybe a Case calculation that would start by measuring the availabl…

Hey all, For now, I've decided on changing the schema so that I won't have to buy any third-party products. One problem I'm consistently running into is the import feature; how do I import Excel spreadsheets to multiple tables? I can import into one table, but not the other; I need to be able to place three columns of the Excel spreadsheet into one table, and the rest (10) of the columns into another. Sorry if this is in the wrong forum; I considered this to be a scripting error, although I may be wrong. I appreciate any help anyone can give me. Thanks, Aviosity

I used Panther's "Keyboard Shortcuts" utility (in the Keyboard & Mouse preferences) to assign the F1 key to a script in FileMaker's script menu. When I go into the menu, F1 DOES appear, and when I press F1, te script menu DOES flash black, but the script doesn't run unless I manually go to the menu. Also, Script Debugger doesn't activate. Has anyone had success using this feature with FileMaker?

I want to use a start/stop button to track an operator's time. Every time the button is clicked, the time should be recorded in a repeating field. I need to see a list of all start/stop times, and then summarize how much time was spent on the job. How do I automatically jump to the next available (i.e. blank) repetition in that field?

i'm trying to generate an appropriate error message for the following script: Set Error Capture [On] Go to Field [select/perform, "Container_with_audio"] If ["Status(CurrentError) > 0"] Show Message ["custom message"] EndIf if this script runs and the field contains data, but quicktime is not installed on a windows machine (and therefore no sound plays), this is not interpreted as an error. i've verified this by capturing Status(CurrentError) into a global field - the result is 0. does anyone have an idea for a workaround?

Hey all, After a long data analysis haul, we're finally ready to move all this extraneous data into FileMaker 7. The database promises to be very helpful yet very complex, and this being the first real day of database design, the problems are starting to crop up. What I need is a script that will allow me to create a new table, name it, create fields within it, and so forth. The table name and field names will have to be created on the fly (dynamically) and combined with static text. Example: I need to create a new table for item 12345. The table would need to be named "12345|ProductReliability" and the fields within it would need to be "12345|ProductRe…

Hi Im having trouble exiting my loop. Can any one help? I am trying to create an entry which ISN'T one a value list that is assigned to that same global field. (gDuplicate Section Check) please see the attachment for screen shot of scripting window.

I have a FileMaker script that copys a field, then runs an external script, then pauses the filemaker script so that the external script can perform its process. When the external script is done it comes back to filemaker and presses ENTER to resume the Filemaker Script. My problem is when it comes back to FileMaker, the copied field is still highlighted. How do i unselect the field ( like when you click on an empty space) so that i can continue the script?

I am attempting to expedite data entry for our database of biological samples. Every sample becomes a unique record, however, there is information that is common to groups of 25 samples. I would like to design a layout that collects the common information from the user (Box_ID, Population, Date, Species) and creates new records for all 25 samples each with a unique DNA_ID. DNA_ID is a 6-digit number preceded by the letter of the species it represents (say, M000123). Ideally, the script would automatically retrieve the next available DNA_ID for the species identified on the data-entry layout . Any assistance is much appreciated. Thanks.

Is there a way to verify that a person chose a value from a value list via script? For reasons too long to explain here, I cannot use field validation on this project so all validations are done by scripting. Thanks!

Hello - I am relatively new to FM7, although a programmer by trade... I spoke w/ someone knowledgable in DB ways, and he pointed out in a sample I was building, that is is generally not good practice to create relationships based on Data in use, but rather use a generated index number. That way the data can change later, and the linked records are not affected. In my sample, I have a table of 3600 NASDAQ stock symbols, and another table which is a record per transaction total for a month, by a certain company, for a certain stock as listed by Market_Symbol. I was linking by Market_Symbol and doing lookups, sums, etc. It was suggested that I add a Symbol_ID …

Hi im getting into a bit of a mess try to duplicating a parent and all its children. In trying to duplicate all the children records, I have tried a loop. Each time I create a duplicate, the records jump to the latest duplicated record so I cant move to the next record and duplicate again. I planned to apply the new ID number as each record is duplicated. Any help would be greatly appreciated? thanks

I have 4 temporary entry fields that I would like to automatically delete contents when the database is closed. I tried a loop and set field commands but it takes way too long (I have 55000 records). I tried making 4 subscripts to be used within a main script. Each subscripts searches one of the temporary entry fields for any contents and then uses replace contents "" to clear it out. This works fine except for when there is nothing in the field to find and the "no records match this request" dialog box appears and you have to click continue. This is no good because I don't want people to have to babysit the database while it's closing. Any ideas? T…

FM Techinfo confirms the problem -- when use Open URL, the URL that gets passed to Safari or Internet Explorer is made all lower case. Unfortunately, the site that I am connecting to requires that part of the URL be upper case. This might be a Mac-only problem, I'm not sure. This use to work fine in FM Pro 6 (i.e., the upper case characters were preserved), but is broken in FM Pro 7. Does anyone know of a work-around? Thanks

Simple question: what is the best way to toggle a field between yes and no values via a button?

In another post I was asking for help in where to find script help that is "Dick and Jane" simple. Unfortunately I did not receive the answer I was looking for. So in tying to understand some of the examples that came with FMP7 I again got stumped. In the Contact Management file there is a script step called - Go to form layout 2 the script step in question is - Set Field [Contact Management::Most recent form layout; 2] Most Recent Form Layout is a global and number field Could you please explain what is actually happening with this step. How is the global function working, how is it set etc..... In trying to reproduce this step in this file I was …

I have a script that's giving me some trouble. The last step is a Goto Layout, but it doesn't work. Actually, the script step executes, but then for some reason the layout switches. I added custom dialog steps before and after the Goto Layout. When the second dialog come up you can see the window switch to the correct layout, but when you dismiss the dialog (which is the very last step) the window switches again. Very annoying. Is this a bug? I can't find anything in the techinfo at filemaker.com. Thanks, J

Am I missing something? The script is making me "continue" the script twice - pause mode (continue), and find mode (find). Also, the step "show custom dialog" comes in before the find mode so it doesn't work either way. Set Field [ Publications::gPublicationID; Publications::PublicationID ] Go to Layout [ "Contact" (Contact) ] Enter Find Mode [ ] [ Pause ] Perform Find/Replace [ ] [ No dialog ] Show Custom Dialog [ Title: "Add Individual to Publication"; Message: "Do you want to add " & Contact::ContactDisplay2 & " to the distribution list?"; Buttons: "Yes", "No" ] If [ Get(LastMessageChoice) = "1" ] Set Field [ Contact::gContactID; Contac…

Hey, Everyone. I

I

I'm a scripting newbie, so please bear with me. I've done a couple of looping scripts with numerical loop invariants, but don't know how to traverse the DB based on contents of a particular field. Ex. Given database with two fields MANUFACTURER and COMPUTERTYPE, I want to loop through the DB once for each unique value of MANUFACTURER. How do I structure a Loop to do something like the following pseudocode: for each MANUFACTURER select (MANUFACTURER, COMPUTERTYPE); <do other stuff I'll fill in here> done I'm a scripting newbie, other than really minor stuff...

I have two databases, One is an estimates DB which consists of two related tables; the

Just wondering whether anybody can tell me the value I should use if I use the script step GetCurrentModifierKey, referring to the return key? The filemaker helps seems to give numerical values for the shift, option and control keys but not return! thanks Melodea

Hi... i have a database with aprox 40 fields... is a sales databases. This databases have 2 big parts: The client information and the product information. Every register is a new sale. The problem: When a old client buy a product, i must enter your personal data again. I make a button that clone the register, but when a i clone all the data is copied... i need copy just some fields (for example the name, phone number, street, etc... but i don

I have a sales report in preview mode. I have a summary field showing sub-totals, I would like the report sorted by this field so that the higher sales figures sit at the top of the report. When I look at my report in preview mode it is sorted by product, I have to click 'sort' then the checkbox to include summary fields, then move the summary sub total field into the right hand field list, then click 'descending order', then click 'sort'. Question is - How can I automate this? Surely it must be possible Thanks for any help

Hi, does anyone know if it is possible to export an appointment from a filemaker database field to MS Outlook? I read somewhere that it might be possible using DDE executes but I have no idea how to use this. I know that there are dedicated plugins out there, like Outlook Manipulator, but the problem is that this one is not a Filemaker 7 native plugin and only supports english fonts - I am Greek and I want the title and other information related to the appointment to be in Greek. I contacted Productive Computing and they say that I could pay them $150/hour to enter the Greek character set into the plugin or wait for a FM7 version whenever they decide to make o…

Is there a way to grey out or disable a field if a checkbox is unchecked and enable the field when it is checked? Is there a plugin that will do this? Thank you,

I have searched for help on this with no results. Using WINDOWS and FMP 6.0v4. Here is the situation: I have a database with 419 records, and four fields: "Names", "number of push-ups", "Grade" and "Ranking". After I do a find for the students I am looking to number. I would like to write a script that would go to the

I have searched for help on this with no results. Using WINDOWS and FMP 6.0v4. Here is the situation: I have a data base with 419 records, and four fields: "Names", "Height", "Weight" and another named "Age". Can you help write a script that will go to a specific layout, find all the people named John and sort the found results descending by age, ascending by height and ascending by weight?

I need to create a script to open a Word document from a form. Can someone provide an example? Dave Please respond directly to my email address: [email protected]

Hi all: Is there any method in FM 7 for choosing what objects (specifically buttons) appear on a layout based on a calculation? Does FM 7 offer that level of control? Thanks Kurt

Hi: Get (WindowName), according to FM: "Returns the name of the window that the script is acting on (not necessarily the foreground window)." I have created a floating menu that can appear alongside many different layouts as a new window. They share screen space. I have a 'Print' button on the floating menu that I would like to affect whatever OTHER window is present. Is there a way to determine that other window's name programatically? Since the script for 'Print' will only work on the window it resides in, without specifically naming the other window, is there a method to grab the names of all open windows, then subtract the known Menu window mame f…

Go to layout (leftValues(get(scriptParameter);1)) Does anyone know why this script step doesn't work? I have tested and pretty sure that leftValues(get(scriptParameter);1) returns the exact layout name that the script step "Go to Layout, layout name by calculation" supposed to display. It simply doesn't go there at all. Very strange

Hi: I have this script step: Replace Field Content [Trips::TripStatus; Trips::gBilledText] Error capturing, and inspecting the data, shows that the Replace isn't happening. I know the global field gBilledText has data. I know the step is firing because I have a debug placed. I suspect it's the way I have chosen to replace the field that is wonky. My only practical choice was Replace With Calculated Result:. But I don't actually need any calculation, I just want the text 'Billed', so in the calculation area I just refer to the global field. Can I do that? FM gave me no warning upon closing the dialog to say otherwise. Thanks Kurt

This is my first time writing a database application with FileMaker. I'm wondering if someone can help with my problem... (1) I have two tables: "Requests" and "Employees" which are related through the 'EmployeeID' field. There may be multiple "Requests" records for each 'EmployeeID.' (2) When I enter a 'WeekBegin' date in the "Employees" table, I want it to look at each "Requests" 'RequestDate' that matches that date and enter a '1' if a "Request" exists for that date and a '2' if it does not. (3) The problem: It works fine for the first "Employee" who has a "Request" that matches. But if there are two or more "Employees" with a "Request" with matching dates, it…

Building a db for my girlfriend who runs a cleaning company. Set up a simple client contact db (clientContacts) with a portal that lets a client have more than one cleaning address (CareProperties , address what needs doing etc) . Each client has a unique number . Each cleaning address had a unique number (House Id) displayed in portal. Made a relationship between the two Added a button to the portal to goto the related record in careproperties. This works fine though if someone does have more than one it finds both records. I understand why as both are related. What I need to do is only goto the file via HouseId . I think my rough script wants to be ge…

Hi there: What is the script step I would use to exit an entire script? Exit just pops you out of a subscript (or, in my case, an IF...End If step) and back into main script. In my If...End If (nested inside another If...End If) I execute some code. When that's done I want to just leave the user where they are and exit all script functions that may follow. Can't seem to find the command for that, though. Kurt

I am using FM 6 pro. Is there a way to get my script out of FM so that I can edit it in another program? I have a set of functions I need to perform on 15 different files. I am thinking if I can get the script out I can use the find/replace command in Word to change the appropriate info and put it back into FM. thanks jon

Hi there: Is there a way to attach a script to a layout such that just opening/visiting the layout launched the script? Thanks Kurt

I have a relational database containing reseller details, sales records, stock levels etc. I'm quite happy with the way it's working, however, I have run into some problems as I try to create some meaningful reports to run. I have a 'sales details' database containing all of my sales information. I want a sales report that can show me the total sales for all my products, by month or year or region or whatever. The issue I have is as follows. When I find all of my sales, say for a particular month, I get something that looks like this as I have different resellers making sales of the same product in the same month. Item ----- Quantity ProductA ----…

Uh-oh. Everything seems ready to roll on the scripting for my end users, but there's one more problem. How do I change the 'Insert date' script so it goes to the START of the notes field, adds a return, then the date, followed by the cursor for data entry? TIA!

Hey FM'ers, I need to write a script to duplicate an order, with some modifications to the order and the line items. I've checked some threads on the topic here, but they're pre-7. I'm wondering if there's a better way not that 7 lets you have multiple tables in one file that can be accessed by one script. In my particular situation there's a relationship between the original order and the new one. This script is building a back order out of an order, so the new back order has a reference to the original order. Copying data is pretty easy. What seems harder it duplicating the line items. I'm not sure it I should use finds, or show related records, or …

I have a layout where the records are in list view. I have created a container field that contains a color. I would like to have a script change the color of a selected record through a button action. What has me stumped is how can I change the selected record back to no color when another record in the list is selected. thanks in advance - Sam

Hi everyone, My company has developed a lot of FM DB to help different departments and the company. Now, we are facing a big problem. The problem is I can't create variable. As a result, I need to create a same function of script to different users to achieve my company needs or objective. For example: I have 100 users and each user has 10 scripts, so total is 500 scripts. When the change is needed, it will be a huge job. Does everybody can advice me a solution or plug-ins can improve our saturation? Also, does everyone know how to make a sorting in ScriptMaker inside? It will be a big help. Thanks for your time.

Hello again, I'd like to run a script when exiting a record. Actually, I'd like to force the user to run "Save Invoice" before exiting a modified record. The script is going to do some validation and automation, and right now I have a button, but I'm trying to find the best way to make sure it was run. Changing the Layout to not automatically save changes is good because it pops up the dialog, but I want to run my script before the changes are committed. I'm already using a plug-in to run a script when a certain field changes, so one of my ideas is to set up a DateModified field that's set to auto-enter with the modification date, and validate with the plug…

I am trying to create a solution that rather than deleting record completely from the database a log is kept in a .tab/csv file. The problem is that I want it to be a file that is writen over but is added to and hence keeps a list of all the deleted names Has any one got any ideas? would it be best to add a new file and add the details to that? Thanks

For some reason Filemaker is bringing an error message as part of a script. This message occurs early on in the script and there is no reason for it appearing. Is there a way of continueing the script without the user performing any action???

Is it possible to view a window in a different zoom from what is provided by the menu, let's say for example at 115%? Thanks, Toni

Hi everyone, I've create around 15 Datebases and have over 100 scripts in each files. Could anyone can advice me how to do the sorting in ScriptMaker? It will be a big help and can save a lot of developement time. Many Thanks.

HI there! I have a portal with names I want to filter them via a classic method (mini buttons A,B,C,D,E,F.....) In version 6 of Fm I have to create a 26 buttons and 26 scripts set Field(Name_letter_key; "A")for the A button set Field(Name_letter_key; "B")for the B button etc Now in a Fm 7 With a new script parameter function I read that is possible to create only one script but with 26 different parameters (one per button) O.K fine.... but which is this parameter?: sorry but I don't understand the concept here... Any one please?

Dear All I have a huge problem that I have no Idea about. My Boss wrote an enrolment process for the college and has since gone on Maternity leave. When I go through the enrolment process using the enrolment password an error comes up at the end when the script tries to print a report <Filemaker Pro Print has been cancelled. Do you wish to continue with Script>. The report prints no matter what you select. If I run through the process using the master password the error message does not appear, I have checked the passwords and the settings are all correct. I can not have this error coming up when we are enrolling as the people enrolling are not ver…

This is my situation at the present moment. In my database I have a single date field that reads as such 7/09/2004, then I have three new date fields, one for the month, day, and year. I need to convert the information in the old date field, into the three new date fields for 16,000 records. Any info would be greatly appreciated!

Hi guys, I came up with a bit of dilemha and wasn't sure exactly how to solve it. Okay, there are basically two list layouts. They are both near identical, except one provides summaries for sorting, and the other does not. Each of these has a link to one of four other layouts. These layouts are all capable of going to any of the other four layouts. When they are done, regardless of which of the four layouts they are on, I would like to be able to return to the original 1 of 2 layouts they had chosen. (The first two). Basically, i want to be able to save which layout I am on when I leave the two layout stage. Thanks a lot! Jim

i have a problem in which i need to calculate when five working DATES from any given DATE is. I have a field that is a date ordered field. And i need a due date field to equal five working dates after the date ordered. I haven't had a chance to mess with this too much, but sounds like it would be a wierd calculation (or script, if needed). Also another problem i have a variety of databases that will need job numbers, problem is, the job numbers will not be specific to each database, rather the job number must be unique across all the databases, i need this to be done in a serial number type fasion. what i mean by that is that they need to be uniform. The letter "I…