| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
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
- Version 8.2
- Added Audit.TableIDForName and Audit.FieldIDForName.
Blog Entries
This function is free to use.
Created 20th April 2018, last changed 17th January 2020
