Topics   All   MacOS (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server   Client   Old   Guides   Examples
New in version: 9.0   9.1   9.2   9.3   9.4   9.5   10.0   10.1   10.2   10.3    Statistic  

Audit.FieldNameForID

Looks up the Audit cache for a field ID.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
Audit 8.0 Yes Yes Yes Yes Yes
MBS( "Audit.FieldNameForID"; TableName; FieldID )   More

Parameters

Parameter Description Example value
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"

See also

Blog Entries

Release notes

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


Audit.FieldIDForName   -   Audit.GetEnabled

Feedback: Report problem or ask question.




Links
MBS Xojo Plugins