# How do I register multiple failures a day?

**URL:** https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481
**Category:** Newbee
**Created:** [November 18, 2020, 8:17pm UTC](https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481 "2020-11-18T20:17:50Z")
**Posts on this page:** 12
**Page:** 1

<div class="post-metadata">

### Author: ![ioioio](https://avatars.discourse-cdn.com/v4/letter/i/d78d45/32.png) [@ioioio](https://forum.beeminder.com/u/ioioio)
#### Post date: [November 18, 2020, 8:17pm UTC](https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481/1 "2020-11-18T20:17:50Z")

</div>

I maintain a Google Sheet in which a certain column must never get a negative value. Whenever it does, I need a sting, or multiple stings (the number would depend on another column). But all I can find is binary: a goal met/not met.

Alternatively, I could use Habitica’s Habits, but, while I do see support for Habitica, only Dailies and ToDos appear to be supported.

Thanks!

---

<div class="post-metadata">

### Author: ![shanaqui](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.beeminder.com/shanaqui/32/3513_2.png) [@shanaqui](https://forum.beeminder.com/u/shanaqui)
#### Post date: [November 19, 2020, 12:02am UTC](https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481/2 "2020-11-19T00:02:26Z")

</div>

Hi! Hmmm, interesting use case – thanks for mentioning what you were looking for; it’s always helpful to hear! You would only be able to be charged once a day, using a Beeminder graph. Maybe you could set something up with the IFTTT charge trigger, though?

---

<div class="post-metadata">

### Author: ![ioioio](https://avatars.discourse-cdn.com/v4/letter/i/d78d45/32.png) [@ioioio](https://forum.beeminder.com/u/ioioio)
#### Post date: [November 19, 2020, 1:25am UTC](https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481/3 "2020-11-19T01:25:18Z")

</div>

I could do that. But I believe immediate reinforcements are more powerful psychologically, otherwise I’d just be putting that money in a jar and not need Beeminder. (I once did exactly that, ended up with $300 in a jar, then took them back, lol).

Anyone knows any other service to do that?

Curious why Habitica habits are not supported. Sounds like you already have all the logic in place.

---

<div class="post-metadata">

### Author: ![ioioio](https://avatars.discourse-cdn.com/v4/letter/i/d78d45/32.png) [@ioioio](https://forum.beeminder.com/u/ioioio)
#### Post date: [November 19, 2020, 1:37am UTC](https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481/4 "2020-11-19T01:37:21Z")

</div>

As a dev - perhaps you are experiencing scalability issues preventing you from doing intraday adjustments? Just curious.

---

<div class="post-metadata">

### Author: ![adamwolf](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.beeminder.com/adamwolf/32/484_2.png) [@adamwolf](https://forum.beeminder.com/u/adamwolf)
#### Post date: [November 19, 2020, 2:14am UTC](https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481/5 "2020-11-19T02:14:54Z")

</div>

I don’t know all the details of what you’re trying to do, but I think shanaqui’s suggestion is a good one. Beeminder exposes its “charge me” functionality via IFTTT (and an API, too. [https://api.beeminder.com/#postcharge](https://api.beeminder.com/#postcharge)). Set up your Google Sheet with IFTTT and having it trigger a charge. If IFTTT doesn’t check fast enough, I’d recommend hitting the API directly. There are a variety of no- or low-code tools that can connect the two, like Integromat, but Google Sheets supports Google Apps Script. Apps Script will let you monitor cells or a column, and run functions based on changes to them.

The derailing-multiple-times-a-day thing isn’t really a scaling thing.

Beeminder aggregates data by day to get a daily value. Depending on the type of goal, the aggregation may be different. Some goals take the “worst” datapoint, others take the “best”. Some take the average of the datapoints, others take the first datapoint. This is pretty great, in general, and works to support many, many different types of goals, and bypasses quite a few snags.

One place where this approach limits things, however, is in scheduling things at a greater granularity than a single day. If you want to be able to derail multiple times in one day on a graph, which datapoints would be taken into account? Would each datapoint be considered on its own, without any aggregation? Once that’s the case, there are some tricky things that Beeminder’s been able to bypass by using daily aggregation. For instance, what happens if a datapoint gets submitted twice? Instantly two charges? (There’s deeper things too, like multiple transactions in rapid succession for the same amount of money from an online vendor are often pegged as fraudulent by the payment networks…)

---

<div class="post-metadata">

### Author: ![alys](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.beeminder.com/alys/32/4726_2.png) [@alys](https://forum.beeminder.com/u/alys)
#### Post date: [November 19, 2020, 7:38am UTC](https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481/6 "2020-11-19T07:38:24Z")

</div>

> [@ioioio](#):
>
> Curious why Habitica habits are not supported. Sounds like you already have all the logic in place.

Because Habitica’s Habits work differently than its To Do’s and Dailies, all the logic isn’t in place for them. There’s some brief details about why Habits aren’t supported at [Tracking Habitica Habits - #5 by alys](https://forum.beeminder.com/t/tracking-habitica-habits/5715/5) and more info at the other post it links to. 🙂

---

<div class="post-metadata">

### Author: ![alys](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.beeminder.com/alys/32/4726_2.png) [@alys](https://forum.beeminder.com/u/alys)
#### Post date: [November 19, 2020, 7:41am UTC](https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481/7 "2020-11-19T07:41:36Z")

</div>

TaskRatchet may be of interest to you. [TaskRatchet Development Updates](https://forum.beeminder.com/t/taskratchet-development-updates/5037) (also search for “taskratchet” in this forum for other posts).

---

<div class="post-metadata">

### Author: ![ioioio](https://avatars.discourse-cdn.com/v4/letter/i/d78d45/32.png) [@ioioio](https://forum.beeminder.com/u/ioioio)
#### Post date: [November 19, 2020, 8:02pm UTC](https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481/8 "2020-11-19T20:02:35Z")

</div>

I tried and got scared by the login screen. No CSS?

---

<div class="post-metadata">

### Author: ![ioioio](https://avatars.discourse-cdn.com/v4/letter/i/d78d45/32.png) [@ioioio](https://forum.beeminder.com/u/ioioio)
#### Post date: [November 19, 2020, 9:10pm UTC](https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481/9 "2020-11-19T21:10:43Z")

</div>

Another use case. I need to make a one-time payment of X dollars to Beeminder. I can’t spend any time figuring out how to do that, because by doing so, I’ll derail even further. I don’t want to risk further payments. It’s a fairly large sum. What do I do?

---

<div class="post-metadata">

### Author: ![ioioio](https://avatars.discourse-cdn.com/v4/letter/i/d78d45/32.png) [@ioioio](https://forum.beeminder.com/u/ioioio)
#### Post date: [November 19, 2020, 9:23pm UTC](https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481/10 "2020-11-19T21:23:25Z")

</div>

I understand that my premium account allows me to send half to charity.

---

<div class="post-metadata">

### Author: ![shanaqui](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.beeminder.com/shanaqui/32/3513_2.png) [@shanaqui](https://forum.beeminder.com/u/shanaqui)
#### Post date: [November 19, 2020, 9:25pm UTC](https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481/11 "2020-11-19T21:25:06Z")

</div>

I guess there’s always the donate button! (That would not allow you to send half to charity, mind you – nor would charging via IFTTT.)

---

<div class="post-metadata">

### Author: ![alys](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.beeminder.com/alys/32/4726_2.png) [@alys](https://forum.beeminder.com/u/alys)
#### Post date: [November 19, 2020, 11:06pm UTC](https://forum.beeminder.com/t/how-do-i-register-multiple-failures-a-day/7481/12 "2020-11-19T23:06:12Z")

</div>

> [@ioioio](#):
>
> I tried and got scared by the login screen. No CSS?

Sounds like it didn’t load properly - maybe try a shift-reload or a cache clear? It definitely has CSS. This is what it should look like (but larger; this is at 50%):

 ![image](https://us1.discourse-cdn.com/flex019/uploads/beeminder/original/2X/2/2da60098ee420d471f4726fb5bb6a41cd816a09b.png)
