😬 What was hard for you to discover in Coda?

As you use Coda have you found things that were hard to find but easy to use once you knew it existed and figured out how to use it?

Would love you hear of these in reply below.

I have a few of my favorites below - I’ll keep adding to this list from the replies :slight_smile:

4 Likes

I’m pretty new to all this and I’m still really struggling with a lot of the coding and relationships between different tables and views but here are some of the things I’ve struggled with recently.

Calculating total days spent by someone, when they have multiple different tasks which may fall on the same day.
Using the Filter Function in different scenarios.

1 Like

Discovering that I could reference individual rows with @display column value in formulas and not have to do Table.Filter(...).First()

UPD: just saw it was already on the list

6 Likes

Good initiative :+1:

  1. Reverse lookup :left_right_arrow:
  2. Search a table :mag:
1 Like

Could you expand on these concepts for those that don’t know how to do it and stumble on this thread? I.e.: How do you reverse lookup / search a table?

3 Likes

It would be nice to add a field for voting on your table. This way we could vote the items that were hard to figure out for us

2 Likes

Using a formula to generate the visual row numbers (not RowID). There is a Find() variant that works for many of my cases, but it was not easy to locate. It was extra confusing (and still can be) since the numbers appear left of the rows (i.e. it seems like something that there is a formula for).

1 Like

Thanks for the suggestions so far - I have added them to the doc.\

@GJ_Roelofs - Once I have the list I will pass it onto our product team to make in product improvements and we can also work on expanding these concepts and providing link and help for them.

@Juan_Luis_Chulilla - good suggestion. For now can you just mention them in the thread please - would also love to know why you found something hard or how you learnt about it.

Ah, also that special care needs to be paid to whether it’s a value, or a list with a single value.

  • in formulas (using .First() where appropriate)
  • in formula columns with Lookup table type (properly switching the “Allow multiple values” on or off)

More on that: Here’s a riddle for the community

2 Likes

That is a tricky one. We need a whole section dedicated to debugging and helping with this!

For me it’s understanding how to use formulas for something I can describe in words but am unsure how to actualize in the Formula logic. For instance, if there’s a value in a cell, then do X. I found the documentation on the Formulas a little dense (I’m not an engineer) so turning to Community and Help chat was integral to my success.

Hope that helps!

2 Likes

“Named Parameters”. See this thread.

1 Like

Added @Ian_Nicholson - even I forget about that one now and then!

1 Like

Hi @mallika,

Instead of getting a copy from another users doc,

That you can copy content from a “view only” doc and place it in a doc you are the owner of.
Automatically you will be able to see all formulas used!

Important: if the content you copy has “related tables”, “controls” and "formulas"over more pages, it’s important to take them with you. (see doc map)

2 Likes

That you can see the changelog / history of a row, courtesy of Al_Chen_Coda:

2 Likes