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:

Set Value
Blank
Formula
Copy Field
Date Edit

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

Date Edit Settings

If you select the Data Edit option in the 2.Editing method field, you can configure the following settings:

Setting	Description	Output Field Type (Field types that can be specified in "1.Choose to create a new field or replace existing field")	Example of Input Data	Execution Result
Add days to date	Returns a date that adds a specified number of days (increment value) to the specified date.	Date, Date and time, Text	2023-07-10 Increment value:3	2023-07-13
Add months to date	Returns a date that adds a specified number of months (increment value) to the specified date.	Date, Date and time, Text	2023-07-10 Increment value:3	2023-10-10
Year of date	Returns the year of the specified date.	Text, Number	2023-07-10	2023
MOnth of date	Returns the month of the specified date.	Text, Number	2023-07-10	7
Day of month	Returns the day of the specified date.	Text, Number	2023-07-10	10
Day of week	Returns the day of the week for the specified date. The days of the week are returned as the following numbers: Monday: 1 Tuesday: 2 Wednesday: 3 Thursday: 4 Friday: 5 Saturday: 6 Sunday: 7	Text, Number	2023-07-10	1
Week of year	Returns the week number of the specified date.	Text, Number	2023-07-10	28
Day of year	Returns the number of days between January 1st to the specified date.	Text, Number	2023-07-10	191
Days until date	Returns the number of days between two specified dates.	Text, Number	2023-07-10 Start date:2023-07-01	9
Working days until date	Returns the number of business days between two specified dates, excluding weekends and holidays.	Text, Number	2023-07-10 Start date:2023-07-01	6
First day of month	Returns the first day of the month of the specified date.	Date, Date and time, Text	2023-07-10	2023-07-01
Last day of month	Returns the last day of the month of the specified date.	Date, Date and time, Text	2023-07-10	2023-07-31
Specify date	Returns the specified date.	Date, Date and time, Text	3 days from today	2023-07-13
Year and month of date	Returns the year and month of the specified date.	Text	2023-07-10	2023-07
Convert western calendar date to Japanese	Returns the Japanese era date string of the specified date.	Text	2023-07-10	令和５年7月10日
Convert Japanese calendar date to western	Returns a date converted from the specified Japanese era date string to the Gregorian calendar. The convertible Japanese era formats are as follows: 令和5年7月10日令和5/7/10 令和5-7-10 令和5.7.10 令5年7月10日令5/7/10 令5-7-10 令5.7.10 R5年7月10日 R5/7/10 R5-7-10 R5.7.10	Date, Date and time, Text	令和5年7月10日	2023-07-10
Times between times	Returns the number of hours between two specified dates.	Date, Date and time, Text	12:00 Start time:02:00	10:00

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