I am using this to show caller name and language, using a virtual column, based off two table columns:
=CONCATENATE([CallerName], ’ ', “(”,[Languages],")")
Now I want to add to this expression and IN or OUT based off the sign in and out timestamps.
end result should be: Tammi Canelli () IN or Tammi Canelli () OUT
I can get this to happen using a virtual column and it updates the status when someone signs out but only in the caller sign in table.
The column in the evac table that holds the valid if statement does not update/refresh - it remains static with whatever the initial info was upon sign in.
How can I get the caller status to update from one table to another?