Script Workspace and Script Triggers

Here is a simple problem I'm sure, I'm just a litle dense today . I have a file with 200+ records. I want to be able to pull up a random record from that file and display it. For example "FlashCards" for training purposes. Basically I wnat to integrate a button with the function of get_next_record_RANDOM. Any input is, as always, appreciated. Thanks, Rob

I have a text field with a value list assigned to it. Each value is tied a different script action. Once the user selects a popup value, then a button must be pushed to activate the script. Is there a way to lose the button and make the script occur after making a selection from the list? Advanced Thanks, mb

I am creating a database to track items on purchase orders. Each purchase order we receive from our customers can include products from any of twenty different suppliers. We must place orders to each of our suppliers for these products. I need to find a method in which, after entering the purchase order in the database, each product in the purchase order would be copied to a page specific to only that company (so that we can then use this page to place our order to that particular supplier). For example, if a purchase order contains products from companies #1, #2, and #3, I need to have all items for company #1 copied to a particular page, all items for company #2 copie…

I am looking for a way to either tab to different fields depending on the value of a given field, ie if Field A is "x" then go to Field B, if it is "y" go to Field C, but I do not want the user to have to click on a button. Field A will be a set group of selections from a value list. If this can't be done then is it possible to have one field (or set of fields) appear in lieu of another based on the value of Field A? As before, I'd like this to be "automatic" without the need to click a button. TIA for any feedback. EasyEdE

Hi, I'm trying to do a "add new request" in find mode for my script. But I don't see this option available in Scriptmaker. I want to do a find in one field, and another find in some other field, but I want the results for both. Not if option 1 AND option 2, but if option 1 or option 2. There's probably some simple solution out there. Thanks, Henry

Hello, is there a way to paste text into an existing value list. The idea is to do a search ,then take that criteria ,paste it into a global field ,then when the resulting records have been edited (omitted) i can press a button which pastes the global field into a value list .this then can be used to "re-search" at a later time. i am a bit of a newbie so be gentle thank you in advance Paul apted

Hi there, I'm a real novice when comes to FM but I'm the only one in the company (8) that knows enough to try and the db. I'm trying to create a button that will enable the user to click on and it will generate the date, time and user name. I checked everywhere and it doesn't seem to let you update multiple fields. Please help? Thanks Mark

Okay - This is kind of an addtion to my previous thread - on looping. I have the initial loop created, but I now realized that I have portal rows(just one portal) that need to be duplicated as well. How can I add a loop of some sort for the portal rows to my current script for duplication of my records. Here is an outline of my current script: Show All Enter Find Set Field Set Field Perform Find Sort Goto First Record Loop Duplicate Record Insert Current Date Page Setup Print Set Field Omit Record Go to First Record Omit Record Exit Loop If (Status(CurrentFoundCount)=0 End Loop Somewhere in there - I am assu…

I'd like to remove all fields that aren't used in a database I got. Is there a way to find out -myself, without any help of analyzing programs- which fields aren't refered to (or are) in the scripts? Thankyou for reading and eventually answering my question. Mich

i am having some trouble creating a find scrpit that will find on my balance field, a set vaule. For example i need ti find all records with a balance greater than zero. i have tried this several ways i just can't seem to have it enter the ">0" symbol in this field automatically. please Help RET

Is there a script step that returns the location of selected text within a field? That is, if sample = I am fond of cheese and I have highlighted 'of', is there a function that will return (11, 12) to indicate the start and stop of the highlight? OR any other way to acquire this information?

I'm attempting to do the following - when a new record is created, a button specific to that record would be created on the "switchboard". The button would open (goto) that record when clicked. When a checkbox is selected on the record, the button is deleted. Would this require scripting? If so, how difficult? Thank You.

I'm having problems formatting my database using xsl. Even when I use css, it doesn't do it correctly. But when I use xsl, it doesn't work at all. I get the message: "Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. " I'm using the url with the tags in it like this: "-styletype=text/xsl&-stylehref=http://192.168.254.205/xsl1.xsl" What could be wrong with how I'm doing this? Any ideas? Thanks, Zach

Not sure where to ask this but it might involve scripts. How the heck do you create a tabbed interface- you know the kind of thing where you have several different layouts and they all have a tab sticking up with a label on it? Then you can click on the tabs and jump from screen to screen? Is there a tool for that or something? I got a book called "Using FileMaker Pro 5" by Rich Coulombre that mentions the "tabbed interface" but gives no info about how to actually create it.

Okay - Loops should be simple - why do they get the best of me. Go to Layout (invoice entry) Go to Record (first) Loop Duplicate Record Go to Record (next, exit after last) End Loop I will add the other stuff later - I am just trying to get my base loop to work first. It pulls the first record and then is done - what am I missing. Thanks for your help

Hallo, I have the same problem I have had a couple of times before - maybe you can help. I want to take text from a number of fields and concatenate it in one field. This is the easy bit =) But I want to insert a return between each of the entries I am adding, because otherwise the text all ends up on line and is - for a human - very difficult to read. I have searched around here and no-one seems to have an answer for this... I cannot use related fields, as the text entries I am dealing with are contact reports and range in length from a couple of lines to a couple of paragraphs. Therefore I can't make a field that will accommodate them all …

I'm trying to write a script that will take a date (mmddyy) and give me the date (mmddyy) one year from that date it's for a warranty date base, it is driving me nuts. Any and all help would keep me from formating my hard drive. thank you Nerd

I have 1 database (DB1) that stores standard client record information (name,addr,ph,etc.). I have a second related database (DB2) that stores contact history. New contact records in DB2 are created when a user clicks on a button in DB1, which runs a remote script in DB2. The remote script enters browse mode, creates a new record, displays the client name and ID from DB1, and enters the name of the person creating the history record. The problem is that if there aren't already records in DB2, then the script creates TWO records. Single stepping showed that it creates one when it opens DB2 and enters Browse mode, and one when it runs the "Create new record" part of the scr…

How can I prevent the user to use "show all records" and/or use the keyboard shortcut to view all records? Thankyou for reading and eventually answering my question. Mich

I have a script that uses the set field command, that when executed, changes a field (formatted as a pop-up) to "Yes." The problem is that the field is in a portal. The script works, but it will only change the first line of the portal. If the portal has entries in more than one line, it does not change the pop-up field to "Yes" in any other lines (related records) except the first. Is there a way to get the script "set field" to change all the fields in the portal, no matter how many lines (records) there are? LR

Is there a way to configure a script to easily do a find that finds the current record being browsed and omits all the others? LR

Is there a way to have a script goto a URL and grab the web page and either insert the results to a field or save it to a file? TIA Dave

Hello all, I'm brand new to scripts, have only written one simple one so far. But, that said, I need to create one to do the following, and I don't know where to begin. I have two fields: zipcode and postalcode If a US person enters a zipcode, they should be locked out of entering any information in postalcode. The reverse is also true, if someone enters something in postalcode, they should be locked out of zipcode. However, if they delete their entry in one, they should be allowed into the other field again. How can I do this?? Thanks! -Lynn

Hi experts, I have a master database called Building and a detail db called Units. There is a relationship from Unit to the Building using a Unique Building_Code. I have a Building_Name_Temp field in the Unit record which at the moment looks up the Building_Name from the Building database. You may wonder why I could not just show the Building_Name as a related field in the Unit database. I need the Building_Name in the Unit database locally for some other purposes. It looks up the Building_Name properly when I create a new Unit record for a Building. My problem is when there is a change in the Building_Name in the Building database I also want to update t…

Sometimes when my users switch to a preview of a report they have their page setup wrong (landscape as opposed to portrait) and it looks weird! They think something is wrong. Is there some way through scripting to force the page setup to always be portrait?

Has anyonefound an easy way to list all lines of a repeating field across records with in single list

This should be simple. When I open my Purchase Order Database it opens a related file Companies. How do I create a button on the Purchase Order Layout that will bring up the Companies layout, without having to go up to the Window Menu?

I have a search layout in which the users enters a date period in a field and after he clicks on a search button opens a report layout with the period the user chose in the search layout. In the search layout there is a field that is the creation date and the search button has a script that copies to a global field the creation date entered by the user and sets other two global fields with the beginning and the other global field with the ending date. For that to happen I used the function left and right. It works well if the user typed the date like 02/02/02...02/03/02 and for the left function I have left(_gperiod1, 8) and the right function I have right(_gperi…

Hi there, I have a report layout which has a serial number, description and amount fields. I also have a summary field for the total which is displayed in the footer. I need to prepare a report (preview mode) so that in the second page onwards I want to show the brought forward amount (which is the total amount of the previous page) in the header part. Has anybody done this before. I am quite new to the FMP. Your help will be much appreciated. Thanks, Hameed

Hi all, I am using FileMaker U 5.0v3 on a win2k server with Outlook. I made a scheduled fmp script that automatically (no user interaction) sends an e-mail with attachement. It works fine for a while. Then it stops working. The script will do everything BUT the SEND MAIL step... it seems it is simply ignored. The only way I found to make it work again is to create a new SEND MAIL step (with the same parameters) and delete the old one. Then it works again for a little while... Any idea what the problem is I need the process to be completly automatic and the e-mail MUST include an attachment so the Open URL trick won't work. Unfortunately it has to…

Hi! I

Running FM 5.0 on Mac 9.2.2 Here's something weird. I have a big script that runs a dozen sub-scripts one after the other, to prepare data for export. Yesterday I added one new subscript to this, which essentially found a small set and performed replaces on a dozen fields. I tested the subscript and it ran perfectly. However, when I ran the main script, it halted telling me it couldn't find that subscript. Scriptmaker shows that Perform Script step as <unknown> and my new subscript is gone from the script list! I rewrote the subscript, and redid the main script and tried it again. Once again my new subscript vanished from the list and the Perform Scr…

One of the best kept secrets is the zero pause. If you insert pause script with a zero seconds value you can activate many other script steps such as go to and select a field with a value list. Any ideas on why it works??

Hello everyone, I'm new at this forum, so maybe my problem already is solved, but here it is: Is there a way to connect a key combination i.e. Shift+F5 to a script/button

Hi, I know this question should not belong to this section, but I don't know where should I go? Please forgive me. Anyway my question is there is anyway that I can a serving filemaker files from a Internet browser such as Explorer, and Netscape, etc.. for example I just type some path name from "URL Address" of the browser. Thank you for any information

Hi all, have stumped myself trying to figure out an accurate way to script page #s with columns conatining fields that slide up and reduce the size of the enclosing part. Without sliding, I just script or calculate the # of records visible per page, and divide the total number of records by that. however, when the # of records per page can vary depending on the sliding (amount of text in field), this no longer is an accurate method. anyone encountered this problem before? Thanks

I have a script which contains multiple other scripts. I'd like to give the user the chance to abort the script early enough to halt the other impending scripts. I have a message that asks if they would like to continue but the "Cancel" button doesn't stop the scripts. How do I get the "cancel" button to work?

I am trying to create a report from a running balance field. The things is that I only want to list the records with names and balances that owe money. In other words I only want to list records with balances above $0. How would begin to create this calculate this? RET

I have a simple inventory database for t-shirts. Now I need to be able to find out how many of each size shirt have been sold. Any ideas? For example: One record has the shirt name, quantity for 8 sizes, date. I want to be able to compare previous data with new data so I can determine if shirts have been sold. Then update another file or field with the difference and keep a running total. And this needs to happen for each record. Let me know if you need more details? Thanks

Hello, i need a script that exports not only tha fields but also the images that i have put into a particular field named "foto". How can i do that? Thanks in advance

I'm not to sure how to go about this but I have a few users that play with some buttons including the new records button, thus creating lots of empty records. This might be very easy but I can seem to figure it out. What I need is to preform a check.....Are you sure you want to create a new record? Yes or cancel. to give the user a chance to cancel before the record is created. Any help? RET

I'm trying to set up a script that tracks he history of changes to a record, and it's very dependant on the "ModifyTime" field being accurate, to the second, but it only updates periodically, like every minute or so. Is there any step that I can add to the script that will make sure it's updated? "Refresh Window" doesn't do it.

I have two related db's. When I make a new record and then enter the acct # in one field, I want it to add the same number to a new record in the other (related) db. How do I do this? I've been trying various scripts without success. Each db has the same acct # field. thanks

How do I script a report that is blank after finding 0 record in a query. My current output layout has a header but the preview is blank after the find. I would like to still print a page that reports no records in the find.

I have two fields that I want users to enter data, and after entering data in the last field, I want them to be able to just hit "enter" on their keyboard, and have a button that is on the form activated. Is there anyway to accomplish this? All I have seen is that the user must click on the button. Any help is much appreciated. Thank you -Paul

With W98 and FmPro 5.0 I could let my desktop telephone connected to the PC via COM-1, such via the W98 dialer, dial a telephone number. In Windows 2000 this does not work anymore. I have installed the proper TAPI driver. Also in Windows 2000 the simple database software that came with the telephone dials out OK. Can anyone please tell me the settings I have to enter in the Windows 2000 dialer? The support from the Filemaker helpdesk was only frustrating and not even knowing this feature... Pse also forward reply mail to [email protected] Thanks ! Jan L.F. Bos

Is it possible to create a script that, when i klick a checkbox in FM creates a new folder on my server for example, i create a checkbox named "images", when i click the hexbox in FM on my Server it will create a folder named "images" someone?

Hey guys, When I use a command "Goto related record" and there is no related record in other file - the script does nothing. How can I recognize that there is no related record and react respectively on that event? Is there any status function to recognize that? (I would like to view all records in such a case). Thanks for help

Can anyone please explain the steps for creating a script where my database will open in browse mode with 1x zoom view? This will help me out alot since the text is so small now after I had to drop from 12 font to 10 font for printing. All the fields were not showing up in printed lists. I don't want to have 2 different layouts. Just open in browse with 1x zoom view. Any ideas how to remove the big, white empty area on the right side that is left over from when I moved the fields to fit on preview mode for printing? Even with 1x zoom, there is still a good size blank area on the right, but not as bad as with no zoom. Thanks.

In a nutshell, my basic question is: Can movies and sounds be activated in a filemaker app by a script? As far as I can tell, both filemaker 4.1 and 5.0 (the two versions I currently have) force the user to click a play button on inserted movies and double click on container fields to hear sounds, music, etc. I ask beacause I have an application I want to build that will require Filemaker to behave sort of like an electronic story book where videos and sounds are activated automatically simply as a result of the user "turning a page" i.e. clicking a button or link. I'll be building this with either Developer 4.0 or 5.5 and deploying it as a runtime, d…

I need to use a script to highlight changes. Can text within a field be formatted using a script (such as changing the text color or style)?

The online help of Filemaker warns that the output of Status(CurrentMessageChoice) is 1 2 3 on Mac, and 0 1 2 on Windows. A friend of mine experiences on Windows 1 2 3 as it is on Mac. It seems to me it would be rather a handicap if the output on Windows is indeed different, you should rewrite your scripting, or catching the system (Mac/Windows) used with the status function developed for this.. Can some superuser shine his or her light on this?

"Your divider might be a comma, or a semicolon." I use semicolons, here on the forum I often see comma's. Next thing you see is a question mark.. Is there, considering cross platform functionality, something to keep in mind about this? May it be that in some circumstances scripts and calculations with semicolons are not valid as a comma is expected? Harry

I'm trying to allow end-users to delete records, but only through a button which can check various details and make sure that it actually *should* be deleted. The problem is that I have to make their available commands "Normal", so I can't just give them permission to delete and only let them use it when I give them a button. Currently, they just don't have permission to delete. I thought that if I set up a script to delete, it would override that lack of permission, but it doesn't seem to. Any suggestions?

I'm trying to use filemaker as an automatic database who recives data from a media workflow management system. I've writen a script that analyses whats in the third post and creates new posts and also calculates new values in other new posts. The problem is that there will be about 25 different values that will need to be changed and calculated. Example: Data: NA, SUM 4000 should become:NA=US.CA.SD.HU.BE and SUM*0.6 SUM*0.24 SUM *0.03 etc This is done by a Loop/if script. But as the script grows speed goes down etc. Is there another wa of doing this? /H

I want to build a script on an opening file that detects if the main file has crashed (error 805) then opens the backup file. Any ideas?

Hey, I've written some dbs in FMP - but this is first time when use one in a network. It is not complicated, but works so sloooooooowly (having just 3 comps) - it takes about 6 sec to perform all scripts. DB exists in a server (NT 4.0) - it is run as a host and opened by 2 users as guests. All db consists of 5 files (in FMP called databases). Calculation requires to find some data in other files (using perform external script) and then returns to original file. Why it is so slow? I noticed that being a guest - even when I had opened the other file before (having two files opened) - performing an external file - it reopens the file again from the server (host) and…

I have a script that contains a string of about 6 actions. Is there a way that if at any point the script is interupted or canceled that a single action can occur, say something like returning to a certain layout. LR

I posted a question yesterday about puttinga PDF file into a container field. I figured out how to do that. Now I have another related questions. If I insert a PDF object and click the link button when I put it into the container field, is there a way to get the pathname out of the container field and into another field? I would like to get the path from the link and then write a script so it will open the link automatically. Is this possible? I tried several different things but no luck so far. Thanks, John

I am working with FileMaker 5.5. I have to fields, field-1 and field-2 What I want is: if field-1 contains the word "Leak" then field-2 must be filled in with "Yes, No or Not Required" which is selected from a popup menu. if field-1 is empty then field-2 should be empty can someone please help with a suggestion

I think i've FINALLY figured out why my scheduled scripts sometimes crash and other times run fine without any explanation. I have a script that runs every 5 mintues. At scheduled times, it executes another script. Unfortunately, they sometimes execute on top of each other (Another goes while the first is still running). I was wondering if there is any way to "pause" the first script while the second is running. As I'm writing this, i realized i could set up a variable and if/then an exit code of the variable ='s, but still, is there an easier way? Thanks -j

Hello, I have created a simple database for restaurant listings. The fields are Name, Address, Town/City, State, Zip Code, and Phone Number. My listings are currently in .doc format from MS Word 2000. They are in single line form with the name with a dash(-) then the street address with a comma, then the town/city with a comma, then the state with space then the zip code with a comma, and then the phone number. Here is an example of what all my listings look like: Elkhorn Bar & Grille - 38750 Highway 82, Aspen, CO 81611, 970-925-1500 All my listings are categorized by state, so I have 50 different .doc files. There are over 11,000 listings, so…

I just got a project to create a DB that holds all of our MSDS Chemical listing documents. Most of them are sent to us in PDF format. I wanted to just create a container field and then insert the pdf files into it. I was hoping that it would show the contents of the file and not only the link to the file but it won't. It gives an icon to click on and then it opens up the file. Is there a way to get the file to be displayed in the field? Or is there a way to create a script that will open the file that is inserted into the container field? Any help would be appreciated! Thanks, John

Thanks for all the help. I finally cracked it - dont know what I was doing wrong but I can now feel confident of importing as required. All the best John Carpmael

Hi there, I have a relookup that searches all my records. Records are broken down into 3 categories. The first record on two of the categories are not updated, does anyone know why? Before I begin the relookup I first make sure all records are showing. I am open to any suggestions. Thanks in advance, -Morning man

Hi, I have two related databases: Clients and Agents. As a client is entered into the Client database I want to be able to assign an agent from the Agent database. This is how I did it. In Client when I hit the Assign Agent button, this triggers an "Add Agent" script which runs the external script, "Get Agent" in Agents. The steps in this script are (sub script is denoted by >>>>): Perform Script[sub-scripts, "Select Agent"] >>>>Enter Find Mode [ ] >>>>Go To Field ["Last Name"] >>>>Perform Find [ ] >>>>Pause Resume Script [ ] Copy[select, "Agent# "] Perform Script[sub-scripts, Extern…

I have the following script. Show Message ["do you want to continue?"] Go to Layout ["Budget"] Page Setup [Restore, No dialog] Print[] The "Show Message" script window pops-up and gives a warning. The two buttons are "ok" and "cancel." Is there something I can add so that if "ok" is chosen the script continues, if "cancel" is chosen then the script does not continue? LR

Hi, I was wondering if it is possible to do a If..Else structure in such a way that when I select a certain field from a pop-up list, the pop-up list used by a second field is different. Made no sense? Well, to explain it a little bit further, suppose I have two text fields called Country & Culture (Both use pop-up lists). For every country, there is a separate list of cultures. Can I define various different value lists for these cultures, & make it so that the field knows which value list to use depending on the country chosen? Or is there another way to acomplish the same without using pop-up lists etc. This is a database that is fianlly going …

Okay. I've read through the posts looking for information about triggering scripts at a certain time, hourly, etc., Apparently there are solutions using Applescript and there are also some plugin solutions. It also appears that there is no simple way to do this with Filemaker. Is this correct? This seems fairly bizarre. Apologies for the multiple post. I just want to affirmation. :-P Tim. ps. If this is correct, can anyone reccomend the best way to do this? That is, which plugin, etc,?

I'm using a plug-in from Dacons called launch-it to relate specific documents to individual FM records. The plug-in relies on FileMaker's File:Open module which, by default, looks for files of type "FileMaker Pro". How can I change this to "all files"? Thanks for the help...

Hi- I've written a script that will 1) send a user to another layout or 2) cancel the script. That portion of my script works, but if the user clicks on the "x" at the top right corner of the message window they are sent to the other layout. What I would like to happen is if they click on the "x" then the message and script are canceled. Is this possible? Thanks in advance for the help.

I want some help with a scripting problem, please. I have an application which I have written in Filiemaker Pro5 and which I have used Filemaker Developer to convert into a stand alone solution. The application uses 39 seperate files. I have distributed it to a number of users in both Mac and PC format. I am now ready to upgrade the application. This will involve importing data from the old version into the new version. I need to create scripts to do the import for the users. I have tried using the

can i assign a background color on a field depending on the result of the field. eg field="Yes" background="Green", field="No" background="Red"

I think I have a tough one here... I have a text field that when populated, looks like these examples: Record #1 -- 2 days (Tony), 5 days (Chris), 1 day (Andy) Record #2 -- 3 days (Chris) and 4 days (Julie) I already have a script that will find all of the records needed, but I want to add a line to the script that will parse the undesired data and sum the desired data. For the above examples, I would want a line that would go through the fields and strip away everything except for "Chris'" entries and add up the days, which would be 8 days. Is this possible, or am I hoping for too much? If not, I'll have to export everything i…

Today I stumbled upon what I think is a bug in FileMaker. It seems that when clearing a date field over a relationship, like this: 1. Set Field([relationship::date_field], "") FileMaker instead of a blank entry in the date field, displays a question mark to indicate invalid data. However if I use: 2. Set Field([relationship::date_field], TextToDate("")) it works. But 1 works in a local file. My environment is Windows 2000 and FM Dev.Ed. 5.5. Has anyone else seen this? /Daniel

Hi, Does anyone know if it is possible to run a script when the value of a field changes. I have a basic order process of a order -db which has a portal to orderitems -db . Basically the orders -db holds the portal linking to the order items (linked on the orderid). the orderitems calls up the delivery format from the orders database and then works out the delivery costs etc. trouble is, if they change the delivery format it only updates the formats - the prices etc (which are lookups) don't update. I understand that you need to flip between browse and preview mode - is there anyway of doing this with a script that is triggered by the form…

I am using a script to open another file to access data that needs to be changed. The problem is that it opens it behind my existing file. In the past when I have used a script to open another file they have always opened to the front. I have tryed all the options I can think of to move this file so when the script runs the file opens infront of the current working file. HELP! Thanks, -Morning Man

I am trying to make a script that will perform a script (find) and populate a field (field1) with the CurrentFoundCount, then run another script (find) and populate another field (field2) with the CurrentFoundCount again. I am using setField to do this, but for some reason it clears the results of the first find and only fills in the results in the last script. For example: Script 1 = 4 records Script 2 = 8 records Results, Field1 = Blank Field2 = 8 My ultimate goal is to have a script that will run 14 sub-scripts, filling in the CurrentFoundCounts for each script. If this is possible, will I need to create 14 differ…

I'm working on a schedule-maker for teachers: 1. I have three fields: LastName (text), Team Partner (text), and Team (calc that puts the other two together). What happens now is I get a list that displays Smith, Jones, Smith/Jones AND Jones, Smith, Jones/Smith. Naturally. Is there a way I can have a script pick up that Smith is duplicated in another record (as Jones' partner) and eliminate one of them since they go to Art, Music, etc. together? 2. One one layout, I have a field (text) to type in times that each period begins. This varies from school to school. When the schedule is generated, I want to ba able to grab that text and use it in a script. Right now, …

Is there a command to exit all currently running scripts? I know there's exit script, but if i'm 2-3 levels deep in scripts i want an easy way out. Thanks -j

I guess it's fun to be called a "newbie" by the list software. Been programming 25 years, since junior high, paper tape, punch cards, TeleType and DecWriters, BASIC, Fortran IV, WATFOR, APL, Burroughs Extended Algol, Lisp, Pascal, C, C++, ... Anyway, here is my problem. It's multi-disciplinary because it includes scripts, layouts, fields, relationships, the works. So apologies for not knowing into which forum to place this question. I am trying to create a letter to parents of campers in Ukrainian. The layout is stored in file >master<, which has relationships to files >families< and >children<. The scripts are in >master< as…

I am newbie with FM and I have a very stupid question : How to create a script wich determines the minimum value in the database for a specific text field ? I hope with you can help me

I need to put quotation marks into a set field. Unforutnatly, FM things of quotes as a marker to say when text starts and stops. Is there a way around this? THanks -j

I am trying to create a script that will copy found records from one FM file to another FM file. Could someone please help me with the basics of how to do this.

Hi All, I am creating an online registration form using FMPro as the backend database. Users are asked to select a date and time from a drop down menu (whose values come directly from a value list within the FMPro database). Whenever a given date and time has reached thirty registrations, that date and time should be removed from the value list, signifying that it is full and no more registrations can be accepted. Therefore, when another user returns to the website, he/she will not see the dates and times that are full. My question is this: have any of you ever wrote a script to facilitate this kind of action? If so, please feel free to respond. I do…

Hi, I am new to FMP, and was wondering if it is possible to make a button such that when I click on the button, a file opens up in Picture Viewer. I am new to Macintoshes too, and don't know how File paths are defined in Macs. I tried using a script for opening a file, but don't know how to specify the file path name. Also, I am using a database with thumbnails of pictures, and want a button under each thumbnail which launches a full sized picture which is in another folder. I am using FMP 5.5v2 and MAc OS 9.2 Thanx Shaunaq

I am trying to create Zoom In and Zoom Out buttons. Is there a way to get the Zoom status of a the current layout. I am only wanting to zoom down to 75% and up to 200%. Is this something that is easy and I am missing it. Thanks for any help. Brian

Hi, Iv'e got a database that holds infomation about jobs that we have in the company. What I would like to do if possible is when I open a layout I need a message saying "please enter job number" and a box where I can put the job number in then press OK and it will find the job number. Is this possible and if so has anyone got any ideas of how to do it. Thanks for any help. Chris

I have a Filemaker system with 32 files and I have different passwords with different privileges for 15 users. Everytime I have to change the passwords and privileges I have to do it going though all 32 files. Is there an easier way of changing the password, like using a script so that I don't need to go through all the 32 files ?

Can I adjust my oval tool corners? How? (I couldn't find a forum for this q.)

hello, i am trying to add a conditional to my startup scripts. if main.fp5 is NOT open ...show message "Please start from the Main Menu" ...quit application else ...do normal startup stuff end if in other words i cannot have people starting from the clients.fp5 file, they have to start from the main.fp5 file. how do i do this? thanks.

I have Kiosk application. Is it possible using FileMaker Developer to disable any of the following windows key shortcuts? Want to disable "ctrl-alt-delete" key combo. Want to disable the "Windows" key that launches the Start menu. On a kiosk application, you can understand why I would want these keys disbaled? Thank you.

Using FP5 on a PC: To copy a field I seem to have to first switch to a layout that displays the field not just be in a file that has that field. Is that right?

When I import data to my FM database, the text is all UPPER CASE. I would like the text to be Title Cased. Example: (FRED FLINSTONE) ---should be--- (Fred Flinstone) I have created a calc field, to begin with, using the following suggested script. Upper(Left(UpperCaseText, 1) & Lower(Middle(UpperCaseText, 2, 100) I must confess, I do not understand scripts very well at all and the above looks Greek to me. I did try it, but it returns the text in UPPER CASE yet. Can someone please suggest how to modify the above script so it returns the text in Title Case? Thanks in advance.

I want to put a button on my Purchase order form to create a duplicate record. My form is related to another file for line items, which I input through a portal. The problem is when I duplicate a record none of the portal items show up. Is it possible for FM to duplicate the contents of a portal too, or do I have to avoid using the portals?

I have a key that looks like this: HF000151. I need to take a zero out of it. I need help with a script to do this. I have over a 1000 records I need to apply this change to and I don't want to go through and delete a zero on every record. The one tricky thing is that there are two different size keys, one is 8 chars & the other is 9 chars. If anyone could help out it would be great! Thanks, John

I have a repeating field that has 17 repetitions. I want to enter numbers from 1 to 17 in those repetitions. Is there any easy way to do this without having to manually enter the numbers? I would like to write a script that would do this for 33 records. Any help would be appreciated. Thanks, John

I have a problem. I have a Purchase Order database where sometimes we have to revise a PO and save a copy of the old record. The new record would have the same auto-serial number and a number added to another field called "Revision Num". Is there a way to duplicate a record, give it the same auto-serial number as the old, add a number to the "Revision Num" field in the new record, and check off a box in the old record called "Revised" so it can be filtered out in general searches and reports? It seems really complicated but I don't know any other way. Thanks.

Hello, I have created an inventory control database. It seems to work fine most of the time, but occasionally, I get some funny results from my scripts. For instance, In the Purchase Orders database, a script takes the Qty and uses a SET FIELD in my master database to adjust the ON ORDER Qty. Occasionally there are numbers coming out that did not go in. My script is a very simple operation, mostly a SET FIELD and a FIND based on a Global Field. How can this happen to me? The script is only addition or subtraction. Thanks,

I am currently setting up an invoicing system for our company and one of our goals is to have a summary of all our customer activity (showing all quotes, packing slips, invoices, etc. in a single column of a single portal). I was able to achieve this using multiple layouts in one database. We also want to be able to click on an invoice #, go to the related layout and then scroll through all layouts if desired, without going back and forth to the portal. I can get to the related layout, but can only scroll through that particular layout. (ie. I can get to an invoice layout, but can't scroll through and see packing slips and quotes also. Just the invoice layouts.) Any help …