Bot shows no error in Monitor but the data won't change

[Kawano164]

I'm making a sales management app, and one of the bot as below works (show no error in Monitor and Audit Log) but won't change real data. Could anyone give me the advice to solve it?

●Bot
- - - - - - - - - - - -
Event: The shipping Date in Order has changed
Process: Change Order status depending on the shipping Date（From "受注" to "発送準備中" or "発送済" ）
- - - - - - - - - - - -

●In the Monitor Status has been changed to "発送済"

●Audit Log shows no error

●But the real data in Spread sheet won't change. It is still "受注". Not "発送済".

●Column setting of Status

Sorry for some Japanese including.

What is the problem, and how I can solve it...?

Thank you for every comment.

 

[dbaum]

Try reviewing the cell's edit history. That can help direct your troubleshooting--e.g., depending on whether the cell's value was updated as intended but then reverted to the original value for some reason or was never changed at all. 

[Kawano164]

@dbaum 

Thank you very much!
I'm getting forward thanks to you.

●The result of cell's edit history
- - - - - - - - - - - -
I've checked the cell's edit history and found the cell value was changed once as intended but changed again to the previous value almost simultaneously.

●Things I did after checking cell's edit history
- - - - - - - - - - - -
・Regenerate structure of the Table
→Nothing changed. of course😑

・Directly edit status in form view
→Status had changed and won't go back to the previous value
👉It implies that the problem is in bot?

・To see what happens, I added the wait step "5m待つ" which waits for 5 minutes at the bottom of the process in bot.
→I found an unknown "update_input" step in Monitor just after the Wait step; which doesn't show up until I add a wait step. And it changes the status to previous value!!

👉??😯

Could you tell me what is happening? How can I stop this step?

[dbaum · Accepted solution]

---

@Kawano164 wrote:

the cell value was changed once as intended but changed again to the previous value almost simultaneously

---

The typical cause for this issue is that the row whose change triggered the automation is changed again before the automation completes and syncs its results back to the user's device. For example, this can occur when a grouped action first changes a row in a manner that triggers an automation and then immediately changes the row again.

I hope this helps you zero in on the problem.

[Kawano164]

@dbaum Thank you very much!

---

@dbaum wrote:

For example, this can occur when a grouped action first changes a row in a manner that triggers an automation and then immediately changes the row again.

---

As you say, there is no recall change when I directly edit the [ShippingDate] without action which opens the form view for editing Shipping Date.

I delete these Action and Form view and add another Action which use INPUT() for editing value.

And there is no recall change.

I still don't understand what is the center of the problem but in my case, it seems action or view or both.

Thank you very much!!!

[Kawano164]

Although My problem is solved, I'll leave something I found for the people who have similar problem.

The same problem occurred again when I added an action at the bottom of the grouped action which changes the [ShppingDate].

The action I added at the bottom set another column value "=[ShippingDate]".
Although I don't know the reason, it recalls previous [Status].

When I delete the bottom action, problem disappear.

[JB_app]

@dbaum The actions within the automation could generate this problem too?