Extract data from a table to copy into a field outside the table on same app


I'm trying to extract data from a table to put into a field outside the table in Kintone. I've read and noticed that the native plug-ins, etc. will not perform this so I was looking into coding as an option but to be honest, I'm a noob at best with JS coding. Any suggestions on where I could find some examples or knowledge on pulling data from a table to placing in a field outside the table?

My Table contains a container type, volume, comment. When the container type TOTE is selected, I need the volume associated with the TOTE row to be place in another field that is outside the table BUT in the same app.

At first, I thought using a simple if statement with a CONTAIN function in a calculation or text field (I tried both) will do the trick but it doesn't like it.

Any assistance would be greatly appreciated. Thank you.

Hello @dpoetsch
Welcome to the community! :smile:
Just to clarify, what would you like to happen if there are multiple rows with the container type TOTE?

Thank you.
There will only be one row with TOTE. Won't have to worry about multiple rows with the same type. I'm using tables because the plant that will be using this app may have to enter different types of containers for the same new product or product change. The Container type is a drop down that allows them to select. the type, example we have TOTE, DRUM, PAIL, BIB, etc.

For each type there will be a volume amount(gallons) that they will have to enter (number field) and a Comment if needed (text area) field

My DropDown

I want to copy that Annual Volume into this field which is outside the table

I've been using Kintone for 3 years for minor purposes but this the first time I am trying to play with tables.

Thank You

Hello @dpoetsch
I apologize for the delay, I don't know why but I didn't get any notification.
Below is a script that functions as you described. Feel free to use it as a reference:

(function() {
    'use strict';

    var SUBTABLE_CODE = 'Table'; // Subtable field code
    var DROPDOWN_FIELD = 'Dropdown'; // Dropdown field within the subtable
    var NUMBER_FIELD_INSIDE = 'Number'; // Number field inside the subtable
    var NUMBER_FIELD_OUTSIDE = 'Number1'; // Number field outside the subtable

    // Listen to changes in both the Dropdown and Number fields within the subtable
    var dropdownEvents = [
        'app.record.edit.change.' + DROPDOWN_FIELD,
        'app.record.create.change.' + DROPDOWN_FIELD

    var numberEvents = [
        'app.record.edit.change.' + NUMBER_FIELD_INSIDE,
        'app.record.create.change.' + NUMBER_FIELD_INSIDE

    kintone.events.on(dropdownEvents.concat(numberEvents), function(event) {
        var record = event.record;
        var subtables = record[SUBTABLE_CODE].value;

        // Initially set Number1 to empty if TOTE is not selected
        record[NUMBER_FIELD_OUTSIDE].value = ""; // Clear the outside field first

        subtables.forEach(function(row) {
            if (row.value[DROPDOWN_FIELD].value === 'TOTE') {
                record[NUMBER_FIELD_OUTSIDE].value = row.value[NUMBER_FIELD_INSIDE].value;

        return event;

    // Disable the Number1 field on form show events
    var formShowEvents = [

    kintone.events.on(formShowEvents, function(event) {
        event.record[NUMBER_FIELD_OUTSIDE].disabled = true;
        return event;
1 Like

Thank you @Chris! I will give this a try. Thanks again for your time and knowledge.

HI @Chris, this worked perfectly, excatly what I needed. Thank you for the code/lesson. I have put it in my folder of learned code ideas. Thanks again!