Hi all, I’m trying to use coda to make a scheduling table, where individual staff have different assignments during the same period. I want to include a catch to make sure I don’t assign the same staff twice during the same period. I’ve been trying to change the item settings on my lookup column (which looks up staff on a separate table) so that if they’ve already been assigned during that period, their name doesn’t show up.
However, it only seems to be working for the first argument. For the second argument, all staff still show up even though they have an assignment during that period. Any ideas? Picture for Reference.