It would be great to be able to reference columns with procedural strings.
When you have a large number of columns but with predictable names, this would be very useful.
I’ll try to explain the use case for clarity.
Let’s say we have these columns.
- Column 1
- Column 2
- Column 3
I’d like to be able to do:
That would give me
thisRow.[Column 3] but I currently can’t make it work.
I suppose I could change the topic title to “Reference Object Name with String”, columns are one of the use cases.
A possible solution would be to make brackets usable like this
But I get the feeling that if it was that simple, the Coda team would have done it already. Things are much more complicated behind the scenes, I can barely imagine.
Another solution would be to have a specific function like
Thank you for taking the time!