How do I make a bot wait for a virtual column to calculate?

[Lukevancleave]

I have an app that is creating routes for fuel delivery.  It selects the 20 highest priority customers, and then orders them.  The route order is based on a decimal virtual column that is calculated by their days till empty plus distance from the last stop.  Distance from the last stop is a virtual column that uses the lat/long of the stop and the lat/long of the stop with the highest assigned route order number.

I'm trying to make a bot that will assign these route orders automatically but it's not waiting for the virtual columns to finish calculating.  Is there a way I can make it wait?  I see there are "wait for" conditions for bot events to trigger but I don't know what I'm telling it to wait for.  Any Advice?

[Joseph_Seddik · Accepted solution]

You cannot use virtual columns for this purpose; they recalculate only upon a new sync. Instead, put the formulas directly in the bot, or use physical columns for this purpose

[Lukevancleave]

Thanks, I’ll try that approach