Script Workspace and Script Triggers

I wish to script the pasting of a value into the next blank repetition in a repeating field. I could find not a specific function to allow this and have constructed a complex workaroud...though it works, it seems there must be an easier way! What I did: 1. Created a calc to return the number of the next empty repetition by adding "1" to the result of the function that returns the repetition number of the last populated field. 2. Created a series of "IF" "End IF" loops: IF the value of the above calc is 1, paste in repetition 1. IF the value of the above is 2, paste in repetition 2.....and so on until I reached the number of possible repeats. Any Ideas?

I am trying to write a script that does the following: 1. Filemaker searches through about 4,000 records and returns x number of unique alphanumeric category numbers that are contained within the same field on each record. (This is as far as I have gotten). 2. Filemaker then uses this criteria to perform several searches. But it must print out each the results of each criteria search before moving on to the next search. The script needs to be set up in such a way so that as new categories are added, I don't have to go back and redefine the script. To give a little more background, the database is a collection of photographs archived according to a catalog…

filemaker 5.5 (windows and mac os x) i have an image database which has a field for pathname... the images are saved on a shared volume... since I imported the images in windows...the pathnames are saved as computernameshareddocspicfolderpic1.jpg then...if the user wants to access the file...i have created a go to url script... however, if the user is on a mac...they cannot go to url cause the path is different..is there a way to change the pathname to the mac format automatically? i have 2,000 + images... i have to change the format to file:///localhost/volume/shareddocs/picfolder/pic1.jpg and i'm not quite sure how to s…

If you are get this message on opening the file. Take a look at the preferences and see if a script has been assigned as a startup script. -bd

has anyone else run into this issue? even if, on the 10.2 client machine, I choose page setup, choose say landscape, then go to the script and "replace" the page setup step to freeze the preference, when the script is run again the preference is lost... works fine in OSX 10.1.5 and earlier, and on classic Macs

Presume you have a field "foo" defined to use a Popup List, but NOT to allow entry... If you setup a button that performs a script that first does Exit Record/Request, and then does Go to Field "foo", then it will popup the list. Cool. If you try to avoid the need for the script by just having the button do Go to Field "foo", it no longer pops up the list. Darn. Why not? Bonus: If you leave the button performing the script, but instead change the field to where it is a popup *menu* rather than popup *list*, then the Go to Field doesn't manage to pop it up. Why not? FWIW, I am trying to implement OSX-style popup menu fields. Thanks for any enl…

I am trying to write a script that will find all records that do not have an empty start date field. Is there a special character or function that I can use to indicate not empty or null and be able to use it as a find criteria? I want the records that have an entry for a particular start date to show up on a specific layout. I just can't remember how to do this. Thanks, John

Hi, I've 5 fields(repeating fields,column) in my db. The problem I've is I can't copy all the fields at one go.(I want to copy the whole row at one go) Currenty I need to go to every fields to copy one by one to another file. I've written script to copy but the script only works for the first record.

Good afternoon - I am creating a recurring invoicing system on FMP 5.5 and OS 9 & X. I have some scripts that "post" my data out to another piece of software and also print an invoice for the customer. More times then not - when I run this script the LineItems portal will magically clear itself. There are no script steps that have it clear this information - it just does this every once in a while. Does anyone - have any clues to as why this is happening? Thanks for your help

I am running a database for a short time. Now I get this message. Is there a clear cause or do you need more info? The previous script step "Sort" could not be completed because it restores an invalid request. Do you wish to continue with this script? Thanks

I'm looking for the"best" way to maintain my inventory count. I am developing a POS system for my retail store. I have an inventory db as well as a line item db for individual sales. What is the best approach to update the quantity in the inventory db from the line item quantity sold? Thanks!

hi all, i'm trying to set up a script that will create a new record in a data base that is related to the one that is performing the script and sets up the value of one of the fields of the newly created record to a randome number... the fields of the remote database are displayed in a portal in the database that will perform the script... how do i do that? thanks

Hi, I'm not a pro with FM scripting and i need help!! My boss asked me to create a db that would contain time sheets for the employees. I want each employee to see only there own time sheet. I have a "login screen" where I prompt the user for his name and a password and then with a botton, I check it against another db that only contains names and password. If everything match I want to search for the user records. Maybe it is simple but it's not working. Every time I give a name and a valid password, when I press the search botton, I get a message that my search field is empty... or something like that (the message is in french!) I would like to give…

In windows, when starting an FMP application, is there a way to get FMP to read the Window's registered user name as stored in the registry, or the computer's network name? Thank you.

I have been using fmp for about 6 months now and am slowly getting the hang of basic scripts but i now wish to use filemaker for my letters out and faxes. My wish is to set up a blank letter and blank fax - i would like to set up a selection of standard letters and faxes that i could then choose which was required and copy the appropriate text into the blank fax/letter and edit as required. I this something that someone can help me with or do i need to get a professional in to help me?

Is there a way to keep a script button from performing the script on all records? I have a script to insert text in one field based on the number contained in another field. There are often exceptions that I change manually. When I add new records and run the script, it overrides changes I've made to previous records. Is there a way to stop this, or do I need to always run the script in found sets? hope this makes sense! thanks

I have a multi platform, multi user database system which is menu driven... it has a file for phone messages, timesheets, purchase sheets, calendar, etc. the employees now want me to devise a back button so no matter where they are, they can press back and go back tot he layout they had just come from... The problem is that there are about 15 files with relationships....and I don't know where to begin to create a back button... thanks gary

Upon migrating a working system to a new FM Server 5.5 running on a Win2000 PC, from a FM Server 5 on a G3, the scripts seem to be running too quickly to populate the fields before moving on to their next task. It is almost as though it is happening too fast - we have put in a temporary solution which is to Flush cache to disk and pause steps throughout the scripts (they are heavily nested) which seems to have helped, but not in all cases. This is especially a problem when a new record is required. I would love to know if anyone else has come across anything similar (I have worked with FM for some time and never needed to slow things up before) and if so what you…

Hi to all, how can I tell FileMaker or Applescript to wait until a AppleScript "do script" subroutine is finished? If it runs alone it`s perfect, integrated into a FileMaker script, FileMaker executes the next commands without waiting for the "do script"-routine to be finished. Any suggestions?? Thanks!

Here's my problem, hopefully someone out there has some insight. I have 3 tables, one called Paginator, one called Gaps, and one called Ads. Each entry in ads has a measurement, and I'm trying to fit a number of those ads into a Gap, which has a larger measurement. Basically, the script I'm using looks at the space left in each Gap and finds the best Ad to fill that space. So here's my problem. I'm trying to test the length of an ad against the space left in a gap, to see if the ad is a candidate for insertion. The problem is, that when I've already inserted two other ads, the length stops updating, to reflect the space filled by the ads it already holds. The ca…

I have two different databases which exchange information between each other (scheduler and a mail database). Via the Mail database you can schedule a task in the scheduler which is related via an ID in the mail database and the scheduler. When a new task is made in the scheduler with the help of a record in the mail database I want to enter the following in the notes field in the scheduler: This task is related with the following mail: Date: 21 august 2002 Subject: order of 19 august 2002 Sender: Trinkets & Co Everything is passed nicely via a script to the scheduler. But everything is written on one line: This task is related with the following mail…

i've got an image database for multi-users..cross platform...(fmpro 5.5, windows xp, mac os x) I thought i would create a step for users to easily locate and open and manipulate the actual image they want to work on by having a button that opens the url of the image on my shared windows drive...and then save the image to their computer... it works fine on windows...but the open url does not work on mac... Does anyone know how to access from windows shared drive on the mac via web browser... I have mounted the drive on the mac desktop...i have tried typing in the ip address in the web browser address window rather than the shared drive name...as well as oth…

Hello, I am brand new to FM, I started learning this morning. I love the program because I have come a long way toward building exactly the database that I want, but I have a couple of questions. 1. When each record is entered into the db in a table view, one of two radio options is selected. I want to add the records with one of the options checked to another layout, excluding the records with the other option checked. I have no idea how to accomplish this. 2. Each name in the db has several records associated with it. I want to display a list which includes all of the associated records at the bottom of the page so I can quickly move from one record to th…

Hi I got two fields: Date 1 is a calc field (Creation date + 180), result is date. And Date 2 is also a calc field (Today), result is date. I created this script to get the list of expired dates: If (Date 1 > Date 2) Show omitted End if But something's wrong. Any help would be appreciated.

Working on an app and client threw a wrinkle at us (go figure). Now wants app to loop each time a user runs their barcode ID (ie read ID, log ID, process various scripts (ie debit accounts, identify and log transaction,etc.), loop back and ready to read next ID. But of course, they want to do this unaided by a human (ie no hitting "new record" on the touch screen). They wish to basically toggle the feature on, let the system loop, then turn it off again and process the balance manually as normal and originally designed. Asterisk's (barcode start/stop control characters) are not captured during a scan, so looping based on 2nd asterisk is out. ID's apparently are not …

i am creating a time sheet db with a new user function for people to add them selves to the datebase. i am trying to make sure that the new user is not in the database, i am currently using a pattern count on a value list items function to make sure the new name is not in the list. but i have found that if the user enters a part of an existing name it find it and wont allow the new user name, so when a user called Ed tries to enter his name and there is already a Ted present it returns a 1 and my script rejects the name (should of seen that coming really) so my question is this is there any way of a making a pattern count that is absolute and will only return a…

Using a script, how do I use Filemakers auto update plugin to pull over a fp5 file?

I am unable to copy and paste in Scriptmaker. Scripting would be much quicker and more accurate if this were possible. Am I overlooking something? Mac OS X 10.1.5 FileMaker 5.5 Thanks, dp

Help. What am I doing wrong here? I wrote a script that takes a user to a specific layout based on matching text from a specific field: If field x = "layout 1" goto "layout 1" If field x = "layout 2" goto "layout 2" If field x = "layout 3" goto "layout 3" etc. The problem I'm having is that I want to add a line in the script that takes a user to a "Home Layout" if the contents of this specific field don't match any of the criteria: if field x (is not equal) to "layout 1" or "layout 2# or "layout 3" then goto "layout home" I'm sure this is a syntax problem but I'm just not getting it.

I have a script that is originally called from another related file. Job_hdr has a button that calls an external script in Job_items. This button performs a find on the child records and prints a report. I want to display a message box that no records were found and the user be taken back to the originating form. I have the following code in the external script: Set Error capture [on] Allow user abort [off] Print setup [restore, no dialog] goto layout ["commission report"] perform find [Restore] If["Status(currenterror)=401"] showmessage["There are no records to print"] Open["Job_Hdr.fp5"] Halt script EndIf Sort [Restore,No dialog] …

Hello All, I am in the habit of creating a small database file with no fields and 1 script with the goal of opening a hosted solution. The script is simple: ToggleWindow (Hide) Open (database.fp5 xxx.xxx.xxx.xxx) Close (opening database) Set this script to run at opening. This seems to work well, for a time... I can't seem to figure out what causes the file to fail. When it does fail, opening the script results only in the application opening and a brief attempt to locate the hosted database. Its a catch-22, because as soon as this file stops working, you can't troubleshoot it because the script runs at start up and when it fails to ope…

I have a unique problem. Well at least I haven't seen anything posted like this. I have a Start-up script that opens 5 related DB's on a Apple G4 500Mhz sever running FileMaker Server. The script used to work great (befor we started using Mac Manager). We just installed a complete new network that added 2 OS X servers and run Macintosh Manager on the network for file level security and permissions. All of the computers used to access FMP are running OS 9.2.1 or 9.2.2. FileMaker Pro 5.5 runs fine with Macintosh Manager. All of the files on the FM server are set to multi-user and if I use the open command and the Hosts button I can get to the DBs. However, when I double …

I posted this message in the Portal Forum, but must be stay in this forum. Tks Saludos Hi every body... Maybe this question is so easy, but please I need your help. Ok, How can I create many fields in a portal from a payment field, with just a click? For example: In my DB I have a option to create the payments, in this layout I have a field (num_payment) in this field the user indicates the payments for a patient (i.e. 10), ok, how can I create the 10 records in the portal just with a click (I think this should be a script), but in this Portal I have a date field, how can I make the 10 records with a month of difference between them. I ho…

The post office has sent a list of corrected addresses from a tab delimited file I sent them. They put the zip and zip+4 in the same field (now 9 digits long). Can I design a field or script that will take the last 4 digits out of the first field and put them in the second field? Maxwell Morlay

i have a relationship between customers and customer products. for customer abc i want to copy all their products to customer bcd. any help would be appreciated.

Hey guys, I'm new here, so go easy I haven't used filemaker before, but my co-worker has. Unfortunately, he's a-wall, and we have to finish a project this week. Here's the deal: We have created a filemaker database that is going to be self contained, and burned onto CD's to be handed out to a group of people. The application will run locally on the user's computer, and when they're done filling in the entries, they hit a button, (while connected to the internet) and it uploads all the data to a master database on our server. Now, we have the interface, and it collects the data, but the part that is incomplete (which we're stumped) is how to get the local appli…

Without an EOF or a Loop...Until construction or a For loop, I am unsure as to how to create a script so that it runs until it has applied it's results to each & every record in the db. Any help would be appreciated. TIA, KC

I have databases containing students' responses to test items. Each record in the databases corresponds to a student. 40 of the fields in each database correspond to test items. The values in these text fields are "correct" or "incorrect." How can I programmatically count each student's number of correct items on the test? In other words, I want to count within records, not between, the total number of correct items. Many thanks in advance for any pointers!

This is a long desciption, hope I am not pushing the system, here goes... I have a text field that gets populated with "items" - text that are delimited (in the field) with comma and a space (due to screen space issues). As these items build up for each record, I then want to press a button to look at the related records for this field and take all the items, make them into a check box list so that previous items across all the related records can be selected, then take these selected items back to the original field delimited as above. I have done this using a self relationship, replacing the comma and space with a return then displaying this field as checkbo…

Dear Gurus and all users, I need to recognize users’ passwords as they log in to the database working on a one single computer. So I have few users and one single PC. Depending who logged in I want to perform a certain action – like automatic signature. It is easy in programming languages, but how can I do that in FileMaker? Appreciate your support, Robert

Topic says it all! I stumbled across this a couple months ago when I was fixing up some old database, the find button kept on restoreing an old request; after a bit, i found there was 2 "find" scripts. @$^#@!

Any recommendations for a plug-in to parse info from a web page? Thanks -j

I have not tried this before, but I have need for a user to import a picture from their computer. This pic will become part of their record. How do I address the picture size and import. I am new and am having trouble beginning this. Thanks in Advance

hi all Have a condition on a script that is acting a little funny. The script is written as follow: Case[fillet<"4.5",".750",fillet="4.5","1","Unlimited"] this works fine when fillet is 6.625 or 8 but not when fillet is 10 or 22 or 30 or when the first number is not smaller than 4. what am i doing wrong. thanks in advance oilman

hi there i have a radio buttom with to options. I want to set it up such that clicking one of the options will add the current date into a seperate field, where as clicking the other will not. Im having trouble getting my head round how i should assemble the script. can anyone help?

Hello All, I am rather new to filemaker 6, and I am trying to use web companion to publish a simple database. The problem I am having is that every record is associated with an PDF file, and I would like a button to open that file in a browser. My question is 1. Where should the PDF files be kept? I have tried putting them in the web directory, and referencing it with http://xxx.xxx.xxx.xxx/blah.pdf or http://xxx.xxx.xxx.xxx/web/blah.pdf and neither of them work from the web. The first one seems to work fine within the FM6 program tho. 2. Is there an elegant solution where i can just have a field with the name of the PDF, and then click a button to launch it (aga…

I'm sure there must be an easy way to do it, but I can't find it! When a new record is created thru Web Companion, I want FM to automaticly (without me pushing a button) send an eMail. Is there an "On New Record" command? Some other work around? Thank you!

Hi experts, I am trying to do a sync with a Filemaker file which is hosted in a Filemaker Server. When I tried to do a sync with that file I could not get the file in my palm. It means it is impossible to sync with a Filemaker file which is hosted in the server? I tried to click on the FM Mobile Plugin settings by going to File-->Sharing I got the error message "You do not have proper access previleges". Please shed some lights on this. Thanks a lot. Hameed

I have a layout with 6 buttons. Each button's script contains a conditional statement that if not met displays a message with a specified duration that varies from 3 to 10 seconds. The message is displayed in a text field, not as a dialog box. It works just fine EXCEPT if someone is finger happy and clicks on one of the other buttons before the specified duration for the first click is completed the script hangs up and requires the user's intervention by clicking on the script "Continue" button which is unacceptable since the status area will not be accessible to the user. Freezing the window when the script starts doesn't help and I don't want to use a "Click here t…

I am looking for a script method to deny field modification based upon the user's scripted pasword level. I know I can do this with the standard FM password system (groups/passwords), but my db uses a scripted pwd system (because of the type of users and security). In short if a user scripted pwd level = "viewer" then view only, no additionals, deletions or field modifications. Any Ideas? Thx

Does anyone have a script that compares an ID field in two or more open databases (unrelated) and flags those records that have a common ID value between the databases? In other words, Mary Smith has a record in Database 1 and in Database 2. I would want to put an X in a "flag" field in her record in both databases. Susie Jones has a record only in Database 1. I would not want to put an X in the "flag" field in her record. Thanks in advance.

Hello all, I am trying to write a script that navigates from 1 file to another file. I have 3 different files and I want a script in two of the files to go to the 3rd and maximize the window. So here is what I did: In the 3 rd file I wrote a script that toggle(restore) and then toggle(maximize). In the other two files I wrote a script that performs an external script(the script in the 3rd file). This works perfectly for one of the files. The other file minimizes itself and then switches to the 3 rd file but does not maximize the window. Both of the scripts in both files are identical. I don't understand why one would work and the other wouldn't. Any ideas? …

Recently there were some posts re: changing the text of a button by a script. The suggestions related to the use of a field vs actual text label. I want the reverse. I have two screens w/ roughly 50 buttons each. Each is to launch a script (preferrably the same script) that pastes a value into a field. The "value" I want to use is the button label. Other fields perform lookups based on the contents of this field. The button labels may change from time to time, so IF the text label can be used, the user can be kept from having to edit one of 100 auto-enter fields and/or 100 hardcoded scripts inserting text. Any ideas?

i have a timesheet program that has (among other fields) a value list field for start time and a value list field for end time... each employee must enter their time for each client and enter start and end times for per record... is there a way to copy the end time from the previous record into the start time of the new record so the employee doesn't have to enter the start time for each new record? thanks

Is it possible just to write a script that checks that for every unique id in one db, there is a record created using that unique id in another? I just don't know the logic without being able to use a FOR loop or a WHERE clause. And I don't want to have to rely on user input. It would be super cool if the script would automatically run everytime that either db was opened or if a change was made to either. TIA, KC

Hi experts, I have read in the filmaker.com website that I could export records into a formatted excel spreadsheet. I received a request from my client for this kind of excel export. But I do not have any idea about how to accomplish this. Can anybody share your experience if you have succesfully accomplished this already? Thank you all in advance. Hameed

I have a 2 db solution setup. Art db and Supplier db. I open up with Art db in form view and want to move to Supplier into list view. Easily done. When Supplier opens I want it sorted to field "Supplier Name". It defaults to sorting by field Supplier ID(my primary key). So, I make a script, Page_Setup. Script is simple. Page Setup (restore, no dialog) Sort (restore, no dialog) When I make a button for this script it works perfectly. Proceeds to sort by Supplier Name. However, when I set Document Preferences for 'When opening "Supplier" perform script Page_Setup' it doesn't work. Its the same script. Works on button but doesn't work on open. …

Sorry to bring this topic up again, but I seem to have a problem that no-one else has experienced? The same scenario, I have a field which uses a value list displayed via a pop up MENU. A script is attached to the field, which is intended to transport you to another layout based upon the choice. The script is as follows: Goto Field 'Pop Up' Pause/Resume If ["Pop Up" = "A"] Goto Layout ["Layout A"] Else If ["Pop Up" = "B"] Goto Layout ["Layout B"] End If End If The problem is:- When using a pop up MENU (On the Mac), the user has to click the field/button twice to get the menu to appear in order to make a choice. I can get the same script …

i'd like to strip tab characters from a text field. i thought the easiest way to do this would be: Set Field ["textfield", "Substitute (textfield, "tabchar", "")"] but i can't see how to insert the tab character into the above formula. is there a way to do this in native FM, rather than 'export text - process in text program - import'.

I apologize if this is a repeated topic - I have searched the archives and could not find an exact solution for my seemingly simple needs. Building an elaborate contact database - elaborate only in the sense that there are lots and lots of fields per contact. I have a Reminder Date field where a user inputs a date for a follow up phone call or email. Right now, I have a simple script running every time the database is opened - if today > reminder date then displays a reminder message. How can I have it IMMEDIATELY upon opening display or go to the record(s) (contact person) that needs to be contacted? I would think this is a simple task that is escap…

Hi everyone, I would like to create a script that would automatically take the user to a new layout when they select a certain value from a pop-up list. For example if they choose "Summary Data" from a pop-up list, FM would open the "SumData" Layout for further data entry. From what I've been reading here in the forum it seems that I may need a plug-in to do this. Does anyone have any other solutions? Thanks in advance, Kel

I have many people who use our Filemaker forms. I have set up a reply script using a text calc, but the problem I am having is that the text is not capitol like in filemaker. I have title text on but copying text doesnt preserve that. Example: Mrs. smith, How do I make this Mrs. Smith.

Hi there, I work for a recruitment company and we have a database of around 3000 candidates. Currently, when a candidate is registered on to the database, a registration number is generated. This corresponds to a MS word file with CV documents named the same. My question is; Is it possible to have a button on the database (each individual record) which, when pressed would open up a word document? If so, how could it be possible for this button to open up the corresponding CV? Any help would really be appreciated. Thanks in advance. Mark

I posted this question earlier and I thought I had come up with a solution for it but it isn't working. So I will try to explain what I am doing. We have 8 different dbs with one of them being an index db that only contains links to the other dbs. The 8 dbs contain different forms that our Human Resources uses (Ex. Termination, Promotions, New Employee...). What they want to be able to do is have a search button on the index db that will allow them to search the other 8 dbs to see if an employee has a record created in any of the dbs. If they do, then they would like to be able to see which dbs the employee is in. I tried writing a script that would copy the emp…

Does anyone know where I can get more information on Activator ? I have the manual provided with it but would like some examples of how to program using it.

I've been searching the forums and haven't found an answer to my question, so if it

I am trying to dynamically populate a repeating field. How do I insert values into the 2nd instance of the repeating field, 3rd and so on? I know I read how to do this somewhere but I can find it again. Thanks, John

I am trying to come up with a script that will look to see if a record has been created for an employee in 6 different dbs. If there is a record for the employee in any of the dbs, I need to know where it is. The databases are not related. There isn't any direct relationships. I may have to end up creating them to accomplish this. Is there a way to send a field value to a file that is not related? Here is what I think I need to do in order to accomplish this: In the main file, create a script that will call sub scripts within each of the 6 files. It somehow needs to pass the field value to each of the files. Then within the files I will run a search script. …

Can file maker do several sub reports on one report - not sub summaries?

Is it possible to do SubReports in FM?

I guess I should start by saying that I have VERY little programming experience, but am trying to design a database to help me keep track of veterinary radiation therapy and chemotherapy treatments. I have a chemotherapy treatment sheet that makes use of an indexed field (patient case number) and the treatment number for a particular patient. Whenever I create a new patient using the web browser, the new record is created when I hit "submit", but the browser refreshes to another record in the database, rather than to the record I just created. I have tried multiple scripts, with no success. Is there a way for me to have the new record appear in the browser once I hit …

Is there any what to change the text on a button from within a script? My scenario is this. I have a record that I mark for deletion by clicking a delete button. I would like to change the text on the button to say "Undelete" once it has be marked for deletion. The purge of all items marked for deletion takes place on a daily basis. That way if something is accidentally deleted, it can be saved. Any thoughts? Thanks a bunch! Amy

I have a script that checks to see if someone has access privileges to a layout. If they don't, I am showing a message that says that they don't have access to the layout. I would like to add a graphic to the message box. Is this possible or how do you guys handle showing messages to areas that a user does not have access to? Thanks, John

Is it at all possible to create a script that will change background color based on a calculation? example: if the number goes under 100 it will be in green and if it goes above it will change to Red. If so how? Thansk, RET

Is it any way to have script such as it will returns the field name when click on any field? Such as ti returns field A when I click on field A Thank you

I have an application that contains 6 files. All 6 files are opened with one file's opening script. Each file is password protected (they all share the same password). I have a "master" password for designing the files and the operators have a password that restricts their access. To make it easier for my operators, I need a script that eliminates the need for the Operators to enter a password for each file as it opens. I'd like them to only be required to enter their password one time. Any ideas? PS I'm not sure how this site works, so I also listed this question under the Security topic.

is there a way to find the line count in a field and then display that in a containing field? thanks paul apted

Let's say a have a data looks like this: "aaaa bbbb ccc ddddd" How so I trim to be like this: "aaaa bbb ccc dddd" I want to get grid off spaces Thanks

It is very easy to find duplicated records by entering "!" in the Find Mode. But let's say I have 100 records that contain same data such as "SA" in the field name called "Code". I want to Find such that it will return one record found for SA if I enter SA in Code in the Find mode. Why do I do this? Well I just want to know there is a "SA" is existed or not WITHOUT showing me all records found that contain

Hi Everyone, I just ran into an unexpected behavior. I had the following simple script: (Condensed for typing sake) Set Error Capture ON Loop Set Field (some data in the record) Go To Record/Request/Page[Exit after last, Next] #Look for records that fail required value validations IF[status(CurrentError) = 509] #Must revert the record to allow the script to continue. Revert Record/Request [No dialogue] End If End Loop Using Developer 5.5 and the Debug Script mode, when stepping through each Script Step FileMaker fails to capture the 509 error because the comment is in-between the action that causes the error and the IF that catches t…

Hi - I have a script where the first section does a find for me. I have created the find using Set Fields. One of the Set Fields is on a Calculation(Date) field. Set Field [NextInvoiceDateQuarterly, ">= Status(CurrentDate)"] - - - this is my line in ScriptMaker When I run my script - just get a question mark in that field and I have to modify it manually or cancel my script. I have tried changing the Set Field command to Insert Calculated Resut, but then it just literally enters ">= Status(CurrentDate)" and tells me I can't have that because the field is a Date field. I want the field to be found on >= and the current date. I can do …

Hello all! My app contains three files: A prospect file, producer file, and a help file. The prospect file is the main file. Only in this file do I have a script that runs at closing that clears a variety of fields ( these fields are flags for re-printing, and are cleared when the app is closed so that the next time the app is opened and the print script is executed those letters dont print again). It works fine (a bit of a pause when there are thousands of records, but its not bad), but I was in the producer file, and I dont think that it ran because the app closed quite fast. Do I have to link each file to that external script in case the app is closed in a f…

hey guys i've created a report in list layout.. i need to be able to sort by atleast 2 of the columns(fields)... i've created 2 buttoms, placed above each of the 2 columns... i cant however create a script to sort the specified column... anybody know how i can set up 2 seperate sort scrips on the same layout? cheers ss

I need to know if there is a way to make something happen in a field when you click on it. I know that you can turn a field into a button but it has it's limitations. Here is an example of what I would like to do: I have 50 fields and each has a toggle (x or blank). I would like the user to click the field and have it trigger a script (if x, then blank; if blank then x...). The catch is, I only want to write the script once (as opposed to once for each field). It seems that there should be a way for FM to recognize which field to clear based on which field/button was clicked to trigger the script in the first place. Any bright ideas?

High all, is it possible to suppress that annoying dialog box which appears every time a search didn

Is there a way to automatically resume a paused script through Scriptmaker without having to rely on a user to hit the continue button? Do I need to Applescript this function or can I even do this?

Hi, I have a menu file with a button labelled "Close all files". This button just performs a "Close" script step, which makes the menu files' close script to run. This closing script performs a Close("File X") script step for each file in the solution (about 25). After these, FileMaker itself is shut down if no other file is open using a: If("PatternCount(DatabaseNames,"<Return character>")=0") Quit program End If The problem: When running this close script, I always end up with some files still open. When pressing the button a second time, all of the files close properly. It seems that some files are re-opened after having closed them one time. …

I need to create a script to replace information in multiple fields of a current found set. I am concerned at giving the database users the replace command due to the ease at which data corruption can occur . Conversely, though I would also like the users to be able to make changes to fields in multiple records to save time wasting repetition of data input. The answer to this is a script that will prompt the user to find the CORRECT found set and then initiate the changes to this group of records. As a result I need a script that will initially ask the user to 1) Input two criteria for the search 2) Make the required changes to the fields in one record 3) Apply …

I have an inventory system in a heirarchical tree structure. When an assembly is entered into inventory, it automatically subtracts all of the discrete parts that make up that assembly, times the number of each part per assembly. This is very nice for a snapshot of where all of the inventory is currently in the assembly process. However, I've been asked to provide ordering information for the inventory specialist. NOW I need to be able to recursively search through everything and multiply the parts per each assembly times the number of assemblies on hand and get a total inventory of each part, regardless of which level, or assembly, it's tied up in. I've studied …

Hi I have a Customer database, a Product database and an Email database. In the customer database I have a portal with the email records. These email records can be marked using a pop up list. This works fine when I want to email to specific "marked" customers in a found set. But I would also like to be able to go to the Product database, find a specific product, which also is linked to a customer, and then go to the email database showing only the customer which had the product and who's email had been marked. Any good idea's Peter

Hi everyone, I have a problem which is bugging me enormuosly. I'm in the process of developing quite a large solution (30+ files) for a trading company. The system deals with most processes needed for running the business. This includes storing/processing for the following entities: Customers Contacts Suppliers Orders (from Customers) Orders (to Suppliers) Products/Items (including "automatic" inventory management system with trigger points for semi-automatic ordering of products from suppliers when orders for those products have passed the trigger points) Delivery addresses Invoices Events Reports Price contracts Service/Repairs Quotatio…

I was just wondering... could a script modify a field in a record even if someone else on the network is "using" that record? I am anticipating a problem with adjusting inventory of a product if somebody is looking up that product elsewhere. If my assumption is correct.... any suggestions on how to get around this problem? Thanks!

Here is what I want to do. I have a script that finds a certain set of data. I want to have a message come up before the user prints that says how many records were found, so that they know how many records are going to print. I was hoping that I could include a Status function in my message box, but that did not work. Any ideas?

I am working with FileMaker Pro 5.5 and FileMaker Server 5.5. I have two questions. 1. Recommended process for backing up files on the server without shooting down service. 2. I have a script that finds records goes to preview mode and pauses at this point there is a "Continue" button and a "Cancel" button on the task bar. What I want to do is Exit the script if you click "Cancel". Also would like to do the same at the print dialog box.

Trying to find out a way to check to see if a file is open. Thanks.

I'd programed a series of script steps in FM4, but I only can use "ALT"+ "print SCR" to copy and paste what displayed on the scren to Word document and print it out from Word. It's kind of very tidious and silly way to print out. Is there any otherway to print the entire script steps from FileMakerPro ?

Hi , I am trying to extract data from body fields to place in summary parts and then perform a comparison calculation on the data. The script steps work ( or don't) like this: Perform Find (Department) Sort (Job Card No.) Go to First record Copy(Define Field=Job Card No.) (the fields above are in the body) Paste(define field=First job Card) (This field is in the summary) Go to last record Copy(Define Field=Job Card No.) (this field is in the body) Past (Define Field=Last Card No.) (This field is in the summary) I then want to subtract the first card No. from the last card No.+1 and compare this with the record count which should be equal. This wo…

Does anyone know of a plug-in for a Mac that allows a pdf file to be automatically named for a FileMaker field when the file is printed from FileMaker? I've taken a look at PrintToPDF, but it doesn't seem to do this. I need something like AfFiler, but for the Mac. Thanks!

Using FM 5.0, I have a found set of N records. Each record has a unique identifier field, and also a field containing the identifier of a companion record. I need to write a script which will create a found set of all of the original records plus the companion records. A seemingly reasonable way to do this would be to Enter Find Mode, and create a multi-record find extracting the ID numbers from the ID field plus the companion field. Thus for N records, the FIND would have 2N lines. However, once you enter Find mode, you can no longer "see" the original found set (you only see the find prototype fields). So it is necessary to capture all of the ID…

This may seem like such an easy question but rest assured, for me it's not. We rely on speaking to our database on a regular basis and have a field that when a button is pressed, the current date is entered. This is the 'last spoken to' field. I thought it would be great if we could have a self generating report that would show everyone who has not been contacted in the last month. It would for example, locate the 90 names not spoken to in over a month, and print out a copy on the 1st of each month. Is this possible? Any other tips on reporting functions would be great. Thanks for help. Mark