Brian Dunning's FileMaker Custom Functions

GetFieldsByType ( theFieldTypes ; theLayoutName ; theTableName ; theFileName ; omitFields ; localFieldsOnly )

Retrieve fields from list or table and filter by field type.

  Average rating: 4.3 (29 votes) Log in to vote

Michael Wallace   Michael Wallace
Richard Carlton Consulting
http://www.rcconsulting.com

Share on Facebook Share on Twitter

  Sample input:
GetFieldsByType ( "text¶number" ; "" ; "" ; "" ; "numberField1" ; "" )
  Sample output:
textField1
textField2
numberField2

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

This will get a list of fields from the current context or a specified context and filter the list by the types specified. Useful for audit log set up like UltraLog by Nightwing.

There is also a global variable that is set by this custom function for debugging purposes called: $$GetFieldsByType_ErrorMessage

If no fields are returned then check this variable for an error message.

A field set to the following will give you all of the non calc, summary, etc fields for you to use in your audit log calculation:
GetFieldsByType ( "text¶number¶date¶time¶timestamp" ; "" ; "" ; "" ; "AuditLog¶ModificationTimestamp" ; "" )

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.