Leveraging the Variables functionality in custom tables

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2019 09:23 PM
We are in the process of planning the design of a Finance module to replace the functionality of the deprecated Finance Service Management plugin.
Where I'm coming up short is how to implement the "variables" field on a custom table (call it "finance_request"), so that Record Producers targeting finance_request can leverage the Variables Related List for questions/answers, in the same way as a "normal" Catalog Item, or one of the "real" Service Management plugin Record Producers (i.e. Finance, Legal, Marketing, etc).
I've noticed that when you create a custom table, the "Variables" field type is not available for use, seemingly making it impossible to implement this functionality on a custom table, without knowing some "trick".
Does anyone know what the criteria is for being able to create fields of the "Variables" type? And/or any documentation on this subject that might be helpful?
Examples below of 2 OOB tables that make use of the Variables field type. This seems to be the main missing ingredient for what we're trying to do. Everything else should be relatively straight-forward(ish).
- Labels:
-
Scripting and Coding

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-24-2019 07:44 PM
I guess what's really missing for me on all of these suggestions is the ability to programmatically access the variables object after the submission, in the same way that I can with a "regular" Catalog Item or Record Producer. e.g.
var rs = new GlideRecord("sc_req_item");
rs.query();
while (rs.next()) {
gs.log(rs.variables.requested_by);
}
Is that just impossible to do with a custom table (i.e. due to not being able to create the "Variables" field on the table itself)?