Greetings! There is a formula for getting the ID of the current table record:
RECORD_ID()
Is there a formula or mechanism for deriving the name or ID of the current table? Such as:
TABLE_ID()
or…
TABLE_NAME()
Thank you!
Solved
Formula for Name or ID of Current Table
Best answer by Otto_Automator
For those following this thread, here’s the step-by-step solution documentation page
And here’s a video showing the completed process in-action
Thank you to everyone for your assistance! -- Sal Soghoian
Not sure if this will apply to your specific situation, but when I write a JavaScript for the Scripting extension, I define the variable "table" using
let table = base.getTable('TheNameOfTheTable');
*Just substitute your table's name in place of TheNameOfTheTable
*Just substitute your table's name in place of TheNameOfTheTable
Ron_Daniel wrote:
Not sure if this will apply to your specific situation, but when I write a JavaScript for the Scripting extension, I define the variable "table" using
let table = base.getTable('TheNameOfTheTable');
*Just substitute your table's name in place of TheNameOfTheTable
*Just substitute your table's name in place of TheNameOfTheTable
Thank you Ron for your suggestion, but it's not quite what I need. I'm attempting to dynamically create an Omni Automation script URL, stored in the table, that when tapped will dynamically meta-tag the selected graphic in OmniGraffle with the record ID and table name of the current row in the AirTable table. The RECORD_ID() function provides half of the required metadata, and I'm looking for a generic way to derive the table name without having to specify it per table, so I can use the same formula for any table.
Once a graphic has been meta-tagged in OmniGraffle, I have another Omni Automation script that uses the stored record ID and table name to construct an AirTable URL to retrieve the other record field contents to populate the graphic layout — in other words, and example of tagged container publishing!
The scenario works currently if I manually insert the table name in the formula, but then the formula is not generic. Make sense? Thanks again! -- Sal
Here's a video showing this scenario in action on iOS and macOS:
For those following this thread, here’s the step-by-step solution documentation page
And here’s a video showing the completed process in-action
Thank you to everyone for your assistance! -- Sal Soghoian
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.