Script Workspace and Script Triggers

I have a main table and three sub tables, all three sub tables are linked to the main table by a unique id. When the user creates a new record in the main table I want to automatically create a new record in each of the three sub tables that link to the new record in the main table. Can I automate this process?

Hallo All, i have installed [color:red]EventScript Plug-in, in Windows 2000 is Okey, but in Windows XP that plug-in not appear in the External functions I already copy into ...Extensions folder. Why..? Thanks

Is there a function that will do the inverse of the filtervalues function? Currently this fuction will filter all values out except the ones that I pass it. What I want is to pass what I don't want and for it to give me everything else. Problem: I have two text lists. Each value is sepparated by a return. List1 is the list I need to filter through. While list2 is a list of items that I don't want in list1. So does anyone know of a simple solution?

I found several discussions that touch on this topic but remain somewhat confused by the process, so here goes. I am developing an mass email function and have programmed a script to shut down the mailing should the messages fail to be sent. I would like to be able to see which messages, contained in an "Out" table have been sent and unsent so that resuming the email process will not result in any omissions or duplicate mailings. My question: is it better to simply have a toggle field for each record (sent/unsent) or to move each sent message to a new table and delete it from the Out Table? Although I really don't want to dilute this post, I would like to know h…

OK this is in follow up to a post last week regarding more than 30 records being found and having a custom message appear. I now have different criteria than what was originally given to me. See attached .pdf for the areas that I will be refering to. [color:green](FYI: An RFI is a Request For Information from a building contractor. Basically a question from him/her that is documented by the architect. We are the architect.) I now need to be able to find records for a specific PROJECT NUMBER (hilighted on .pdf). From that found set I need to omit records where the RFI CATEGORY (a value list) = "DI". There are instances where more than one cate…

Hallo All, I want to perform script from field validation, this is for speed up entry data and checking validation from that field. for example, if i double entry i want to perform script automatically (without MOUSE CLICK and without tab to BUTTON). that script will find double data and show list of detail double data. Can filemaker do this ? thanks Han

Here's the script: > Go to Layout ["Perm Master Records"] > Enter Find Mode [] > Go to Field ["PR~ArtistTitle"] (this part is actually a separate script from another layout, so in the new layout it pauses in find mode waiting for user to enter a word or phrase, then, after a particular record is selected from the find returns, this script is run:) > Set Field ["check box Master", "Y"] > Copy [select, "PR~ASIN"] > Go to Layout ["Main Records"] > New Record/Request > Paste [select, "ASIN"] > Set Field ["check box Main", "Y"] > Go to Layout ["Perm Master Records"] > Enter Find Mode [] > Set Field ["check box Ma…

Hi everyone, I want to be able to open a file on the server based on a variable. Is this possible? Open File - fmnet/01.1.10.15/$$FMFilename I've tried but it seems it doesn't like opening a "variable" filename. TIA

I'm using FM 7, and each day I print out dozens of order invoices and labels to ship orders to customers. For several years, I was on one printer, using dialog box interruptions to prompt changing paper trays in the printer. Well, I bit the bullet and purchased 2 smaller printers (one for labels, one for paper), but my Print script step won't tell between the two. They have different names, and both show up as different printers in every application's dialog box, but when I try to use "Print [Restore, No Dialog]", it prints to whatever printer was used last, rather than using the Print Options I've stored with the script step. Any thoughts are welcome. J

The attached .pdf file shows the layout that I am working in. My hope is that a calculation or script can be created that will do the following: ~Copy the current record's project number ~Enter Find Mode ~Paste the project number ~Perform Find for records that have the pasted project number and where the Consultant Affected checkbox has at least "A" checked. --From that "found set"... Because the "RFI number" is not always sequential, I need to count the number of records that contain data in the "Date Received" field. (this field always has a date) If the total number of records (containing at least "A") for that project exceed 30 records,…

I am a first timer and very new to this forum, so forgive me if I fail to appropriately address certain issues. I am in the process of designing a database that requires a Kappa function value for statistical comparison between observers. This value, if you don't already know, gives the point value for comparing between observers when evaluating data. I have a frequency of 10 steps (or 11 values) for each observer. Each observer chooses one of the values per evaluating session. These values are then opened into a matrix giving the agreement (e.g. 1,1;2,2;3,3;etc.) and disagreement (e.g. 1,2;1,3;1,11;2,3;etc.) values. The totals are then produced from the agreements and di…

i have a script that cycles through 200+ records and works on everyone one except the very last record. the script it supposed to result a "# of #" value for each record based off of two sets of found feilds with a minimum return of "0 if 0" and a max of "4 of 4".after i run it all the records are right but the lastone the last one displayed the last time i ran it as "0 of 552"...? and it should of read "0 of 0" for that record any ideas

you can set breakpoints in scripts so that you can skip script steps...can you set it if you have looping script so that you can start from the last two or three records, with out haveing to cycle through the first 200 records or so you have

I try to import record from a text file into a field. It stores each line as one record. But it will always ignore the content after the first comma in every single line. for example. "Today is a good day, can we go out?" The line will be imported as "Today is a good day" The content after the comma is ignored. The previous version File Maker does not truncated the line at all. But File Maker version 7 does. Any ideas? Thank you. Jackson

I have a file with several thousand event records. Each event is assigned to one of several hundred managers whose name is in the Manager field. I wish to automate a process which does the following: 1) Create mutliple copies of the file. 2) The individual files created contain the records associated with each Manager only (i.e. Smith's file contains 10 Manager="Smith" records). 3) The filename would contain the manager's name and the enclosed record count (i.e. Smith_[10]_Fall_05.fp7). Can anyone suggest a best route to take? Many thanks in advance. DSW

Just thought I'd share a little difference introduced in 7. I was taking a file that needed cleaning up, appending data from a field in multiple duplicate records into the 1st instance record (the data was from a flat file that chopped long lines into pieces). I was using a self-relationship to append the data from later lines back onto a field in the 1st instance record, then deleting the duplicate records. I watched it during the loop. It would append the data to the 1st instance record fine. But when the later record was deleted, the appended data would disappear. Because I hadn't used Commit Record right before each deletion, the deleted record took the da…

Hi, I have the following problem: I have a table called 'transactions_tmp' with the following (relevant) fields: account amount description_1 description_2 This table is populated by importing a comma seperated text file. After the import, I want to copy data from 'transactions_tmp' to a table called 'transactions' that ha the following fields: account amount description 'description_1' and 'description_2' from 'transactions_tmp' have to be concatenated into field 'description' in table 'transactions' (there are more processing steps between 'transactions_tmp' and 'transactions', but I will use the concatenation for exampl…

I have a contacts database where people in our home office assign new contacts to our salespeople and sometimes update information of a record that the salesperson allready has. I'm looking for an easy way of showing upon the users next login which records have been updated or are new. I may be making it too complicated, but here's what I've come up with. First I check if the dateupdated > the users last logout (which is set in a script that runs on close). It that's true and updatedby or created by (autoenter fields) change I get the current user and if that does not = the salesperson I set a field called notifyOfUpdate = 1. Then I have an on open scri…

What is a good way to write an error checking script that will check if 5-7 fields match exactly. Like I hit save it go's to the layout does a search to see 5 or more of the fields match exactly. Thanks Tony D.

-------------------------------------------------------------------------------- I could swear I've done this before, but for some reason its not working. I want a script to create a new record in a different database from data in a current database record. I thought You just used "set field" or insert calculated value and it automatically created a new record with that data in the target field. For whatever reason its not working. I am running FM Server 7 Advanced and FMP 7 Developer. I'm having trouble updating the files even though they are both open on the Developer machine. Ideas? Thanks! -- Chevell :

I have a table with a unique id field and a sub id field, as well as a number of other fields. I want to merge records where the sub id field is not unique. Is it possible to automate this option?

What If statement do I use to set a condition on a find script? I mean if after all search critera is found or not found How do I write a script off of the results of rather the item was found or not?

I'm pretty new to FMP. Is there a way to create a script based on the layout your in? An example would be I have several tables (all with layouts created for them) that all have a New button on them, based on which layout you're coming from I would like to choose which new screen to go to. Hopefully, I'm explaining that right.

I can't figure out what I'm doing wrong. The fields called Condition A thru D are using check boxes for "Yes" (blank for nothing). I want the text to display red when no conditions are met (this is working). I want the text to display green when Condition D is met (this is working). What doesn't work is getting the text to change to blue when Conditions A,B, and C are met. I keep getting either red or green, even though I have ConditionA, ConditionB and ConditionC (but not D) checked for Yes. Does anyone know what I'm doing wrong? If ( ConditionA = "Yes" & ConditionB = "Yes" & ConditionC = "Yes" ; TextColor ( Employees::Name ; RGB ( 0 ;0; 25…

hi, can some please tell me how to write a script that finds the last record in a table which was created by the current account (user).

I have a web-enabled performance review database (Pro 8 advanced). Reviews require a self-assessment, possible Team Lead assessments, and a supervisor assessment, which must be done in that order since both Team Leads and Supervisors need to see the Self assessment, and Supervisors also need to see Team Lead assessments for each person they supervise. I have the menu set up so that when a Team Lead comes in, he can tell if the employee is ready to review because of the font color of the employee's name in the portal (i.e., if a Team Lead has 3 people to review, their names show up in red initially. As they submit their self-assessments, their name(s) turn to gree…

I have a text field with 10 repetitions. For the purpose of this database, I would like to enter one value into the first repetition and have the remaining repetitions repeat that same value. Can this be scripted? Thanks for any insight. Jarvis

I feel pretty stupid, but...right now I have one DB with multiple layouts, and a script which copies data from two fields of one layout into 2 fields of another, creating a new record in the latter. The first layout ("master records") holds data that will never be deleted. The second has records that will be deleted after 3 months or so. I really need to create a relational DB (I guess) so that these two can be separated, but nothing I've read about lookups or relationships seems appropriate for this situation (which just cannot be right??). I don't want to have ANY relationship between the two, but can't figure out how to use a lookup to achieve this, since loo…

I've created a simple script which runs from a button in a specific layout of found records. The script inserts today's date into all of the found records. Go to record First Loop Insert current date Go to next [exit after last] End loop [i did say it was simple!] However, the record which was onscreen at the point the script was triggered is not the record that is on screen after the script runs (unless co-incidentally it's the last record). What I want to achieve is having the script run whilst apparently staying on the same record. Anybody got a simple solution? Tim

Before I get started I just wanted to thank mr_vodka (whom I forgot to mention) Ender, Inky Phil and comment for getting me this far. I have three tables Client _ClientID FirstName LastName H.Address g.clientID Property: _PropertyID HouseName HouseAddress Ownership: _OwnershipID ClientID PropertyID I within the client table I have a property assign layout. You hit the button and the P.Assign layout pops up and you choose the address. Then you hit the button and you are returned to the client layout. After you have selected the property via the address you will hit the button to 'set' and the script runs, creating a new record…

I am working on a fairly complex donation tracking database (a few dozen tables, lots of table instances, etc). Fairly complex for me, anyway... I am trying to figure out a way to have my Reports area allow the user to select, from a preset group of fields, up to seven sort criteria and ascending or descending for each one. This will determine the appearance of Subsummaries and order of each subsum's members (like, group by year descending, then by quarter ascending). Each set of preferences can be saved and reused. The ui is working fine, but I can't figure out a way to do the scripting without a mind-boggling number of conditionals that lead to dozens of preco…

Hi there, Quick background: I've created a form, the user entires info, hits submit, the info is copied to another layout and the form is then cleared. I have been setting each individual field (because I don't know of an easier way) and then clearing each individual field. I have done this and it has worked until now. The only difference I can see is that I have to go to multiple layouts for this script... Can someone tell me what is wrong here? It works for the first layout but not the others. For example: Go to Layout ["ACOU" (Student Eval)] Set Field [student Eval::ACOU_Material, Form::ACOU_Material] Set Field [student Eval::ACOU_Knowledge…

On Windows XP, I want to use 'send event' to launch an application on the desktop. I need to use the 'calculation' option. If I use the 'file' option to see the path to a desktop application, it is of the form: file:../../Documents and Settings//Desktop/ Both and can vary which is why I need the calculation option. How can I get the 'Windows username' so I can properly build the calculation? 'Get(username)' returns the Filemaker username, not the windows username and no other 'Get' function seems to provide the necessary information. Or is there another form for the calculation to launch a desktop application from 'send event'? TIA

What is wrong? I need global repetition field in which I like to create month names. Doesn't works. Way? ino :qwery: If anybody have suggestions, answer can be in any fp 5 - 8 ... test.zip

Good Morning Everybody. I need help. I have a Report with Various Customers. JCP Miller Sears Kohls. Every customer has its own checklist. What i want to do is create a scrip so that when i click on a customer i'll go to that specif checklist that pertains to the customer. HOW CAN I DO THAT. Thanks

I have a series of related tables that use an ID field for the relationship. In TableA, I want to add a new record by opening Table B in a new window, so that I can do a search for the relevant record. When I have found the relevant record, I want to run a script that will copy the ID for THAT record and paste it into the ID field of the NEW record in Table A. Thus, the window for Table B forms a small "lookup" window that is separate from the main layout window for Table A. I have tried a number of combinations of copy/paste actions in the script for the Table B lookup. Do I need a second script that is run from within Table A window to paste th…

Well after spending an hour or so browsing through these posts, in the words of U2 "I still havent found what im looking for". I am a complete novice at this and maybe this idea is a little over my head, but i am giving it a try. I have 3 questions, 1) I need a script which takes the current date which i have in one field, and automatically calculates another date. The first instance for this is to calcualte a date which is exactly 1 year from the current date (membership renewals) with the ability to remind me when the membership is due. the second instance is to work out a date which is calcualted from the current date but is a factor of a time i enter…

I have a series of fields (FM8A, Win XP) with similar names (FullName1, FullName2, etc.), and I need to clear/set all of them in a script. I can do this, of course, by specifying each field individually and the set or clear operation to be performed. Since the names are identical except for the numerical designator at the end, how can I set up a loop to do this more simply? Thanks! James McAlister www.BulletinInserts.org www.james-mc.com

Would it be possilbe to create script that saves a copy of the file and renames itself so it will not overwrite the existing backup file? I would like to be able to track changes to the database. Any help will be appreciated. Thank you, SO

Hey guys, you've been a lot of help so far. I'll try to make this my last question for a while... I have a global field called gReport. There's a pop up menu with a valuelist of the names of my reports that I have in another table. I want to make it so that when a user chooses one of the reports from the listbox and pushes the command button I can somehow run a script that basically says: perform script(reports::scriptname) So it'd be a script that tells filemaker to run a different script that is named the exact same as the report name (these are allready defined). So to put this in a nutshell, I'm looking to run different scripts using a pop up list. Any …

Could anyone tell me if there is a way to attach a file based on a field name ? From the look of it I have to specify the path.. I'd really rather not export the file to some arbitrary name and then upload that. The name of the file I want to attach will be things like Smith_reference_letter.pdf, Charles_CV.pdf Any ideas I don't want to use AppleScript because then it won't be so easy to know that the email sent correctly. If there is any fault in my thought logic, please do point it out! thanks!

I've searched and have not found a solution for this. I am a novice/intermediate user so bear with me if the solution is simple. I also hope this is in the right forum, please tell me if it's not. I have a PROJECT_DB with a layout called "RFI". I have a CONTACTS_DB where each individual and their company also has a representation of three initials (Universal Consulting Engineers = UCE). In the PROJECTS_DB, when I enter a contact into an RFI record, also linked would be the three initials for their company. What I need is the serial number to be contigent on the initials, so the first few records might be: UCE-001, UCE-002, ACM-001, UCE-003, ACM-002, UCE-004…

I have a script that does somthing critical and in normal use, is irreversable. When the user hits the button I have a custom dialogue that pops up and says "Are You Sure?" - they can then choose "OK" to continue or "Cancel" to... wait for it, cancel - but Hay - I hit cancel and the script just keeps on running!!! - What can I do to allow my user to back out and stop the script from running?

I am sure this is a pretty basic question, but I am still teaching myself filemaker. This is what I want to do. I need to have a follow-up of records. So if I have a record with the date....10/10/2005 of when something is shipped, and I need to follow up 1 week later, how do I create a script so I can pull up only the records that fit the criteria I am looking for. Does that make sense? thanks

I have an application where I want to do some processing when closing the file, but it appears that when I Quit FileMaker, by the time that the script gets invoked that only one window remains open. All other windows have been closed. Is there any way to prevent this?

Hi, I have a solution, which works together with another windows application (it generates data to be imported into FM, created by another developer). The database communicates certain conditions (for example, data import succesful) to the other app. through simple exported text files created by FM scripts. In most cases this works fine, but sometimes, when the database first opens the external application and the user instructs it to do its thing, and while the external application is running (this can take a couple of minutes), the user switches back to FM and presses for example Enter, an error box appears - while this dialog box is active, FM does not …

I've seen a lot of examples for really good logging systems. They're very advanced and something that I would like to use. However, the database I'm building is based on a flat file database created in the early 80's. So we have some fields that contain A LOT of text. Keeping track of the actual changes to the field would basically make our database HUGE, which wouldn't be a big deal, but we use synchdek to distribute full databases to our sales team. Here's my idea, let me know if I'm on the right track. I want to track when any changes were made to a record, but not at the field level. I want to keep a running tab of who modified the db, as well as the date.…

I have read most the manual, and unless I can get someone to answer this I'm going to go nuts. In the scripts, how do I change the setting so the cursor starts at the front of a text string when it moves to a field. I need to paste a "1" at the start of a phone number string. Is there some property that I have not seen that changes the insert point. the manual says to change it, but not how. I worked around it by copying, clearing, inserting text, then pasting. Thats like 5 steps to do 1 thing. Anyone, please.

Hello, I've used FileMaker a bit but have something which I am hoping is a basic question. I am working with a scheduling database that organizes appointments for a school guidance office. Each day of the school week gets a new record in the 4-digit year format -- DD/MM/YYYY. I am familiar with startup scripts and wish to use one to enter find mode when the database starts up, auto-enter the current date and search the system for that date's schedule so that counselor's the correct schedule when they open the database each morning. Any help is appreciated

Righto, im hosting a file on fm server 7, lots of globals which need to be set at startup... my question is, when im using the set field script step, do i have to be in the layout related to the field? Secondly, is there a quicker way of doing this.

I scripted into my opening script a step to log-in as a read only account without dialog box. Not realizing what I was doing, I have locked myself out of my own database. Is there a way to disable the opening script? I can option-open the file and log in as an administrator, but then the opening script runs and I'm back to read only access. Thanks in advance.

Hi there As a brand new Filemaker Pro user, I've been working in depth with Panorama DBs and we are looking to upgrade (probs with Tiger etc etc). I'm unfamiliar with coding (scripting?) in FM and I'll be needing to convert some pretty complex code, so I'm hoping to be reassured that FM has amazing capacity for in-depth programming. Any recommendations for books would be well received too! The database is to manage accommodations, courses, dining, scheduling of workers and more. My skim of the FMPro book that came with the software doesn't show any familiar looking code. Please advise! (And although we have 6, we can upgrade to 8 if it's a go-er!) Thanks …

Is there a way to specify in a shutdown script where you can save a copy of the file ONLY when the host closes the file. For example in the script you have the line that says save a copy as ["backup.fp7"] Now is there a way that it WILL NOT save a copy of the file if the user just remoted in but WILL save a copy of the file if the host closes the file down? THANKS!!!

On PC it's easy to use a track and CD Drive field to have a script launch a specific track from cd - On Mac I'm not sure how to go about this since the CD drive / name is not fixed as it is on PC - how would I script this on Mac, OSX 10.4 FMP 8 Advanced Thanks for the help, Blaze

I have 2 FM7 runtimes. Runtime1 invokes Runtime2 via 'Send Event'. Runtime2 runs in background mode and requires no user intervention. Both use Secure FM to control user access to menu functions. All menu items are disabled except the edit menu 'copy' & 'paste'. They are 'created' in one set of directories and then copied/installed into their 'production' directories. When Runtime1 is run for the FIRST time, and then invokes Runtime2, Runtime1 then sits idly waiting for Runtime2 to finish. Invariably Runtime2 appears to cause Runtime1 to abnormally terminate while Runtime1 is just sitting there. The Windows message is: "Runtime1.exe has encountered a pr…

Has anybody ever had your script NOT exit after last in a loop? Because mine is doing that. And not only that, but it seems to be ignoring the If's that I have checked and should work. Is this ANOTHER file corruption, or am I just a moron??

I'm assuming a script could somehow do this: We would like to now host the database on our local machine, however power outtages are always a concern. We now have a UPS system giving us 15 minutes of power. However we have the windows OS go to hibernation mode after 5 minutes on battery power. I created a test database to see what would happen when the computer tried to go to sleep mode and filemaker actually has a dialog box saying the files have to be closed before sleep mode occurs or it will cancel the request. Is there a way to automatically close the file (etc) when the computer wants to go to hibernation mode (or shutdown)? Thanks for any id…

I need to select groups of 37 random records without repeating records. The database is about 900 records. Is there any way to do this?

I have a request to creat a report in an existing database that will find 1. New records entered in the last week using the date field "Date Entered" 2. Jobs completed in the last week using the date field "Date Finished" 3. Jobs in progress (the total of "Date Entered" minus "Date finished" The problem I am having is getting all this information on one layout. I am sure FileMaker is capable of doing this, I'm not sure I can handle it without a bit of help. Thanks

I need some help with this one. I need to be able to automatically update a calculation field that store a total qty of product in the field. It seems like there is no method to have this field update automatically when a field value is changed in one of the fields used in the calculation? Please let me know if there is a way to accomplish this. Thanks in advance. COFFEE.

Is there a way to set up a script so that when applied to a button it will navigate the user to a specifc field. The Scroll Window [to selection] does not seem to work the way I understand it should. My understanding is that if I write: Go to Layout... Go to Field [field name] Scroll Window [to selection] the script should open the layout, go to the specified field and scroll the window so that the field is visible. Am I wrong. I just need HELP I guess. I need to be able to set up buttons to take users to pages 1, 3 and 10 of an 11 page layout. Everything I try will only get me to the first page of the layout. HELP!!!! : :(

How can I compare a fields content against the values in a value list as a script step. My attempts so far have failed. Thanks

Is there a way to control (in a script) how many windows are open? Such as: "if the count of open windows is greater than 3, close 1 of them" Thanks for any help yknot

I have a database with three tables. 2 contain info and the 3rd is periodically re-created with a script which exports data from the info tables and then imports it into the third table. The location of the ex/import files is a separate external folder. This works fine. However; I do backup the database frequently because I make mistakes and I want a backup. If I go to the backup file and try to run the script or if I copy the file to the original location and re-name it to it's original name and the run the script I get this message: "test.tab could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different…

I'm sure this is easy. I am just missing something. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ [color:red]Basic info: I have a "home" layout which displays buttons for certain layouts in the file. When the user clicks a button they need to be taken to a specific field on that layout. Button in question is named "Utilities" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "Utilities" button is specified to: "Perform Script ["Home_P1_Utilities_button"] "Home_P1_Utilities_button" script is written as follows: Go to Layout ["Phase One Report_Pages 12-20"] Set Zoom Level [150%] Go to Field [Phase One_ISV::utilities_tsu_exist} Commit Records/Requests …

... I have problems sometimes with buttons that are assigned a script to goto a layout when a certain criteria is met... the button ignores all the criteria and decides to default to the first layout in my list of approx 150 layouts (this happens approx 1/50 times)... why is this? (Multi User Solution hosted on Server 7).

Hi All looking for a definative answer to this one. I have 2 printers and am trying to have my scripts remember which printer i want to goto. Seems filemaker cannot retain the printer choice within my scripts no matter what i do! Is this a bug? Stu

Mac Help needed! I've got a solution created on PC that is being migrated over to Mac (OSX 10.4) There is a script that takes drive and track info from fields and launches the cd to play the appropriate track. How does one go about this in the Mac World - I've not had my hands in it since system 9

First, big thanks to everyone on these boards. I didn't even know filemaker existed two weeks ago until I got this new job, but I've learned a lot from lurking.... Now for a possibly easy question, I searched to no avail... I have a report that I want to create for only one state. Is there a way that when the user clicks on the button to perform the script filemaker can prompt them for which state they want to do the report on? I'm sure I'm missing something here. Brain farts all morning....

I have a database of products which need to be exported in groups of 1000. There can be as many as 40000 or as few as 8000. The steps as I see them are: l. loop to export the records 2. if record count is greater then 1000 then export 1000 as file name 1.csv 3. else export remaining records and name as 1.csv I understand the logic of it but I do not know how to script it? My scripting ability is very basic. Any help would be great!

i have a script that creates either a panel record or a graphic record depending on what value is chosen from a list before the script is activated. when a new record is created an ID number is assigned to the panel or graphic. the last part of the id is a number which signifies where in the order of panels or labels the item in particular falls. the problem is i want the panels and graphics to be linked to different counters but because a serial updates regardless of whether a panel or graphic record has been created i'm having trouble. i'd appreciate some help. thanks.

I'm sorry if this question has already, previously, been answered; however, I simply ask this question because it appears as though your search function isn't functioning correctly. Link me to previous posts or web-tutorials if necessary. Basically, I am making a database on behalf of a company, to organise various work projects. Each project has its own ID, and its own Site Location (including Postcode). I want to have a button that opens a URL, with the Postcode information in it, in order to show a location map from multimap. This needs to obviously change, based on the record currently being viewed. I have tried to input various elements into the URL field, i…

Hi everyone, I'm an extreme novice to FileMaker Pro, and I'd like to get some help from any of you here about serial numbers. Basically, mgmt handed me a database to work on, and everything has been okay thanks to this FM Pro Bible book. However, I have a problem I can't solve now with auto serial numbers. I was able to create an invoice record number with this auto serial number feature for the three companies I deal with, but I've now been told I have to segment my invoice record numbers by company. (I guess the most layman terms example is that instead of records 1 - 60, mgmt now wants to see company A have invoice 1 - 20, B have 21 - 40, and C have 41 -…

Hi all, I work in an academic music department in a university. Last year I created a bespoke room bookings database with some great help from the kind folks here. The problem is this: I have booked in all of our scheduled classes, and now I am able to offer time in our rooms to part-time music tutors who often don't sort out the rooms they need until the last minute. I would like to be able to produce a full list of times when are rooms are NOT already booked. As Filemaker cannot show records that don't exist I figured that I could create a script that would loop through all our rooms every teaching day between 9am and 6pm and create a new record for eve…

Does anyone can tell me how to resolve my problem? In order to keep the records updates within different offices, I have to update the modified records twice times a days by export and import during working hours. The problem is if someone accessing in specified record, this record can’t be updated and don’t know which record can’t be updated is well. And, we really don’t want to close the file when perform the importation because isn’t convenient and will disturb all users. Thanks in advance.

Anyone know how to resize a scripted custom dialog box so that it doesn't need to be stretched in order to see all of the text. In other words it opens at it's maximum needed sizing? Thanks, Blaze

If I have one table with three different layout options pertaining to address's :: Main; Work; Home; etc. When I run the script go to related record my option is [from table: Main] I need the option of [from layout: Work] ; [from layout: Home] etc. How can I acomplish this? Thanks

I was wondering if anyone could tell me a way to get a script to run automatically after a field gets modified. The script is designed to look-up a value in a different record in the same table and paste that value into the new record. Cheers!

I'm writing a script to take data from a FileMaker 7 file and create iCal events with it. The FM data is a series or records, each containing three fields, like so: AAA-111 09/23/05 Description of event I can figure out how to use FM to find and sort the records I want and then export them as a tab-delimited text file. And then I can read that text file in Apple Script, coerce some of the data and then create iCal events. However, I'd like to do this without the step of having to create a text file and then open it for access in Apple Script. Does anyone know if I can skip this step by having FileMaker export the data to the clipboard? My plan i…

I have a csv file that I need to import which looks like: item quanty location smurf1 50 ny smurf1 60.2 nv smurf1 20.1 mn smurf1 24 ca smurf1 12.2 il smurf1 7 fl smurf1 58 tx smurf2 91.66 nv smurf2 90.66 ny smurf2 22 mn smurf2 64 ca smurf2 33.25 il smurf2 51.2 fl smurf2 2 tx The info I need is which three locations have the lowest stock. So in the above example it would be: smurf2 tx 2 smurf2 mn 22 smuf2 il 33.25 smurf1 fl 7 smurf1 il 12.2 smuf1 ca 24 I know this can be done via a portal but this creates duplicates of each of the three lowest fields. I need to somehow be able to export out of this FMP7 file a …

I have some scripts which make use of a "New Window" step, followed by a "Pause Script" - So the user couldn't close the window without using a customized button on the layout. "Allow User Abort [Off]" was set in the first line of the script. It worked fine (OSX Panther), but now (under OSX Tiger 10.4.2) you only have to hit the return-button on the keyboard and -- the script gets resumed! Is it a bug with Tiger?

I am trying to send an email from within a "Contacts" DB that (ideally) includes a record (containing a thumbnail pic) from a related file called "Works". So far, I can create a seperate layout in "Works" with all the data for a work record in a calc field called "Data Field" (except the thumbnail) and I think its possible to create in the "Contacts" a pop-up that chooses a record in "Works" and via lookup get the data "Data Field" and name this field in the "Send Mail" script. However, the data from "Data Field" is unformatted and there is no thumbnail. Alternatively, I could print to pdf the "Works" record to the desktop and then add as an attachment but …

I've tried everything I could think of to get the script below to behave as I would wish, but without success. When the user fails to enter any data at the 'Enter Find Mode ' stage, (i.e. user just presses Return/Enter key)I cannot get the script to pick up the fact that no info was entered. It jumps past 'If [Get ( FoundCount ) = 0]'etc., Thanks ================== Allow User Abort [Off] Set Error Capture [On] Go to Layout ["To be cancelled List" (Link)] Enter Find Mode [] Loop Pause/Resume Script [indefinitely] Exit Loop If [isEmpty ( Link::Code )] New Record/Request End Loop Perform Find [] If [Get ( FoundCount ) = 0] Show Custom Di…

I have a scripted find which takes me to a layout. The user enters the details of the find they want and it finds the information. If the user just presses the Enter key without entering any information, that error is trapped and the script works ok. The problem; The layout has 2 buttons, which have scripts attached. These scripts work fine (on other layouts) but on some occasions, the user presses one of these 2 buttons, directly after entering the layout, and the script gets confused. I assume I need to somehow close the 'find' script, if the user clicks on either button. But how? Bear with me - I am a novice...

How do I write a script to set a field in find mode as none are working for me. What I am trying to do is set a month, year, and magazine in find mode. I used! Goto (layout x) enter perform set field [month ; monthname (xdatefield)] set field [Year ; year (xdatefield)] perform find What am I doing Wrong? Thanks Tony D.

Hi, I'm new to version 8 having just upgraded from v6. I love the whole tables thing but am a little confused - how do I set which table a script runs in? Say I try to delete all sales history records in a table and re-import so customer histories are updated, I keep deleting all the customers! Any help would be gratefully appreciated...

I'm trying to make a custom login minus file maker dialoge box... Firstly is there a way to conceal a password in a standard text field. Secondly, although the login and password details clear after people login, there is only one record so if someone happens to try to login while someone else is attempting to login... their login and password are left there, any solution? Help would be great, cheers.

I’ve imitated an opening splash screen script I found here on the forum and I’m having a couple of problems with it. [color:brown]See the attached PDF for the code itself. Goal: Have an opening splash screen that is approximately 432 pixels by 432 pixels pop to display an image for about 5 seconds, then disappear – returning to the Main application screen. As I test the script – I’m starting at the “Main” application screen. When the current, erroneous script runs it starts by doing the following: It takes “Main” layout window and makes it much smaller while simultaneously opening the new Window named “Splash.”. Also, the contents of both windows are the …

I have almost no experience with the script maker so this may be more than I can handle. I have my own work request database which I have made. There are (2) related tables: 'Current' - houses active work requests 'Storage' - houses completed work requests. Currently the status field (you have a choice between active/completed/canceled) is a pop up menu. What I ideally want: when I change the status menu from active to completed (or canceled) I want the record to be removed from the 'current' table and placed in the 'storage' table. I am not sure, but it might be helpful to have it happen after a time period say 24 hours or so after complet…

Description: I have a script that opens a new window. What I want to do is lock the new window until an action has taken place. As it stands the new window opens on top, but you can select the window behind it. There has got to be a way to lock a window. thanks in advance irage

Hi, I would like to automate counting of all records related to a a given record in a database but I am having a little trouble. Database: I have a database of patients and a related database of sequences. A patient can contribute 0 or more sequences to the sequence database, but a sequence can only come from one patient. (The relationship between sequences and patients is actually via another database called sample, in which every sample comes from one patient, and may yield many sequences) Objective: I would like the script to go through each patient in the database, and count how many related sequences each patient has. Problem: I am trying to do …

I have 1800 records and I have been asked to assign each record a serial #. How would I start from # 1 and assign all 1800 records a serial number in increments of 1 automatically without generating a new record? Thanks

I have a checkbox field in TableA that shows a value list whose values are derived from a field in TableB. It's imperative that all values in the checkbox field exist in the current value list. All is fine until I delete a record in the TableB, thus deleting a value from the value list. If that value that was just deleted was one of the values checked in the checkbox field, it ends up being a hidden "orphaned" value in the checkbox field in TableA. My question is: What is the best way to get rid of the orphan values in the checkbox field? The table containing the checkbox field will hold 10's of thousands of records, so I want to make sure I don't end up doing it…

I have two fields, Date of Birth and Age. The age is calculated by the date of birth with by calculation below: Year( Status(CurrentDate) ) - Year( V Birth Date ) - (( Month( Status(CurrentDate) ) + Day( Status(CurrentDate) ) / 100 ) < ( Month( V Birth Date ) + Day( V Birth Date ) / 100)) Here is the issue: If only the age is known, I want to be able to skip the Date of Birth and just enter the age. Currently the age filed is non modifiable because of the calculation. Any suggestions would help. Thanks

I have some scripts which I plan on using to convert an application from FM6 to FM7. First I import the data into the new FM7 databases. The scripts do things like fill in fields that are now mandatory, convert date formats etc. I would like to be able to create a log file containing information about this process ... similar to the one that FM7 writes when it converts databases. I could write to a new database but I'd prefer not to do that. I have searched FM7 help for a hint on this, so I suspect it is not possible. Am I wrong?

I've been trying to use the SetField function to select a radio button based on it's value list with no luck in getting to work. Am I going about it wrong? Any insights would be appreciated. -Thanks

Is there a function to select and display unique values from a field? I want to display all of the unique values of a sequence number with a "select" click box next to them in browse mode. Like a subsummary report, but in browse mode. Then the user can pick one or more of the sequences --- to be plugged into another script to display record search results. Thanks one and all. Sandrotter

Hi, Does anyone know how I can get to perform a script immediately the RETURN or ENTER key is pressed in a text field. For example, I would like to set up a text field where the user inputs the information to search for. This should automatically trigger the appropriate search script once the ENTER or RETURN key is pressed. Grateful for any ideas?.

In FMP8, I need to export the current record and import it into another identical file, or Copy the current record and paste it as a new record in another identical file. I know I can make a script to copy the record, but do not know how to get that delimited text into the new record. Also, I know you can email an export of the current file and attach it as an email - I just dont want the user to have to go to their email to find it. Is there a scriptable way to get the data from Record A in File A to a new record in File B? Thanks, Rick

In tasks there is a "begin_task" field created by insert current time. There is also a "end_task" field created by insert current time. I have a script to trigger a custom dialog when "end_task" is empty and 4 hours have past the time value of the "begin_task" field. I can get the script to work manually -- is there a way for it to occur automatically? And for it to occur for all records in the file?