I have a simple lunch ordering app. I’m building a function that emails parents when their balance goes below 0. In the action window I set the condtion runningBalance < 0 (see picture below). In doing so, the action will not run. If I change it to runningBalance > 0 it will run without any issue.
Here is the parentDB that I built with the running balance formulas
I tried doing an “if-then-else” statement to bypass it, but that failed too.
I hope someone could assist. I think I screwed up somewhere.
Is that button on a screen that’s specific to each row. So for example, are you viewing a specific parent row when you click on the button? Just trying to determine if there button is acting on the row you think it is, or is it always the first row in the table?
I have two buttons. One is outside of the collection that refers to the runningBalance column in the DB. The other button is the one inside the collection.
That action only runs against one row. Which row depends on where you are executing the action. If the button is outside of a collection, then which row depends on a lot of things, but my first guess would be that it’s the first row in the table if the screen with the collection is attached to the first row. If the button is on each collection item or inside the detail screen when to select a collection item, then it should be working correctly since it should be executing against each respective row.
I did follow the advice and it is working now. If I make it an item click, it will notify the individual with the correct verbage. This works for me for the time being.
