Column Advanced Settings: Option List: Set Parent Record Values for Specific Column when Creating Child Records

Overview¶

When you create a new child record from "Create Linked Column" of a parent record that has the same parent as the "Link" set, the value of the parent record can be set only to specific columns.

Limitations¶

1. Only "Class Column" can be used.

Prerequisites¶

1. "Site Administration Permission" is required to configure settings.

Operation Procedure¶

Open the advanced settings of the class column in the Editor tab and write the link settings in JSON format in the options list.

Setting Content¶

Example Setting¶

In the following example, a link to the parent table (site ID 123) is set in the options list of consumables ① (ClassA) and consumables ② (ClassB) in the child table. The SelectNewLink setting switches the automatic setting of the values ​​of consumables ① (ClassA) and consumables ② (ClassB) displayed on the new creation screen after clicking the create button of "Create Linked Column" of the parent record.

Normal Link Setting Case¶

If SelectNewLink is not set or is disabled, such as "[[123]]" in the list of options for consumables ① and ②, it will be displayed as follows.

Option List¶

[[123]]

New Creation Screen after Clicking Create Parent Record Button¶

When SelectNewLink is Enabled¶

If SelectNewLink is enabled only for consumable ②, it will be displayed as follows.

List of options¶

[
    {
        "SiteId": 123,
        "SelectNewLink": true
    }
]

New Creation Screen after Clicking Create Parent Record Button¶

Related Information¶

• Manage Table: Editor: Column Advanced Settings: Option List: Link
• Manage Table: Items: Class