Script Workspace and Script Triggers

I'm an FM newbie. Just feeling my way through the dark right now. I'm using a script that I copied from a template to list all "client" records in a list layout. This is the script: Allow User Abort[Off] Show All Records New Window[] Adjust Window[Maximize] Go to Layout ["SelectClientForModality"(ClientData)] Sort Records[Restore;No Dialog] Go to Record/Request/Page some other lines not related to the layout What I get on my layout is a list of all clients currently entered into the database. I'm passing a script parameter which is a number. I'd like to omit any records if a specific client field matches this parameter. I haven't b…

Is there a way of creating a script that will take the user back to the previous layout in browse mode? I have seen it done in MetamagicData, but their define fields and scripts were locked, so I could not see how it was done. With their solution you could not only go back to the precious layout, but also those that preceded that one. Thanks in advance - Sam

How can i put a button in only one record

Is there a simple way to launch a script via a calculation? Say for example I'm tracking how many times a user logs in and the count equals 5, I would want it to then launch a customized script that would change information in a particular field. I've got my script working perfectly, I just don't know how to make it launch from a calculation. Thanks for the help

Can anyone help me create a script that would accomplish this? I want to strip all data out of a record except for one field. Is this do-able? Thanks

I am using the "Perform Find" step in one of my scripts and my question is how to get it to not display the window saying that no records were found and just continue on with a result of zero. The "Perform Find" step is used multiple times in my script and if one of the find requests turns up with nothing, it messes up the rest of the script. Thanks for any help that you can provide!

I would really appreciate help on this, any questions - please ask! database...######################################### table 1 id client joining date [e.g. 25/03/2001] table 2 id client statement date status relationships table1::id client = table2::id client ####################################################### We need a script to find all records in table2 which are related to the current record in table1 and whose statement date is before last occurance of the joining date [e.g. if joining date was 20/01/2003, then the last occurance of 20th January] and whose status is blank Cheers, Matt

I have created an order entry system. In the backend data files, I created a privilege set called processors. I did not give this extended privlege the ability to create and delete orders. I did not want them to be able to use the FMP shortcut keys to do this. I wanted to force them to use my scripts to create & delete records. So on the new order script, i set the option to run with full access. Thinking that this would allow the script to create a new record but when a user runs the script they still get the message saying their security does not allow them to create the new record. Am I thinking wrong on how this option should work? I forgot to mention …

Hi there, I want to create a script that will delete all related data. This is how things look... It's a college library system, for example, each book has two copies, and each copy has two loans. If I need to delete a book, it will create invalid data in the 'loans' and 'copies' tables. Is there anyway I can create a script that will go through copies and then loans to delete all the data. This is probably a simple loop answer, but I'm a newbie, so please forgive me .

Hi, I'm running external scripts (in other files) from the main file. The problem I'm having is, that when the external scripts run in the background, the window in the main file keeps flashing, or becomes blank, or sometimes the window of the external file appears in the front (just blank window). I have the "Freeze window" step as the first step in the scripts that run the external scripts in the main file, but that seems to be working only partially. Is there a way to completely freeze the window in the main file while external scripts are running? Any help is greatly appreciated. Jari V.

I am a bit stunned that FileMaker doesn

I have a script that is assigned to a button. When this button is clicked, a new window pops up, displaying data from another table within the same FM7 file. How can I limit the number of windows that this script will open? The issue I'm having is that the user will open this new window via the script, and then go back to what they were previously doing. They forget that they already have that window open, so they click on that button again, and now there are 2 windows open. And they really get frustrated if they can't modify any records because they never finished modifying the first window. Does anybody know of a way to make the script check for any windows tha…

On one list layout, I have a 5 fields. It is possible created a just one script for sorting ascending/descending for all 5 fields?

Is it possible to run a command prompt (cmd.exe) command from a FileMaker script (rather without the actual promt showing)? I imagine it would be the easiest thing, I just can't figure out how. I think I should be able to do this with either Open URL or Send DDE Execute. But no success so far... Any ideas? PS. I can easily access the prompt by executing a Open URL script with the path to cmd.exe defined... but I would like to actually run a command inside the prompt...

Hey Guys, I'm designing a database right now to keep track of employees and their devices which are using Class C IP addresses in the 192.168.1.x range. I'm using Filemaker Pro 5.5. It's a relational database with an employee table, a devices table, and an accounts table. The employee table has two portals to the other tables, which display the most important info. Right now my plan is to pre-create all 254 IP Address records, with no other info except a unique IP address. What I then want to do is make a script for a portal button that will bring up the list of existing IP Aadresses from the devices table, ask you to choose which IP address you want to use, and inp…

set field {"GBL. Resume URL", ""http://(host computer ISP #)/"&Right(Applicant ID, 1) &"/"&Applicant ID &".pdf"} open URL {nodialog, "GBL. Resume URL"} can't figure out why if the files with all our resumes are hosted on a computer with os9 this script works fine but If I move the files to a computer with os X it doesn't work I've already put it in the public folder, the shared folder and the sites folder, i've enabled almost everything dealing with sharing in the syst prefs i just can't figure out how to make filemaker pro 6 pull up a specific file from another mac with osx. any help?

I'm setting up a printing script and I don't want the screen flashing while I'm changing to the print layout, so I'm trying to use a Freeze/Refresh combo. I have a main printing script ("Print") attached to a button with a script parameter of "invoice". Allow User Abort [Off] Set Error Capture [On] If [Get(ScriptParameter) = "invoice"] Perform Script ["Print Invoice'] Else Print[] End If The Print Invoice script reads: #Set the orientation to portrait Perform Script ["Page Setup"; Parameter: "portrait"] Freeze Window Go to Layout ["print_invoice" (invoices)] Print [Restore; No dialog] Go to Layout [original layout] Refresh Window[] …

Hello everyone, I'm using the "Send Mail" script function, and it works fine, except that when the Outlook email window pops up you can't minimize it or switch windows -- you're stuck until you press the Send button or click on the X to cancel. I actually thought of a workaround; I used OpenURL with "mailto:" and it worked. There's only one problem, it doesn't work with lots of email addresses. I need to be able to use 100+ email addresses. "Send Mail" works fine in this situation, but my mailto: workaround does not. So does anyone know how to get Send Mail to stop "locking" the email window? People that are using it need to be able to switch to another…

The function "Get(SystemNICAddress)" cant capture Physical Address of my mashine !?! 1.) The Application is on my mashine. Even, I did make new file with one field and one script step which just has to capture and store the NIC Address. 2.) I'm able to see NIC address when I enter ipconfig/all in CommandPrompt(dos shell). 3.) There is no firewall influence. 4.) Recently I did put new hard disc on mashine(what was accepted from windows) but cant figure out how it can be related to my problem...the function "Get(SystemNICAddress)" has to read Phisical Address of my network card and doesnt deal with serial number of my hard disc. Does someone have a tip ab…

newbie question. I have a field which can contain a number. Not every record requires a number to be entered but when it does I need a script that will go through all previous records to find the highest number used, then I can increment it by 1.

I have a very simple newbie question How do I get a message to pop up as soon as i open my db. thanxs

Hi, I have worked with Filemaker, but not the scripting abilities very much. I'm trying to modify an application written by someone else. I'm trying to take the text from one field and modify it and write it out to another field. The text field, gPIDtemp1, contains XML that looks something like this I'm using Set Field like so Set Field["gPIDtemp2", "Replace(GetField(gPIDtemp1), 1, Position(GetField(gPIDtemp1), "<pid>", 1,1)+5, "")"] Set Field["PID","Replace(GetField(gPIDtemp2), Position(GetField(gPIDtemp2), "</pid>", 1, 1), 18, "")"] Is this valid? I'm not getting any error nor is Filemaker crashing. But i…

Hi to all friend! Can a button perform a script that, among other things, send itself a "do nothing" ?? (so the button never highlights anymore)

I know how to set the value of one field to another field, the trouble I'm having is making the script run through all the records and set the value of one field to another field. Here's what I have for the script: Go to Layout ("Layout 1") Show All Records If [Field 1="A"] Set Field ["Field 2", "A"] End If What's the proper way to make it run through all the records and set the values of Field 1 to Field 2? Would a Loop Statement work? Not exactly sure how to setup the syntax. Please help!! Thanks Ron

I have just finished a student tracking database for use at the school I teach at. In showing it to the School Executive, the Principal was wondering if there was an easier way in entering dates and date ranges. Instead of entering //, <specific date>, >date, date1..date2 in the Date field on the Search layout, he was wondering if you could use terms such as Today, Yesterday, This Week (>date to today), This Month (first day of current month..//), From Beginning Of Year (1.1.2005..//), Term 1 (date1..date2), etc, from a drop down menu which would then transfer the required dates to the Date field on the Search layout. The idea would be that when the Searc…

Hello... So.... is there any way of picking up the 'name' of a button for subsequent use in fields or scripts? I have a number of buttons; each needs to instigate an action that is related to the button name. It would be nice to write one script that could take the name of the button that called it and use that to figure out what to do, rather than having to write one script per button. Any ideas, anyone? Waiting in hope.... Thanks, Rob.

Hello all I have two fields Customer_::Phone AND Invoice_Old:: Phone. What i'm looking for is a copy and paste script. Copy everything from field Customer_::Phone and paste it into Invoice_Old:: Phone. There are no portals. I'm sure this is simple but for some strange reason I'm having a great deal of difficulty. Thanxs

Hi all, Has anyone run across a Pause script statement not working correctly in IWP? I have a 3 second pause then a change to a different layout. The original layout displays until I click the "Continue" button in the Status Area. I'm using Server 7 Advanced to host the file for a Windows IE 6 browser. Thank you.

I've got a project where I get a lot of hand written memberships. During after the data entry I would like to click a button and have an email created with the members first name and their other info automatically put into this email. I've tried a couple of things and looked through several books I have and nothing seems to help. I'm hoping this is possible because the next step after data entry is to enter their email address into an email server so they can receive our posts. I'm trying to create an easy way to double check their scribbled info to help cutdown on bounced back emails. I tried something like <database name::field name> to have the email start w…

How do I do the filemaker 7 script (Select Window) in filemaker 6? I have a script which is opening the window but not making it the active window.

Hi there, i just want to ask some question related to file path. Every time we run a script from external file, when selecting the file, it will have a check box for save relative path. I want to know that what is the different for this option. Because now i facing a proble related to file pointing, let say i have a set of db files in my pc, if i make a copy of file to another folder and open it, sometime the script still will call the original file, it means i have open 2 files with the same name. It will not automatic point to the folder i select, it make me need to check all the script and do the repointing to the correct file again. For multiuser environment, the clie…

I need a script to scan through a text field that contains numbers and text and format the numbers with a thousands "," separator where needed. The single text field contains a list of items separated by returns. The number of items varies. May be as few as 10 or as many as 50. The items will be either text or numbers (dollar amounts). The first and last item will always have a "$" prefix followed by a space. The items are similar to the following list; $ 12456 300 incl. 1000 incl. ---------- $ 13756 I have accomplished this but only with a huge script that acts on the data as it is gathered, before it has been concatinated to the field. …

Am a school teacher currently creating a database for school use. Am, after 6 months, nearly finished it MASTER2005.zip

Our school district uses DHCP to assign IP addresses to computers. We reserve IP addresses in the range 230-255 in each subnet so we can statically assign IP addresses to our network printers. For example, in subnet 80 we have the following addresses set aside for printers: 10.121.80.230, 10.121.80.231,.......,10.121.80.255 We have 10 different subnets on campus. I have a database that keeps track of all our printers. I have a checkbox in one of my layouts labeled Networked. I have a script attached to this checkbox that I would like to do the following: - When it is clicked and becomes checked I want the next available IP address in the subnet to be a…

Ok I have created a page to select the month and the year of the data you are requesting. I have 2 drop down lists one for the month and one for the year. I went into scriptmaker and wrote what I thought would work for a script to navigate to the desired page per what you choose on the month pop up list. Here is what I did in script maker if month = "january" preform script [sub-scripts, External"billing1.fp5"] end if if month = "february" preform script [sub-scripts, External"billing2.fp5"] end if if month = "March" preform script [sub-scripts, External"billing3.fp5"] end if if month = "April" preform script [sub-scripts, External"billing4.f…

Is it posible for someont to click a radio button (ex. #4 of 5) and it displays 4 stars instead of the radip button?? It should work like http://cdn.nflximg.com/us/pages/widget/stars_2_30.gif Thanks TMAS

Ok I have created a page to select the month and the year of the data you are requesting. I have 2 drop down lists one for the month and one for the year. I went in to scriptmaker and wrote what I thought would work for a script to navigate to the desired pages per what you choose on the 2 pop up lists. Here is what I did in script maker if month = "january" preform script [sub-scripts, External"billing1.fp5"] end if Repeated this sript 12 times but only will goto january How should I write this script when I want it to choose between 12 choices. Thanks in advance Mentairia Bulveridge

This is going to sound stupid to you experienced users but I've just purchased Filemaker pro 7 and can't get it to do the task I want. I set up my Teaching Materials database and have filled record 1 with the appropriate fields and buttons. I want to press on my created button labelled "lesson plans" and for the program to open an OpenOffice or Word File and show me my lesson plan. I would also like to be able to press another button and get a picture, or something else with a different layout from my original record. I just cannot seem to do this and I have been trying for hours. I just don't know what to choose on the specify button menu or how to set the procedure up. …

Hi! I have an invoice page where I have set it up so that once I put the client's name in, it automatically takes the address from a relational contacts Database. Is there any way to set it up so that if the client is new (so no address ifo to be found), I can enter it into the invoice and have it automatically make a new record in the Contacts DB? (since the address fields are from a related DB, I can't enter information into them, right? Currently, I have a button that does nothing more than open the Contacts DB - can I even script it into that related DB so it at least goes to "New Record" ? Thanks, sarah

Hi, I have email set up to send through OS X "Mail" program (not Entourage or outlook). When you forma the outgoing email in Scriptmaker, your only options are to enter the email addresses into "To:" or "CC:" - Does anyone know how to insert a "BCC:" part? Also, to route it through Outlook or Entourage instead, do you need a plug -in? (if so, is there a BCC option with either of these?) Thanks! Sarah

how can I create a script that, when I click a button, it automatically stores (copy and paste) some records into a new layout?? I have a layout with contact names and address. When they pay their debit notes I would enter a date that they made the payment with the check number. Finally I want to click on the "REGISTER" (that will perform the script) button so it stores all info "names, adress, date and check number" into a new layout named "REGISTERED DATA". So I wont have to enter again the name, adress, into the "REGISTERED DATA" layout. Any help?

Hi Guys, I'm sorry if this has been answered before, but I've search this forum as well as articles and tips, and havn't managed to come up with any answers. I have a data entry screen (Form), with 7 records. When the user clicks on search button, it takes you to a modal window which is a search screen. The user can perform a Find, by entering data via a pop up list, or cancel the find (which shuts down the modal window). My question is, it creates a foundset in the wrong layout, i'd like it to return the foundset back to the Form screen. Is this possible? I've attached a very simple file, with one field and 3 basic scripts. Any help would be much ap…

Is this a simple question? I think it ought to be but the answer isn't obvious. I would like to be able to click on a column heading of a list and toggle the sort between ascending and descending. Is this easy to do?

Hi, I have a solution that i want to remove the status area for the user. I have a find script that is very basic. I want to be able to give the user the option to omit records, extend found set and constrain found set using the same find script and I don't know how to do this. Can anyone help?

This is probably posted somewhere but I couldn't find it. When the user is filling out a form, there may be a need to add a new item or category in a subform. An "add new item" button is next to the field, so by clicking on it, the user is taken to the item/category/etc. db, the script is paused, to add the item, then returned to previous db by pressing enter on the number pad (with "go to last field" in script to end up in the same place). My goal is for a "continue" button to appear on the layout where the new item/category/etc. is being added so that the user does not have to always remember to press the "enter" key on the number key, and not the regular enter k…

Does anyone know of a script that will forward specific users (referenced by the entry of their password) to specific layouts? I know you can assign specific layouts that can be viewed only by certain users, but it does not include forwarding based on the enttry of a password. I'm running FMP 6.

Case( mod(char1+8;26)=1, dsd_code = dsd_code & "A", mod(char1+8;26)=2, dsd_code = dsd_code & "B", ) I have to do a calculation to know what letter correspond to the number... I get the "an operator (e.g. +, -, ...) is expected here" message... why!? I also tried multiple if, like: If( Mod( char1 + 8 ; 26 )=1 ; dsd_code & "A"; "") If( Mod( char1 + 8 ; 26 )=2 ; dsd_code & "B"; "") If( Mod( char1 + 8 ; 26 )=3 ; dsd_code & "C"; "") I get the same error... anyone can help to go through that step?!?

HI! I would like to know if ti possible to write/update registry key with file maker. I have to do a piracy protection.

I have a complex problem. I have a database of records with a text field that contains a 1 to 5 word phrase such as "winner circle post horse laptop" I want to search through each record's text field to find and compare another text field for a match of all of the words in the field regardless of the order they are in such as "circle winner laptop post horse" would be a match because the field contains all the words. I would like to reject matches that only contain a partial match of less than the complete word count. Anybody ever done this or have any ideas?

Hi! I have to generate two numbers. One between 1 to 9 (1,2,3,4,5,6,7,8,9) and one between 1 to 26 (1,2,...,25,26). I tried the random function, but I only know how to generate from 1 to 100 or 1000... Anyone have a formula?? Thank you! jca

Is it possible to display field contents in a custom dialog statement. I thought you could format your text like the insert:merger field command heres all i want to do "<<Table_Name::FistNameLastNameCombo>> has been logged in at <<Table_Name::TimeIn>>." this is part of a script i have attached to a login in button that just records the current time in the TimeIn field. this line only displays exactly what you see there

Does anyone know if using "pause" script will work for runing a script that follows through multiple different emails. I'm trying to automate my email follow ups with clients that contact me for a service quote. Example... 1.Create initial record 2.Start script for 2 day follow up 3.have an option to stop this process 4.if script is not stopped then send a 5 day email 5.have an option to stop this process 6.if script is not stopped then send next follow up e-mail. I'm sure this can be done. Can anyone confirm this? Any idea's how to set this up? Thanks! [email protected]

Hi all, I am developing a business administration system and have problems validating a value. When a script runs, it opens a custom message that requests a value. The value should be unique, so I want to test it. As the field definition already requires it to be unique, I planned to use the ErrorCapture to catch the invalid non-unique value (error code 504 - value is not unique as required by field definition), but it doesn't. Only when the script has ended and a record has been created, do I get the standard system message saying that the field requires a unique value. This is too late. Anyone any idea how to solve this prob? Thanx in advance, Chavito - The …

I created a script that would allow the user to type a name and then hit enter to be able to enter another name. I am using a custom dialogue box with one input field for name. Button 1= OK Button 2=Finished Button 3=Quit. I run the dialogue inside a loop that has an (exit loop if status(currentmessagechoice=2)and creates a new record every time you click ok. It works great until reaching the last record. After clicking button 2 it exits the loop, but the data that was typed in the field input is not there for the last record. The only way I have found around this is to have it create a new record, click finished, then delete this record. Any suggestions or e…

I have a db that will let our Estimators create Misc Work Requests for our company. They all log in with a password and are assigned a group that will display their name when they create a new record. I also have a few users that need to print reports for weekly meetings or for accounting purposes. My basic users do not need access to these reports. I have a script that will print the weekly report, and also the log for accounting. I can make it where, based on Access, they get an "access denied" message when they click on the link, but I want them to get nothing when they click on the link. Is there a way to add this to the scripts I want blocked out of the…

How do I script for email to be sent that includes a particular stationery? My email sends fine but without a nice background stationery. I use XP pro, FP7 and Office XP.

Does anyone know how to end an email script that loops? I want it to stop on the last record. Right now it keeps generating emails... Thanks everyone! Great forum! Great program! [email protected]

Hi, I have a re-login script in my solution. when a user logs in the staus area is hidden. When I re-login with my account the status area is shown. But when I use the re-login script to go back to a guest account the status area is still showing. The script has an if statement: re-login[] If[get(privilegeSetName)=["Full Access"] show/hide status area [show] else show/hide status area [hide] why doesn't this work? what am I missing?

How can I use a script to take data from the first file, create two new records in a second file, and insert the data there?

Hi Everyone, When writing a script and selecting Go To Layout [ ] and then selecting from the SMALL popup, is there a quick way to jump by beginning letter? Scrolling works but I have 110 layouts (is that a lot?) and my index finger is taking a toll (from repeated scrolling)? I'm hoping someone has discovered a shortcut command (for Windows). [CTRL] and 'Alpha' doesn't work; neither does any other combination I can think of. LaRetta

Is there a way to trigger a script using the return key? Specifically, type into a global text field, and when the user presses return, a script is triggered. Thanks, ev

hi! i would like to know, if you could recommend filemaker books (or internet links) where "filemaker scripting" is well documented? i would love to learn how to script and the books i have does not seem to be good enough. thanks in advance.

Im New to FM pro, using version 7. Id like to set up a method that checks that the salesman enters data into cetain fields, and returns to that field until he does complete it. does anyone know of a library of scripts that i can peruse and adapt to suit. Cheers guys & gals Hope you can/will help Philgavin

Hi Guys, Any tips or hints on the most efficient way to duplicate Master and Child records in FMP7. In FMP6, I used to use John Mark Osbornes duplicate portal example (www.databasepros.com), but this does not work with the newer version of FileMaker unfortunately. Cheers

This is what I want ot use: PatternCount ( keywords::KeyPhrase ; " " " )>0 What will work? I want to find and remove qoutes in a text field. I will also need to add quotes as well. Can you help?

I have an application originally written in FM5. I don't have any manuals for FM5 and I can't find this documented in FM7 ... can anyone tell me what is the meaning of a number following the filename in the Open File statement?

I have a DB that manages a schedule. I have a table that dates get put into and kept to show a history. I am trying to make a field that shows the "next appearance date" where it parses the related appearance date history table and shows the latest entry which would be a date in the future. Any thoughts on how I would constrain this "next appearance date" to show only the latest date in the history, which unless we mess up the data entry or forget to update the record, should be a date in the future...

I need a script that will allow a calculation of hours that each event entry in our database took per week, per person.

(Using FM 6, multi-platform) This is one of those odd obvious questions that either has a simple answer, or is impossible. I need to script leaving a field. Or, script the action that happens when you click a layout's background, the last field visited is "deselected." I have a script that does some stuff, then enters a field to copy the contents to clipboard. It works, but it leaves the user "in" that field, which is highlighted. This field is normally flagged to not allow entry, so at that point entry is possible anyway. Besides, it looks untidy. Is there any way to end this script at rest, with no fields selected? Steve Brown

this seems like it should be so easy, but after buying $100 worth of records and spending 3+ hours i can't figure this out. i want to create a new record in table #2 when a certain yes/no (yes) is satisfied in table #1. so far i have If [table#1::fieldX = "yes"] End If i have no idea how to compelte this and any help would be appreciated. thanks.

I have a script that is used to import a record from one database to another(Database 1, Database 2). The script will first check to see if the record already exist in Database 2. If it does then it increases the number in a number field by 1. If it doesn't exist in Database 2 it imports the record from Database 1 to Database 2. The script I have now copies an ID # from Database 1. Then goes to Database 2, goes into find mode, paste the ID# in the ID field, and performs a find. If the Total record count > 0 it increases the number in a number field by 1. The problem I'm running into is, if there are no records found I need to import the file in from Database 1. …

I would like to put an If then statement to get different layouts. Something like this: If User-Name = Joe Go to Layout #1 Print Layout #1 End If My problem is how do I do a get User Name so I can do a condition test for the Joe? Then I can do the rest. It's just that part. Is there a function, Get, Status or what? Thanks in advance

1) Is there a way to determine what is currently 'stored' as my script parameter? All I can think of is to set a global field with it and look. It doesn't seem to work in a calculation (doesn't update as the script runs) even as unstored. 2) Is it true the parameter will not pass to another script without starting the sub-script with Get(ScriptParameter) again? 3) Is it true that Script Parameters will behavior in this same fashion if passed between files? Situation: I'm using them a lot and I need to troubleshoot some problems with them. Thank you. Item 1 is a bit unclear ... can I test what is being held on a Script Parameter within a script, i…

Hi, Several scripts have just suddenly stopped working; they've been up and running for the last few months, I took a fortnight off work and whilst I was away, they decided to take time off too. Trouble is, I've come back and they haven't. Any ideas?

Hi everyone, I'm hitting a brick wall here, and would like some help if possible. I have one fp7 file with two tables. Each table has a userID field, which have an established relationship. This seems to work fine. I need a script that will do the following. When switching from a layout on table 1, will perform a find and only display records on table 2 with a matching userID. Currently, I have the following script: Enter Find Mode [] Set Field [table2::UserID; table1:UserID] Perform Find[] Go to Layout [table2] //don't remember the exact syntax I used, but I know this part works This script errors out at Perform Find. It says that an…

I am releasing a new version of an existing FM Developer 5.5 solution. I want to create a simple FM file that will: -show all records in each of the 3 old version data files; -create a compressed copy of each old data file; and -import records from the 3 compressed copies into the corresponding 3 new version files. My hangup is described in this FileMaker Help topic: "Open" script opens the specified file or lets the user select a file to open. [color:"red"] Script steps after Open execute in the file that contains the script, not the file opened by the script. Is there an easy way to create a simple file with script directions to do the 3 tasks show…

hi. i have been trying out filemaker for a few months now. and i have this question. the answer would really be trivial, i know, but i still can't find the answer, searching in this site or the internet. so i would appreciate it, if you guys could help me out. i want to create a counter. the user needs to press a button if a person needs "option a" or "option b". after a month, i would like to be able to create a statistic how many users chose "option a" or "option b". i would also like the option to a statistic per year. this is the way i see it (please correct me if i am wrong). at the start of the day, the (let us say) "go" button gets re…

hi, let us say, i have a working database and i want to improve or edit some scripts. but i do not want to touch the working database. i understand it is easier to say "save a copy as...". but is there a way to copy a whole script? and paste it in my test db?

Hi, I am using open url to send sms messages from filemaker. The problem i have is that the open url command does not keep the correct cases (lower or upper case text) when opening the url in Safari. everthing is reduced to lower case. Http is case sensative so i dont know why filemaker does not keep the correct cases. I have tried the Proper(text) function but it makes no difference. In addition when opening the url it does replace some http code for you, for example a space is indicated by %20 and a % is replaced by %25 which makes it very difficult to add my own http because a % is an essencial part of the code but keeps getting replaced by %25. If anyon…

I have a found set that I can export to another file using this script: Set Field ["PO info::Manufacturer," "MfgrCompany"] Go to Record/request/Page [First] Loop Go to Record/request/Page [Exit after last, Next] Set Field ["PO info::Sort 1, "Buy Select"] Go to Record/request/Page [Exit after last, Next] Set Field ["PO info::Sort 2, "Buy Select"] etc. End Loop Which triggers the lookups needed in the file with "manufacturer" and "Sort 1". This script only seems to work on the first record of that file (the file "Set Field" is directed to) -- is there a way to direct it to the last, next or any record in that file?

Hello, My apologies if I should post this general question to another forum. Please let me know and I'll do so.... Let me preface this with I don't consider myself a Filemaker guru, but my employer does... We are looking for a platform independent solution (i.e. Windows and Mac) to incorporate into an existing Filemaker application that was acquired. We want to add a script call to the action of clicking on a button. It would call a URL or possibly a command line Perl script that will return a data value. The data value needs to be stored in a record's data field, i.e. the process is bi-directional. First, I'm wanting to confirm that it would be possib…

I have a master client database and a proposal database. In the client master db we use a lookup on the proposal db to populate the master client db. What I need to do is after the new client record has been created, I need for the client number to be then written back to the proposal database. The relationship key being the proposal number. Can someone point me in the correct direction to get this accomplished?

Hello, I've run into a problem with the population of data in the lookup fields in a related record which is generate by a scripted button. My research shows me that when the data entry to the main record "Jobs" does not have the enter key pushed prior to hitting the scripted button which creates a related record "Work Order", then some of the lookup fields in the Work Order do not population. Is there a script step I can put at the beginning of my script attached to the button that will make sure the data in the original record has been saved? Or is there another way. I've already tried to have the record changes be required to have a manual save rather than automat…

Can i by script changing filling color of a field?

I have a shipping file that has a record for each customer purchase as follows: Record 1 Name: joe Smith Address: 45 J st Item purchased: widget 34 Weight 5oz Record 2 Name: joe Smith Address: 45 J st Item purchased: widget 57 Weight 10oz reimbursement Record 3 Name: joe Smith Address: 45 J st Item purchased: widget 16 Weight 5oz How can I determine the total weight for this customer when all three of the widgets are in separate records? I think a self join relationship would work somehow, or creating a new record with globals for the weights?? Attached is my work on the script to find the duplicate names I am close b…

I need to create a system that is easy to use, consistent in look-n-feel, and at least the layout and table defs are reasonably easy to maintain -- in a very large multi-table, multiple target-audience, data mining application (in this case, dozens of tables but only tens of thousands of records). To keep maintenance reasonably possible for not-so-techie people, I want to give them single layouts for each table, and then many other layouts specific to search tasks. The single layouts bit is what keeps this from being an easy task; but without single layouts the length of time before the application becomes inconsitant is shortened considerably (…

Can any of you Windows wizards help me out? I am looping through a found set and calling a Send Event on each one. Trouble is, the Send Event for record 1 is still executing when the Send Event for record 2 is called. Since I am appending echoed text to a file, the data from different records is getting dovetailed together. Not good. Here is the calculation I am calling with Send Event: "cmd /c echo & Substitute ( Contact Info ; "r" ; " >> c:" & New Filename Global & " & echo " ) ( "r" is actually the paragraph symbol in the real script ) So, the calc result on a typical record would be somthing like: cmd /c echo Name:…

In order to make such as "Each monday" do I use of multilinekeys instead of inner join records, because it's easier to change to "Each Tuesday" if the key is made by a repeating field exploiting Get ( CalculationRepetitionNumber ) for generating each date in the key instead of Ray's recursively defined RangeKey( ) from his template http://www.nightwing.com.au/FileMaker/demos7/demo705.html Now I do not in this case work with the freestored principle as Ray does in his, but instead with an Albert Albert Harum-Alvarez scratchpad to make conflicts show up in either overlapping dates or matches in a returndelimited field of resources. This is a stacked relation two mult…

We currently run FileMaker Server 5.5 on Mac OS X Server 10.3.8 and FileMaker Pro 6.0 on Mac OS X 10.3.8. I run Developer 6 edition. I came into this company a few months ago w/ limited FM experience. Here is one of my biggest issues. Determining what the Find Request(s) are in a script's Enter Find Mode and Perform Find step. I have to admit, I'm a little confused by the "Restore Find Request" option. If I am correct, if Restore Find Request is checked, the Find is based on the Find Requests that were in place at time of Script creation. If this is the case, how do I know what those Find Request(s) were? In Access for example, I would go to design of Query, and s…

Hi, I would like to create a pop-up window with a message on a given date. For instance: At the date of "contract expires" in the database, I would like to have the message to appear the day before. Thanks in advance. Nicolas (Newbie)

I know there is a script step for Allowing Toolbars On/Off. What I would like to be able to determine is what Toolbars are currently On. Like a Get(TextToolBarStatus) function. Is there a way that I am not seeing to do this?

I've created a simple database of all expenses for every project with the ability to print expense reports on a project by project basis. Is it possible to lock individual records after initial data entry to prevent someone from changing original content without confirming their intention to do so? The concern is that expenses associated with a project will be missed if someone changes the project it is associated with. Thanks for taking time to respond!

I have a layout with several fields that have validation without user override capability. A 'Proceed' button takes the user to the next operation. When a user enters a value into one of the validated fields, but does not tab out, validation does not take place until the 'Proceed' button is hit. So the first step in the 'Proceed' script is a 'go to next field' step which generally causes validation. I set error capture to 'on'. If the field value is invalid an error is detected and I exit the script with an appropriate message. That works in almost all cases. BUT -- For those fields, I use a pop-up list with valid values for the user to select from, but some u…

Hello, I just stumbled upon a bug in my system which has brought up an interesting problem. I use a separate window for choosing customers for invoices. The user clicks on the customer name in the invoice and a new window pops up that lets the user do some sorting and searching. Then the user clicks on a customer name which runs a script that populates the customer ID field in the invoice. The problem is that I choose the Invoices window with a Select Window script step and the window name is hard coded to "Invoices". The order people have discovered Window->New Window so sometimes they have a window up called "Invoices - 2" and when they try to select a…

I

I've created a file that uses a combination of calcs and scripts to write html to a global field. Then the Export Field Contents script step exports the global to a file with a .html extension. The html file works great in Firefox (PC), IE (PC), Safari (OSX), but not for IE on OSX. It shows "

Hello, I am in desperate need for someone to sort my database in a complicated sort of way. This should be easy for the experianced and I will pay around $20US for it to be done properly. See this project page for more info and how to bid (mention fmforums when you bid please) http://www.getafreelancer.com/projects/13472.html Thanks!

I upgraded Developer to 7.0v3 from 7.0v2 yesterday and suddenly url's no longer open up. They worked perfectly prior to the upgrade. I use the goto URL and all I get now is a blank page. Is there a bug in the v3 upgrade?

I have two fields, one is catagory, and one is class. How can I make a script that would find matching records based on whatever is in those two fields, even if the content of those fields change?

Hi Guys, Does anyone know if its possible to run an Excel 2004 Macro from Scriptmaker using FMP 6 on a Mac OSX machine. Thanks