Having problems with workflow rule and an action not being fired

Snoopy
New Member

Hi everybody,
I have the following problem and run out of ideas what the root cause could be.
I defined a workflow rule for my table that is based on a row-level action triggered by a static field. When I set the field to invoke the action, the workflow rule test detects it, but nothing happens. When I execute it from within the tester, I get a success message, but nothing happens, either. Only when I manually fire the action from the detailed view, I finally get the result that I want.
And when I add an email send action to the workflow rule, that email is also sent out. So the Workflow rule does detect the trigger event correctly.
Is this a bug, or still a lack of understanding on my side ?

Besides, the RecordWarning field in the test report is flagged, but I suppose that is due to the email warning when the app is not yet deployed ?

Any idea or suggestion ? Thx.


Solved Solved
0 11 197
1 ACCEPTED SOLUTION

Snoopy
New Member

I am happy to report that my issue is solved now! It actually only took me minutes to do it, once I got the hint from the error message in the log file that you had made me aware of.

The problem was the following:
Some of my fields only need to be filled once every 40 or 50 times. For that field I had implemented an on-edit validity check involving [THISROW.AFTER] to avoid later problems with data integrity. But unfortunately that fired back when I started implementing my workflow rules. When those are run, the context obviously is no longer the form, but e.g. the execution of actions, and that value was no longer there. So I added a context constraint to my validity check, and now everything seems to run smoothly again. You made my day, guys.

Having learned about the log file has given me a confidence leap that I have not wasted my time looking into AppSheet, and I will definitely continue with my explorative journey, even if it is currently only for fun.

View solution in original post

11 REPLIES 11
Top Labels in this Space