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

Superhuman Ask the Community

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 Ask the Community	6	735	March 31, 2021
Is it Possible for a select list to be selected only once? Ask the Community	13	2886	December 10, 2022
Should not be able to select same time for any date twice. How to do it? Ask the Community	14	973	November 2, 2022
How can I filter a select list for all yet unchoosen items? Ask the Community	2	586	December 28, 2022
Select list in the second row to be unique from first row Ask the Community	4	620	November 10, 2022

Show items NOT selected

Related topics