Here’s a riddle for the community

Not sure if this is what you’re getting at, but it seems similar, anyway:

  • Manually entered tasks with client selected from drop-down list = single row.
  • “Current client” field returns a list of some kind (e.g., Filter(), Lookup(), etc).
  • Tasks created by button copy the list-of-one value to the client field, which looks identical to a single row value, but is actually a different object (list vs. row).
  • Hence the two groups, because they are actually two different objects, even though they don’t appear that way to users.

SOLUTION: Convert “Current client” formula from returning a list to returning a single row by appending .First(), .Last(), etc.


What a coincidence that you would post this riddle today, @Paul_Danyliuk. I’m in the middle of a huge rebuild, and just caught this. It’s proving to be quite the pain to fix, and would have created nightmares if left undiscovered until farther down the road. I brought this issue up to someone at Coda long ago, but didn’t press the matter because I was too new to properly articulate why this hidden gotcha is going to be a big problem. I could probably articulate it a little bit better now… :grin: @Krunal_Sheth

6 Likes