Having difficulties with contain formula

[Remco_de_Louw]

Hi Guys.

If I have a table with a column that has a select option for days of the week and a row of that column has Thursday, Friday, Saturday, Sunday and I would like to see if thisrow.days contains the word Friday how would I do that? I tried loads of things like Contains(thisRow.days.Lower(),“friday”) I tried to text I tried the IN formule but it just does not work for me.

I googled a lot but can’t find to seem a working solution, sorry if this has been asked a million times.

For some reason I cannot get the hang of coda formulas.

[Christiaan_Huizer]

hi @Remco_de_Louw , I am afraid I do not understand well your question.

I created an example table with the USA day numbers, the WeekdayName and the contains function

and next the usage of Contains()

I hope it helps, if not please add a sample doc,
cheers, Christiaan

[Remco_de_Louw]

Hi Christiaan,

I have no clue how to make a sample doc, I would love to add it but instead I will add a picture.

So as you can see a few days have been selected in one cell and I want to do like an if contains statement on it .

[Christiaan_Huizer]

ahah, I see the issue.

the weekday names in Dutch live in a separate table I guess, maybe like the weekday names you see here. My table DB Days contains Dutch, French and other languages. This one was open in French. I selected multiple days per day and turned them into Dutch by referencing the column with Dutch day names.

first the filter I guess you might need

next the formulaMap

and this you can turn into a checkbox via an if statement

Not sure however it this makes it easier for you…
Cheers, Christiaan

[Remco_de_Louw]

Thaks @Christiaan_Huizer I think this does help me in finding a way to do what I want to do.
For some reason I find it hard to find the logic in the way coda wants me to structure formulas. I am more used to SQL and other languages that feel more logical to me.

I will see if I can use your examples!!