How to search for Column ID

Sometimes it is useful to use the ‘Column ID’ rather than the column name in a formula. This way the reference will always work, even if the column name changes. This is especially relevant in Cross Doc.

I have used this technique, and now many months later I am looking at a Cross Doc formula and I am unsure which column the formula references as it only presents a cryptic column ID.

The sidebar search does not return a result - anyone have a good idea of how to find the column?

Recorded a demo here:

2 Likes

Nice hack there Paul :slight_smile:

Do you know of any way to access the Column ID programmatically, within a formula?

I am aware of the various ways to get the table ID and the row ID from the grid reference that coda spits out when you enter the following:

thisRow + ""

There is also the _ROW_KEY hidden function which I prefer:

_ROW_KEY(thisRow)

There doesn’t seem to be a similar trick for the Column ID. But the fact you are able to extract it here makes me think there might be a way.