Script Workspace and Script Triggers

I don’t know how to go about this so here goes! I need to create some graphs based on the data entered into FMP. I thought about a script to open Excel since both are database but I don’t know how to script Excel from my FMP. How should I go about this? I have some basic coding under my belt so maybe even an external script program? Not familiar with apple script but always willing to learn! Thanks for your time!

I have a cut up portal with row 1-4 separate from row 5-8. In a script I want to navigate to row 5 the first row of the second portal. I am unable to accomplish this. It will only go to the first portal that it finds. See attached file. thanks portal.fp7.zip

I've gone through many pages of the forum and also did some searches but I haven't found what I was looking for. My current database which is a Prospect management currently employ a table occurence of itself to show subsidiaries (child companies of the prospect). I would like to know how to create a script that will let me add a second new record while I'm already in the process of adding new one. Prospect.zip

I have a script that export a bunch of HTML tables based on various finds I perform. However, some of my find requests don't come up with any results which causes FileMaker to display the "No records match this of found requests" message. This causes the whole script to stop. Is there anyway to bypass this message or avoid encountering it so that even if one find request doesn't find anything the others can continue and I can get my exported tables? Thanks. -Chris

Could anyone tell me how or if it is possible to... automatically create a record (in another table) when a specific checkbox is checked? :qwery:

Someone, please help me!!! How can I calculate by adding a lot of numbers, recorded in a database, even if those numbers are the time type? I need a script that make this calculation... Thanks.

I've written a script that is supposed to show a time picker for meetings that show in a portal. I'm getting weird behavior.. it seems that this script (attached picture) will only work if I click into the portal row to select the row... if I don't, it will use the previously used portal row. How can I get the script to work on the portal row that the button is in ? thanks everyone :)

Hi folks! I recently purchased FMP8 Advanced upon recommenation of a freind. I started learning database programming on a TI994-A. I know this dates me but "what the hey". I quickly ran that thing out of memory and got myself an IBM PC (Yep the original thing). To make a long story short I worked my way up through Dbase III, IV, Foxbase, Foxpro, Clipper, etc. Then I got away from it for a few years (about 20 or so). Now I find myself wanting to get back into it but I'm afraid the 'ol DOS days are gone for good. In other words I'm Lost. Can anyone recommend the best place to start (other than this forum of course)as far as gaining the education I need. B…

Dears, Please guide me where i can put my own generated quries in File maker pro-8. I want to control the click function In win2K.....

I need to combine a first_name field contents with a last_name field contents into a joined_name field. I have tried a few calculations with poor results, what am I forgetting?

Help us get back to teaching music! We are trying to get rid of Quickbooks and put it all under one roof with Filemaker. Here’s what we have and what we need… Main table layout (for student info) Related table (for monthly charges and payments) in a portal on main table layout. Contains fields for tuition, paid, date paid, student ID (relationship to main table based on this) I need a script that I can run on the 20th of each month that will determine if a student is currently registered by comparing the enroll date with the withdraw date and if today (the day I run the script) is between those two… Create a new charge for the following month dated the 1…

Hi, I have a field value that is calculated. When in a list layout I click a button that changes a parameter used in the calculation of of this field's value, but the field does not show the new value until I scroll down the list to hide it and scroll back to show it. I've tried window refresh and relookup field contents but neither causes the field to repaint its new value.

Hi, I have two related Database's, related by a product code field. In Database A's records I'd like to have a field display whether or not the current record has a related record in Database B. I cannot work out how to do this.

I'm not sure if this is the right forum for this, but as the problem hapens during a script run, I might as well. There are times in a served environment (FM6) when I need to run some replace scripts on a set of records. When this occurs while another using is on one of the records, I get a "cannot modify" halt. Somewhere I ran across a technique for trapping this error and saving the info as to which record was being hung, then proceeding with the rest of the script. Afterward, either the record being locked could be found (key field stored in a global?) or the script would rerun on just the locked record. I searched the forum every which way I could thi…

I'm using FileMaker 4 on Windows You don't want to hear what I have tried, so here is the problem. I have two related databases Courses and Students. From the Courses database I want to print a letter from a found set of students in the Students database. Record_number is the key field. I prepare the letter in the Courses Database with Record_number, First_name and Last_name related fields from Students Database. I find the students that should receive the letter and create a script: Freeze Window Perform Find Request 1 Restore find request Mail List Yes Loop Copy Record_Number Select en…

I'd like a script to do one thing if the option key is pressed, and do something else if it's not pressed. Is there a script step that senses if the option key is pressed ? Hope you all had a nice day yesterday.. turkey eater or not! -)

I have a dispatch solution where a selected driver picks up a member passanger and takes them to a destination. Members and Drivers have dedicated tables. A trip table reflects driver name and passanger name, pick up location, pick-up time, travel distance and charge. New trip record allows for passanger and driver fields input from drop down lists. What I am trying to accomplish is that once a name is selected a script will run that goes to the member file picks up the member ID and then paste it into the fk_membersID field. I have tried to get the data into the field via a portal but can't get it to work so I thought that using a script would be OK.

I was under the understanding that if i did a script step "insert calculated result" into a remote field in a related database, the remote database would create a new record with that related content in it. I can't get this to work. Can someone walk me through this? I used this all the time in FM6, but with FM7, I can't seem to get it to fly.

Is there any way to use a script parameter to specify the target field of a script step? Thanks

Newbie Question: I want to create a new record in a related database and populate its fields with some of the values from the current record displayed. How do I do this, if it's even possible? The ScriptMaker seems very basic. Thanks Graham

Hello.. I am trying to insert username into a field. I tried both 'insert user name' and 'insert by calculation' but can't get it work.. I guess the way i did it is wrong.. Help needed.. Thanks a lot Kelvin =)

Hello, I'm tryig to write a script that reads thu 1 layout (table) and for each record it finds it inserts a record into another layout (table). The tables aren't identical. It is to populate an invoice line-item table prior to the invoice being displayed. The problem I'm getting is that when I switch layouts to insert the record I lose position in my original source layout, and the loop just carries on forever! I've searched through a few FM forums & web pages & can't see an obvious answer (usiing FM Pro 8 Advanced). I'm very new to FM so apologies if this is an obvious answer. Grateful for any help anyone can give. It's driving me nuts!

Here's another bug that appears to only happen in FM8. If looping through portal records, aggregate functions like Count() fail to evaluate if the record is open (like when the cursor is in a field on the portal.) See the attached sample. The problem can be avoided by adding a Commit Record[] step prior to the step count() is used in. : CountTest.fp7.zip

could someone point me in the right direction with a nav log setup

Hi all, I have a paragraph delimited list of values in a single global field. ABC123 ABC234 ABC345 No spaces and a blank line at the end. I am using leftvalues(thatfield ; 1) to take the first value and place it in a newly created key field. The result is 3 new records each with its own value. The problem is that sometimes each field populates normally with the paragraph return being stripped out and other times each value will be followed with a paragraph return. Has anyone seen this?

Hi, i need help... i need to read from a value list i named it department. And e.g. the user select IT dept, this field of mine called HOD will reference from value list and automatically input the HOD person name . e.g. Dept: IT (User just need to select), Head of Dept: Mr Jonathan(Auto input) so its like if GetField(IT) = true, compute Mr Jonathan on field HOD. Sorry im not really gd in script.. help needed.. thanks a lot..

Hello ppl... I wonder if its possible to track all modifications made in my database. I can track the creation date and user, and also de LAST modification date and user, but what I (my boss), really wanted to do is to create the history of each record (The creation, and all modifications, made by who??, and When??) Thanks

Hi. I wish to hide and lock the status window once i browse it, I know how to do it for button but not at startup. How can i do that? Thanks a lot..

I am trying to write a script that will close the program after so many days. In other words the program is only a demo. I found this one but I am having problems with it. If ( IsEmpty ( FirstRunDate ) ) Set Field ( FirstRunDate , Get ( CurrentDate ) ) Else If ( Get ( CurrentDate ) > FirstRunDate + 30 ) Exit Application End If End If I am obviously putting it in wrong. I made a new table called FirstRunDate, because when I write the script an error occurs, "The table cannot be found" I also wrote it as a field. What am I doing wrong? I also do not see how to make it start right when the user opens the program the first time. I hope …

Is there a script that will allow you to change or set a field you wish to display in a table layout? There are 4 variable fields: sort1 sort2 sort3 sort4 One layout asks you to specify fields for the layout variable thus: 'sort1' could equal first_name if selected 'sort2 could equal last_name if selected or 'sort1 could equal phone_number selected. This is basically the same steps as when you are creating the layout and FMP asks you what fields you would like to include. I would like to streamline the process a little within the database.

Here's one for you. I have a table "Orders" and another "OrdersPart" When I create another OrderPart for my Order through a script Freeze Window Set Field[Orders::gOrderID;""] Set Field[NewOrderPart::OrderID;Order::OrderID] Commit Records/Request It creates a new OrderPart that related to the Order Table just fine. But then, in my layout, it contiues to edit the original OrderPart instead of the newly created one. Should I add more to the script? In my layout I have the Orders Table as the destination table(Or whatever you call it when you create the layout and it asks from which table) and the OrdersPart table and tables that are …

here goes: i often need to match a clients bank deposit to multiple invoices. for example, they might deposit $100 which is payment for 4 invoices of $10, $20, $30 and $40 respectively. the only problem is that there might be many other invoices outstanding and i need to use trial and error to find the invoices they have paid. is there a script that will run through all the outstanding invoices for a particular client and then show the combination that matches a set amount. for example, i want to enter the $100 referred to above and then let the script sort through the entries for that client until it finds the invoices that add up to $100. this would be …

I've got a script that's behaving differently in FM8 that it did when I created it in FM7. The problem is with a Set Field[] where the target is a cell in a repeating field and the source is the sum of related values. Only the first repetition gets entered correctly, the other cells are left blank. Trying the Extend() function didn't help. Attached is a sample illustrating the problem (it works in FM7, but not in FM8.) I'm trying to use the repeating field to hold totals of related values to improve the interface speed over the network. Is this a bug, or a feature I missed? :qwery: RepeatingFills.fp7.zip

I am at a loss on this & would appreciate any help. I have a field that offers the user a choice of "names" in the form of Checkboxes. Users can select either 1 or multiples, and the "list" of chosen will differ each time (can have 1 name or 15 names). What I need to do is to use each "name" on the list, one-by-one. I've tried to work with "Word Count", but the "names" have word spaces, hyphens & underscores -- all which seem to trigger FM to see them as word breaks. I've been playing with Left, Middle, & Right -- but have not been successful. Does anyone have any suggestions or methods to use these Names, in a calculation/script, value list, repeat…

Dear all, is it possible to trigger a script (Perform script [...]) based on a current field content? The idea is to have all desired script names in a separate table; based on the entries = names of scripts I would like to * copy that special script name from the table and * pass it over to the Perform Script-Step so that this script step just performs the script which was copied before... Maybe there is a solution based on parameters/variables but I am not able to figure it out.... Any ideas? Brgds Harald

I have a class registration database which has a script (runs daily) that searches for the students for that day and sends them a reminder email. Problem is that the email address that is generated (I'm using the "Get values from every record in found set" button) is separated by semicolons not commas and the emails are not getting to the students. Anyone know how to rectify this problem?

say i have a field with a number such as this [color:red]12748a030827 i already have this being figured out. as far as what it means. like this: [color:blue]Let([ Issue = Middle(MyText;4;2); Alpha = Middle(MyText;6;1); Category = Case(Alpha = "a"; "Automotive"; Alpha = "b"; "Boat"; Alpha = "h"; "Home"; Alpha = "q"; "Internet"; Alpha = "t"; "Truck"; Alpha = "r"; "Bargain"; ""); TextToDisplay = Category & " " & "Ad Issue" & " " & Issue ]; TextToDisplay ) this is not my problem this is my problem every now and again the number will change to something like this [color:red]#240084 well as you can tell this will not work …

I want to set up a button to have a number of selected records either 1) Print, 2) Save to PDF or 3) E-Mail. The Custom Dialog script step only allows 3 options, so if I use all three options, there's no Cancel option. Anyone have any ideas as to how I can offer three choices plus a Cancel option?

Would it be possible to close the custom dialog using a script? Now it seems that the custom dialog pauses the script indefinitely. for instance: .... show custom dialog["task performed"; "this window will close in 3 seconds"] .....close custom dialog??? Kip!

I have a question, but first let me show you the dumbest thing I just did. I should have known it was going to freeze up my pc, but this is what I did: Loop Go To Field [Main::Curr_Time] Set Field [Get(CurrentTime)] End Loop Hahaha. Do not ever do that! Anyway, does anyone know of a good way to get the time displayed in real time (either with seconds or without)? I know there is a clock on windows and why does it matter, but I want to know how...If possible. Thanks

is there a function or a way to determine if a checkbox is selected? I'd like to run two scripts. One is if button is clicked check the specified checkbox from value list, then return a calculated result into specified field. Then script two is a startup script that checks the date in the specified field and if equals current date then deselects the checkbox associated. I am only asking for guidance, not anyone going out of there way and writing a script. What are your thoughts?

Hi, I'm trying to make the color of a field conditional on the value entered in the field. If the value in field "test" is Y then i want the color of the field "test" to be green; if the value is N then I want it to be blue. I have read a number of posts but can't make anything work. I created a global container field gGreen and another one gBlue and formatted one to be green and the other one to be blue. Then I stacked on on top of the other and placed the "test" field on top of both of the container fields. I attempted various ways to put a calculation into the test field but had no success. Help is much appreciated, yknot

Hi all, I'm trying to figure out all the ways a script parameter can be used instead of a global field. Is there any way to use a script parameter instead of a global field when a counter is needed (like in a loop)? Thanks in advance for any input on the subject!

I would like to set a field to multiple values as if I was typing multiple values into a field set field(abbreviation)= "na" "k" "cl" "bun" It will not let me do this any ideas?

Go to Layout [ “Labs” (patients) ] Set Field [ [color:red]Labs::gAbbrev; "na" ] Set Variable [ $c; Value:0 ] Loop Set Variable [ $c; Value:$c+1 ] Go to Field [ Labs 2::DATE COLLECTED ] Set Field [ [color:green]summary::nadate[$c]; Labs 2::DATE COLLECTED ] Set Field [ [color:green]summary::navalue[$c]; Labs 2::RESULTS ] Go to Portal Row [ Select; Next ] Exit Loop If [ $c>2 ] End Loop Go to Layout [ “Summary” (patients) ] This script is working great so far. It sets gabbrev to "na" and performs the task. Now to make it very powerful I want it to change "na" to other values and perform the loop on each of them. the next values…

i have a button that triggers a new window to open at a specified size and location...but when it opens it shrinks the origional window some....how can i keep the origional window full size and still have the second window show at the specified size and local

Hi, I have made a databse which contains file name entries. I would like the file names to be clickable as links. I know how to do this manually for each entry but would like to know if it is possible to do this with a script? Any help is much appreciated!

If I press "cancel" after an "enter preview mode (with pause)" script step, the script stops. Is there any way to get it to perform an if statement. ( I tried : error capture/set global to last error/if global=1 … :but to no effect) thanks for any help

Hi, I am very new with FileMaker. User FM 7 with XP. I am working on a report for Sales. The report need to count the calls made per REP and per day. I do no have problem with the part :per REP. My problems is that I have one table:one main form(flat file) . Now from this stage I have a Button that generates a script to create a report. I have 4 fields containing date. I need to validte each one of them and if the date = Curent date show the record on the report. Can you help!

Is it possible to change the color of a number in a global field via a script calculation? I would like any number that exceeds $50,000 to be seen in red. I looked at the case and let functions but I guess I don't understand them because I can't get it to work. Is this even possible? thanks Arapahoe

I am trying to use SetField to set all but the last 9 words of one field to another. I have tried using Leftwords(Text_Field - 9) didn't work. Then I tried LeftWords(Text_Field;WordCount(Text_Field) - 9) Nope. What am I doing wrong?

Is there any way to pass a field name as a parameter, to use it on a Go to field step? I have 10 different buttons and 10 fields. When the user press each button, a script is run passing the optional parameter. A different parameter is passed with each button. This parameter is a field name. Then, I would like to use this parameter in the script to go to the corresponding field: button1 > field1, button2 > field2, etc. It would save me a lot of scripting because I can use one script for all the buttons. If I can further enhance it and pass the vfield name, then only a couple lines should suffice for many different fields. I was thinking in something l…

...but i had to of mess up somewhere... i have a looping script that goes all the way until a "next record, exit after last" command...it is supposed to cycle through about 10 feilds on each record and if hte script parameter is met it puts a X in that feild....but it only works on the first feild in the record when i know that more feilds met the script parameter any help?

I'm not a wiz on scripting so I was hoping that someone might be able to help me find the solution to my problem. I have a number of records and want to output fields with html coding to format in a specific way. I have been able to export fields so that I get the proper html code by creating fields with html in each record and then exporting them in the proper order along with the data fields. Works great. However, for formatting purposes (look on the web) I only want to include the State field in the first record of each State that I have records for. In other words if I have one record from California I want it to show up... (first record) "CA" + re…

I have a field that holds the retail price of products. Unfortunately the database was poorly designed. The price as well as the unit of measure got entered into the same field, for example, "3.95 EA." Now, I have something like 18,000 records that I need to separate the price from the UM. Is there a script that can be written to automatically separate the number (3.95) from the UM (EA)?

Hi, Does anyone know how I can go about writing a script that sends an automated email to someone everytime a new record is created. Context: The person who prints the membership cards wants an alert on new members to know when to print the cards. Thanks, David

I have a relational database containing artists, songs, records (EP and CD), royalty agreement, sales etc. I'm quite happy with the way it's working, however, I am running into some problems as I try to create some royalties statements, that can show me the total royalties generated per semester for each one of my artist. I guess I should run a script to first select a period (for example 1st of January 2005 until 30 of June 2005), then sort it per artist, and other grouped data etc... But because I would like to be able to control my cashflow whenever I want, I would like to have the option to kind of "simulate" the rapport. Can anybody suggest a usef…

I have 200 records. Each record has different values for example. DC # Store# Style# 10 27 107 10 27 107 10 27 107 10 27 101 10 27 101 10 27 101 10 28 107 10 28 107 10 28 107 10 28 101 10 28 101 10 28 101 10 29 107 10 29 107 10 29 107 10 29 101 10 29 101 10 29 101 10 74 107 10 74 107 10 74 107 10 74 101 10 74 101 10 74 101 10 81 107 10 81 107 10 81 107 I want to create a report using a scrip so that i can print all stores at once, but having all records with store "27" on 1 page, store "28" on another page and so on. Any Ideas. Thank you

I have a script that basically creates a new related record in a table, but before it does that it checks to see if there is not already a "new" record (really incomplete data entry) ... all this works fine however one I go to the layout and create a new record the primary key identifier data is reset to empty and the paste just pastes anything I have in my clipboard... This all worked fine until yesterday... and I can't see why but it goes bad at line 11 1 Set Field [ Participants::Participant_RecordID ] 2 If [ Determinations Incomplete::Determination_Status_FK = "0" ] 3 Show Custom Dialog [ Title: "Invalid Choice"; Message: "An unfinshed determinati…

In the same way that HTML documents can have hyperlinks embedded in text, is there a way to have a hyperlink embedded within the text of a scrolling text field in FM? Conceptually, it would be just like a static button that triggers a script--the only difference being that the "button" is a word or two of underlined text that scrolls along with the rest of the text in the field. Thx.

I have been working on updating a database for a school that I work with. At this stage, entering a new student into the database at any time during the school year has been done by importing the student’s details via an Excel spreadsheet. This is fine if you are entering 1000 students at the start of the school year – but for 1 student, it is very fiddly. I have tried to simplify the addition of one student into the database by adding an “Add Student” button which asks for the student’s firstname, surname, year (via a drop down menu), homeclass (via a drop down menu) and a Student ID number (which can be any unique number). The process involves 2 scripts: NewSt…

I'm trying to open a URL of the following format: http://localhost/~xxx/yyy.html However, when I execute the Open URL script it gives me an error that cannot find the URL. The URL now has two slashes in the name: http://localhost//~xxx/yyy.html What am I doing wrong here? I assume the problem is with the use of the tilde, but is there a way of avoiding the insertion of the extra slash in front of it. I've tried escaping it with a but that doesn't work.

Is there a way to write a script using the Script Parameter Feature so that it will keep current even if you change the name of the layout involved? My script looks like this: Go to Layout [ Get ( ScriptParameter ) ] Script Parameter = "General" However, If I change the layout to "Basic Employee Data", my buttons no longer works because they are still looking for the Layout titled "General" as the Parameter for the script. I did a search of the Forum, and I couldn't find where this was discussed before. TIA Lee

I am fascinated by FileMaker by now, a bit addicted, I guess; and I want to learn more. I can create a script to enter the username in a field to log who is changing what in a DB. Is there a way FM can sense a change in the modification date so that the script I have is automatically triggered?

Hi all, I'd like to know if it's possible to dynamically call out the target field in the SetField [ ] step. Specifically, I want the step to get the target field name from an optional script parameter. Thanks in advance.

The 'recover file' script step will not allow me to open/recover a damaged runtime data file. In fact, all runtime data files are 'grayed out' and can not be opened in the recover file script step. What am I missing? Or am I (and my users) out of luck?

I need to put some text formatting butttons (italic, bold, change color to red) above a text field so that the user can highlight some text then click the button to apply that format to the highlighted text. The TextStyleAdd() and TextColor() functions look promising and also the Get(ActiveSelectionSize) and Get(ActiveSelectionStart). I just don't know how to put them together (if these are indeed the right functions) to get the effect I need. Oh, and I am not talking about inserting HTML codes, but actually changing the look of the text on the screen as if the user had gone up to Format on the menu bar. THANKS.

So I have the following tables & fields: user::memberID roles::memberID, roles::year, roles::status currentRoles::memberID, currentRoles::year, currentRoles::isParticipant, currentRoles::isStaff... and the following relationships roles::memberID = currentRoles::memberID roles::year = currentRoles::year So each user has a roles table for various years. Roles::status contains text, such as "Participant," or something else. What I want to do is move all the roles information into the currentRoles table. Currently, a user will have multiple roles tables if they have multiple status' for the same year. So if a user has two roles tables with year…

I need to generate 3 reports for my case log. I have tried to create the script but it's not doing what I need/ want it to do. I need my report to sort: Assigned Cases, Investigator Assigned and Month - in descending order. Next report should sort: Closed Cases, Investigator Assigned and Month - in descending order Finally the last report I need it so show me: Open Cases, Investigators and Month.

I just had a problem with a script going into an infinite loop because there was a related field being accessed as the script was processing local records. It just so happened that a required field was empty because it was created before I put in the validation. The script kept on looping, but it never showed me the validation error box until after I started debugging, and even then I had to actually click off of the debug window to try and look at the data before it showed me the error. It shouldnt happen with new data because the users can't leave the field blank. But there still might be a few records that are blank. Is there a way to bypass field validation when…

I am developing a database where I will be importing virtually thousands of records from an excel spread sheed sheet on a daily basis. The core data (because of the automated system it is pulled from) will sometimes have erroneous information that I would like filtered out of FMP database. Is there a script I can write that will filter through all records and then "auto delete a record" if a value in a field is Greater than "X" If so, is this something that I can run automatically after/or during the data import, or is the only way to "click" a button to activate a looping script after the import is complete? Oh...And as long as I am asking for the sky…

I have a field that is next to a button performing a script related to whatever is entered in the field. When you hit the return key after entering the script the text goes down one line. I would like to run the button script rather than returning one line. Is there a way to do that?

I would like to use the field name in a calculation. the Get(Active...) only displys information when the cusrsor is in the field. I would like the information displayed all of the time. Example... The field name is D101 Case (MoveSample::From="D101";TextColor("FROM";RGB(255;0;0)); MoveSample::To="D101";TextColor("TO";RGB(0;255;0))) I would like to copy this field many times and only change the name of the field... not the calculation.

Hi all friends can someone explain me this new function of FM8 ? Also , with event script, can I fire a script and have this result in the calc field ? Something like: S4HU_EventScript( Get(FileName) ; "MyScript" ;"")& Get(scriptResult) If it's possible, can you make an example for me ?

I would like to take a field that contains free flowing text (Notes) populate another field with a Date and Time stamp each time when text is entered into the field. Thanks

Hi Gang, I recall seeing a plugin that allowed you to enter text in a field that filtered the database by that search as you typed. For example I want to search for an item called "Hello". I want my item list to first show all items. If I type the letter "H" in a field, the list would only show all "H" items. If I then type "e" then all "He" items show up...and so on. I recall seeing this plugin on a web site, but now for the life of me, I cannot find it. Can anyone help? Many thanks, Nando

Hello All! Ok, I have a script that would import a credit report, and parse it's contents into my database. In FM7, I used a substitute function to get rid of specific CR characters in the HTML that would show up as a little box. It worked for a while in FM8, Until I started editing. I had to make a change in the script, and when I saved it, it changed the little box into a regular CR, no box. I couldn't do anything to get it back. 3 hours on this. For this issue, I have a work around. WORKAROUND: Open the database in FM7, and copy the text back the way it was, and never touch the script again! I would like to know how to fix this issue without…

I have an date field that I want to be able to add a number of days to it. I want to be able to add 20 days to a date field. What kind of script would be used here to accomplish this? I tried adding the number straight to the date field and set the calulcation to return as a date and get some really weird results. There must be an easy way to add to a date field. Thanks in advance, Coffee.

I would like to script a process by which I save multiple copies of the same file. But I would like each file to save a specific found set - a subset of the records in the file No problem with the Find, the loop, the dynamic filename and path. My particular issue: Is there a good way to do a "Save a Copy As..." with only the FOUND SET of records, without the need for a clone file and doing a bunch of imports? Thank you in advance for your thoughts. DSW

I am writing a database where sales people on the road will be able to sign in via terminal services and enter a sales order. Is there a way that after a sales order is created that FMP can be scripted to send a "canned" e-mail message (Preferrably containing Order number)to customer service notifying them that a new sales order has been entered? Any ideas, thank you, Steve

Hi, I've declared some fields as auto-enter (with a calculation, replacing set to yes). I want to force the refresh of the auto-enter calculation. In FM6, I think, I was able to do it with relookup, but I doesn't seems to work anymore. I've found out that you can use eplace fileds by themselves but you have to do it fo each field. So If you have 15 fields, Filemaker will loop 15 times ! I'm looking for a solution that would make Filemaker to scan only one time the records (1 loop). I know I could use Loops with multiple set fields but thats too slow Thanks

can someone hook me up with some script steps tp opne up a pdf on the click of a button please

In version 6 I was able to do the following: In file A have a script that runs a script in File B. The script in File B gets records, goes to a screen and let's you see the screen in File B. In version 7 it always goes back to File A (where the script in File B was started from) so I can't see my records from File B. Does the question make any sense? Any help?

Hi there, Here is my problem. I got 15 records that I want to duplicate using a loop script. See my script: Go to Record/Request/Page(First) Loop Duplicate Record/Request Go to Record/Request/Page(Exit after last, Next) End Loop Go to Record/Request/Page(First) The result is one duplicate only. What should I do get 15 new records?

I'm using FM 6 in Windows. I have run into another situation I can’t seem to resolve. In the following calculation, I need to add another argument. My customer informs me that the following calculation is including jobs that have been finished. She wants me to fix it so no projects that have been finished appear in the list. Where do I put in this calculation that if “Finished” is valid, no calculation should be made for that record. The fields "Total Jacket Cost" and "CC Total Jacket Cost" in the calculation are in a related database. “Finished” and “Est. Cost” is in the parent database Case( IsEmpty(Est. Cost),"" , (Main to Action by Jacket…

Purpose of script: Make sure an important document (Deposit List) prints properly before continuing. Custom Dialog presents three options: Yes No Cancel. Script should exit loop on Yes, loop back to print again on No or Halt on Cancel. Script won't exit loop on Yes; it loops again instead like it doesn't see the Exit Loop If [ ]. Allow User Abort [ Off ] Loop Set Error Capture [ On ] Print [ ] Show Custom Dialog [ Yes ; No ; Cancel Print ; "Did Deposit List print correctly?" ] If [ Get(LastMessageChoice) = 3 ] [color:blue](Cancel print) Halt Script Exit Loop If [ Get(LastMessageChoice) = 1 ] [color:blue](exit loop) End If End Loop Script…

Hello gang. I'm having a problem trying to build this model. Thought it thru and maybe am blocked because I've "overthought" it. Anyway, here is the scenario: The Environment: 1) Many records and many fields of data. 2) A Radio Button based STATUS field which shows CURRENT, RESCINDED and CANCELLED. 3) Two CSV files, one named RESC and one named CANX. === What I need to do: Update the STATUS field from CURRENT to RESCINDED using data from the "RESC" CSV file, while also being able to update the same STATUS field from CURRENT *or* RESCINDED to CANCELLED using data from the "CANX" CSV file. How: Within either CSV file, there are three fields…

For a solution which requires strict complaince with the Data Protection Act I require all records which are 5years older or greater to be deleted automatically when a script is activited. I need Filemaker to calculate 5years or greater to the DAY not simply just 5 YEARS old going by the year The script I have been playing about with looks a bit like: Get ( CurrentDate ) < Client::created_date - Year ( 5) Delete Record/Request [No Dialog] End If Obviously this script doesn't stand a chance but I am getting desperate!

If I have a script that needs to address field1, field2, field3, field4 (all numbered sequentially) can I have the script act on those fields using a scriptparamter ? so.. to address the first field, i would set scriptparameter=1 then in the script: if ( table::field&get(scriptparameter) = 4; "") if not that way, is there some way to achieve this ? also.. could I address repetitions of a repeating field with a script parameter if(table::repeatingfield[get(scriptparatmer)])=4 ; "" ??

I originally posted in the File Definition Forum and they suggested this is more of a scripting thing. I have 50 records in File A. Each record has a number of fields. (Call them Field X, Field Y, Field Z, etc.) I am attempting to build File B that will contain a single field (Field XX) that will contain the information from multiple fields in File A. However, I am trying to do this in this manner. File B - Field XX: 1st 50 records = info from File A - Field X 2nd 50 records = info from File A - Field Y 3rd 50 records = info from File A - Field Z. Total records in File B will be 50 x (Number of fields in File A). Is this possible?

How can I lock a record if Field "Audit" is set to 1? Thanks

Ok here is somethign i wanted to do, the old way and the way my work will import information as how ads run in their books. is formated like this 12748a02020303030306060606 1 meaning year 27 meaning volume 48 meaning issue a meaning automotive then the fun part 02 02 would mean that there was 2 full page ads in a certain edition 03 03 03 03 would mean 4 full page ads in a certain edition 06 06 06 06 would mean 4 full page ads in a certain edition well here is what i want to do. say 03 represented monmouth edition id like it that when this moves over to the invoice part. that it tells the customer what they are actually paying for like it woul…

Hello, Post# 179936 on 10/20/05 talked about concatenating two fields when copying between tables. This post and its replies almost got me to a solution to a similar problem. Maybe someone has information more specific to this situation. Within my file I have a table labeled 'contacts' and a table labeled 'outreach'. Records in the contacts table represent unique individuals. Records within the outreach table represent interactions between my firm and individuals in the contacts table. My challenge is: I want to be able to perform a find in the contacts table, then create a new record in the outreach table for every member of that found set. Certain fields …

So, I have built a new solution in Filemaker 8, complete with tabs and tooltips. We are on a large network and have a mix aof fm-7 and fm-8 clients. I have been working on a script that runs at database startup to check the verison of filemaker so if I get a FM-7 client opeing up the FM-8 built solution they won't call tech support to complain about it not looking right. I have not had too much luck, and I was curious if anyone has any advice or pitfalls to this approach. Thanks, Jesse

Is it possible to send a record using the send mail script step. I would like to be able to include it in the body of the message instead of attaching the record as a .pdf.

right now i have 2 databases setup called Contact Type and Deleted Contact Type. What I want to do is when a record is deleted from the Contact Type database I want to record it into the Deleted Contact Type database (for recovery purposes, if needed). The only way I've been able to come up with doing this is when the Delete button is pressed, doing a find and exporting the record to a file, then deleting the record and going to the Deleted Contact Type and importing the file. I know there has to be an easier and more effiecent way of doing this. Anyone have any suggestions?

:bang: why in the efing world would a script step as basic as sort by date in descending order mess up at the end of my script i have a sort by a date feild in descending order....and it doesn't why not image :soap:

I am using FM 6 and would like to automatically have a barcode inserted into each record. So far the Id is automatically generated and so is the barcode number. For example if the ID is 72 the barcode is MC0000072. This barcode number relates to the number on a picture file of the barcode stored in a folder on my Hard drive. The codes are name int his manner - Code-128-MC0000072. How would i write a script so that as soon as the barcode number is generated it finds the matching code and inserts it into the relevant container. At the moment I am doing this by hand which is very time consuming as i have hundreds of records to do each week. Thanks.. Jules

I have a report card database for 6 schools - the Report Card (RC) ID is slightly different for each school - A-RC0506-1, C-RC0506-1, etc. (The first letter of the RC ID is based on the first letter of the respective school.) How do I set conditions in an "Add a New Record" script that auto enters the RC ID based on the last record for that specific school? For example, the Day School has 403 records, each RC ID increases by 1, so the last record is D-RC0506-403. How do I write the new record request for adding a new student for the Day School comes in at D-0506-404? Is it defined in the RC field as a calculated field, or is it defined at the "New Record Request…

I was running this script yesterday, and I could have sworn it was working... now it doesn't. Show All Records Go to Record/Request/Page {First} Loop If [isEmpty {Comic::Notes}] Omit Record End If Go to Record/Request/Page {Next; Exit after last} End Loop Show Omitted Only I want it to find & display all records where Comic::Notes is empty, but it doesn't seem to find everything, and occasionally finds things it shouldn't. Any ideas?