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.FieldIDForName
Looks up the Audit cache for a field name.
| Component | Version | macOS | Windows | Linux | Server | FileMaker iOS SDK |
| Audit | 8.2 | Yes | Yes | Yes | Yes | Yes |
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
Blog Entries
Release notes
- Version 8.2
- Added Audit.TableIDForName and Audit.FieldIDForName.
Created 20th April 2018, last changed 17th January 2020
Audit.Delete2 - Audit.FieldNameForID
Feedback: Report problem or ask question.
Links
MBS FileMaker blog
