Script Workspace and Script Triggers

Hi, I've got a layout(15) that has purchase orders entered into it. When the user has completed it, they may send it to print onto headed paper (layout 15a) or PDF it where the headed paper is included on a layout (15b). The user selects either a button labelled PDF or Print to select the option they want. This works beautifully the first time I run the script when I initially create a new record but if I want to go back to the Purchase Orders later and print or PDF I get an error message that tells me that there are no valid criteria in this request. I've included the script as an attachment. POPrint.pdf

Hello, I am relatively new to FM, though not programming. I am building an extensive app under FMP7 to run my business. Though FMP7 looked good at first, I am starting to uncover major deficiencies... Foremost, it seems that you cannot script repeating fields. That is, you cannot programmatically set the index. As a result, there is no easy way to have an array.. This is absurd, IMHO. I'm sure others have needed arrays in the past. What is the recommended technique to obtain this kind of functionality? Does anyone have example scripts that I might look at? Any help would be greatly appreciated. (The specific need is to go through a set…

I have a form with inserted data being compiled and inserted into a layout using the Set Field(..) command. It previews well but will randomly NOT print words in the middle of the report.(leaving the area blank) If I insert the same calc into a container field it will all print, every time. However, I have type commands( bold,font change ect....) that will not print out of a container field. I didn't want to use the container field, I was just experimenting to see the results. I have downloaded the Developer V7 Update as well. I have broken the data into sections to see if volume was the problem. The form was imported from Word oringinaly, could there be hidden co…

I have created a send event script to automatically print a referenced file held within a container, works fine and dandy for some files and not others. Have realised that if the refenced files name has spaces in it ie. c:Smith Mortgage Application.pdf the send event script only looks for smith and generates this error the file c:Smith could not be found Has any one any ideas on a work around or am i looking at another dead end? Thanks

Basically, I subtracted todays date from the due date and resulted it in a cal field. It worked yesterday, but now today, I get a rather large number! Any idea's where I went wrong?

Hello, Is it possible to run a script upon selection or change of a pop up menu, which is similar to the onchange or onSelect events at javascript... And for sure, I want to transmit the selected value to another script as a parameter to do something else on the database... WHen I specify the popupmenu as button, it can not be opened at all... I strongly think that this should be possible in FM7 , however I could not manage it, and I can't find a related post... Any suggestions Best

I have a DB (same as before!!!) with a portal to another db showing a series of records for each day (date). I have made a script using Set Field (using a global field) to take a user from the Front Page (my Main Menu) to another layout showing a particular date (and its records). What I would also like to do is to be able to send a user to the layout from today's date plus show a certain number of dates in the future (say 10). I have a field in the header of front page showing the current date (using a script involving CurrentStatus(date)). Basically I need to show say 9 dates (and records) after the record for the current date. Can anyone help me g…

I have two files, the parent has a running record list of all the transactions of people checking in and out items(could have mutltiples in and outs). The child is a list/records of each individual item in the inventory and lists the item and other basic info. I need a script that automates the status of an item based on a find through the parent transactions file. I have have gotten as far as isempty and some basic if statements. Having difficulty with automating the find and then sending the results to my child file with a portal, maybe? Any thoughts?

I need to generate a statement once a month that details all current and outstanding invoices. I have created a statement layout and linked it to my invoices layout. The invoice layout contains a field that gives the status of the invoice. I would like any pending or invoiced invoices to show up but all paid invoices to be omitted from the report. Would also like to show where the invoice stands i.e current, 30 days, 60 days etc... Can anyone help me with a script to achieve this? Many thanks Di x

This sound like is it should be easy... But I can't seam to figure out how to convert alpha characters entered into a field to a number the same field. ie: Enter into "Field 1" a single letter A-Z "Field 1" should return a single number 1-26 A=1 B=2 etc... Any Ideas? Thanks in advance! Joe T.

To the Forum I want my script to omit a record where a certain field is blank and then export the results in csv format. My script below results in an endless loop. I have elementary experience in writing scripts. Thank you for your help. Perform Find [ Request 1: Thol ] [ Restore find requests, Replace Found Set ] Go to Record/Request/Page [ First ] Loop If [ IsEmpty(Tr1) ] Omit Record Go to Record/Request/Page [ Next ] Exit Loop If [ IsEmpty(D2) ] End If End Loop Export Records

I'm brain dead...I have a list layout of a DB where individual records consist of a portal to another DB...in FM6. I want to construct a button/script that chooses/finds a particular record (actually by date) in the list then prints it. I have the print layout set up but I can't script to it. I'm sure I've done it before but I can't find it...can I have some help please. TIA Stephen

One of my users has changed email clients (from Outlook Express to Thunderbird) and complains that that email sent from the FM6 application now does not format the message properly (all one run-on paragraph including signature). She sent me a message to demonstrate. I've never heard of Thunderbird and suggested she talk to their technical support, but wanted to see if anyone has had a similar experience with Thunderbird or any other email client. TIA

Hi I am new to scripts and filemaker. I am trying to create a scrip that would create a duplicate record but only copy certain fields from that current record.

when i show the directory layout at the end of the find script, i want the category in the header to reflect the category chosen in the find script, which i attempted to set as DCategory. i can't seem to get the merge field to show a value. i tried just using the category field, but it only works if the matching category value was selected first in data entry. how do i set the field properly? thanks db GLCCtestdatabase.zip

i'm trying to write a script that finds all the records matching a category chosen from a list and then displays the found set in the directory layout. it kind of works, but doesn't always find things i know are there, and i don't know why the merge field doesn't show, so i've probably done the set field step incorrectly too. please help! thanks have a beautiful day db GLCCtestdatabase.zip

I would like to create a set of buttons that would control the text alignment of a field: Button1=Left Justify Button 2= Center Button 3 = Right Justify I've looked through ScriptMaker, and if it is already there I'm just totally missing it. Any thoughts, ideas, samples out there? Thanks in advance.

Whenever I want to transfer data from multiple fields in one or more tables to multiple fields in another table I use a script to set the data in a global repeating field (kind of a temporary holding area), that is then used to set the fields in the destination table. Is this good practice? Is there a better way to script this? I've read some pretty strong opinions in the forums against the use of repeating fields except in some instances. Is my instance a "safe" use of repeating fields? Can script parameters handle this in a cleaner manner? Thanks in advance!

Hi, I am having a problem with this... I wish to open a folder in MS windows with the "send event" command. The following script shows my attempt to open a folder who's name is a fieldname. No matter what I do, scriptmaker always reads the field name as a text, not at the contents of the fild. Enter Browse Mode [] Set Field [GLOBALFIELD; "cmd /c explorer c:FIELD_NAME"] Send Event [aevt";"odoc";GLOBALFIELD] When I run this script, the command is sent to windows, but it tells me that "The path 'c:GLOBALFIELD' does not exist or is not a directory" Can anyone see what I am doing wrong and how this can be changed to open the folder that is call what GLOB…

is it possible to prevent someone from closing a database using the "X" button in the corner of the window. I don't mind if they use it to close filemaker all together, but is there a way to prevent them from closing indivual databases with the "X"? My guess is probably not, but never hurts to ask...

I have attached a file. The "get rid fo stuff" script does not work like it should.. It seems pretty simple.. If this condition is met delete the record I have tried finds then delete the info and that does not work in scripting So I resorted to a LOOP. And still it does not work.. techusedCopy.zip

I have a script that is designed to report a student's performance qualitatively using the student's average, the average of the class, and the population standard deviation of all of the students' grades. This is all acomplished through a series of If / Else If statements. All of the statements, with the exception of 1, work perfectly and I can not figure out why the 1 step won't evaluate as true. I have attached a pdf of the script. Field Definitions: Performance is a plain text field. TotalAvg is a calculated number field that gives the student's total average. ClassAvg is a calculated number field that takes the average of students's total averages self-joi…

Quick overview of our current setup: Running FileMaker 5.5 Server on Mac OS X Server 10.3.8 on a Dual 1 GHz xServe G4 w/ 1 GB RAM. Hosting about 30 - 35 databases. Staff uses FileMaker Pro 6.0v4, I use FileMaker Developer 6.0v4. Want to achieve the following: In a particular database, there is a field called Location_No, type is Number. Some of the numbers are 00001 or 00075 or 00235 or 03040, etc. Is there a way I can script the following on just this field: If characters 1-4 of field Location_No are 0, replace with nothing. So, basically, 00001 becomes 1, 00235 becomes 235, 03040 becomes 3040 and so on. Naturally, others I want left alone. Only the…

Hello! I'm having problems with the cmd commands once again. I'm able to rename exported files and move them to a folder with currentdate name. What I want to do now is compress the folder, it is a lot easier to attach a zipped folder to an e-mail than each exported file..... This is my code for compressing the folder but it ai'nt working, has anyone of all you geniuses on this site a good solution? "cmd /c compress "" & Substitute ( Substitute ( Left ( Get ( FilePath ) ; Position ( Get ( FilePath ) ; "/" ; 1 ; PatternCount ( Get ( FilePath ) ; "/" ) ) ) ; "file:/" ; "" ) ; "/" ; "" ) & "export…

Okay...I've tried everything my newbie brain can think of. I need a script that I can attach to a button to do the following: Button is placed in "Layout A". When this button is clicked, needed script looks at "Field1" in "LayoutA". If "Field1" isEmpty then "Field2" in "LayoutB" (not a typo, a seperate Layout) is set so it can not be entered in Browse mode...effectively making it hidden. Finally we go to "LayoutB" (don't need help with that part!) Of course the opposite would also be true, that is if "Field1" not isEmpty then "Field2" would remain visible/enterable. Any suggestions would be appreciated. Thanks in advance.

I am a newbie to FM7. I have two databases and I need to be able to perform a script that copies/or sychronizes fields from on to another. (For Ex. db1 table 1 field 1 to db2 table 1 field 1.) Is there a script that can do this? Or, is there a relationship I can set to have the fields automatically be synched depending on what record I am at? Thx for any info... db.zip

I just need to be guided in the right direction on this one. I trying to create a script the will find records that have been created and or modified within a certain number of days. I would love it if the user could specify the number of days or a start date and end date. Currently I have 3 fields that deal with the date, 2 are auto entered creation and modification. There is also 1 date field that is set when a record is assigned to be handled by a user. While writing this I wondering if some sort of calculation field will be need to pick the most recent date from all 3 of those fields. But any other advice would be greatly appreciated. grubachr

if i send a dos command with the "Send Message" script step, is there any way for my script to test to see if the dos command reported an error?

Hi All, Since I am new at FM, I am working in a database that I need to get the field and create a new record in another database. I am wonder how can I write the script to copy the firstname, lastname and there is a option that is "Outstanding" or "Returned", copy it one to their related field in a different table. Any help will be good. thank you, php2005

I want to automate a script to a container field, i have a field that has the destination file path but cant work out how to get the file referenced in a container field using the destination field. (already have the destination field via a move file script) Any ideas?

Help needed: Is there anyway to make text revert to the field default with regards to its style, size & font. The situation is that my clients copy and paste a lot of data from the internet into various fields in the database. I'd really love it if there was an easy way for the sometimes huge and colored text that gets pasted in, to be reverted to the default for the field. I don't think there is anyway to make the field not allow the text attributes to be overwritten, but is there a function or combo of functions that I can use in a script to make it conform. I realize that the new FM7 text formating functions has a remove style function... but there is no…

I am trying to determine if a record in a survey I've created is useable. I only want to use records that have a said number of questions answered(well say 12 out of 14). I want to created a field that begins set to 0 and is then incremented by 1 each time a question field recieves data. if the value in this record is less then 12 the record will be deleted. i was looking to use the IsEmpty function as a way to look to see if the data fields contain actual data. however im not sure the best way to implement the increments. or if this is the best way to approach this problem. please, any input would be greatly appreciated

I am doing some financial transaction tracking stuff in a project I'm working on. I am using scripts to set pertinent information in the transaction records, and one of the steps involves updating a balance in a user table. In the script I am going to a utility layout where I enter find mode, use two pieces of data to find a record in a join table, and then I update the one that I find. I am wondering how reliable a setup like this is, using scripting. My guess is that as long as good error checking is in place, it should be pretty stable. Any thoughts?

I have field in a table that show "Current Status", "Current Location", etc,etc... I have scripted a button that moves the CUrrent to a Portal that shows Activity History (through a series of set fields into a global and then into the related table. Ideally, I want the most recent move to be the first row of the portal - so that they move down through the activity history from most recent to oldest. I tried to do it based on sorting by "date created" but for some reason, it refuses to sort - Am I sorting wrong? Or is there perhaps a way to automatically move the new record into the topmost portal? THanks! Sarah

I am very new to File Maker Pro, I am trying to initiate a script automatically from a field

What is the best way to grab all the related records for one record and move that data into a text field so I can parse the data and formate it? I already have a script that sends an email of my invoices as a text email. I do this by pulling up the invoice record. Then a GTRR step (for line items) and moving to a special layout that shows only the fields I need in a list. I then use the copy all records script step. Then move to another layout that has a global text field and paste the data into it. Now I am able to parse the line items data and formate it. Then I use another global text field to create the text email invoice. Then send this to the email progr…

When I open via a script (for example a small notes window) it also minimize's the main layout window that I was in. Is there a way to leave the main layout window open and maximized. and just open the notes window on top without affecting the main layout window size ?

I have been searching and searching, no luck. How do you create a new script in scriptmaker? I select new and expect to be able to enter text. But it doesn't appear that way. I'm not versed at all in scriptmaking, just picking up bits and pieces along the way from this forum and the web. I'm trying to create a script that will open my file that I have imported into my DB - assest management. TIA

Is there a script I can use to control the size of a window (not Zoom) so that different layouts have different sizes?

Hope this makes sense: I have a satisfaction survey posted online using IWP. The values are stored as text values 1-9 and also N/A for non applicable. In another table I use these values to calculate averages and the like for reports to be used by various personnel. In order to use these values in the calc. I use corresponding fields for each of the values that use a getasnumber function to take the values and change them to numbers. Most of calculations use the avg function provided by FM. This ignores values that were marked as N/A in the original table(this is a good thing). Heres the problem I also have an Low Score Indicator field that evaluates …

I need to keep track of software licenses and hardware warrenties, but need to be alerted somehow when the current date reaches within 90 days of the expiration date field. Is this possible? If so, please describe in detail. I'm a fairly experienced user, but only moderately in the script area. I have managed, however to follow instructions to make pretty complicated scripts and calculations work. Any help would be greatly appreciated. Dave

I am runnnig FM6. Basically i am want to create script that will automatically will export records to tab file with out a user selecting what field to choose to export. what i did, i create two fields one is call g_delimiter which hold the "," as the delimiter and calc a field call c_custom_delimiter_export which has in it: Last Name & g_delimiter & First Name & g_delimiter & SSN & g_delimiter & Location & g_delimiter & Session & g_delimiter & Year & g_delimiter & StudentWithDrawDate & g_delimiter & Status & g_delimiter than i have button to run the script. the problem that i am havin…

Hello everyone. I'm trying to create a button that will move the contents of one field into another. Is there a way to do this? i have done anything with scripts yet--is that the way to get it done? thanks

Where can I get a book just on filemaker scripting? Thanks

The following script works in a particular DB layout to print an individual record: Enter Find Mode [] Set Field ["Name","Find_Name"] - NOTE: Find_Name is a Global field using a pop-up menu using a Value List based on another field...it is the only field on the particular layout. Perform Find [Replace found set] Allow User Abort [Off] Toggle Status Area [show] Go to Layout [Print_Reports"] Perform Script [sub-scripts,"Indiv_Report_Sort"] Enter Preview Mode [Pause] Print[] etc Now I have different DB where I want to use a similar script to print an individual record based on a unique ID... But the ID is a Set Field from anothe…

Hi, I have a rather large and complex request for a script. I am trying to create a character generator for D&D. In one table i have a set of records. Each record has prerequisites and benefits. In another table i have records containing character information. what i want is a script to transfer the selected record from the first item into the second table (already can do this part). But when it is transferred i need it to check that the character record has all the prerequisites, then if it does, i need it to apply the benefits. I could normally do this, but the prerequisites and benefits can apply to many fields. I will try to…

Hey, Ive made an invoice program for my dads friends bussiness and it has a button that when clicked it displays "PAID" in big bold red font over the invoice details (and it dissapears when clicked again). Now thats all fine but my question is: How do i make its so it says Paid on: (the date the button was clicked)? Not the date that the record was created. I have this script so far: If(IsEmpty(_ispaid), "Paid", ""). under a setField action. Thanks

I am a beginner in FM and have a problem. A script that has been created on one computer functions incorrectly for others in the office. Is there something basic (or not so basic) that could be causing this problem? [email protected]

I have imported a file from XL that has many spaces at the end of each piece of data. Can I run a script to get rid of those spaces? Your help is much appreciated. Maxwell Morlay

Here's what I'm trying to accomplish in a script: -Import data into FILE B from one record in a found set in FILE A. -In order to import only that one record, I am *omitting* that record in FILE A and then using the "Show Omitted" script step. The ensuing Import Records step then correctly imports only that one record. What I can't figure out is: At the end of the script, how do I then go back and restore the previous found set in FILE A to the exact state it was in before, sorted in the same order as before, and make the 'omitted' record the current record being browsed? Hope that makes sense. Any suggestions greatly appreciated.

What's the best way to get visibility into intermediate values calculated during a Script step? For example, I have the following script step: Move/Resize Window[CurrentWindow, Height:Get(WindowHeight), ...] and I want to see what the value for Height turns out to be. Thanks!

Can anyone point me to a reference that lists what script steps are web compatible for older versions of FileMaker? (both platforms)

I have created label layouts from a found set of referrals. The membership form can have up to 4 referrals. I have 4 label layouts, but not all membership forms have 4 referrals (Clear so far?) For those that have only 1 referrals, the label layout works fine. But, if the referrals are >1 then the label layouts have blank spaces in them. What I would like to do is to: 1) remove all blank spaces from label layouts 2 thru 4 2) cocantenate the 4 label layouts into one (if possible) 3) print the labels Currently there are 39 records in the found set, with 74 referrals. Most have only 1, a few have 2, a few have 3 and only a couple have 4. …

I have a very large table (137,000 records - 49Meg DB) that I am processing with a script. Part of the script is to move the contents of a field in table1 (the large one) to a field in table2. The move is accomplished on a field by field basis and then the record is indexed using GotoRecord/Request/Page[next]. The script works fine but the further it indexes into table1 the slower it gets. By the time it gets to record 5,000 the move is taking minutes (per record!!). Allowing the script to run for 15 hours on a G5 with 2Gig ram only processes 10,000 records. I have tried using the Flush Cache to Disk script step, increasing cache memory to 99M, index everything, index not…

Hi, Back in the days of FMP5 I developed a script, that worked with a MAC OS applescript, to open the folderpath contained in a field (creativly entitled) "FolderPath". It would enable a user to quickly recall a archived folder (i.e. their work for a specific day) and then let them select the files of their choice to open etc Now I'd like to do the same, but in FMP7 and XP. I'm not sure where to start. I would appreciate any suggestions. with thanks in advance Giles

I need a script that copies the text from a field into a field in a related table! In other words, it copies the result from a field in table 1, opens table 2 and pastes that result into the specified field - Any ideas? I don't think you could transfer data this way in fmp 6, but I think i heard talk that you can in fmp 7? Any suggestions would be great! Thanks, Sarah

I have some old data that I'm trying to build a 1 min bar chart from. The end result will have the open, high, low, last, volume for each minute. The data looks like this: date.........time........price......volume 10/1/2004 13:45:00 1129.25 0 10/1/2004 13:45:01 1129.25 5 10/1/2004 13:45:01 1129.25 5 10/1/2004 13:45:01 1129 9 10/1/2004 13:45:01 1129 1 10/1/2004 13:45:01 1129 2 10/1/2004 13:45:01 1129.25 160 10/1/2004 13:45:01 1129.25 0 10/1/2004 13:45:01 1129.25 1 10/1/2004 13:45:02 1129.25 1 10/1/2004 13:45:02 1129.25 10 10/1/2004 13:45:02 1129.25 10 10/1/2004 13:45:02 1129.25 25 10/1/2004 13:45:02 1129.25 2 10/1/2004 13:45:02 1129.2…

A user will select one value from a popdown menu. The selected value should determine whether another entry field will be shown (required) or hidden (superfluous). I wonder if this should be controlled by a script. However, I can't think of how a script would be activated automatically in response to a user input (in this case, the entering of a value from the popdown menu). Any help would be much appreciated.

I'm having variable results with the attached script. In my database each job may have a load of tasks per employee. When the employee has completed each task they can press a button, run a script and the task is deleted from the list of tasks. They access this button from the 'Job Book' Table which shows the tasks as related records in a portal. Most of the time, it works beautifully, BUT every now and again it deletes the Main (PARENT) record rather than the Related (CHILD). This causes absolute chaos. Each time it has done it, I have tried to get it to do it again, but it doesn't and our employees always shut it down in a panic and can't remember what they've …

I'm developing a contact manager and have some records which have been called and others which haven't. I flag the ones called with a timestamp, plus create a log file. I need to make a script that will get the next record within a selected state that has not been called. If I use Find in a script, it wants a hard-coded value for the state. I would like to keep the current state in a global variable and search for the next record alphabetically within that state that has not been called. Any ideas? TIA Paul

I have a membership database that includes fields for up to 4 referrals. At one time it was a repetition field, but have since changed it to 4 seperate address fields (refName 1-4, etc.) Now, I have created a Referral layout that lists all the Referrals, but it has blank spaces which I would like to remove. If a member has only a referral (<4) the layout has spaces for all 4 of the addresses, creating blank spots in "preview". I would like to get rid of them if possible using a script. But, am a little leary of "deleting" if the field is blank. If I "find" and "remove/delete/don't show" (whatever the language) is it going to remove the field in the "found" set? …

Greeting and Salutations everyone. I'm starting to discover the many wonderful things one can do in FM7 with creating/positioning/etc multiple windows. I'm sure that what I'm going to propose seems possible, I just don't know exactly how to make it work. Some explanation - I've got one window on the left side with all my navigation buttons. When a certain button is clicked, a new window is created, going to the relevant layout and record needed. With each navigation button click, it'll keep creating a new window as long as there isn't another window already opened with the same info. If there is, it bring that one to the front. Not having any prefer…

I'm trying to write a script but I am getting an error message that says: "An operator (e.g. +, -, *,...) is expected here." (the ;Get(PageNumber) is highlighted) This is what I am trying to enter into the Specify Calculation dialog box: Purchase Orders::gpage; Get ( PageNumber ) What am I doing wrong? Phil

Is it possible to navigate to a field on a layout which is otherwise hidden and not part of the tab order? I'm trying to develop a search layout which will fill in criteria to search on a target layout. Also, the fieldname it navigates to should be based on a calculation, not hard-coded in. THanks for any help.

Hi, For some reason, I cannot get a script to work that will find all records in a table that have a given value, in my case, today's date. I am making a library system, and want to find all loans that are due back today. This is my script so far: Set Error Capture [On] Go to Layout ["Loans - Due Today List" (Loans)] Enter Find Mode [] Set Field [Loans::Date to be Returned; "= //"] Set Field [Loans::Checkbox Number; "1"] (This just checks if it has already been returned) Perform Find [] Print [Restore] Show All Records Go to Layout ["Main Menu" (Admin)] For some reason, even though there are several records that are due back today, when you manua…

Hello All, I have a script that pauses with a small popup window, and uses Pause/Resume and Allow User Abort [Off] to lock the window from being closed. The issue I'm having is that the small popup window locks, an I'm not able to run other scripts. However, a user can close the application to get out of if. I checked help, and confirmed that Allow User Abort [Off] is supposed to prevent that. Thanks Hello All, I have a script that pauses with a small popup window, and uses Pause/Resume and Allow User Abort [Off] to lock the window from being closed. The issue I'm having is that the small popup window locks, an I'm not able to run other scripts. However, a …

Is there a way to enumerate all databases that are hosted on a FileMaker Server? I would like to create a script (e.g. a vb script) so my endusers just have to click this script that will open e.g. a HTML file with all hosted databases displayed. Then they only have to select one and click ok and the enduser will be automatically redirected to this hosted database. It doesnn't need to be in vb script, it can also be a different language (or maybe with ScriptMaker). Any help on this subject is very welcome! thanks in advance.

Hello, When importing records from one table to another I only want to keep unique entries. For example, if 100 records in Table A all have value "11" in field "Strata" then when imported into Table B, only one record for "11" should appear. I wrote the following script (which worked perfectly well in version 6) Import Records [ Source: "file:Homestead Dummy.fp7" ] Show All Records Sort Records [ Specified Sort Order: Strata::Stratum; ascending ][ Restore; No dialog ] Go to Record/Request/Page[ First ] Set Field [ Strata::Stratum Global; Strata::Stratum ] Go to Record/Request/Page[ Next ] Loop If [ Strata::Stratum = Strata::Stratum Globa…

I can't find any documentation about the Current Script option (Halt/Exit/Resume/Pause) when defining a button that runs a script. I'm guessing that the "Current Script" is a script which is currently paused to allow the user to interact with the GUI? Working from that assumption, the "Resume" option is baffling: with that option, will clicking a button cause the "current script" to continue executing, and simultaneously cause the designated script to execute? Sounds kind of like multithreading to me, although I can't believe that's what really happens. I think I'm short a clue or two here. Any help is greatly appreciated... Chap

I have a text field that is blank at the start. When you press a button and the field is blank it add the letter "A". What I want then is if you press that button again the letter will become "B" and so on. I could write it out of course. Case ( field = A ; B ; field = B ; C and so on ) Is there a better way to write? TIA

I have a 3 table that are linked. patients is 1:many to medication. medication is 1:many to prescription. Each patient has many medication entries and each medentry can be printed as a prescription many times. linked by fields patientid, medentryid and prescriptionid. In my script to create a prescription I have the script parameter as the medentryid to isolate the one being worked on. Then in the script I set field Prescription:medentryid=medication:medentry. Following that I fill in the rest of the info,Set field Prescription:prescrip_medname=Medication:medname etc. Everything works except for 1 glitch. I have a related field all the way back to patient table…

Hi, I am trying to make a dice roller, but have had no luck in working out how. I need to be able to roll any number of dice. I need to be able to choose the size of the dice - 4, 6, 8, 10, 12, 20 I need to be able to modify the dice rolls - remove lowest; remove 2 lowest, remove highest & lowest, or no modify. Can anyone help me?? (i found one post using a recursion? but i didn't understand it.) Thanks in advance

I tried looking for this in the Forums, but did not find anything that directly addressed my issue. I am trying to make a script that will be assigned to a button. I would like the button to (upon clicking it the first time) enter Find Mode, and then Pause so that the user may enter search criteria. This I have had no difficulty with. However, upon clicking the button for the second time, I would like the script to Resume, taking the criteria and actually performing a find. Is this possible? If not, can anybody suggest an effective way of doing what I am trying to do? Thank you.

Trying to automatically trigger a script to flag a record. I am tracking a bunch of students. I want to flag them as freshman or upperclassmen for example. for practical purposes this can be a 1 or 0 in a field in student table. 1 for freshman or 0 for upperclassman. I want this to be updated automatically based on events. I have event records viewed in a portal in table students. When I enter an event "Started Freshman year" I want to automatically flag freshman field to a "1". If I put "Completed first semester" nothing should happen. If I put "Started Sophomore year" then freshman flag should reset to 0. It seems like a very simple calculation using ca…

Is there a way of deactivating a button (e.g. greying it out) when it is pressed and peformed its script - and automatically reactivating the same button when a user returns to the layout that that button was on? Frank

Hi everyone, I've written a process which works. However, to help me learn, I'd like to throw it open to the Forum for improvement. This will need to be generated periodically and my existing process doesn't appear to be very efficient. Can anyone give me pointers on how I could have handled this better please? I have a table of Products. I need to generate new records within the Sales table - one new record for each product for each month and each year; from 1/1992 through 12/2005. I ended up creating 2 scripts (geez). This is what I have: Sales Creation Script: Import [ ... entire Product table ] Go To Record/Request/Page [ Last ] Lo…

In my contacts db I wanted to find a way to clicking a button to call some one with Skype. I figured if I put in a field for it and then create a button which would then have a script to open Skype and maybe call the contact or if this was not possible to at least open Skype. As my ability on sripting is copy and paste etc and not seeing any option that allows opening an application such as Skype I am wondering if this is possible. On the Skype Forum the following script was offered to us to put into our users/library/address book plug-ins and I am wondering if this could be adapted to be used in FM7. using terms from application "Address Book" on action pro…

We are using repeating fields over our solutions, but we found that we didn

Hi. I'm not sure if this is the correct forum for this but here goes... I have an Invoice Status field which the user can change by means of a dropdown box. What I need to do, is to write to a log file every time the user chooses a new status. How do I do this? I've been trying out a test script (I set the field as a button which performs the script) as follows... P.S. I'm fairly sure this can be solved by obtaining a plug-in but is there a way of doing it programmatically? Allow User Abort(Off) Go To Field[select/Perform, "Status"] # add to log file using the new value of the "Status" field Exit Script However, when trying to add the new st…

Hi Guys, I've got one text (ordinary) field, with about 120 words in it. I'd like to delete any duplicate words that are in the text field, i thought I could use the indexing command to achieve this but are there any more effecient ways of doing this? What is the maximum field limit (character wise) FM7 can handle?

Hello all, I'm hoping this is the right forum for this question. I have a field that contains first and middle/maiden names. I'd like to write a script (or do something) that will take all the text in that field and divide it up between two fields; one for first name and one for middle/maiden name. Ideally, I could run something once and it would search through each firstName field until it found a space, then cut and paste everything after the first space into the middleName field. Any hints? Thanks!

I am curious whether it is possible to execute Filemaker and perform scripts externally from the program? If I wanted to make a program outside of Filemaker, could I have it execute Filemaker, open a file, login, and execute a script remotely from that application? If so, how would I go about doing that? I am considering putting a front end application on our company's computer desktops. We have alot of applications and not all of our work is done on Filemaker, so abstracting pieces of it by doing this would make the interface MUCH easier to use, and interoperable with other applications. Any help along these lines would be appreciated. I know Java, C#…

hi, Heres my problem, when the user presses the button to cancel an order placed i need to remove a assigned turkey to that customer. I have a script to set certain fields to correct values to remove from the relationship of the portal. The button for cancelling is in a portal with a relation to filter out cancelled orders and only show active. Now I need to make a script that sets the ID of the turkey in that table to nothing. I noticed that if i removed the unique value (because the id needs to be) the script works setting it to 0. But however if i apply it with unique set it only works once. I need a way to select the portals fields value and set to nothing no val…

I have created a script to import from a .csv UTF-8 file. When specifying the Import Order, I select UTF-8 as the character set. The script description is: Import Records [No dialog; "PSP_fr.csv"; Add; UTF-8]. When I run the script, it defaults to MacRoman and imports incorrectly. If I deselect "Perform without dialog," I can manually select UTF-8, but that defeats the point of the script. Is this a bug? Or is there something I'm missing that I need to set somewhere? Thanks

I need to perform repetitive finds. Basically, it's like this. I need to perform finds based upon the contents of a value list. The number of items in that list is going to be subject to change. Currently there are 10 items, but that number will almost certainly increase and I can't know in advance what the newly added items will be. I need to perform a find and on several iterations of the find I need to set a field to (Item 1 of value list), after the search has been completed several times I need to do similar searches based on (Item 2 of value list) and so on. I need to know if there is a method for accessing the Nth item in a value list via scriptmaker…

I help to maintain the membership database at the Campus Club of the University of Minnesota, hence the clever username. Anyway, I would like to export our email addresses, but currently the export function that the original designer of the system made exports all member names and email fields, including those with blank email fields. I would like to exclude these so I can more easily dumb the names into my bulk emailer. How can I rewrite the process to do this?

I have a script shown below, that works fine until it gets to the set field steps that increment a counter and a question id. The steps simply put a 1 into each new record instead of adding 1 to each previous value. Anyone know how to fix this so it does increment the fields? I'm stuck until this is working. All help appreciated. New Record/Request Set Field [survey Answers::gLoopCounter;0] Set Field [survey Answers::n_question_id;0] Loop Set Field [survey Answers::n_survey_id ;Survey Answers::n_survey_id = Survey Respondents::n_survey_id] Set Field [survey Answers::n_respondent_id;Survey Answers::n_repondent_id = Survey Respondents::n_dem_respondent_id] …

For this database, it takes a bunch of text generated from an online form, and then fills out the record accordingly. For some of the values, I'm using value lists as checkboxes because sometimes there are multiple answers for that same question (what OS will you be using this product with). But, whenever I have the script SetField[OS, ... ] with multiple values (more than one checkbox), it only enters the last checkbox selection, overriding the other necessary checkboxes. How do I get it to x multiple checkboxes with this script?

i know this a dumb question but using a script how can you set a field to the value that was in the last layout you visitied eg i start at Layout one and field one=2 i click a button it will set field one =2 in a different layout

I have a layout termed job list that is set up in list view with all of the records. I have a field defined as terms. It has a value list defined with 4 values in a pop-up list that are: (1)Due upon receipt, (2)net 30 days, (3)payable at closing and (4)Paid, Thank you. On the same layout, there is a field defined as paid status with 2 radio button values set as (A)paid and (B)pending. When one of the three values in the terms field are selected; (1)due upon receipt,(2)net 30 days or (3)payable at closing, I would like for the (B)pending radio button in the paid status field to be highlighted. If (4)Paid, thank you is selected, I would like for the (A)paid radio button to …

Help neeed urgently. I am new to FM7. I am writing a data entry system without using mouse click. I need to capture keyboard function keys (F1-F12) pressed by user & jump to different layout or popup new window selection. Is there any function or FM7 command to do this. Thanks.

This is ridiculous...FM is adding a "/" after the .com in a Open Url calculation. I have tried adding a "" like a previous post recommended and now the calculation is saying that the text string does not end with "" when it in fact does! I am creating the url using the combination of three fields. NOTHING seems to work. I have another Open Url calculation that is strictly text and the "" did work, but it is not working on the combination field calc. Can anyone help, this is completely frustrating!

Is there a way of clicking on a field on tableview and triggering a script. It works in form and list views but nothing works in table view. Many thanks

Is it possible to make a script that is assigned to a portal button, and upon clicking it asks you to choose an existing record from the related table, and when you choose the existing record it automatically puts the related key field ID into that record? If so, is it possible for that script to only show records with empty key fields? Thanks for any info you might have! Chris

This may be simple, maybe i am to burned out this evening... How do I finish the following senario... I have a list of data, summarized by a group of owners. Each new owner is on a separate page. Currently I have it doing a search for the known owners. Printing as a pdf and saving with a static name for each. I am bringing on many more and it would be eaiser if I could print each new page as a pdf with the name save as (whomever).pdf in a folder. Any help is appreciated. Thanks

Hello, could somebody help me with a example script to call a FM server served fm7 file from a fm7 file hosted on a generic machine? thanks, Joeri

I am new to FileMaker and am wondering if I can do the following. I want to do a "Find" for a particular set of records. Then I intend to print those records and then I want to mark all the printed records as having been printed. Is there a way I can mark all the records at once? The only way I can see to do it right now is to go through them one at a time and click a radio button on a "Status" field that says "Printed / Unprinted" and check the "Printed" button. Is there a way I can automate the filling in of a field in multiple records? Thanks

I have read through a number of posts concerning portal rows and the way they are affected within FM7 but I am still not clear on what the work-arounds are. I am just in the process of converting a FM database from FM5.5 to FM7 and I am having terrible problems trying to get a number of scripts to work. I am hoping that someone can explain reasonably simply how I should work around the problems I am having. In a number of very significant places I have written scripts that copy records from one portal to another to create sub-records. The script loops through the records in the first portal and creates records in the second portal. The problem is that it fail…

Well, I was pretty good with variables in Director, but FMPro has me stumped. After several unfruitful hours, I could use some help. This is a simplified explanation of what I want to do. 1. Go to a record in Browse mode. 2. Set a variable A= to the contents of field "FieldA" 3. Set a variable B =to the contents of field "FieldB" 4. Go into find mode 5. Put variable A into field "FieldC" 6. Put variable B into field "FieldD" 7. Do a find I have tried many possible combinations of Let, Set Field, Evaluate, Get (Script Parameter), Evaluate, but I guess the syntax is just too different from Lingo. The variables can be discarded after the script is run. C…

Hi, I have a massive relational database that needs to be updated daily. Problem is it takes about 45 min, even through ODBC. I was looking to see if there is some script I can run or schedual to where it can run at like 3 am or something so it is not such a pain for me. There has to something I figure, just haven't found it yet.