Phillip Holmes

Thank you very much for the input Regards Phillip

Is it possible to script multiple finds. When I use "Enter Find Mode[]" in my script it forgets about the previous "Enter Find Mode[]" and only runs the last request. I used variables in my script and so also use "Set Field" after each "Enter Find Mode[]" Thank you.

If you can not get a definitive answer to your question you may want to think about using a global variable. Depending on how that variable is set the script does what it needs to do. So you can set the variable say $$myVar to something once the button is clicked, and just before you exit that script and recall the previous script that can then examine the variable and do whatever you want. If(Exact($$myVar,0) Do something here Else Do something here Endif Exit

Have you asked the SALESFORCE administrators how to get external connections setup. If you have that information then depending on what is involved maybe.

Hi, One way is to create a new DB with 2 table that hold info from your current inventory table and the other (table 2) holds the EXCEL info. Create a relationship between the 2 table using PART NO and then from table 2 (The Excel table) create a LIST layout that has both tables on it in LIST form and you will see what parts are in what BINS from the perspective of the EXCEL file.

How are you assigning the records to the user? Once you know that you can easily create FINDS that OMIT or FIND records that contain an EXACT matching criteria. You can also do what you want via the RELATIONSHIP between tables. Provide more information and you will get more information

Hello, Please see attached file I hope this is what you are asking. Regards Phillip Post_314227.zip

Is it possible to remove the 3 icons that control a window - "Minimise - Maximise - Close" I have users that close windows by clicking the X icon and not the icon I have provided which does validation and other functions. They are making a total mess of the data and is becoming a nightmare to maintain. I have asked them to use only the icons I have given them but this only lasts a short time. I know in other DB's like 4D you can specify the type of window you want to use, but I can't find any for FM Thanks in advance.

AnFrusch@pepp, Are you loading the SUBJECT directly from a field, or are you combining data in a readable subject line. Phillip

As long as both sides of the relationship are TEXT and are EXACT in content I do not know of any issues in setting up the links in that fashion. Regards Phillip

Are you able to get a trial version of FM Pro9 as this may give you the options you are after as you are able to select "File/Folder" during the creation of the script step. I do not have version 7 to check against. Regards Phillip

Hello, Have you carry out a search in the forumn looking for "Filtered Value List". There are many posts about this subject maybe the solution is listed in one of the replies. Regards Phillip

Hello, Try 2 things - Firstly I would change the printer driver you are using to some very simple HPLJ4 and on the layout adjust the width of the field so that the board is nicely inside the page and then test. Regards. Phillip

Hi Steve, Are all fields RELATED? If they are you might not need to use the "lookup" function to get the data. Something like this If ( // Test CurrencyExchangeRate::Abbreviation=CurrencyExchangeRate::Abbreviation ; // Result if true "The "& GetAsText ( CurrencyExchangeRate::Region ) & " currency rate was last updated " & CurrencyExchangeRate::Updated ; // Result if False "Please navigate to the Currency Exchange table and enter the Proper Values for this currency" ) Cheers Phillip

Thank you for the feed back, I will start to look at the XML stuff - Must confess I don't like that type of stuff as I find all the tags hard to follow once you get a lot of information on a page.

You will need to use a related table to hold all the linked files (either as a pointer or copied) into the DB. That way you can have as many files as you wish linked to a single client record.

I have to create an excel report and need to know if it is possible to set the column heading so excel shows the HUMAN NAMES to the users and not the internal field names. I use the "Save/Send Records as - EXCEL" to get the data out to excel. Thanks for any help.

Ok, the only way I have found to do this is to get the list of addresses out of a single text field and into a portal. Once you create the layout for the excel export just add the portal and FM will bring out the rest.

Hello all, I need to calc field "Combined_ALL" that brings together the contents of 3 other text fields. The only issue I have is that the calc field needs to place a carrige return only between the fields that actually have data in them. I have tried to figure this out and have come up short.

1. The first part is very possible of question 1. The last part is not possible because the very moment you move the record pointer to some other place you lose focus on all related records. FileMaker can only work from a layout that is directly linked to one table. Other DB programs can give you the ability to create a form that handles more than one table, and work with records from those tables.

If the search is date based, and is done between years then you can do something like. 1. Create in your table a field that holds a 0 or 1 depending if the person meets the quota. 2. Create a calc field that sums the field from point number "1" 3.In your script set a variable to calculate how many years - In this case is 4. 4. Then omit records that the calc field = 4 that should leave you with what you want.

Hi Karen, The only way to do this is to use an external plugin that can evaluate the content of the field and then run a script. There are a number of free plugins available that can do this type of thing. ZIPPSCRIPT or EVENTSCRIPT are 2 that come to mind. Cheers Phillip

See if this helps ValueList.zip

Please see the attached DB for help. Cheers Phillip ValueList.zip

Hi Mike513jr The way I would do this is to create a summary field "s_Total" of the field that displays the VL. Then create a SORTED report to display the count of each occurrence, the report must be sorted by the input field before you can get an accurate count.