KrewData Features / Commands / Edit Data
In This Topic
    Edit Data
    In This Topic

    Edit Data command edits data in a field and stores the result in an existing or new field. You can select the records that you want to edit using the search criteria. The Edit Data command allows you to perform following editing operations:

     Settings
    Setting Description
    1. Choose to create a new field or replace existing field  Create a new field or select an existing field to save the edits.
    • Create new field
      Create a new field to save the edits.
    • Replace existing field
      Overwrite the data of selected existing field with the edit result.
    2. Editing Method Select the editing method.
    • Set Value
      Set a value in field specified in setting#1.
    • Blank
      Set blank in field specified in setting#1.
    • Formula
      Perform various operations using built-in functions and standard mathematical operators, and save the result in field specified in setting#1. For information about available built-in functions, see Function List.
    • Copy Field
      Copy the value of selected field to field specified in setting#1.
    • Date Edit
      Edit the date data and store the result in field specified in setting#1.
    3. Replace found item with Value of this setting depends on the editing method selected in setting#2.
    • Set Value
      Enter a value you want to set.
    • Blank
      Nothing is set.
    • Formula
      Click the setting icon to create a formula in the Insert Function dialog. Formulas work on record basis and cannot be calculated by referring to the values of other records.
    • Copy Field
      Select the field to be copied.
    • Date Edit
      Select editing content for date data.
    4. Enter a term to search for Specify the search criteria for the record to edit.
    • All Records
      Editing operation is performed for all records of the app.
    • Only records that contain
      Set conditions in kintone filter. Perform editing operations on records that match the criteria.
    • Use a formula to determine which records
      Set conditional expression using formula. The formula is executed on record basis and edits the record whose result is true.
     If selection items are added or their order is changed in following field types by changing the app settings after the filtering conditions for target field has been set in the filter, items selection in filter might get changed. Hence, in such case, it is recommended to check the filter settings and change as required.
    • Radio button
    • Check box
    • Multi-choice
    • Drop-down
     Example(Set Value)

    This example demonstrates how to add a Fiscal Year field to an expense management app and set the text "2018" in that field for the records which have value between April 1, 2018 to March 31, 2019 in Date field.

    Input Data

    Command Settings

    1. Choose to create a new field or replace existing field 2. Editing Method 3. Replace found item with 4. Enter a term to search for
    ・Select Create new field
    Input new field name: Fiscal Year
    Set Value 2018 Set the following condition in filter
    • Date ≧(greater than or equal to) Specify date 2018/04/01
    • Date ≦(less than or equal to) Specify date 2019/03/31
    • Select All conditions are met

    Settings Page

    Execution Result

     Example(Blank)

    This example demonstrates how to add Actuals field with blank data in an expense management app.

    Input Data

    Command Settings

    1. Choose to create a new field or replace existing field 2. Editing Method 3. Replace found item with 4. Enter a term to search for
    ・Select Create new field
    Input new field name: Actuals
    Blank (Blank) Select All Records

    Settings Page

    Execution Result

     Example(Formula)

    This example demonstrates how to a replace "(Co.)" with "Co. Ltd." in Company Name field using SUBSTITUTE function in customer master app.

    Input Data

    Command Settings

    1. Choose to create a new field or replace existing field 2. Editing Method 3. Replace found item with 4. Enter a term to search for
    ・Select Replace existing field
    Select field: Company Name
    Formula SUBSTITUTE(Company Name,"(Co.)","Co. Ltd.") Select All Records

    Settings Page

    Execution Result

     Example(Copy Field)

    This example demonstrates how to copy the value of Department Name field to a new field named Old Department Name of a department master app.

    Input Data

    Command Settings

    1. Choose to create a new field or replace existing field 2. Editing Method 3. Replace found item with 4. Enter a term to search for
    ・Select Create new field
    Input new field name: Old Department Name
    Copy Field Department Name Select All Records

    Settings Page

    Execution Result

     Example(Date Edit)

    This example demonstrates how to extract month from a Date field of expense management app and save it in a new Month field.

    Input Data

    Command Settings

    1. Choose to create a new field or replace existing field 2. Editing Method 3. Replace found item with 4. Enter a term to search for
    ・Select Create new field
    Input new field name: Month
    Date Edit ・Select Month of Date
    Field:Date
    Select All Records

    Settings Page

    Execution Result