I have 4 actions in an โExecute a sequence of actionsโ to add child rows when a new player is added which are โAdd Strokes Rowโ, โAdd Points Rowโ, โDelete Total Rowโ, and โAdd Total Rowโ. The โDelete Total Rowโ has the following formula โFilter(โA_Flight_Scoringโ, AND([Label] = โTotalโ, [_THISROW].[Team] = [Team], [_THISROW].[Game] = [Game]))โ and the action is โDelete Rowโ. There is only 1 row for each team that contains โTotalโ in the Label column. However, when โDelete Total Rowโ action is run it deletes all the rows with the [_THISROW].[Team] = [Team] disregarding the [Label] = โTotalโ. It also seems intermittent. It appears that if I populate the spreadsheet with more than one player on the same team it seems to work. Each team is to have only one Total at the end of its section in the spreadsheet and needs to be at the bottom of the team section.
Solved! Go to Solution.
Steve,
I found the problem. An unintended workflow was being activated that was interfering in requested actions.
Thanks for your prompt responses,
Steve Rose
Note that, because of an odd quirk in the way AppSheet handles the =
operator, this:
[Label] = โTotalโ
is TRUE if the Label column value is blank (as well as if it matches Total
).
Putting the raw value first avoids the quirk:
โTotalโ = [Label]
That was it!!! Thanks again Steve. Now that you mentioned this quirk I remember references to it before.
Steve
I spoke too soon. It worked when I added more players to a team. But when I deleted all the players it behaved the way I explained in my bug report. Very disturbing and frustrating.
Steve
Theses are subject to the same quirk:
[_THISROW].[Team] = [Team]
[_THISROW].[Game] = [Game]
Ok. So is the correct way the way you stated the expressions in your response?
Unfortunately, no, itโs not that easy. This is the full expression Iโd recommend:
Filter(
โA_Flight_Scoringโ,
AND(
โTotalโ = [Label],
IF(
ISBLANK([Team]),
ISBLANK([_THISROW].[Team]),
[_THISROW].[Team] = [Team]
),
IF(
ISBLANK([Game]),
ISBLANK([_THISROW].[Game]),
[_THISROW].[Game] = [Game]
)
)
)
No that doesnโt work either. The thing that bothers me is that I have another Appsheet app that almost an exact copy that works fine.
Perhaps best to engage support@appsheet.com at this point, so that someone can look deeper into your app.
Steve,
I found the problem. An unintended workflow was being activated that was interfering in requested actions.
Thanks for your prompt responses,
Steve Rose
Yep, thatโd be a problem, alright! Glad you found it!
User | Count |
---|---|
40 | |
36 | |
34 | |
23 | |
17 |