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: 12.1   12.2   12.3   12.4   12.5   13.0   13.1   13.2   13.3   13.4    Statistic    FMM    Blog  

Audit.FieldIDForName

Looks up the Audit cache for a field name.

Component Version macOS Windows Linux Server iOS SDK
Audit 8.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Audit.FieldIDForName"; TableName; FieldName )   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"
FieldName The field name to lookup. "123"

Result

Returns text or error.

Description

Looks up the Audit cache for a field name.
Returns empty result if not found.

Examples

Queries field named for third field in a table by ID:

MBS( "Audit.FieldNameForID"; "1065089"; 3 )

Example result: "First"

Queries field name for 4th field:

MBS( "Audit.FieldNameForID"; "Contacts"; 4 )

Example result: "Last"

See also

Release notes

Blog Entries

This function is free to use.

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


Audit.Delete2 - Audit.FieldNameForID

💬 Ask a question or report a problem