Let’s take a layout called « Customers_list » and a script that goes to this layout using the Go To Layout option. Mainly, referring to a database structure item as a text constant in an expression prevents from renaming this item, unless you investigate the whole DDR (Database Design Report) before renaming anything. This article won’t solve this case, but the equivalent technique could be developed for the php side.

Not to mention the PHP API that forces us to hard code everything. With generalization of techniques such as plug-ins to trigger scripts (zippScript, DoScript…) that call a script by its name, or LayoutProperties that call layouts by their name… this problem becomes more crucial. ValueListItems ( Get ( fileName ) theListOfM圜lients )

Case ( Get ( ActiveFieldName ) = theNameOfTheFieldThisCalculationIsDefinedFor A B )The GetFieldName function now allows this] This is due to the lack of functions giving information on database structure. ValueListItems ( Get ( fileName ) 'myValueListName' ) Case ( Get ( ActiveFieldName ) = 'myFieldName' A B )Ģ. It happens though that you need to hard-code things, that is to say quote an item name such as a field name or a value list.įor example, to define an auto-enter calculation depending on active field name, you’ll have to write:ġ. When I try to remember the reasons why I chose FileMaker among the available development tools, I think this one is in the top 5. No matter if a field is used in a calculation or a script, you can rename it and FileMaker will update all dependencies instantly. One of the nicest things with FileMaker is how free we are to rename things at any time.

Filemaker pro 12 hack