Dynamically retrieve column ID using the column title

Hi guys,
Is is possible to dynamically retrieve column ID using the column title?

I would like to reuse the same Make scenario across multiple boards, but the same columns carry different IDs across the boards.
I can set a limitation (not best practice, I know…), where the target column to be updated with a new value MUST carry a specific name.

Thanks!

hi @RyanBY

The columnId and the columnName are two different things. Even if you edit the column name to be the same the columnId will still be different and the API (and therefore Make) is using the columnIds. There is not an easy way to retrieve the Id knowing the name, other than go through all columns and check for the column name.

@RyanBY

Bas is correct, of course. However, getting the Id in Make it not difficult…

You can use the get board module to get the column information. Then to use the columnId of the column you want, just use an expression like this:
{{get(map(1.columns; "id"; "title"; "Person"); 1)}} (where “Person” is the title of the column you want)

Get Board data:

Expression (presented in a set variables module):


Jim - The Monday Man

:magic_wand: Column Magic :sparkles:- the magical columns toolbox app

1 Like