Script Workspace and Script Triggers

Hi all, I need a smidge of advice. I am hoping to add a script to my client database. Here is what I would like to happen. I open fm, the script runs. The script performs a find looking for all records in the 'reviewdate' field that either = todays date or are anywhere between todays date and seven days into the future. When it has located these records I want the script to copy the data in the 'review notes' field into an email for each record found. I have so far worked out how to do the find and how to paste the data found into an email for each record. However the trouble I am having is getting it to only select dates within that 7 day period and if the …

Hi I want to copy contents of a postal address field in one table layout "Contacts" to another table layout "Projects" address field. As a time saver I want to be able to script a button to copy the postal address contents. If the postal address of the client happens to be the same location of the construction project, although this isn’t always the case and then the project address would be entered manually. I have... "Contacts" layout with Table "contacts" with say a field "postal address 1" and.... "Projects" layout with Table "projects" with say a field "project address 1" The Contacts & Projects tables are related by: Contac…

Hey All, I'm running into a repeated problem with my databases. Not enough to make them useless, but this is an important problem that does cause our otherwise VERY helpful inventory tracking databases to fail occasionally. I have relationships set up for various reasons; I need these relationships to be good, based on user-input info in different fields. What is causing a problem is occasionally a user will hit "return" when entering sensitive text-based information. This invisible problem causes all the relationships to break that point at that record. I know I can flip over to automatic entry key fields (such as a unique, numeric, unmodifiable re…

FMP v8 in Windows XP and Outlook: will not send a separate email to each record in a found set. I have selected the "Multiple Emails..." radio button and selected an "Email Address" field, and have NOT selected "Collect email addresses across the found set." For example, if there are 10 records in the found set, Outlook generates 10 email messages with all 10 email addreses in the "TO:" box of each message. A Mac running OS X sharing the file on the server runs the same commands just fine with Entourage and creates 10 separate email messages and only 1 address in the "TO:" box of each message.

I have problems with loops, and try and avoid them, but they soon catch up with you. So I need a little help. I have a database, and the three fields this script is dealing with are 1. Quote price 2. Deposit paid 3. Deposit paid by – pop-up menu with cash, visa etc. I have created a script like this (Each an IF statement) 1.Check to see if “deposit paid” and “deposit paid by” are empty. If yes massage to check if user forgot to add deposit amount, or OK to continue. 2.Check if “deposit paid” valid and “deposit paid by” not empty. If “deposit paid by” empty user directed to select “deposit paid by” type, as you can not have a “deposit paid” amo…

I'm trying to build a navigation system where you select a table in one portal, and the available scripts show up in the portal below. It all works, except I don't know how to attach a script to the various portal rows. I guess I'm trying to assign a script name in a field and have the script attached to the portal run the script named in the related record. Somewhere I'm way off track! -Its bad when you can't even describe the problem.

Hello, I am new to FileMaker Pro and need some help editing a script for the Lending Library template. I want to insert the First Name of the person who checks out a library item in the reminder and late notice email. So the email would look something like this: -------- (Contact First Name), You borrowed (item x) by (author y) on (check out date)from the library. This item needs to be returned on (Due Date). --------- Everything works in my script except the first name field. I've tried entering the History Contact ID: Contact Name field as well as the Contact: First Name field into my script, but it isn't working. I'm not sure which…

Ummm, right, i brought up a point about where i should store my accounts a fair while ago in my backend (serverside) / frontend (clientside) split. Backend was logically decided to be the place to store the accounts. I have three issues. Firstly, the scripts which i've attempted to place into my backend and execute in my front end work as follows: when the back-end file is open, it will generate / suspend the account for the currently viewed record in the BACKEND. So the front end record that is being viewed is not the record which the script manipulates. Secondly it doesn't work at all when the backend file is not open. I am using the "Perform Script" script step an…

I'm wondering if there is a simple calculation formula for this: I have field that auto-enters a unique calculated "tourcode" for a bus excursion on a particular date. The code always ends with the letter "A" when there is only one bus for that excursion on that date. However, when there is more than one bus going to the same event, the code is the same except that it ends in "B", "C", etc., to identify the second, third or more buses. Is there a simple calculation or function that I can use in this field to automatically place the appropriate letter "A" through "Z" at the end of the code based on how many buses have previously been assigned? thanks in advance.

... I kind of have a bit of a dillema here. One would assume that Running a Script with Full Access Priveleges would allow it to run as if it was logged in with ... a Full Access Account... However, because i have 2 files, I'm coming up with an issue at the login point. I'm trying to set a variety of necessary globals at "startup" (both static globals, and ones from fields i.e. company details etc.) before showing the user the login screen (that logs them into both the front and backend).. with a full access script.. but the issue is the fields are in the backend and I'm seriously stumped about how this will work seeing as the script is in the front end. I …

How do you email a separate email to each email address (one per record) containing the corresponding record/layout as say PDF e.g. emailing out invoices or like a mail merged letter? Hope someone can help. Phil

Is it possible to get the email script step to create the eMail in HTML instead of plain text? My signature/logo etc disappears. Phil

I'm trying to find a quick, solid way to transfer data from multiple-line fields in HyperCard 2.2 to FM Pro 8.5. I have a small business, and have an invoicing-project tracking "stack" that has a multi-line field for the products/services offered ("Description"), and another that shows what each item/service costs ("Elements"). (Don't ask why it was called that, I dont' know either). "Description" holds each product/service, each one showing up on a separate line. Each corresponding line in "Elements" shows the cost for each entry for the product/services listed. The "Elements" entries will total to a field called "Total Services Rendered". It's important that …

I hope this is the right place I have two tables, one for electric meter readings and one for water meter readings. each meter belongs to a unit. I want to be able to enter the new readings once a month and and have the old readings update for an amount used automatically. As you can see my problem is with isolating the readings to the unit. I think I should be using a script but i know just enough about this to be dangerous. Any help will be greatly appreciated.

Hello, I try to master the webviewer to use as a line chart. I'm nearly there if I input values one by one but I know that you can work with variables too! Can you help me in how to define a variable: The Y-axe is supposed to contain all the values of a field in a table. The variable has to be named &y. For example the y-axe needs to show/contain all values from the field 1603 from table FUP. Kind regards

The Step is for a Calculation with result container. I.e. If ( File not found; pic a ; pic ... Whats the step that fits in File no found... Cheers, genx

Hi, I'm using FM7 on Mac OS with 3 macs networked using filemaker for our eye clinic. The receptionists computer is the host for the FM file. With new staff I find they sometimes close the host file when they click the little red button on the top left of the window. Is there anyway to prevent that, maybe by making a warning window to appear so that they can confirm they really want to shutdown the host? Appreciate any solutions to this. Thanks

I use FM8 and enjoy it but I don't have the training to understand it well. I need help to set up an email warning that a due date is approaching overdue (the number of days remaining is less than, say, 10 before the action required is done). I have a field that calculates the due date and compares it to today's date, displaying it as a negative number until the due date is reached when it goes positive. I want a script that will send an email to a certain address when the number reaches -10. Either every day from then, or maybe another when it reaches 0. I have tried to set up such a script but honestly do not know where to start, nor do I know how to make it work…

I need to know how to write a script that will copy a part number and a QC ID number from the current table, go to another related table and perform a find in both fields, and then either: a - Display the existing found record as a QC Form, or b - If "No records match this set of find requests", create a new record with that part number and QC ID number and display the QC form. So basically, I'd like to click the button and see the QC form whether it's a NEW QC form or an already EXISTING form. How do I script that? Thanks!

I am adding records to a database and want to mark some records as incomplete, so I can easily identify the ones I need to update. How can I easily do this? Thanks,[color:red]

Is there any way for a record to not be saved until the data entered is confirmed by another user?

I'm sure someone has done this before but i would appreciate any guidance on this. I have created a fm database in which all users assign tasks and notes to one another. How can i create an open script that will send users to an intro layout with a summary of only their tasks. Right now everyone logs in and has to fish through all the recodes to find their own. I can set up a sort but, how do i create a "found set" based on the user account name? That would hide everyone else's records. As always, i appreciate any advice. Thanks FM Pros

Greetings All, I am looking for a modular script or custom function that I can use to sort records both ascending and descending. I'm NOT sorting records in a portal. I know the field labels in the table view will do exactly what I want, but I can't use that view. I need one that can do either text or numeric data. If that means two functions, that's cool too. I know I can do this by creating scripts for each field and for each sort direction using a variable to track the sort direction, but I am looking for something with much less overhead. A custom function would probably make the most sense. Just can't find one or figure it out. I've searched …

I have a price list database that needs to be updated every week, we do this by importing the new information every week. My question is about automatically running the script every week. I want the records updated every Saturday so on Monday we have the current pricing information. I'm not sure how to have a script run at certain time intervals. Any suggestions would be greatly appreciated.

Hello All, I am new to this forum and I am a novice at filemaker. I am creating a database in which every record I create has an auto-entry serial created. What I would like to do is, based on the current user, add some text to the beginning of the serial. EI: If user A is currently logged on then "A1, A2, A3, etc." If user B is logged on then "B1, B2, B3, etc." The solution I have found is creating a script, using: *New Record/Request *Set Next Serial Value -Let ([ Acct = Get ( AccountName ) ; ID2 = ProspectIntake::ID#] ; If ( Acct = "A" ; "A" & ID + 1 ; If ( Acct = "B" ; "B" & ID + 1 ; If ( Acct = "C" ; "C" & ID + 1 ; "" )…

I'm using Open URL within a script of mine 3 different times. Basically, I have a button in filemaker that is used to generate HTML for use in an ebay description for that item. something else that has to happen the way our system is currently setup is that a .php script has to run to the add the item to another data source that the web uses (I'm changing all this now, but for now this it has to be this way.) So as it stands now I have 2 Open URL commands in the script. the first one adds the item to the web source and if you stayed on that page it would just display the fields that were added. the second Open URL command goes to a script in your browser which ge…

Is there any way I can check if an FM file exists in a folder external to my main solution folder. TIA Phil

With the cursor in a field, or the field otherwise in focus, using "Get ( ActiveFieldContents )" works as expected. When I make the field into a button, the field is no longer active after the click-event has finished, hence its contents are not returned. I want to be able to use a script using "Get ( ActiveFieldContents )" generically (i.e., not tied to any specific field). In HyperCard, which used a hierarchy for layers and objects, a mouse-click event could be passed (or not, depending on scripting) to the next layer/object after the layer/object higher in the hierarchy received the message/event, and so on. I mention this because the FM field-as-a-button seems to…

Anyone has problem with Replace Field Content Script step in FM Advance 8.5 on Mac. A very simple script, crashing every time when it gets to this step. There is no sharing just stright step ;)

I've got a set of customized files created with the developer utilities. Virtually all of the menu functions are turned off so I'mm unable to do much diagnostic work in the custom files. I've been getting a 101 error - record is missing - in the custom files. When I use the original files to try to diagnose the problem, I'm unable to reproduce the problem, so can not isolate the exact location of the problem. What causes this problem? What might a script be trying to do and what are the conditions for in the table when this occurs? That might help me figure out where and how the error is occurring. TIA

I have 21 separate fields in one table....each of which is either blank or contains "yes". I need to go through these fields one at a time to find if it contains a "yes". When I get a 'yes" I need to then go to a specific field in another table and fill it in (and that depends on what is already in that field). The two tables are currently related via a 6-digit school ID number....unique in both tables. Is there a way NOT to have to write 21 separate scripts referring to specific fields by name but rather write one script that dynamically finds the correct field in the 2nd table: I am thinking something like the following (knowing of course it is not now set up this w…

I've been trying to implement some advanced (for me) scripting using Set Variable with Repetitions. I've built this simple example to try to get to the core of the problems I'm experiencing. It's supposed to move the three text strings from a repeating field into individual fields in a seperate record, but it always moves only the first repetition. Thanks in advance for any help. Variables.fp7.ZIP

Hi, I am new here and reletivly new to Filemaker. I am just experimenting at this at the moment but am looking into implementing it at some stage soon. I am looking to construct a Point Of Sale interface (for a retail store) using Filemaker Pro 6 which works in unison with a existing database that stores information about certain products. I am planning to use a portal (or something similar) for this: What I want to do is have 2 database files, one for the products, and one for the POS interface. In the POS interface, i want to have a portal (connected to the products file) with a number of fields: Product#, Product name, Unit Price, Quantity & Total price. Wi…

This script is working every now and then but not every time. It's pasting the date & initials but leaving off the time. It's strange because every now and again it will paste the time too, but mostly leaving off the time. I need it to paste all 3 each time. GetAsText(Get ( CurrentDate ))& " " & Bailbond::Initials & " " & GetAsText(Get ( CurrentTime )) Thanks in advance for any help.

Hi, I have just started using File Maker Pro 8 and have been battling with a problem for about 6 hours. I know how to find duplicate records in my client database, based on name, address, post code etc, but is it possible to ask File Maker to omit the first record found. This will enable me to delete all of the found set leaving just one record for each client. I would do it my hand but there is 40,000 records to go through. Any and all help is appreciated. Many thanks

Ok sorry everyone for being so clueless but I just got into filemaker, I did a search on a few different topics about this but couldn't find any answers...Anyway here goes. I have a database that has people's information in it. Say two people are entered into the database and they are best friends. I want to be able to link them so that they are connected. What I am trying to do now is create a script that is sort-of a perform find of their best friend where I can jump to that person's "profile" or record. Here is a little scenario. Travis has a best friend Jon. I enter both Travis and Jon into the database and each has their own record. In Travis' record Jon is…

The Set Next Serial Value script step has two items in the Options section. One item is for selecting the field whose auto-enter serial number you wish to set aka the target field and the other is for specifying the number you wish to set it to.... The item that is for selecting the target field has a checkbox which, to me, indicates that it's optional to specify the target field. This is true of other steps such as the Set Field script step. If you don't specify a target field, the current field will be effected by the Set Field step. So, with that logic, I would expect that if you don't specify a target field in the options for the Set Next Serial Value s…

Is there a way to duplicate all the records of a found set without doing each one separately? If so, how?

I want to send multiple emails from within Filemaker, but want to see the Script dialogue first, so I can add an attachment if I want. The only way I see to add an attachment is within Scriptmaker. Also, I don't want multiple emails created through Apple Mail. If I click the "Perform without dialogue" option, the emails are sent nicely...but I don't see any way to get to the setup dialogue first. If I don't click "Perform without Dialogue", then a separate email is created for each record in Apple Mail. That's a pain. Don't want that. So...any help would be appreciated.

I have a multi-table database in a single file that references a table in another file via a relationship that I defined. Whenever I open the primary file I am able to access records in the secondary file via the relationship without opening the secondary file and the relationship works as expected. My problem begins when I close the primary file. If someone else opens the primary file they get a message saying the secondary file is in use. Acknowledging this message then brings up the open file dialog window expecting you to open a file to satisfy the relationship. Choosing the secondary file results in the same message. Canceling the message causes the relations…

ok here is something i was wondering im sure this may be easy but is there a way for me to specify how many weeks aprt something is ... ie i have a global field that uses the date(10/1/Year) and then i have a field that says Date ( Month ; Day ; Year ) is there a way for me to get the weeks in number difference from the global to the current date but not change over to the next current date till the global field passes 10/01/2007

I have the following script: Show Message ["Click cancel to stop transfer of grades"] If ["Status (CurrentMessageChoice) = 2"] Halt Script End If Perform Script [sub-scripts, "Update grade 5"] However, when I click the cancel button the script does not cancel but continues on and updates the grade. Any help would be appreciated.

Newbie question: Is there a SIMPLE way to create a script to move the cursor from one open Filemaker 8.0 window (different unrelated databases) to the next open window WITHOUT SPECIFYING THE NAME OF THE FILE. I would like to be able to move with one keystroke from one open window to the next--and ultimately back to the one I started from--in the manner of alt-tab between open windows in applications that create separate task bar tabs for each. Thanks.

I'm trying to setup a utility script that I can use throughout my application to update a field based on a ScriptParameter. In short, this is an example of what I want to do: Toggle the value in the field Invoices::checkbox_value between 0 and 1. When a button is clicked it triggers a script named "Utility|ToggleCB" and sends a scriptParameter value of "Invoices::checkbox_value" along with it. (Note: the script parameter is the actual NAME of the field, not the value) The script then needs to determine the value of the field sent via the scriptparameter and act accordingly. My problem is getting that variable, or script parameter turned into the ac…

Hi there, is there a way to add a check box to a dialogbox? How would I make a box with an check box option for: "Do not display this message again." Thx in advance

I need help with scripting to find the middle initial or name when full name might be John Smith, John A. Smith, or John Allen Smith. I can't seem to get the Middle Name field to be empty in the first instance.

I need to populate 2 global fields (Temp::TDG and Temp::TDG2) so my portal will automagically display the current months records. I have a portal that displays the records that have been created and you can filter them by entering the To: & From: dates and it will display. But I want to have it automatically enter the current month into the fields so it will display without the user having to enter anything unless they want to look at a different month. I can't seem to figure out the calc to make it happen because I want it to be dynamic so that if it see's 11/14/06 I want it to display To: 11/1/06 and From: 11/30/06. Can anyone show me what the calc might look …

I understand that you can use Ctrl 1-0 to activate scripts. Is there anyway to create more shortcut keys to activate scripts?

Is there a way to have a script/button activate only after a double click? I have a portal set up and I want to have users be able to select records in the portal and perform a number of predefined actions based on their selection. But, if the selection is double clicked I want to have a detail view window open up. I know I could put two separate buttons in to accomplish this but I hate to clutter the portal. The double click approach seems more intuitive and standard to me. TIA

I want to use a custom dialog box to get a element and drop it into a script. Is this possible?

Hello, I am trying to automate a constrain on a report with user parameters. There is a report that is pulled with all these conditions (already scripted in Summer 672)... Since the report has so much data, the user likes to preview it on screen prior to printing. So if the user just wanted to see a certain dept's pages in this huge report, I would like to make button so they user inputs what dept they would like to constrain the report to I don't know how to do this and to set up error catching on it..... we have 16 or so depts and don't want to set up 16 buttons (one for each dept). here is what I have so far... and it's wrong -Perform Script…

Is there any way to add info to fields in an external file without setting up portals in the original file. In other words I need to add data from the original file to the external file. I can do it with copy and paste but this seems rather inelegant

Can someone help with the following please? I want to copy a postal address (5 fields) contents from one layout, "Contacts" to another layout "Projects" address(5 fields)in . Thanks Greg

Hello, I have a script that I save a copy of the current layout as a pdf, but would like to name the file based on the values of two fields. I can't seem to get it to work. Here is the script. Set Variable [$Saveas; Value:Purchases::Invoice Date & " " & Purchases:Vendor &".pdf Save Records as PDF [Restore; No dialog; "$Saveas"; Records being browsed] after running the script I get an error message "2006 Vendor_name.pdf" could not be created on this disk. Use a different name, make more room on the disk, unlock it or use a different disk. The disk is not locked, or full. The problem appears to be with the date. Not sure why it is on…

Hi there, I'm trying to figure out the cleanest way to create a set of new records in one table based on the found set in another table. I have a table containing TEMPLATE records, or records that are used for the sole purpose of populating new records in another table. From a FOUND SET of records in the TEMPLATE table (3-20 records at any given time), I need to create an equal number of new identical records in a DESTINATION table. What would be the best way to do this? Is there a way to reach out from the DESTINATION table and step through the found set or does it have to be performed from the context of the TEMPLATE table? I'm hoping to get some idea…

How do I delete an item that is no longer needed from the Auto Complete Index and leave the rest there?

This is the script step I have. Set Field[GetAsText(Get(CurrentDate)) & " " & Bailbond::Initials] I want to add a timestamp to it, on the end, but I can't figure out how to do it. Would someone help please. Thanks Mitzi

Hi there I need some guidance in field lookups and auto fill. I have a passenger layout that has different frequent flier miles and password in it. in a different layout I have a name field that should display the name of the pasenger a option to choose flier miles and then after it was chosen it should automatically fill in the password in the password field. Please have a look at the file. Thanks a lot! TMAS fields.fp7.zip

Hello There Can anyone help me please... I have a multiuser FMP7 DB used for call logging. We have recently added the getmail & sendmail plugins to 'pipe' calls directly into the DB (which works great), however i'm having some trouble extracting data back out to use sendmail due to record locking. Users are editing records all the time and when a record is created, a mail is meant to be sent to our customer. I have created global fields which are poulated using the set field command with the relevant info to be sent. A script then runs every minute to see if there are any new mails to be sent. If one of our users is editing the record at the time, …

I'm using a script to navigate to a couple of list view layouts. One layout if for the status area showing, one is for when it is hidden. I copied the script from another database. For some reason, the script works in the other database, but not mine. I have the script attached to a button, but when I click the button or run the script from the menu, nothing happens. I have FMP 8, so I don't have the debugger. Does anybody know of a FM bug that might cause this? Here is the script: If [Get ( StatusAreaState ) = 1 or Get (StatusAreaState) = 2] Go to Layout [Get ( LayoutTableName ) & "_List1"] Else Go to Layout [Get(LayoutTableName) &…

Hi can someone please help? I have a table "contacts" which is all contacts. A new contact starts off as a "Prospect" selected in a drop down field (Prospects or Projects). When the prosprct becomes a confirmed "Project" the drop down selction is changed to "Project. I would like to asign a script to a button to enable me to list e.g all "Prospects" in a list layout with the sort criteria being the value of the Prospect/Project drop down box. Thanks Greg

Does anyone know a way to control the size of the dialog box that is generated by the Show Custom Dialog box script step? Or at least to make it so that it shows all text without the user having to click and drag to expand it? I know that it remembers it's size from the last time it was closed, but that is a workstation/user specific preference and if I expand it on one workstation it doesn't have an effect on the other workstations.

Hello, I have a question about using wildcards. I'm new to filemaker so I don't know what the notation is to use them. I have a scripted "find" function. What I'm looking to do is to use a wildcard so that if you don't enter the name exactly it will still go to the record. Ex: Record name is "January Inventory" the user would just enter "JAN" and it would go to the January Inventory record. if anyone has any ideas that would be great. thanks js22

I'm writing out some values to a text file in a FileMaker script, I would like the Number fields to be formatted like I have in my layout, where there is a decimal point a fixed number of digits following it. Is there a function that takes a number and makes it as text with this kind of formatting?

I start my scripts with 'allow user abort off' but I have just noticed that the user can press esc (windoze) and the script DOES stop. Anyone any ideas? TIA Phil

I'm trying to make a calculation field transpose a date into a text string with leading zeroes in front of single digit months and days. For example, I need the date 1/5/2006 to calculate to 010506 as text. The day(date) and month(date) functions seem to strip out any leading zeroes. Thanks in advance.

I'm currently building what amounts to an FM portal file, containing buttons that open various files on our FMSA8 server. This is to help simplify staff access to our databases, but I'd like to be able to pass the username and password to the file on the server in the script. Currently it just pops up the usual authentication dialogue box, which I'd prefer to avoid. Sure, I could set the files to use a certain account automatically, but I'd rather not, as some of them behave differently depending on the login, and I prefer the flexibility of a scripted solution. Anyway, I've found no way of doing this so far - is it even possible? If so, can someone tell me how? …

I've been converting a file from 6 to 8 and I've run into a snag when I run a script. The script allows me to add a new product to a Line Items portal on my Invoice layout. The dialog is, "This product description cannot be modified. Only the “Miscellaneous” product can have a custom description. Please check the Revert Field button to continue." I’ve been told that it looks like either a “Dialog from a script” or “Custom field validation message”. But I’ve been unable to find that in either place. Here are the actual scripts for your review. The first script is the button I click on in the Line Item portal to add a new record. “Create New Line Item Reco…

Is there a function or calculation I can used in a script that will detect when other scripts are queued up to run after it (in a paused state)? Not sure If I'm making this clear. I've got EvenScript triggering several validation scripts. Then I have a navigation script hooked to a button. When I click this button to leave the layout, the validation scripts will be triggered under certain conditions. When that happens, I want the navigation script to stop and not leave the layout. So I put a "commit records" in there first thing, which will set off any validation scripts. But then, what can I do get it to stop when those valid. scripts are triggered?

Hey just a question, im going to be working with a bunch of export to .txt files. and each week depending on the issue number the file will change from say 44010.txt to 45010.txt Now here is the question. Is there a way for me to specify the change of that first 2 numbers according to what week i am on?

Its like i have a layout that needs to sort everytime it is view, so is there other way other than binding the script to a button? Incase the user navigate through the side menu rather than using the button. Or there is a way to disable the side menu navigation? Sorry i am kind of new to fm.

Hello. I'm trying to use this function to determine which layout a user goes to when they open the file. I would think that is possible using this function but i'm somehow not able to do it. In the file option, i've set it to run the script when opening file. In this script, it goes something like this. If(Get(PrivilegeSetName)="DataEntry") Go to layout "Data Entry Page" Else Go to layout "View Page" End if This doesn't work and I can't figure out whats wrong. I hope someone is able to show me the light. Thanks in advance.

Please let me know if this question belongs under another forum. We are issuing a set of sequential numbers. The next number issued is determined by the last number issued. So the user looks at the 'ending' number field in Table A, then inputs that number +1 as the starting number in the appropriate field in Table B, then enters the 'ending' number in its field in Table B . When the record is committed the 'ending' number in Table B is written into the 'ending' number field in Table A. The question is: how do I keep a second user from seeing the same initial number in Table A (before the first user has finished and committed her record) and assigning a duplicat…

I have script step that ends with Print Preview so a user can view what a report will look like before he or she decides to print it or not. The problem is, in the Status Area (the gray bar on the left-hand side of the screen) the user is given two choices with the script: Continue or Cancel. If Continue is pressed the user is sent back to the switchboard, as scripted. However, if the user clicks on Cancel, then Browse mode takes over and he or she is faced with a page from the report instead of being sent back to the switchboard. Short of creating a separate, windowed script that would require a user to click their way back to the switchboard, is there an elegant sc…

I have a field called Gizmo. This field has 5 repetitions. I populate the fields with five scripts that say: Go to Gizmo[1] Go to Gizmo[2] Go to Gizmo[3] Go to Gizmo[4] Go to Gizmo[5] What I would like to do is reduce this to one script that merely says go to NEXT repetition. If Repetition 3 is already populated, I would like filemaker to recognize this then go to Repetition 4. Any ideas how to do this? Thanks, Jarvis

Added a button to layout, to which script attached. Goal is to enable viewing PDF doc whose name is present in current rec. Attached script to button that: 1) declares var, loads with value in field of rec being viewed 2) runs send event with these specs: Adobe Reader is Target App Send the [open document] event with *Calculation (where declared var value should be passed<--this is where problem arises!!! Bring Target App to foreground checked Wait for event completion... checked Result Error: The file "& $Var" ($Var is variable name) could not be found and is required to complete operation I'm not cle…

I would like to write a script that returns active databases only. Meaning, I want a list of only the databases that are viewable on the main screen not ones that are currently hidden or just referenced to (i.e. in parenthesis under Window > Show Window >. I know DatabaseNames will return a list of all the databases that are open (regardless of if they are active or not)...I want something a little more specific---just the active ones. Is that possible? Thanks!

I need some help to this: We have to calculate the total of days that students were absent of school. But when they are absent there are two options. Days that they are absent and bring all the required documents and days that are absent and they did not bring the required documents. Otherwise we have justified or not justified days of absenteism. If we have for example the month SEPTEMBER we have to check the 15th as justified day of absenteism but we have also to prohibit the client to check 15th as not justified day in the other tab. I hope you understand. How can we prohibit the client to check the same option in the other tab.

After running a Perform Find [Restore], I need to evaluate results of the Find. If no record is found, I want to add record to table on which Find was performed, or script will move to other table to load variable with value in next record on which to perform Find. I've tried testing get(foundcount) = "" and get(foundcount) = " " but neither is returning expected value. Running in debug, I know table BB has record with value "101" in field b. I start Loop from table AA, load variable with value in field a, in 1st record "101" Find should result in 1 record, so get(foundcount) should return value of 1 or "1", not a null as "" or " " should be read. How ca…

Hi, I have a small script problem I can't quite get to work. I have a layout with 365 fields on it (one for each day of the year) I want to attach the same script to each field so when it is clicked on, it takes the date and then does a find on some other tables. I have been using the script step 'Get(ActiveFieldContents)' but it doesn't work because you have to actually enter the field rather than just click on the script attached to that field. It looks like it can be done by the front page article "Set Fields by Indirection!" but can it be done in FileMaker Developer 7? Or should I just start creating 365 separate scripts : Thanks

I need to run a patch to upgrade my scripts in my custom Fmp 8 software. In this patch, I need to revise scripts in multiple linked databases. I can not find a way to AUTOMATE the EXPORT of my updated scripts into the existing scripts of the existing databases.

I have this very annoying problem. Occasionally the simple custom dialog (with only 2 buttons - Ok and Cancel) does not response when user click on the OK button. Sometime I have to shutdown FM to get it to work. Does anyone has this experience ?

I want to run some checks on a record when it's ready to be committed or before going on to input another record. That is, after the operator has input data into the record, I want to run a script to do checks on the data to make sure it's valid. (If a field contains "a" then I need to do checka, if the field contains "b" then I need to do checkb, etc. I've written a script that performs the checks I want, but if the operator doesn't click my "commit" button, the record gets committed and no checks are performed, and she can go on to input the next record. I want to guarantee that each record goes thru this check. All suggestions appreciated. Thanks.

Looking for a start with relationship structure. Table A. 15 Categories, ID & Name. A category can have 10 to 15 details, it will always be the same number and type of detail. Table B. 25 Details, ID & Name. Each Detail has sub-details with prices. Ideally, when a user selects an estimate category from a value list and clicks on an (enter details) button, he will be on a layout where all the category details are listed and the estimate quantities can be entered. I've considered portals for the quantity entry to a join table, but fear that at times some of the line items for a complete estimate would be missed without a reminder list. …

Hey Guys, I've got a fairly standard system that has the following tables: Orders OrderLineItems Quotes QuoteLineItems In a script intended to convert a quote to an order I need to duplicate the QuoteLineItem records in the OrderLineItems table assigning them the new order number (probably held as a script variable). What do people think is the most elegant way to do this. I'm sort of up in the air about using an import step or looping through each of the quote line items and using set fields commands to create the records in the orderlines table. I'm just wondering what people feel represents "best practice" in this sort of situation.

We are currently converting a large number of databases from v6 to v8, and I've come across my first real problem so far. A calendar db we have has some scripted buttons that show records for the current date + up to one month ahead. I noticed that converting to v8 updated the syntax of the scripts to be v8 compliant, but they no longer work. I didn't write the original scripts, but have managed to get only the one that selects the current date to work. Anything that appends a set range to the current date just pops up a dialogue box complaining about invalid find criteria. The important lines of the converted script are like so: Enter Find Mode [] Insert Cal…

Hello, I have what I think is a simple question. I am creating a databse that automates the creation of scholarship awards that often come from more than one account code. I currently have a series of nested "if" statements to handle the creation of up to 4 fundings, with variables such as the following: $account1, $account2, $account3, $account4; $letterRequired1, etc., etc. As you can see, I am doing the same thing over and over for multiple scholarships. I am effectively doing a loop w/o using the loop capabilities. I think I can put the format of my script into a loop by using repeating variables. My problem is that I do not fully understand how to store…

HI all, I have a global field that mirrors the Key field's value of the active record on a layout. I need it to update with the current record's Key field value as I flip through the records. I was hoping there would be a function such as "Get(ActiveRecord)" that could be used for this, but perhaps there's something with a different name. Anyone know?

I know this has to be here, somewhere, but I can't find it! Can someone please give me the correct syntax for Send Message to delete a windows file? I have a script that imports data from an excel file into my FMP6 app, and I want the script to delete the excel source file after the import. Also need the same for Apple Send Event command. Thanks.

Mac OS X, FM 8.5 How can I make Filemaker to do a Shell command in the Terminal.app? From Filemaker, I've tried the "Send Event" Script step with a "ls -l" shell command to see if it works, but it isn't. There must be a way to do a shell script from Filemaker, without the need to go via AppleScript...? Tia, /andreas

Is it possible to make a script excecute when a record is deleted and/or created without creating a button. Greatful for help with this matter ! PS. I use FM version 6.

Not quite sure where this falls under so hopefully this forum is appropriate as it is part of a script. How can I dynamically check the status of a field? i.e I have one script which runs, and I need it to check if(isempty(#field#) where #field# is whatever field they click on? get(activelayoutobjectname) doesn't appear to work as it's not "active" if it's just clicked on :-S TIA

I'm creating a simple script with show custom dialog box that will greets me if its "morning", "noon" "afternoon" or "night". but somehow i can't say simple thing like find me a range from 8am-11am. so help me God. " if (Get (CurrentTime) < "4:00:00 AM") and (Get (CurrentTime)>"11:00:00 AM") Show custom dialog ["Good Morning"] if (Get ( CurrentTime )>"12:00:00 PM") and (Get (CurrentTime )<"1:00:00 PM") Show custom dialog ["Noon Time"] if (Get ( CurrentTime )>"1:00:01 PM") and (Get (CurrentTime)<"4:30:00 PM") Show custom dialog ["Good Afternoon"] . . .and so on. " Please tell me thats not a right way to do time range. Thank…

The database in question will have contacts with email addresses, and then also a series of documents stored in a separate table, in a container field. The user will basically select a contact, and then also select one or more documents. (The reality is much more complicated than that, but that's the essence of it.) What I need to do is then script the sending of an email. The user will choose a template for the text of the email. Then the db must attach all of the documents selected from the Documents table. Other requirements: * the docs will be of various types (word, pdf, image, etc.) * the docs must retain their original filenames Is this possi…

Hi All, I'm working on a delete duplicates script based on some posts i've found on the forums. Obviously, i'm missing something. }:| I've posted the script I've created here. When i run the script, i can tell the find all part works, but then, very quickly (way too quickly for it to be checking duplicates - like a second or two) the script ends up at the last record. Here is the basic premise/thinking: GLOBAL is a global storage container. - find all records - sort them by email address - set global to a calculation of 'email address with name' - compare GLOBAL to actual 'email address with name' - if = delete record - if …

Hi all, I posted this to the shout but was told the question would be better asked in a forum. Sorry. I am new to Filemaker. Not new to computers at all. I inherited a FM DB when I started a new job and I am trying to modify it. SO far I have been doing ok but I am having an issue with something now. I want to write a script that goes to the top of a field, makes a new line, enters the date and then makes another new line in preparation of entering text into the field. So . . . you click an "Add new case notes" button then in the case notes field the cursor goes to the top of the field , adds the date, adds a carriage return and then awaits input. I have m…

Instead of hard coding a field's name in the Go To Field script step, I am wondering if there is a way to put a field's name in the script parameter box at the bottom of the Specify Sript Options window?

First of all tx in advance for reading this post. I'm not a programmer at all, so I even don't know if I'm asking to do this in the wright coding language: In essence this my project }:| I have a .log file that I need to convert structuraly to make it usefull in FileMaker. - open the logfile - In the .log file there is a character that needs to be replaced with another, to be able to convert it more easely into colums. - Delete colums the Second and Forth colum (in excel since the shift places it is first B, than C) - Then those colums needs to be transposed (rows becomes colums) in order to be able to import them into FileMaker. …

I have a very simple script (in FM8) that when users launch a runtime solution they're taken to a main screen where there are four buttons for them to click on to take them to other layout screens. (The four scripts are very simple: "Go to Layout..." and that's that.) Frequently, and I don't know why, when the users launch the runtime solution and are presented with the main screen, they'll click on any/all of the four buttons and nothing happens. However, if they go to a different layout then come back to the main screen's layout, the buttons work. There's no rhyme or reason when this happens; sometimes everything works, other times not. Any ideas what could be…

I have a database which shows the names of all files in a folder. I need to be able to be able to make so that when I click on the field title in the database that particular file is opened but i am not sure of the way to be doing this. Can anyone help please