Unstable expression

reggieneo
Participant V

Hi,
I have this expression that is being invoked by an action when form is saved. it was working for more than a month. after a while it won’t.
can please assist me what went wrong

I tested it and still is providing correct answer but not making a changes in the targeted other table’s column
ANY(
SELECT(
Expenses Details[Cost],
AND(
([Expenses Item] = “Short”),
([Date] = [_ThisRow].[Date]),
([Over or Short Name] = [_ThisRow].[Name]))
)
)

0 4 167
4 REPLIES 4

Steve
Participant V

Then the expression is not the problem. Make sure your action is working properly.

reggieneo
Participant V

Hi Steve,
is it possible to have an action name in form saved but is not existing anymore in behavior > action view?

i noticed this “Short or Over” but can’t find it anywhere in the behavior configuration.

2X_a_a9a09e87e514f15da2291633ad9ada705ef6263d.png

please ignore. i selected auto in from saved and refreshed it, when i clicked it again that action name is gone. i may have accidentally deleted it before but it did not automatically removed from from saved options.

Yeah, AppSheet has a tendency to do that. Same with if you simply renamed the action. It would be nice if AppSheet threw an error or warning about it, at least.

Top Labels in this Space