Monkeybread Software - MBS FileMaker Plugin: Audit.FieldNameForID

Topics All MacOS (Only) Windows (Only) Linux (Only, Not) iOS (Only, Not)
Components Crossplatform Mac & Win Server Client Old Deprecated Guides Examples Videos
New in version: 9.3 9.4 9.5 10.0 10.1 10.2 10.3 10.4 10.5 10.6 Statistic FMM Blog

Audit.FieldNameForID

Looks up the Audit cache for a field ID.

Component	Version	macOS	Windows	Linux	Server	FileMaker iOS SDK
Audit	8.0	Yes	Yes	Yes	Yes	Yes

MBS( "Audit.FieldNameForID"; TableName; FieldID ) More

Parameters

Parameter Description Example

TableName The table name or ID.
Can be ID of table, so we lookup name by ID.
Can be result of GetFieldName() function as we remove field name automatically. "MyTable"

FieldID The field ID to lookup. 1

Parameter	Description	Example
TableName	The table name or ID. Can be ID of table, so we lookup name by ID. Can be result of GetFieldName() function as we remove field name automatically.	"MyTable"
FieldID	The field ID to lookup.	1

Result

Returns field name or error.

Description

Looks up the Audit cache for a field ID.
Returns empty result if not found.
Version 8.2 allows you to pass table reference by ID.

Examples

Query first field name in Kontakte:

MBS( "Audit.FieldNameForID"; "Kontakte"; 1 )

Example result: "KONTAKT_ID ABGLEICHSFELD"

Blog Entries

MBS FileMaker Plugin, version 8.2pr4

Release notes

Version 8.2
- Changed Audit.FieldNameForID to accept table ID or name.
Version 8.0
- Added Audit.FieldNameForID and Audit.TableNameForID.

Created 20th January 2018, last changed 17th January 2020

Audit.FieldIDForName - Audit.GetEnabled

Feedback: Report problem or ask question.