Kintone can be easily aggregated, but it is not easy to calculate the addition or subtraction of two different record values. So, based on the statistical information recorded every week, I created a program that notifies me of the difference from last week.

** As a result, good things **

――I don't have to use a calculator anymore --No longer exports to Excel every week and aggregates ――I got better just by looking at the email (if I run it regularly)

Thing you want to do

1. Calculate the difference between the values in the kintone app

2. Send email (regular)

To send regularly, go to cron settings

Creating an environment

This program runs in Python, so let's prepare for the following.

--OS: Ubuntu (I used Cloud9)

Python 3.5.3
pykintone https://github.com/icoxfog417/pykintone
PyYAML -** Download kintone-indicator ** --kintone (best if you have a convenient developer license)

Kintone app settings

FieldCode	FieldType	DefaltValue
Date	Date	Today
Member	Number	0
PV	Number	0
UU	Number	0

Commentary

See ** kintone-indicator **

account.yaml

domain: {Subdomain name}
apps:
    send:
        id: {App ID}
        token: {App API token}

settings.yaml

mail:
    smtp: {SMTP server}
    port: {port number}
    to: {Destination Email Address}
    from: {Sender's email address}
    password: {Sender's Email password * Blank if not needed}

Shell script execution and sample results

`python`


$ sudo sh indicator/run.sh 
Between 2017-06-05 and 2017-05-29
Members: 7,000 (+2,150)
PV: 6,000
UU: 400

Send to mail >>xxx@*****.***

It was sent to the specified email address ♪ I think it will be even more convenient if IM such as Slack is notified in addition to email.

Try sending the aggregated results of two records by email with pykintone