working with matrix items, if I do not know how many available options there are in the system, how might these programmatically? The fields are custitem fields but the system owner does not use any pattern that can be derived by the naming convention, the "itemmatrix" property of a customfield is not available in a query either.

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you can programmatically determine the matrix item options by loading the item record and looking for fields with the

matrixoption

prefix in their ID. This prefix is used for matrix options in child items of a matrix. Here is a general approach: 1. Use the

Record.getFields()

method to get an array of string internal IDs for all the fields on the item record. 2. Filter this array to get only the fields that have an ID beginning with

matrixoption

. These are the matrix option fields. 3. For each matrix option field, you can get its internal ID by removing the

matrixoption

prefix. 4. Use the

Record.getFieldValue()

method with the internal ID of each matrix option field. If the returned value is not empty, it means this field is being used as a matrix option. Please note that this approach assumes that you are working with SuiteScript, and that the

matrixoption

prefix is used for matrix options in your system. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******