I’m building an app where an AI column (text to boolean) checks if an address is complete or not.
This column will be used on thousands of rows and I want to make sure it updates only when the instructions or the input changes.
I’ve read somewhere that the AI columns auto update every 30 days. If that’s true that means my app will clock in thousands of update at the beginning of every cycle.
Anyone knows how and when the AI updates or counts updates? Else I will just use an AI action.
When I set up an OpenAI computed column, how often is the column updated?
Computed columns, such as the computed math or template columns, are usually computed in real-time. OpenAI computed columns, however, act differently: the output on each row is saved (cached) 30 days for the same input. The output changes in real-time when the input changes and is saved 30 days as long as the input remains unchanged. After 30 days, the output is computed again.
Columns are only evaluated when their values are used (displayed, or used in a workflow). What would cause all of these columns to be re-evaluated each month?