Question on example plug-in.

Posted on 2006-04-14
Last Modified: 2010-04-27
I have a table with companies.
I have a field in each post called "Fld_compname". (Unik data)
I need to make a pull down menu that on change, finds one companie. Data in the menu should be the companynames to choose from.

I have a global field "FindCompanie" that apears as a pull down field. Current data is last search.

I installed the examplePlugIn that can run a script dependiing on a formel value.
So far so good.
I compare the Fld_compname and FindCompanie globalfield. If they are different the findcompaniecsript will run. I was so happy it worked. But I forgot something.
1. When I delete a companie. The fields will be different. And the script will run until I quit Filemaker.2. When I add a record the same thing will happend. It starts as fast as the fields are different. I found that this is not a good method.
Has anybody done this before. Im out of ideas.
PLS help
Question by:perbackman
    LVL 28

    Accepted Solution

    it is probably because yr script has a loop from which it cannot exit. you should modify the delete script to change the global field content to the value of the current record after deletion. and when you add a new one, you should set the global field to be the same as the last record created.
    LVL 28

    Expert Comment

    So, what was it exactly?

    Author Comment

    I found an easy way to solve it. The script now only runs if the start position of the find field is an "-". I created a calculated field that puts an "-" befopre the companyname. I let the pull down field swow values from that. When the field gets that value it runs the script. In the end of the script I just delete tha value so that when the script end there is no "-" in the first left position. I was happy to find it out. Thanks anyway.
    LVL 28

    Expert Comment

    tricky indeed, but there must be a simpler way to do this; what if the purpose of doing this? to find only records from one company? Using a selfrelationship should do it as well and would be faster...

    Author Comment

    Wow. Now I understand what you mean. Ill try to do that. You are a way ahead of me.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
    Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now