ProZachJ

In my solution I use the script master function to check if a file exist on a layout as conditional formatting to change the color of text based on the condition of the files system. This was working fine on my win xp systems but on my new windows 7 system it causes a serious loading loop in the layout.

I was just more talking about using scriptmaster to leverage the JDK in a way that could make FM more object oriented. Like in the example before: I have 1 table that represents my "people object" and I use a field to be the "describe myself" behavior of that object. The field is a simple text field but using scripmaster/groovy is used as a map thus allowing me to alter the attributes that compose a persons description based upon the type of person they are. For example: Here is the value of the "description" field for two different people. Type:Employee Name:jimmie Address:222 my lane Salary:$1,0000000 Type:Customer Name:jack address:1234 Sample st accountrevenue:$15000 Both people have names and addresses but only employees have salaries and only customers have account revenue. Instead of using separate fields for all the attributes that describe a person, and thus having to create either different or more tables to normalize the difference in description for different types of people. I have created a field that functions as the description regardless of the type of person by using scriptmaster/groovy to leverage maps, a very useful tool that is foreign to the filemaker world. The question is if dealing with this in implementation would be to laborious. It would definitely represent a whole new way of thinking about a Filemaker database. I just was hoping to kick this mental football around a little as my employer is never going to pay me to develop Object/Relational filmaker theory but its a topic that has been running around my brain ever since I met scriptmaster.

Wanted to get some input/ideas on something I have been kicking around in my brain since finding ScriptMaster and beginning the journey of learning Java/Groovy. Can SriptMaster/Groovy be used to create an FM database that is Object-relational? This is just strait brain spewing, but if you code your own classes and package them as jars for use with ScriptMaster could you leverage java/groovy classes in a way that would allow FileMaker tables to become more like persistent objects and thereby avoid some of the pitfalls that accompany traditional relational db data normalization? Can we bring the concept of inheritance to FileMaker? Example...Leads/Prospects/Customers have many similar characteristics and need to preform many of the same functions/behaviors yet each has some unique properties that cause them to be modeled in FileMaker/Relational DBs as a separate table. This leads to a lot of duplications in layouts, scripts, fields and calculations. I have always feared that my daily use and development in FileMaker is turning me into one of the bemoaned "dataheads" who thinks in terms of tables, fields, and functions rather than in terms of real world objects. How can we use ScriptMaster to bring a little bit of object thinking to the FileMaker world?

I had a similar problem with some custom mail scripts that I wrote. I solved the problem by loading mail.jar before registering the function.

Just solved my own problem...now I feel dumb Needed to put the JavaMail --mail.jar into a container field and load it before registering the functions! READ YOUR DOCUMENTATION DUMMY!

I have created two modules in Scriptmaster. One that checks my email inbox and returns a count of messages. The other retrieves a specific message number from my inbox. These functions work well inside of scriptmaster and work fine in my solution as long as I register them via scriptmaster. However whenever I try to use the registergroovy function they both register fine and return "1" but when I try to use the functions they return an error. How can it work when scriptmaster registers it but not with registergroovy? I know that could just use the register on startup to register the functions via scriptmaster, but i want to use these functions server side so that doesn't work.