Jan 09, 2023 07:44 AM
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! Go to Solution.
Jan 16, 2023 08:26 AM
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
Jan 10, 2023 01:09 PM
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
Jan 10, 2023 07:14 PM
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:
Jan 16, 2023 08:26 AM
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