val.town get airtable record stats.

airtable.js

const airtable_get_data = (async () => {
  const today = new Date();
  today.setHours(0, 0, 0, 0);
  const yesterday = new Date(today);
  yesterday.setDate(yesterday.getDate() - 1);
  const data = await @stevekrouse.fetchJSON(
    "https://api.airtable.com/v0/<TASK_ID>/Tasks",
    {
      headers: {
        "Authorization": `Bearer ${@me.secrets.airtable_api_key}`,
      },
    },
  );
  let todayCount = 0;
  let yesterdayCount = 0;
  for (let record of data.records) {
    const recordDate = new Date(record.fields.Created);
    recordDate.setHours(0, 0, 0, 0);
    if (+recordDate === +today) {
      todayCount++;
    }
    else if (+recordDate === +yesterday) {
      yesterdayCount++;
    }
  }
  const message =
    `You have completed ${todayCount} tasks today, compared to ${yesterdayCount} yesterday.`;
  // Send a POST request to the Pushover API
  await fetch("https://api.pushover.net/1/messages.json", {
    method: "POST",
    headers: {
      "Content-Type": "application/json",
    },
    body: JSON.stringify({
      token: @me.secrets.pushover_app_key,
      user: @me.secrets.pushover_user,
      message: message,
    }),
  });
  return message;
})();