Hi @timutana, based on Steve’s advice, I ended up getting this to work. In my case, we have some machines that make a product. The machine operators record their Runs on the machine for each day. I wanted it so that if the daily report was open they could add and edit the Runs. But once they “punched out” for the day and submitted the report they could only view the runs. No adds or deletes.
I ended up creating two virtual columns.
One was “Runs for the day” which had a Show if of “ISBLANK([Transaction ID].[Production stop time])” and pointed to an Open ticket runs slice of the Runs table. The slice allowed Adds and Updates.
The second was a “Runs for the day - production closed” virtual column which had a Show if of “ISNOTBLANK([Transaction ID].[Production stop time])” and pointed to a Closed ticket runs slice of the Runs table. The slice was Read only.
Both slices were the exact same info, no conditions on the slice other that the one allowing add/updates and the other being view only.
At the end of the day you have a few things going on. You have 2 virtual columns, each with a show if condition. And each virtual column reference a different slice of the same table. One slice being Read only.
Would this work for you? What’s your application?