mun

please give more detail about what you want to see happen.

I think this what you are after - in the script editor you can use nested if's: If["scholasticYear = "K""] Set Field ["scholasticYear","1"] Else If["scholasticYear = "1""] Set Field ["scholasticYear","2"] Else . . . End If End If You get the picture. So now when you run this script for a record, it will update for you.

What would be some sample requirements?

Anyone know of any fax software/solution that will allow Filemaker to fax over a large number of lines? I'm looking to create a solution to automate up to 4,000 faxes to be sent and want to do it over at least 20 lines.

I believe your problem is with the convention OS X now uses with file paths. Since it runs with BSD in the background, it also uses the "/" to separate files/folders to define the path. You have "sfx1:fx:az:az01:az-01/01" as a file path. Try renaming it to "sfx1:fx:az:az01:az-01-01" or "sfx1/fx/az/az01/az-01-01" paying attention to change your "/" in "...01/01" to some other character. This should do the trick for you.

Try having a button in your find layout to cancel out of a find and returning the user into the correct layout. One thing you can also do is to hide the status area to hide the cancel along the left which will cause the problem you are having. Also in your cancel script, have a halt script step to stop the other script from looking for input in find mode.

Okay, after looking at this - what if you don't even include the if statements, just the "Set Error Capture [On]" step? It seems that this will see the error, but won't report on it and will get you straight to your layout. Sorry to have put you back to square one with my suggestion.

In the scriptmaker window, you'll notice a print button. Hit that for the particular script you want to print. Depending on the OS you have: Windows XP: Click the "Print to file" checkbox Mac OS: Go to output options and check "Save as file" box If these don't work, let me know what OS you are using.

Try modifying your "go to" script with error capture. Turn error capture on at the beginning of the script and after the step where you open the database with no records (where your script usually fails) put: if (status(CurrentError) = 0) # your script steps to exit this script else # your script steps to go straight to the layout without a find end if I hope this helps you avoid those messages.

I'm not sure about the adjusting of the headroom of the actual field box, but maybe this workaround may be helpful: Create your field without defining any field borders and create your own field borders using the square tool. Now you can move the field as high or low within that box.

Try using "getURL" instead of OpenURL. I've had success with this in my scripts.

Depending on what else you are tracking, how about sorting it by date first (if you are storing that info) and then by time - or are you just wanting to store times, and dates may get in the way of what you are making?

Keith, It is due to some previous testing of the solution. I've already tried pipelining the data to the first file. What I do not understand is (if this is the proper solution) is how to bring the data to a report if the record that another record from another file that it is referencing to references many other records in yet another file. The solution that I had tried to impliment was to create a script that would check if a record contained records from another file from a portal and then go to those records and determine if those records contained yet more records within its portal and develop a tab-separated text file to be exported to Excel - this works fine, if nobody else is in the file (I also have issues with the tab-separated file offsetting the data with certain records for some reason). For example, say I have 3 different files: Plan.fp5, Animals.fp5, Location.fp5. Now I have some records in Plan.fp5 that I have grouped together to sell to a buyer and in each record of Plan.fp5, I have 3 Animal.fp5 records per Plan.fp5 record and I also have stored multiple locations in which I can find these animals so that I can track where to get them for the buyer. I have not found a way to pipeline all of this data back to Plan.fp5 so that if someone wants to print a report that gives ALL of the details of the Plan items, they can easily build it and not worry about others being in the records that are being reported on. Again, I've tried doing the pipelining thing and have found that it pipes back only the first referenced record. My question is: Is there a better way to pipe this back without running into what I've run into or is there another way that I am not thinking of right now or am I doing this pipelining thing all wrong? I hope this is clear, I am trying to be as specific as possible without confusing with too many details. (it is probably too late)

You can probably use a script to determine the number of items in portal 1 by going to the last portal row and setting a field to the value of that portal row #. If the field is less than or equal to 20, then have the script print the one page layout, if the field is greater than 20, then have the script print the multi-page layout. i hope this helps.

That sounds good, but the problem I see is say that a particular record in file A relates to a record in file B and that record relates to several records in file C (through a portal). How would I pipeline all of the appropriate records in C to a report based on A?

I have a rather large relational database and have to create a rather complex report to show information from records that are related by records that are related by other records (goes 3 levels deep). In order to do this, I have a few scripts checking certain criterion and copying appropriate fields and pasting them in a "report" field. this works fine - if nobody else is in the record that I need to copy data from, but if someone is, the pieces of information I need do not show up in the report. Is there a better way of doing this? I thought of creating calculated fields, but that would not go 3 levels deep appropriately.

I agree and am starting to be afraid that Filemaker is going to charge for every tiny improvement they make to their program - they are entitled to it, but it may be the reason I give up on using it and moving on with my life wit mySQL and PHP. It may be a bit more difficult, but worth it if I don't have to pay for EVERY little improvement made to the program.

I'd also like to add that I just found that if I use the same file I'm having issues with and used a different field to relate it to, it works fine. The difference in the field used for the relationship is that the one that does not work is a calculated field, whereas the one that does work is just a normal field. Does anyone know why?

I have a particular issue with trying to perform a find for a record through a field that is related from another database. I have not had any issues with a previous relationship I had, but then I created a new relationship to another database and when I attempt to perform a find through that, I get a "No records match this request" error message. The data does exist, but I cannot find the records with that relationship. Again, the earlier relationship I set up still performs the find correctly. Any thoughts? Thanks in advance.

After the show message script step, try using the status(currentmessagechoice)script step in an "if" script step. Depending on what you use for your default choice, you may have No as the default and Yes as choice number 2. Then have the if step determine if the currentmessagechoice equals 1(default) or 2 and depending on that, have the field changed to yes or no accordingly.

You could also try VNC (like Timbuktu, as well as probably just as slow) or even try using a program called Albert - you can email requests for certain scripts to activate. Pretty cool stuff.

Does there exist an upgrade for Developer similar to Filemaker Pro 5.5v2? I am having the same issue as in Filemaker Pro 5.5v1 Developer for the fact that when I print from OS X, it does not always print the correct layouts.

I had a similar issue on the mac side between OS 9 and OS X. The resolution that I found was to go into the OS that you want to print off of and create a script that will restore the page setup that will print your layout correctly. After you do that, then create another script that will test what platform you are using and then print your layout based on the page setups.

You'll have to get on those machines and set up separate scripts for each platform that have the the page setup and print steps and save the page setup from each platform (each different OS). In your main script when you go to actually tell the program to print, use an if (status(currentplatform)=X) statement to determine what the platform you are using is (X would be: 1 for Mac < 10, -1 for Mac >10, 2 for Win 95/98/ME, -2 for Win 2000/NT). After it makes that determination, let your script run a subscript for the appropriate platform.

That is pretty cool - putting the "