Hi, Newbie here just working my way through Coda. I have a table ‘Schedule’ which has a lookup in a column to a table called ‘Employees’. What I’d like to do is show above the table which employees have not been scheduled/selected (on the day filtered). I’m sure this is simple, and I did a searc…

hi @JasonB , you might have a look here : 🚫 Is there a formula for "Not Contains"? Other options: ContainsOnly() != best, Christiaan

Thanks for the response. The formula Not(Schedule.Crew.Contains()) returns the value ‘true’ rather than a list of employees not selected.

I am working on some coda stuff, short in time, but you might want to check this one out as well : Is it Possible for a select list to be selected only once? it took me some time to get the feeling :wink:

sharing a representative version of your tables would help

I know the suggestion from @Ander answers all your requests elegantly :grin: :+1: , @JasonB but I got curious about that specific one :point_down: :blush: [image] JasonB: I’d also like a warning if one employee is selected twice on one day, but can create a different topic if necessary. Your…

Hi @Ander , thank you so much for this, I think I need to get better at formulas because I can’t make it work on my data (and even posting my actual data will not help, because it will be rote learning). Does it take long to get up to speed?

Hi @Pch , thanks for that. I did consider that but sometimes employees do two different jobs on one day, hence the warning and the user being able to decide if it’s okay.

@JasonB The formulas take some practice, but you can get up to speed quickly by studying documentation for the ones that seem relevant to your use cases, here: https://coda.io/formulas The most important part is proper data structure (schema). Everything flows from that. Good data structure does m…

@JasonB , in that case, effectively, @Ander ’s suggestion seems to be the perfect lead to follow :wink: ! [image] JasonB: I think I need to get better at formulas because I can’t make it work on my data You don’t necessarily need to share the whole doc, but could you share a screenshot of the …

Show items NOT selected

Ander December 15, 2020, 12:41am 6

@JasonB

Here are some ideas you can play with:

Table row shading

Topic		Replies	Views
Issues w/ Switchif in Lookup Item Settings	6	724	March 31, 2021
Is it Possible for a select list to be selected only once?	13	2855	December 10, 2022
Should not be able to select same time for any date twice. How to do it?	14	955	November 2, 2022
How can I filter a select list for all yet unchoosen items?	2	570	December 28, 2022
Select list in the second row to be unique from first row	4	611	November 10, 2022

Show items NOT selected

Related topics