I’m trying to get a value from a table based on a row and a column combination. The following example works fine since there ins a row with “Session” value in the Concept column and then the command returns de value of the CO3 column of that row: Table.Filter(Concept="Session").CO3 What I need es …

Have a look at the Switch() and SwitchIf() formulas. [image] Coda | Formula library A.k.a. the official book of Coda spells. Our formula library is a comprehensive list of everything cool that comes after "=" in Coda.

Unfortunately they don’t provide de functionality I require. I need a much more flexible option since the table and combinations are quite large.

We don’t yet have programmatic access to columns. If that’s what you want, common solutions I’ve seen are to restructure your schema or use switch statements.

It would be nice to be able to programmatically access columns. However (for any reader who will find it helpful) in most cases it really is much better to change the schema. Compare and contrast the “matrix” schema of attendance to the “database record” schema below. You can replicate the displ…

For the additional consideration of future readers: [image] Ryan_Martens2: in most cases it really is much better to change the schema. In my experience I find that the correct decision here is driven by use case. In most of my use cases (~70%), restructuring the schema would generate too m…

Our of curiosity, Ander, what is that use case where the schema can’t be restructured and there’s no way switch statements will work? As for @Giovanni_Sades ’ case, I’m assuming based on the names of the columns (CO3, CO4, etc) that all those columns are the same data type and together serve one pur…

@Ryan_Martens2 (1) There have been several of these cases over the years. I’ve just built workarounds or gone without the desired functionality, and moved on. I don’t recall their specifics. (2) I’m sure your proposed solution for Giovanni is solid.:grinning: It might very well be the way to go in…

[image] Ander: But this issue of users wanting programmatic access to columns is not truly solved via schema restructuring – at least in my experience. From a data structure standpoint, schema restructuring does technically solve the problem. However, from a human user standpoint, it will often …

I’ve got a good example for you. I have a table of templates and a button to append those templates to Canvas columns in a table. What I’d like to be able to do is apply different templates to different columns based on what column they are intended for. Without programatic access to columns this…

Interesting. How many canvas columns do you have on that table? Would it be too unwieldy to use a Switch or SwitchIf formula?

Selecting column dynamically

Rickard_Abraham May 11, 2024, 11:28am 14

I’ve made a suggestion here that I believe would solve this

Topic		Replies	Views
New formulas for columns Product Feedback	5	1235	December 8, 2024
Dynamically selecting columns	7	1538	August 14, 2019
Is it possible to filter columns just like rows?	7	228	December 8, 2024
How to get column name? (To generate )	10	5066	August 29, 2023
How can I formulaically point a column of a table from a formula of another table?	2	1018	April 19, 2020

Selecting column dynamically

Related topics