Jerry100

I have inherited a database with six text fields each of which can have one of 30 two letter values. I would like to combine (concatenate) the values for each record into a new field and then perform a find for a specific value within the newly constructed field. I am not sure if one of the FM Text Functions can search a string and find a pattern. Any help would be appreciated. I may be wrong but this seemed a better option than constructing a dynamic find on each of the original six fields.

I have two tables Discipline & Disposition. I created a value list using the records from the Disposition Table. I want to use a drop down list to populate up to six Dispositions on the Discipline Layout. When I use it on the first occurrence, both fields from the value list appear. When I try it on the second occurrence, only the first field populates. Seems like a common use of value lists, but cannot figure it out. Thank you in advance.

Vaughan, Thanks for the suggestion. I tried without any success. Given the limited amount of information requested to set up Email Notification, one would think it would be straightforward. I have tried every combination of configurations that come to mind, but again, to no avail. I have asked my network staff to look at it from their stance and see if anything comes to mind. In the mean time I am open to any other suggestions. Thanks you

We all know it is a process. Now that I have removed the incompatible steps, I thought I had a script that would work. I am still getting scripting errors (100,101). The files that I am trying to import into my db are in the Data/Documents folder. I have pointed the Import Records step directly to that folder. Do I need to use Get(FilePath) function or some other set of steps which I would not use if it were running on the client-side?

Did not see anything addressing this, so I'll ask. I have a portal that is sorted on one field (Field1). I want to compare the values (dates) in Field2 between the first and second row in the portal and determine which is the earlier date. I don't use portals often enough to know if you can do calculations between fields on different rows. Any and all help is appreciated.

Hello, I've searched the forum and have not found any posts which address this topic. I am trying to configure the E-Mail Notification tab on FMS10 (Windows). I've consulted with my network staff am still stuck. Here is what I have: the appropriate IP address for our Exchange Server in the SMTP Server Address, the correct Port, SMTP Enabled checked, a legitimate recipient e-mail, Errors checkbox marked. I have used my own e-mail adddress for the From Address as well as my own account & PW for the SMTP authentication. When I Test SMTP connections it fails and tells me to check SMTP settings and email address. Question: Does the SMTP authentication require an Email Administrative account & PW, and does it matter what the "From" address is? Are there other ports which must be open? Any and all help appreciated. Jerry

Steven The logs indicated that the scripts contained unsupported script steps. Because it would then abort the script, I could only see the initial unsupported steps, but assumed that there may be more. It was not until I used bcooney's advice on how to use the compatibility drop down to identify steps unsupported by server side scripts that I was able to identify just how much of a script may need to be reworked. As always, I appreciate your response.

Bcooney Thank you for both the easy answer as to how to find the incompatible script steps, and for going the extra step (that you usually do) by providing a technique for using the same script for either client or server. You are a true asset to the forums. Thanks for sharing.

I have a nightly FileMaker script for maintaining my db. I am trying to use the FMS (Windows 10.0) Schedule Facility to run the script. It continually terminates and tells me there are scripting errors. The script runs perfectly when started manually. I am guessing that there are some script steps (i.e., Print Setup)which are not permitted when running a FileMaker script from the server. Does anyone know where that list is? Tired of coming in at night to start script manually!

I have created a new solution and bound it into a runtime version. I have used Inno as my installer in the past with no problems. Now I am getting a message when I try to launch the runtime app saying it failed because it could not locate xerces.dll, yet when I look at the runtime package that file is clearly there. I have tried rebinding the original solution and recreating the Inno script several times all with the same result. Any insights would be appreciated.

Lee Thank you. Everything I read and had used in the past told me that it should work. What I discovered was that in creating the Custom Menu, I eliminated the user rights to keyboard command access. When I changed the Menu back to the Standard Menu, the Control Arrow worked as it should. I'll modify the Custom Menu. Thank you for your time and knowledge. Jerry

Runtime solution that contains a multiple page layout in Preview Mode. Without making the status area available to the user, Windows will advance to the next page of the report by pressing CTRL+down arrow. I cannot find an equivalent command on the Mac. I've tried Apple-down arrow, CTRL-down arrow, and Option-down arrow to no success. Any insight from you Mac FileMaker geniuses? Thanks. Jerry

Does anyone know if FM Studio and Dreamweaver CS4 are compatible and if there is any advantage in purchasing CS4 instead of CS3?

Thanks for the tip.

When I create layouts on my Mac using Custom Colors I seem to have complete control. When I enter the same values on Windows, I get totally different colors, and once hue, saturation, and brightness are set it seems to force the RGB values rather than accept my input. The color differences are greater than might be expected just due to different monitors. Anyone have a solution to matching colors across platforms? Is there a basic difference in how color is managed between the two operating systems? Thanks in advance.