LinkedIn
Twitter
Hi @Dion
Virtual columns are calculated “on the fly”, real columns are calculated “on editing”.
I suspect this is the new issue you are facing, if percentage is calculated from another table.
My suggestion:
You may want to set an action that will update this value at any necessary time.
Typically, this could be a combination of:
- action1 that will be performed on a “Behavior” section of a form
- action1 “Execute an action on a set of rows”, that will trigger the action2 on another table
- action2 “set the value of some columns in this row” that will update the value
For example:
OK.
What if you use the bot to set a value on a column “check” ?
So that, the previous condition
AND(
[_THISROW_BEFORE].[Percent Completed] < 1,
[_THISROW_AFTER].[Percent Completed] = 1
)
will become:
AND(
NOT([_THISROW].[check_YesNo]) ,
[_THISROW].[Percent Completed] = 1
)
(assuming initial value for [Check_YesNo] is set to false, of course)
And, the next step of your bot will be to switch that column [Check_YesNo] to true.
What made me think to this suggestion:
and I don’t see any mention of the use of [_THISROW_BEFORE] and[THISROW_AFTER] in this post, even if, in the case of an update, it should be possible to use it:
OK.
What if you use the bot to set a value on a column “check” ?
So that, the previous conditionAND( [_THISROW_BEFORE].[Percent Completed] < 1, [_THISROW_AFTER].[Percent Completed] = 1 )will become:
AND( NOT([_THISROW].[check_YesNo]) , [_THISROW].[Percent Completed] = 1 )
I just tried your suggestion. The Bot still isn’t triggered 
So I looked into the Test for the Bot:
The Event Condition for the specific row that I’ve been testing on indicated “True”. The other rows were “False”. Does it mean the Bot was supposed to be triggered for this row?
At this stage, I would suggest to contact Support, I don’t get why this is not firing the Process.
But I’m probably missing something, let’s wait for @Marc_Dillon or someone else to wake up and have a look 
How did you do this? Give screenshots and details.
First, I began with creating an action, “Update Percentage” which will set a real column’s value to the virtual column’s value (as shown right below this sentence).
After that, I created a Bot with the “Data Change” Event type “Adds only” to the “Completed” table. This table has many-to-many relationship and shows the record of the training each user has done (refer to the picture below).
In this Bot, I created a “Run a data action” process with “Run action on rows”.
In Referenced Action, I used back the “Update Percentage” action that I’d created at the beginning.
This is how I did it.
Just to clarify, you’ve got:
- Bot on Adds to the Completed Table, which:
- Runs an data change Action on a record in the Employees Table.
- A 2nd Bot meant to trigger on changes in Employees Table.
And it is #3 that is not triggering?
That would be because by default, data changes from Bots, do not trigger other Bots. But you’re in luck, since they’ve recently given us the option to allow this, and it’s as easy as flipping this switch on your first Bot:
From here:
Oh I did read it. Sorry I didn’t mention that cause I kinda couldn’t get it at first. So, I went to try it out. I think it worked 
I will do a few more testings and get back to you. Thanks a lot @Marc_Dillon
