Edit Data

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