Script Workspace and Script Triggers

I have a Company text field into which a value is entered manually (Company Name). However, at least 50% of the time the the value entered is 1 of 10 Companies. (the other 50% are never the same name) Rather that reentering 50% of the time the same 10 Companies would like a hit a button or chack mark so a Value List or a List from another file comes up and I can make a selection from that list.After selection made, the next new record is unchecked ready for new entry. Suggestions appreciated

Hi I am using an If function in a script where i wish the outcome based on two possible entries in a field. For example I wish an action to happen if the Status field in the Customer table equals M2 or TBR. I have tried the calculation Customers::Status ≠ "M2" xor "TBR" and a number of other possible variations. Can anyone let me know where I am going wrong.

I'm looking for a streamlined way to script the creation of child records for a found set of records. Example: Perform a manual find on Customer table which yields a found set of Customers. Using that found set, automatically create one child record for each parent record (i.e., for each Customer, create a new related transaction/line item record. The script would end showing a list of all the child records created and their parent IDs. Apologies if there is a thread to this effect already - I couldn't find it.

I am trying to perform a find using an exact field content match with a variable through a scripted search. I have tried two different ways to perform a search to show appropriate records and I'm not having any luck getting it to run correctly. First way: Set Variable [$ADName; Value:Get(AccountName)] Freeze Window Enter Find Mode [] Set Field [Table::User_ADName; $ADName] Perform Find [] ## This way doesn't work because if I have users with nearly the same ADName, the search finds records regarding both of those accounts instead of just the one I was looking for. Example: I do a search for JoniS, but I get records for JoniS, JoniS1, JoniSmith, JoniSanf…

Our Filemaker program is set up with multiple files and it is a pain having to go to "Window" every time I want to switch to a different file. I'd like to create a button that can jump from file to file, but can't find a script that has this capability - do I need Filemaker Business Solutions software to do this? We're currently operating on Filemaker 9 software, but I haven't found a way to do this in this software version.

I have a required "not empty" field that's there for data entry purposes. I'd like to leave the field validation that way but I'd also like to be able to run a script that inserts text into a different field. Right now, whenever I try to run my "InsertText" scripts I run into many error messages because of the "not empty" field being empty (no data entry yet). I know how to turn the error messages off with the SetErrorCapture[on] command, but that still leaves my script hanging and waiting for the now invisible "O.K." box to be checked before it will proceed to the next record. So, how do I turn off the validation and then turn it on again within the script? I ma…

Hi, I am looking at trying to convince my boss to move our associations data base application to File Make from MS Access. I'm developing on a Mac but is they do it it will be on Windows. Well this database is a mess. Before I got there 4 years ago the Boss the Executive director modified things. Anyway I just started looking at scripting and working with FM is a whole new mind set. I will need to move some fields out of 1 table into another to better normalize the Data. I was only able to get it to work by creating a variable. Isn't there a way to referance the data in one table and put that into another table without using a variable? …

Hi! I have a real estate database that records all visits to a poperty in a portal. There are fields for date and agent name among others. I would like to create a script that automatically generates an email (from an external email program, in this case mail.app) with the agents name in the to: field and a stock comment like "how did the showing go" in the subject and email. The script should be triggered 24 hours after the date of the showing. Any help would be appreciated!

Hi everyone, I am setting up a client box with an FM file called eMailer which will check 'periodically' for eMails (which will appear in a portal in eMailer) when they are ready to be sent. eMailer has a field (type timestamp) called Now which is Get ( CurrentTimeStamp ). This timestamp is used in the relationship to eMailLog and determines when something will pop into the eMailer as day/time to send. Robot will be perpetually looping and sending emails. However, I see no need to check for emails all night. I would like a User be able to specify: Monday start at 6:00 AM and end at 8 PM. Fire every 5 minutes. Tuesday ... Saturday start at 8:00 AM a…

Hi. I have a find in a script to meet a number of criteria. Firstly I enter find mode, then I set the relevant fields with a set field command and then I do the perform Find. It works great. I would however like to add one more criteria onto my find. It would be to see if the current date is at least five days after a date in a field. Not quite sure how the best way around this would be. Anyone have any suggestions.

I've heard several best practice techniques for optimizing a looping script: 1. Loop through found sets in form view (not list). 2. Loop on a blank layout. 3. Avoid refreshes, try to freeze window. 4. Go to a field first. Any others? Obviously, I'm trying to optimize a report script that's taking 4 mins. It loops thru parents, children and grandchildren so there are several gtrr, setting variables, global fields and creating new records in a report table. Would creating a layout with a portal avoid gtrr and speed up the process (perhaps, because the gtrr is forcing a refresh of some sort?).

Hi, I'm going to add another topic on a subject that has come up many times, but having searched the forums i haven't yet found a solution. I am building a database to manage a business of mine in the bar industry. In our particular case, good inventory management is key to our success. My relationship graph can be viewed at the following address so as to have a better idea of what i'm trying to achieve: http://www.chacal.co.uk/Relationships.png My question has to do with committing data to the database (in this case the sales/saleLines and deliveries/deliveryLines tables) and updating the running total in the inventory table. Rather than ha…

I am trying to display all the records from a TO in a portal. but what I am getting is seperate portals for each record.....any ideas

I import some data from a online source. Part of that data that goes into one field is separated by commas like> graham jones, 123 high street,town, or mr graham jones,123 high street,town, i need to be able to separate the text before the first comma to a different field. I cant use leftwords as the text before the first comma varies thanks for any input

I want to make a script in which the input of a user is requested in a dialog. The input is to be a typed value (not a check box). How can I do this? The data isn't to be stored on the open record, and I mustn't leave the open record.

I am stumped on this... I am attempting to create a script that will get the contents of one field on the current record and use that value to search for the existence of that value in another field across the whole table. The final stage, I need to put the value I searched for in yet another field as part of a report of what took place. I have attempted several different methods but I am having trouble passing and holding values between the combinations of scripts and functions that I have put together. My last attempt was to go into Find mode... Use an Insert Calculated Result to put the field of choice. Depending on how set the Find, I had different…

Thought this would be easy, so humbling... I thought this would be a basic loop through records, looking at the last record/specific field and comparing it to the current record/field and if they match, delete the current record. The problem is the comparison, when I am on the current record in the loop, how do I compare with the same field from the last record? I see no GetLastRecordField function. The final idea is to have only unique record entries in my field of choice. As always, thanks in advance.

Hello, I have a script I'm trying to create where it does the following two tasks. 1. Only shows "approved" expenses (this part works) 2. enter find mode where the user can choose to search on any other criteria based on the fields in the layout. When I only have #1 written... -Show All Records -Enter Find Mode -Set Field [Expenses::IsAdminApprovedBoolean;1] -Perform Find That part works perfect. But when I enter.... -Show All Records -Enter Find Mode -Set Field [Expenses::IsAdminApprovedBoolean;1] -Perform Find [color:red]-Enter Find Mode [pause] (then the user will hit enter to perform the find) That last step …

I have a solution I'm working on that has the data completely separated from the interfaces by way of files. The files have file references as normal. My problem is that I need to have a field exit script trigger a script. No problem with ZipScript pluggin. But the issue is that when I call the script when it's resident in the data file, it needs to update a field. But that table is open in the interface file that originally modified it, so I get the infamous "This record cannot be modified in this window because it is already being modified in a different window". I want to modify the field in the table in the data file to call the script which i copied to …

I have a global variable, that each time changes after have the task done. That global variable called g_ImportFile need to be the input as filename source in the scripttask Import Records or Export Records. Who knows how to do it?

Hello I made an E-Mail scipt to send an email to an adress of the record. This works fine. I was wondering if I can fill in the from adres as well, for I have different accounts and this way it replies will go to the correct address. Even better if I can determine my entourage account to use.

Ok I have a LineItem table for Order system, posted about it before, different question tho, I need a help with a script that will set a f_key field form me in Invoices table. To see the other post (it might help to show what the script needs to do)(http://www.fmforums.com/forum/showtopic.php?tid/194255/) Fields Are like. PO_Number (autoenter serial) Vendor_Code (autoenter serial) f_key (Po_Number & Vendor_Code) Item Cost and so on So records in LineItems will look like this PO 001 Vendor V1 f_key 001V1 Item1 25 PO 001 Vendor V2 f_key 001V2 PO 001 Vendor V1 f_key 001V1 Item5 500 I need a script …

How can I script a function that copies the contents of a portal field when the user clicks on that field and pastes it into a specific field outside of the portal on the same layout? I seem to be able to do this as long as I don't make the portal field a button but that defeats the purpose. Thanks! Greg

I've been sitting here since about 7 this morning working on my solution. Everything is going OK and I'm making descent progress. Suddenly Filemaker starts getting a little slow and suddenly LOCKS UP! (as it often does) So, as usual, I have to give FileMaker a Hard Close and reboot my computer just as an extra precaution. When It comes back up, it's like all of my scripts and layouts went through a time warp back to about 10 am this morning. Everything I had done from 10 to 3 WAS GONE! Does anyone have an idea how this could happen? Does FileMaker not actually save your work when you think it does? Thanks, Mel

Has anyone ever seen a script that can parse the name and address out of a data field? And, of course, if you have can you direct me to it? Such as: Name: Moira Westerner, M.D., Ph.D. Home Address: 35 Pinky St., apt. 2, Boston, MA 02114 Office Address: Neuroendocrine Unit, Massachusetts General Hospital, 55 Fruit Street, Bulfinch 457B, Boston, MA 02114, 617-726-1347 E-mail: [email protected] Fax: 617-627-2705 So that I can pull Prefix, FName, LName, Suffix, Address, City, State, Zip, Phone1, Phone2, emailaddress. Of course the problem is no one ever puts it the same way.

I know I'm overlooking somethin simple. I have a table that tracks an asset. Each asset has a description and other static info to describe the asset. Although we have many assets that have a unique serial number, basically, thier descriptions are the same, i.e. cell phones. We have many Model 6010s, each has a unique EMSI number, but all have the same descriptions. I have created a related table with a buch of item descriptions (4 or 5 fields). In the main asset form I would like to select a product (by a drop down list, which I have done), then be able to complete the rest of the input of the form. However, to speed data input, I would like to create a button …

Hey folks, I'm using the custom dialog script, after I create the buttons with the desired selections, how do I link that button to go to a specific layout? For example, button one I'd like to go to the purchase orders layout, and button two to go to an inventory layout. thanks in advance Hank

I'm stuck in severe dense mode (working two full-time jobs does that to you) so forgive me for the simplicity of this question: I have two related tables: Alpha (parent), and Bravo (child); the text field that I want to clear in Bravo is named cap_text. Currently, Bravo has four records. The script I'm cobbling together goes to different fields throughout the solution to clear, but not delete records--which is what the client wants. The problem is I'm having a devil of a time trying to code a simple looping script (using GTRR) to find the (four) cap_txt records and clear them. How should the script be defined? TIA for your help, Rich

I am setting up a field that creates an audit trail of certain actions taken on the database. The problem I have is appending the information rather than overwriting it. Ideally when a new piece of information is entered (which is done with a calculation) it 1. Goes to the end of the current information in the field 2. Starts a new line and 3. Inserts the information. The only think I can not do is number 1. I realise this is probably easy but I just can not see it. can anyone help.

I have a very simple database and would like to write a script to find all records for the last week (all records whose date is in the range "7 days ago ... today's date"). I can do it all except the "7 days ago" bit. Any suggestions gratefully received.

Hi everybody, I am real new here and also have not a lot of experience with any other database programs, while I am just on the way to find my way thru Filemaker. I am wondering if someone knows a script, (event) which links directly to a specific folder in MS Outlook or any other email client. I managed to open Outlook with: file:../../../Program Files/Microsoft Office/Office12/OUTLOOK.EXE but now I would like it to link directly to a specific folder within Outlook, where all correspondence of one specific client is stored. Anyone can help??? Tnx a lot in advance.

I would like to clean up a database which someone else created. There are a few scripts that I would like to delete but I do not know if they are still being used and if so what layout. Is there any way to search the layouts to find out if the script is still being used?

So I have a timecard DB that should restrict the days that they view to the pay period that they are in. I created a case script step to do this, but it sometimes works and sometimes it doesn't and I can't think of a reason why. Below is the text of the script I'm using to restrict the dates. The output I'm getting today for example is this: 4/11/08...4/02/08 Obviously this isn't going to work as a legitimate find. Is there some completely obvious thing that I'm missing that is causing the script to sometimes work and then sometimes produce the preceding? Craig Wells Set Field [ timecard::holding; "" ] Set Field [ timecard::holding Copy; "" ] I…

Hi, Hopefully a simple question. I want to activate a script when information in a field is changed. For instance, when the status of a job goes from Plated to Printed, I want to run a script. Can't figure it out...yet. Any help?

I need to use the 'send mail' command in a script (which works fine) but even though I have ticked'perform without dialog' , outlook express insists on asking me to confirm sending.Is there a way of it just sending without the confirmation box from Outlook? I have looked at various smtp plugins which I may well intergrate with my db at a later date, I just need a temporary fix in the meantime Thanks for any help

Hi there Not sure if this is the right place to put this - after much searching I finally managed to get a copy of Scriptology, but it did not have the CD (used copy). Is there any way to get hold of this?

HELP! I have a script that I need to pass local variables between database files. I use the "Perform Script" script step and add my parameters "$Username; $OldPassword; $NewPassword". How do I parse out the values in the referenced script?

I am using IWP I would like to build a URL to 1. Automatically Log me in; and 2. Set a field(s) value Is there a way to do this?

I would appreciate it if someone could tell me how to step through the repetitions of a repeating field like this Go To 1st Repetition Loop Set a value Go To Next Repetition, Exit after Last Repetition Exit Loop etc... Thanks

Is there any brilliantly simple way to set the next serial value for a field after importing a bunch of records from another FM table? I can't figure out how to reach out and copy it from the source table. I tried to write a sub-script to accept table name and field name, and then sort/take highest value/serial increment/set next serial value, until I again discovered that Sort can't take parameters . Short of brute force, is there a better way to accomplish this? Thanks, Chap

A while back someone showed me a great way to script letting the user locate a file using the OS Open File dialog, and then use that choice throughout the rest of the script. It goes like this: o Define g_SourceFileReference as a global container o Insert File [ Reference; g_SourceFileReference ] o Set Variable [ $filePath; GetAsText(g_SourceFileReference)] The Insert File step throws up the OS Open dialog, allowing the user to navigate to any file on the file system. GetAsText converts the "reference" to a well-formed path name. Now you can use $filePath as you like, as many times as you like. I use this when writing an upgrade script, wh…

Hi. Im looking to create lists that are based upon other conditions in the database. My scenario is that I'm developing a database that involves tracking guests and rooms. My request is to approach the same problem from two different angles. I have guests that need to be allocated rooms. I want to be able to bring up a list of clients and have a drop-down box of available rooms (rooms not already not allocated). Second half of the problem is to bring up a list of occupied rooms and then drop down a list of guests to assign them to - guests that arent already allocated a room. Part B of this problem is to have it so that I can swap guests in specific …

As I understand it, the location parameters for move/resize script on a MAC are relative to the whole screen. For Vista, they are relative to the FM window. How can I determine the location/size of the FM window in Vista/XP (especially when it's not maximized) so that I can properly place the windows my scripts manage? TIA

I have a very weird issue where when I export a layout as a PDF on some computers the resulting file is 3.68 MB (too big) and on other computers it is a more reasonable size of 580 k. This isn't a Mac/PC issue because it's small on my mac, but big on another in the office, and big on the PC. Any thoughts? Would it make a difference between 8.5 and 9?

I have a script that works the way I want on my MAC during development, but when deployed on a PC running Windows 98, accessing the solution on FMS 8.5 on a Windows 2000 server, it doesn't run the same. Here's what it is supposed to do. From within the solution, the script opens a new window where I get some info from the user that I put into Global files to do some computations. Then that window closes, the computation runs and then the original window that was sitting in the background changes layouts to show the new records compiled from the computation. When I move this over to the Windows 98 clients and run the script, things don't work the same. When th…

Hey everyone, I wrote a little script to do an export, pause so the user could add information, and then import the file back. Not sexy, I know, but it (should) work until I really learn this stuff. It seems to work fine - sort of. It does the export, pauses, and even does the import without a problem. But then I go to the "main view" which has a portal to this table, and the newly added records don't appear. They do, however, appear in their "home" table. Could someone take a guess at where I've gone wrong? [color:blue]Perform Script ["Find Constituents Query"] Export Records ["Constituent Query.xls"] Pause/Resume Script Go to Layout ["EvCon"] Imp…

I have created a database for IWP. I have a global field value list which populates a portal. The values in this portal can be added to another portal via a script. This works fine only in IWP this "adding script" doesn't work. Does anybody know how to mend this? scriptissue.zip

Does anyone see anything bluntly wrong with this script? The two tables are related via a Constant. If [ IsEmpty ( ddd_online::zContact_ID ) ] Insert Calculated Result [ ddd_online::zContact_ID; GetNextSerialValue ( "trip_d" ; Contacts::Contact_ID) ] [ Select ] End If I've trying to use this when importing records from another files. Is this not how you use the GetNextSerialValue? I've also tried this as the script. If [ IsEmpty ( ddd_online::zContact_ID ) ] Set Next Serial Value [ ddd_online::zContact_ID; Contacts::Contact_ID ] End If TIA.

Pretty new to Filemaker. Database I inherited has the all the postal information in one field (address, city, state/region, postal code). Would love to parse the whole thing into separate fields, but it's not formatted consistently. But I know I can move the first line into an "address1" field. Can anyone explain or point me to information on how to copy the first line in a field to another field? Thanks, Eric

Does anyone have a slick technique for printing selected rows from a portal? I know I can brute force a solution but I was wondering if anyone had any suggestions for a UI that simply asks the users which portal rows they would like to print? I have a production Database where the related portal can sometimes have many lines. MY users have asked if there is a way they can "break up" the output into easeir to digest chunks. Any help, as always is appreciated. Steve

I created a small application that now works very well. It is used to send messages to different services of my work. I want to complete the script to include automatically the additional attachments in the mail when there are some. Who would have an idea? Thank you veille.zip

Curious how the experts are organizing their scripts. In the beginning it made a lot of sense to organize all scripts thematically by function (scripts that add new records, scripts that sort records, scripts that popup selection windows, script to do common tasks etc) ... however, after a year and 120 layout later, the thematic approach proved quite cumbersome to me. It became difficult to maintain, to add new things, and generally to follow the script logic and all its calls after you've forget how (or why) you did certain things originally. It is starting to feel like one tangled mesh of spaghetti. Currently, I am experimenting with a "per layout" scripting m…

I am trying to write a script which, and a record is deleted, it will create a record of it's deletion. The issue is, one of our departments will print a report of all jobs due that week, and if a job is deleted, there is no notification. I have created a very basic table and layout, with the fields of order number, job title, original due date, and date deleted. I have played around with a script, in which when the delete button is pressed on a record, prior to its deletion it will copy the above fields into a new record in the deleted job layout. However, I am having an issue copying the information over into the new table. It will create a new record, and records …

Hello, I have a basic invoice layout for selling items and I'd like to create something (I assume a script) that would allow me to take all the records that are sold in one business day and copy them into a another table/layout so we can track day to day sales. I've attached a few images of the layout I have right now, if it helps. Any input would be appreciated.

I have a container field, and am using it to store photos. I have an insert image button, and a delete image button. They work fine. However, if a user double clicks the container, it opens the sound recorder. How can I prevent this?

I am trying to parse just the names out of the end of these lines. I have looked all of the text function and have not come up with any solution. Any help would be much appreciated. #td class="nm"$#a href="/name/nm0001567/"$Connie Nielsen#/a$#/td$ #td class="nm"$#a href="/name/nm0001657/"$Oliver T. Reed#/a$#/td$ #td class="nm"$#a href="/name/nm0001321/"$Richard Will Harris#/a$#/td$

Hello I have attached my first attempt at a script. The idea is simple. Via a value list in the 'type' field , in the 'project' table, I wish to create a new record in the ddf table, if I choose ddf from the value list. I figure this would be not too difficult ... but I think I was wrong. Can anyone help? Many thanks in advance Untitled.fp7.zip

Hello All and thank you for your interest! I have a timer that I have built into my solution, but I feel it is too confusing to the user and maybe a bit complex. You can view the file I used as a model at DatabasePros: http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000149 I used the Timer.fmp not the SuperTimer.fmp solution. The SuperTimer.fmp is way, way too complex and confusing to a user. Altho it does include a loop that shows time elapsed in real time. The Timer.fmp solution works great, but I feel it can be even better by the use of a simpler UI and a couple of added features…

This is an odd (and somewhat obscure) question but I want to export a table to XML without any newlines and some of the fields have newlines to separate data (a checkbox set writes in to this field) but I want the field to be exported as one long line. Is there a way to do this when you're exporting to xml or a way to create another field which holds a calculated value that is just the same as this other field but strung together as one long line.

I want to create a report where there will be a check mark if a container field has data. I figured I would do this by creating a container field and a calculation field to go with the first. How would I you write that script to check if the container field has data? What do I set for the IF statement to automatically fill in a check box? Say IF ( Container; has data; XXXXX )

Hello, I am working on a little project and have come to a road block. I would like to automate a procedure to backup our asset database to a pdf and email to our first class server. The script would run every friday at say 11pm and perform a find. The find would get the current date and subtract 5 days; find anything modified, by date, in the last 5 days. Is this possible? Thanks!

Ok, so I have another question, one which is probably easy and I am just not looking in the right place. I am using a database to track items that are serial numbered. Some of these items are paired with another item, and in the record, there is a field "Paired SN". I am trying to write a script which will go to the Paired SN record. I think it's a Perform Find step, but I may be wrong. Any help would be greatly appreciated! Tony

Can one use this to pass a parameter between database files? Or is it limited to passing data between scripts within the same file?

Hey Folks. So I have a commonly asked question of which I have yet to find any really good answers to: {background: We are running FMServer Advanced 8.5 on OS X 10.4 and we are integrating it with CWP via the xml/xslt grammer set.} PROBLEM: I want to allow the public to complete a form online using a CWP interface (which works fine) BUT I'd like to get notified* every time a form is successfully complete THAT IS: a new record is added to that database *(run script send me email - that part is easy). If we were doing this directly in FMPRo, it wouldn't be a big deal. So in short, I'd like to figure a way to get the adding of the record to aut…

I am trying to find records, duplicate them, and replace with a specific value. I want to do this in a script. I run the find say for the number 7 , I might find ten records, I want to duplicate the 10, and replace the 7 with a 9 in all 10 duplicated records. I have tried using if and loop statements and I am not getting the desired results. Is there a -foreach- someplace. like: find 7 foreach found duplicate replace 7 with 9

When I run a FMP 8 database remotely - that is, when I remotely opening a shared FMP file on a peer-to-peer Filemaker Network - and I run a script that does Save Copy to file:./Backups/foobar.fp7, where is FMP trying to save the file? My computer, or the host computer? And, relative to where? Not that it saves it -- when I run the script from the client computer I get Error 3 ("command unavailable"), and when I run it on the host computer I get Error 800 ("unable to create file"). Neither of which is helpful to me. I would have guessed that the file would be saved on the host computer in the Backups folder that resides in the same folder as myDatabase.fp7. (…

I have hundreds of volunteers working in 10 schools. I have to do a report to tell how many volunteer hours are worked and how many volunteers did the work. I have the hours worked out in a summary and then it is sorted into their proper volunteer area (senior citizen vol, Parent vol., etc) but I have a problem with how many volunteers did the work. I don't want to count the volunteers every time they work. Once a volunteer works, I want to count it as a 1 and then ignore that volunteer every other time that person works. I still want to calculate all the hours the person works, but I don't want to count the number of times they work. Each Volunteer has un…

I'm stumped on an IF calculation in my script. My faulty calculation is as follows: If [status_field = "Start" or "Continue"] I don't believe I'm using the OR correctly, obviously I'm missing something. How can I use the IF to check if status is either Start or Continue to equal true? THANK YOU FOR YOUR HELP!

FM 8.5. My Print script steps seem to be losing their settings even though I always check the “restore” option. For example, I use two separate scripts to print reports and envelopes. The report script prints to a Laser printer while the envelopes script prints to an inkjet printer. In the report script, the print step is set to: restore ,laser printer, portrait, and letter. In the envelope script, the print step is set to: restore, inkjet printer, landscape, envelope #10. After I run the report script, the envelopes print step loses it’s settings. They become the same as in the report script.

I am having difficulty find a way to exit a script that incorporates a find. I want to be able to exit the script and return to browse mode if no records are found without the user having the option to "modify find" or "continue". Anyone have any suggestions? Thanks!

I am trying to send an event - open an application that is installed in C:Program FilesXXXX.exe - I need to pass some command line options along, so I cannot simply use the 'File:' option (which btw works just fine when i test it). When I use the exact same path that the 'File:' option creates in my calculation, file:../../Program Files/XX/XX.exe, I get an error message when executing the script - cannot find C:Program.... I guess I need to replace the space between Program and Files with some special character - which one is it?

I have a DB that I would like to use a script to create new records in. It is used to calculate and display a payment schedule for a contract. Fields are: Sale Price Deposit Number Of Payments Payment Date Payment Amount Date Paid Payment Amount is calculated from (Sale Price) Minus (Deposit) divided by (Number of Payments) I need The script To create new records in the table = to the (Number of Payments) The Number of Payments comes from a table ContractInfo as does Sales Price and Deposit. The Payment Date needs to be calculated from PaymentStartDate also in the ContractInfo Table In other words... Number of payments = 12 First …

I am trying to get some help on a database that I have separate tables called Product Inventory (PI) and Main Database (MD). I am using these tables, as well as many other tables that are related to each other by Client ID, to keep track of my product quantity in PI and to see who purchased what item in MD. The inventory is the only thing that is not related to the MD because I didn’t think that it needed it. What I am trying to have happen is when a customer purchases an item in the MD table, to automatically reduce the count of inventory I have for that single item in the PI table. As of right now I have the following fields in each table that I think are necessar…

Hi there everyone! I was wondering if anyone else out ther has seen this sort of thing or not. I am using the Send Mail script step with the "no dialog" option. However, when I run this script my computers are prompting with this warning message from MS Outlook: Microsoft Office Outlook A program is trying to automatically send e-mail on your behalf. Do you want to allow this? If this is unexpected, it may be a virus and you should choose "No". Buttons: Yes No Help When you click Yes, the script continues without a problem but I need to automate this and bypass the MS Outlook prompt. Any ideas?

Can somone help me with a script that will delete duplicate records as they are imported into a database? I have a DataSource with more than 4 million records with many of the Order Numbers Being duplicate. I would like to filter out all but the first occurence of these Order numbers as the data is being imported. Is this possible? Thanks, Steve

I tried searching the site to no avail but was wondering what your take would be if you were presented with this problem: Client (don't even ask me why lol) wants to open pdf documents from within Filemaker. The documents are stored on a server drive and set path. We've tried applescript/etc and almost got it to work with Preview - (which would be ok) but not Adobe. Any suggestions? Thanks All!

Im using a send url script step with the following mailto command: mailto:[email protected]?subject=ReportReady&body=see attachment&attachment="C:TempTest.pdf" When the email opens there is no attachment. The Test.pdf file is in the temp folder. I've looked around the web at mailto: syntax and it appears my attachment parameter is correct. I've tried using / istead of . I've been testing this string by entering it into IE but i get the same results so its something with my string... Can anyone help?

Hello, I have a very simple database. The fields are: Product (for the product number) Retailer (for which retailer we're talking about) Price Week of the year (for example: 1-52) Year So one entry could be: Product: 37LCD2 Retailer: Circuit City Price: 907.99 Week of the year: 10 Year: 2008 We are one of the retailers. I would like to find any occurrences where we (one of the retailers) are higher in price than any of the other retailers on a specific product in the same week and year. Basically making sure we are always the lowest price listed. Hope that's clear. Would scriptmaker be the best way to do that? Or…

I used to work with Filemaker pro 6 and few months ago I started to use Filemaker Pro 8 Advanced, so every solution already made was upgrade, the thing was working well but suddenly with one script something wrong appered. In some portal row some data was inserted there with my scripts changing between layouts and databases but right now filemaker is telling me that "can´t do it because the same record is been used in another window!!!" I already checked file references and databases relations everything seems to be ok, I don´t know what else could be??? any ideas??? I´m kind of new with version 8 so I don´t know what is happening??? Help please Tha…

I have a script that uses Send Event to initiate a third-party file conversion and then waits for the result in the form of a named file on a specific directory. Even though I use Set Error Capture [On], FileMaker intercedes and informs the user that "File is locked or in use", instead of letting my script handle the error. I thought using error capture would prevent such messages from going to the user. In fact, a reputable manual states simply that: "during scripting ... developer's are in a position to trap and examine the error codes FileMaker generates." The general sequence of my script is: [color:orange]Send Event: ... pause 2 seconds, then: Se…

Hello everybody, When you open a database in FMP, weather it is local, through FPM network sharing or through Instant Web Publishing, the records are sorted in the order they were entered. You can always sort the records using the sort option in Records menu. But the users that will do the data entry and the users that will be consulting the data in this database are... well... somewhat technologically challenged... And the manual sorting of the database seems to be a little complicated for them. I have to admit, being lazy myself, I find this task to be tedious at best. Now, I've been "playing" with FMP for a couple of weeks now. It's relatively simple to use a…

I´m working with Filemaker Pro 8 advanced, the thing is that i have several scripts that use the go to related record script step to do another kind of functions in different related tables, the problem is that when I try to use "set field" to assign some data to a variable in the related child table and error displays and filemaker tells me that "the record can´t be modified because is use in another window"!!! I need to use go to related record and match all the records that apply main table to use them. Help please I´m trying several solutions and nothing.... Thanks Sincerely BluiSh

I've read everything I can find in this forum and others and so far can't find anything that works for me. I need to create a shortcut on a users desktop that will take the user to a specific served file and go directly to the log in dialog. The suggestions I've read and tried, indeed open the file in the server directory but seem to open the file "Outside" of Fmp Server instead of server opening them. I'm hosting only one file and my users are growing weary of having to wait for the dialog, then click on remote, etc. etc. Any Ideas? Thanks, Mel

I'm actually wondering if this has something to do with exchange. Our agency recently went to outlook/exchange and FMP9 worked fine with it (created email in the send mail script like usual). Since last night it appears exchange was slow...now FMP9 appears to go busy for a brief second but creates no new formatted email like before (nothing happens). I'm wondering if this is a known issue (if anyone else has experienced this) or if it is probablly an Exchange server issue (so when that is resolved, FMP9 should be ok creating emails again). Nothing has changed as far as our outlook 2007 settings, etc, etc...but we have been having slow email sends/etc form …

Last year, I created a database using my non-existant Filemaker skills, and committed a cardinal sin...instead of using a portal, I used repeating fields for ordering advertising space. Here is an example of what the record currently looks like: Order ID Client info Media info Run Date (repeater) Ad Size (repeater) Cost (repeater) This would repeat several times, as a lot of space was reserved per media, per month. In other words, if I had ordered 4 ads for the month in The Times, each of those four ads would be repetitions 1-4 for Date, Size, and Cost. As I am now finding out, that causes tons of issues when trying to pull reports. I wou…

Hi everyone, I am trying to write a Filemaker 9 script that accesses a group of text fields that are named with sequential numbers. Example: Item1 Item2 Item3 Is there a way to read data from these fields sequentially by calculating the field names? I was hoping to do something like: TableName::Item$LoopNumber The above doesn't work, however. Is there any way to do this in filemaker? Thanks!

FM 8.5. Is there a way to detect if the layout is in portrait or landscape mode. If so, I would like to use it in a script step for printing.

Can I write a script so that a container field would display a small .gif of an item that is out side of the FMP automatically? It would be based on the product SKU and would link to a folder that would have the item number (1234567.gif) I could do it in HTML but not to sure how to do it here. It could open in a pop up if that's any easier. Thanks for your help. I'm really new to all this.

Hi folks, I'm back to database building after letting my last creation sit tight since FM7. I've had time to figure out what people do and don't like about our database and I'd like to know if I can implement a few things to accommodate them: 1) Is there a way to create a new record or search for existing records by simply clearing and re-writing into a field? For instance, if I have a field for a customer name, I would like to lock existing data against editing and instead treat any attempts to modify the field as a search...if the search produces no results creation of a new record is offered. Is this possible? 2) Back and forward buttons: is SeedCode's "…

Hello, is there a script that will not let a user print a form unless they have field in all of the required fields? Something like when you are ordering an item online and the database will not let you proceed to the next window unless you have filled in mandatory fields, like your first and last name and email address.

I need to duplicate a record a number of times based upon a value in the record (Quantity). There may be 12 records imported, three of which may have a quantity greater than 1. I need to make duplicates of the records with a quantity greater than 1 so I end up with enough copies to equal the original quantity. I hope that makes sense.

I am having a problem with a script I have written to create new invoices in my DB. Everything seems to work fine except that I cannot get the Progress bar window to stay as the focus. As you can see from the attached images, the loop script needs to change to two specified layouts to create the new invoices. When it does that layout grabs the focus. I have tried to use the hide window and minimize window steps but when I do the script breaks and exits. having created only one invoice. All help greatly Appreciated.

I am on FM7 and trying to run a script that will find all records that show "confirmed" on any of 4 different services I offer. Then I want it to only show records from todays date going forward. Right now I have the script Perform Find Sort by date Go To Layout (where I have a report) Can anyone tell me the script to constrain my find and show only confirmed events from todays date forward. I think this should be simple. Any help would be a huge help. THANKS FM FORUMS!

I've had this same problem with several databases and I'm wondering if I'm doing something wrong or if I've stumbled onto a bug in FMP. I'll use my simplest DB to illustrate the problem. I know that the explanation that follows is long, but please, I'm not good at simplifying and I really do need help here. I have a simple DB I use to keep track of my To Do lists and projects. I have separate tables for Projects and ToDos. I have a portal in Projects that I use to actually create my To Dos. While I need to determine what my To Dos are in terms of projects, I determine when to actually perform the task by a category I call "List" (at home, at office, on phone, et…

I have created a run time application & I have a button that opens a layout in preview mode so the user can see the report he will be printing. I can sort, print, etc the new window - but I cannot close it - the close X is not active. The button that opens the new window to display this report is using the script: Freeze Window New Window[Name: "Effects Lising Preview"; Height: 550; Width: 600] Select Window[Name: "Effects Listing Preview"; Current file] Go to Layout ["Listing"(magicvault)] Show/Hide Status Area [Lock;Hide] Sort Records [Restore; no dialog] Enter Preview Mode[] Like i said, on the run time, when I click the button to open t…

I'm trying to write a script that searches for records that match a certain criteria (that's done) Then I want to make a copy of each of those records and change one or two values. I thought I could do this with a loop, but my loop just keeps copying the first record over and over, even though my script says: Go To First Record LOOP Duplicate Record Go To Next Record Exit when hit last record from original search (done with variable) End Loop Why does this keep copying the first record instead of going to the next record and eventually stopping?

I am attempting to import all records from an external SQL database's table and put them in a FileMaker table. The "Import Records" script only worked the first time I ran it. I only had 4 records in the SQL table at the time. Then I added in 5 more records to the SQL table, deleted all the records out of the FileMaker table so as to make it a clean slate, and reran the Import Records script, and it only imports the first 4 records from the SQL table again instead of all 9. I'm at a loss for what could be causing such shenanigans. Any help would be greatly appreciated!

Hello community, I would first of all like to thank you for being of great help in my times of need. However, I must call upon your expertise once more. I would like to know if there is a way to force some sort of prompt when the user wants to close a window. I want to design it in such a way that when the user fills out the fields and tries to close the actual window it will prompt him that he needs to commit the changes first. In other words. Can I program a script action to the "x" in the top right of the window? Thank you much Doubledunk

I'm using an import script to import an Excel spreadsheet. The spreadsheet will have different names so I can't set-up a filepath to it by clicking on the Specify data source checkbox. What I would like to do is to have Excel Files (*.xls) show up as the default in the Files of Type: drop down on the Open File dialogue. The default is FileMaker Files which is confusing for users when the don't see any Excel files until they select Excel Files in the drop down. Just upgraded to FMP Advanced 9.3 from 8 and this is still a problem. Thanks in advance for any insight into getting this working. I've searched the forums and can't find any reference to this. jerry

Hello, With a little help from you guys I was able to start a script to send personalized emails to our customers. I did some reading to be able to do most of what I wanted, but now I'm stuck and I need your help again. Here's the step script I have for now. I want it to send an email, personalized to each recipient (that's going well), insert the date and time when the message was sent (not elegant, but it "works" and to be able to "insert" the body of the message from another table (not going so well). Basically, I want to be able to write the body of the message in a new table under the field eng for English, fra for French etc..., select my script(email eng,…