In slices - can you write an expression on a virtual column?
Can you be more specific?
If you want to use a virtual column as a filter for a slice, the answer is:
Yes, you can do that.
I have a table that’s my main table used year round.
During incidents, like a hurricane, there is additional data collected that results in certain actions.
Because this is incident specific I was trying to keep this data separate from the main table.
However, i run into issues with workflow because I can’t cross reference certain columns.
I found myself adding columns to the main table just to get filtered data the users could act on - pain.
so you got 2 tables and want to filter data in table A, based on data in table B?
as long as you use a column of the type “ref” that references the one table to the other you can access columns like this
does this help?
I would use in the slice filter?
Here is what I’m trying to do.
Assigned Caller is in table a (registry) but the outbound call complete is in table b (call out).
Preferably I didn’t even want the assigned caller in the registry table but I couldn’t figure out another way to get the names to display in the views I needed.
AND(ISNOTBLANK([Assigned Caller]), [Registry_RegID].[Call Out_Outbound Call Complete]=“no”)
Try to get all the completed calls to filter off the callers list.
So you just want to show the calls wich are not done?
Do you initially save “no” to [Call Out_Outbound Call Complete] ?
If that is the case, then this should work just fine.
Can you make your APP publice so that I can check out the column structure?
you could duplicate it first (to keep your private version to you)
I don’t know how to do that.
Am I able to add you as a collaborator?