Allow user input on virtual columns (trigger workflows without changing real data)

This is super important for many reasons:

  • You can finally have workflows be triggered without having to actually change data.
    Right now we have to either edit a column and reset it back to it’s original value or add a separate column such as [trigger] to accomplish this. Both approaches are very dirty and unneccessary.
  • You can finally start to do magic such as converting a price float (2.10$) to integer cents (210), because you can use the virtual column for input and have an App formula on the real field that converts

Because current Virtual Columns are re-calced on each Sync, I wonder if maybe a completely different kind of virtual column would be better - a non-calculated, in app only kind of virtual column meant only for temporary usage within the app session.

1 Like