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
Richard Carlton Consulting
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" ; "" )
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.