Search Project Mgmt
Search FileMaker Blogs

Thank you for visiting the FileMaker Calculations Explored blog. I recently moved this content over from my blogger account. Hope you like it! When you get a chance, check out the centralized search feature for all the FileMaker blogs found along the right side panel. It is quite handy!

Sunday
Mar302008

FILEMAKER: The ValueListItems Function

From Dwayne Wright
Certified FileMaker 9 Developer
www.dwaynewright.com
info@dwaynewright.com

ValueListItems
ValueListItems( fileName ; valueList )
All Current Versions Of FileMaker
Returns A Text Result

The ValueListItems function returns a list of the values you defined for a particular value-list. The value list items will be return delimited, that is to say there will be a carriage return between each item. This function has two defined parameters, which are: what database, and what value-list do you want to get the information for?

ValueListItems ( "Client.FP7", "Type") in one of my databases would return...

Client
Prospect

More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2010 - Dwayne Wright - dwaynewright.com

Saturday
Mar292008

FILEMAKER: The ValueListIDs  Function

From Dwayne Wright
Certified FileMaker 9 Developer
www.dwaynewright.com
info@dwaynewright.com

ValueListIDs
ValueListIDs ( fileName )
Most Current Versions Of FileMaker
Returns A Text Result

When a value list is created in a file, under the hood, it is given a unique and sequential value list id tag. When a value list is deleted, that value list id tag is removed and will not be repeated.

FYI ... I cannot help but wonder if the organization on internal value lists ids is one of the reasons why currently value lists cannot be copied and pasted by using FileMaker 9 Advanced.

The ValueListIDs function will return those internally generated id tags in the order they appear in the Manage Value List dialog box. The value list ids will be return delimited, that is to say there will be a carriage return between each id.

Again, the order in which the value lists ids appear is by their sorted order in the Manage Value List dialog box. So if you have 12 value lists, create one and move it to the top ... that value list id will have a 13 and it will appear in the list above the others.

More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2010 - Dwayne Wright - dwaynewright.com

Monday
Mar242008

FILEMAKER: The ScriptNames Function

From Dwayne Wright
Certified FileMaker 9 Developer
www.dwaynewright.com
info@dwaynewright.com

ScriptNames
ScriptNames( fileName)
All Current Versions Of FileMaker
Returns A Text Result

The ScriptNames function gives you the name of each defined script in a particular file. Each script name is listed individually in a text result that is separated by a carriage return between values. This function has 1 defined parameter, which is ... what database do you want to get the list of scripts names for?

Example: ScriptNames ( "Client.FP7") in one of my databases returns...

CREATE_New
FIND_Clients
FIND_Prospects
CONVERT_Prospect_To_Client

FYI... for you FileMaker 9 and higher users ... the names of script groups is NOT returned by this function

Although this function will generally be utilized by those with full developer access, the names of scripts that a privilege set is not allowed to view will not be returned by this function for those users.

More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2010 - Dwayne Wright - dwaynewright.com

Saturday
Mar222008

FILEMAKER: The ScriptIDs Function

From Dwayne Wright
Certified FileMaker 9 Developer
www.dwaynewright.com
info@dwaynewright.com

ScriptIDs
ScriptIDs( fileName)
Introduced With FileMaker 7
Returns A Text Result

When scripts are created in a file, they are given a unique and sequential script id tag. When a script is deleted, that scripts id tag will not be repeated. The ScriptIDs function will return those id tags in the order the scripts are currently organized within the file. The script ids will be return delimited, that is to say there will be a carriage return between each id. So if you have 12 scripts, create one and move it to the top ... that script will have a 13 and it will be on the top row of the returned array.

More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2010 - Dwayne Wright - dwaynewright.com

Wednesday
Mar192008

FILEMAKER: The Relationinfo Function

From Dwayne Wright
Certified FileMaker 9 Developer
www.dwaynewright.com
info@dwaynewright.com

Relationinfo
Relationinfo( fileName ; tableName)
Introduced With FileMaker 7
Returns A Text Result

The Relationinfo function will allow you to return information about table occurrences and interlocking relationships. You need to specify within the syntax of the function which file and which table. The function will return 4 lines of information for each relationship to the parameter defined table occurrence. The first line returned is the file name, the second line will have the name of the child table occurrence, the third row will describe any relationship options that are set such as create related, sorting and deleting and the last row will tell you about the match fields used in the relationship.

Each different relationship will be returned in the list separated by double carriage returns.

Here are some examples returned using this function in the database I use to store my blog posts.

The syntax of my calculation is ...

RelationInfo ( Get ( FileName ) ; "Blog" )

and the returned results include ...

Source:Blog Stuff
Table:blog_Chapter_ValueList
Options:Create
blog_Chapter_ValueList::Chapter = Blog::Chapter

Source:Blog Stuff
Table:blog_Crosswords
Options:Create
blog_Crosswords::fk_blogLink = Blog::pk_recordID

Source:Blog Stuff
Table:blog_TERMS
Options:Create
blog_TERMS::fk_blogID = Blog::pk_recordID

Source:Blog Stuff
Table:blog_QUIZ
Options:Create
blog_QUIZ::fk_Blog_Id = Blog::pk_recordID

Source:Blogz_IMAGES
Table:blog_IMAGES
Options:Create
blog_IMAGES::pk_recordID = Blog::pk_recordID

More info about the author and FileMaker in general, contact me at info@dwaynewright.com.

© 2010 - Dwayne Wright - dwaynewright.com