perbackman
asked on
Question on example plug-in.
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So, what was it exactly?
ASKER
Hi,
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.
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.
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...
ASKER
Wow. Now I understand what you mean. Ill try to do that. You are a way ahead of me.
Thanks
Thanks