Fred P.

that works great. thank you.

Is there a way to check via script if a records container field is empty?

I would like to try to reword my question. I have a calc field generated based on the input from other fields. I would like to check to make sure this calc field is unique, giving the user the ability to change the source fields until a conflict no longer exists. If I have 5 records, and the dynamic fields are 322-14 322-15 322-14 335-01 332-14 I would like the 3 "332-14" records to show a conflict until the user changes the fields that the calc field uses. Am I over thinking this? why does this seem difficult?

Here is a better representation of what is happening. Slideprinting-01.jpg shows what I get when i turn on sliding. Slideprinting-02.jpg shows how I want it to look when you turn on sliding. I want all the fields in the current row to scale down uniformly to be the smallest they can be. Is that possible? Fred

I am having his issue as well, on OSX. I want the rows to slide down to the smallest they can be based on the text in the box, but to keep all cells in that ROW the same size as the largest cell can slide down to. But each individual cell in the row slides down to ITS OWN minimum, instead of the rows maximum minimum. Can anyone help?

Anyone know how to open a finder window via script on the mac? I have a mac path i would like to have a button that will open a finder to that directory. Fred

I have a button that opens a file requester and then inserts the file selected into a container as a reference. My question is this, if there is already a file in that container, I would like the file requester to open up to the current directory (already stored in a field name container.dir) so that it is easier for the user to find the replacement for that file. Any way of doing that? Fred

That seems to make sense to me, but Does not appear to be working. I have a global field in my main menu that stores the currentusername. And If the CurrentUserPrivledgeSet is set to Client, then I would like only his projects to populate the drop down to select which project to go into. But when I try to create a value list that is based on the currentusername, it says that it will not work, because it is a global field and cannot be indexed. How exactly does this method work or is there a better method to just showing his projects? There is a field in the project for Clients Name as well which is entered data at the beginning of the project. So essentially, I want a drop down to list only projects where currentusername = clientname. Help! Thanks Fred

Very Odd, but it did in fact turn out to be a printer driver problem. Updated drivers and Numerals Print now.. Good thing... :P

Has anyone ever seen this? Im not sure if its a printer driver thing or what. But no matter what I print, all NUMERALS on the page are Omitted. IE: If a record Name is set to ML_01_R100 what gets printed on the page says "ML_ _R " Has anyone else seen this before? It displays fine even in preview mode. But when printed this happens from evey layout.

Can you do tool tips in FMPro 8.0 or do you need advanced or server? How do you do a tool tip?

I have a need to not only limit the records viewable based on user login, but I would also like to limit the items in a drop down list based on that login. This would be for Client Access to the database. For example, we could have 6 different jobs we are tracking from 3 different clients. For Ease of this example, lets say each client has 2 jobs in our database. When that client logs in, I only want him to see his records, but even more than that, we have some drop down lists that are generated by ProjectNames. Normally this would dynamically list all 6 projects to choose from. But I would want to limit this list to just his 2 projects. Make sense? Thanks for the help! Fred

I have a drop down that lists employee's from an employee table. Then we have a field in that table named ActiveEmployee which is set to Yes Or No. I would like the drop down to not list all employees in the database, but only the employees that are set to ActiveEmployee = "Yes" Can Someone help me with that?

Is there a way to edit the html page that FM generates for User login for Instant Web Publishing? Why I am glad it has that feature, I would really like to change the way the login page looks.. :)

I have a table called Projects with a field named Project::ProjectName in it. In our database we have several projects. For a Main Menu sort of situation, I would like to have a drop down that lists current Projects and when you select one, it finds all records in that project and swtiches to a new layout. I am brand new to this sort of find script and cant figure out how to do this. Because in this "Main Menu" layout, I do not want to store any records. it is simple a GUI for users to navigate to their project and to filter the records displayed to them to only that project. Essentially it could be a button. Anyone have any ideas or thoughts? :

Well, the simple answer is that I made the fields a little taller and there is now enough room to see the entire line of text even when in edit mode..... :

I also tried this to test and this didnt work. a Script on a button that did this: SetVariable[$$AppVersion, Value:Get( ApplicationVersion )] Insert text[select; Database::CurrAppVersion_Field; "$$AppVersion"] But that just puts "$$AppVersion" in the CurrAppVersion_Field Field... Any help would be greatly appreciated.. As you can tell, I am very new to this. But I find it facinating!

That could get me there, but I am having trouble figuring out how to test this, and make it work. Ideally, it would be something like: SetVariable[$$AppVersion, Value:Get(ApplicationVersion)] If[$$AppVersion <> "Web"] Cut[select; Database:DocPath_Field] Insert File[Reference; Database::Container] End If But that is not actually working. First, How do I test what $$AppVersion Is? Just Assign it to an empty field? Second, I probably need help with syntax in the If Statement... Or there is a much simpler way to do this that I am overlooking... (probably.. : )

Is there a way to make a button inactive if the user is viewing the database from a web browser as opposed to the FM application? I have a script that contains some functions that ARE web compatible, and some functions that are not web compatible within the script attached to a button. If a web user clicks the button, it runs part of the script (the part that IS web compatible) and ignores the non compatibile part, which then breaks the data in the database.

I have some drop down menu fields in a database, and when I go into edit mode from a "Instant Web Published" database, all the text in the drop down boxes look like they are too tall to fit in the box. Or that the box is too short to show the enitire height of the selected fonts text in that field. But when you are not in edit mode, they look fine. Is there a way to prevent this?

Is there a way when using web publishing with FMP to have it default to not showing the left side panel that allows users to select layouts and move forward backward through records? I dont like the way that window looks.

I just found this in another Forum and answer my own question... That solved it for me, but what I learned on accident, is that if you want to open an explorer window to a specific directory, i found I had to do this: I created a button added script send event put the path you want to open in a field, and put that field in the calculation window that button will open the folder in an explorer window. Not sure why that works, but it does.

Hello everyone, is there a way to have a button that opens a windows explorer window in a specific directory?