Unable to get formula column values via API

[dinithij]

Hi All

I am working on building a small monday.com app and trying to retrieve formula column values through API. I get ‘null’ as the value for all formula type columns.

Questions,

1. Is it possible to get formula type column values via API?
2. If it is not possible, Is there any way I can get the used formula, for me to do the calculation on client side?

Thanks
Dinithi

[PolishedGeek]

Hi @dinithij - The API will not give you dynamic results for things like formula and progress columns. You’ll need to pull in the column settings and generate the values on your end from what you find in the settings.

We built an app that uses both formula and progress columns to prioritize cards on a board view, and @Spunkie may be able to add more context as well. It will take more coding on your end to reproduce the dynamic functionality.

Perhaps if we’re lucky the next version of the API will include dynamic values.

[dipro]

@dinithij - you can also check out this post for a discussion on how to do this:

Mutation: create_column for a 'formula' type column

Hey everyone! Just wanted to follow up on this – @PolishedGeek is right! While our API does not support reading the calculated value of a formula column, you can use the settings_str field to get the config of the formula column. This config contains the raw formula. Since the formula is almost identical to the Excel syntax, you should be able to pipe this into a formula parser of your choice. Here’s a simple example of the process: Get all the column values from the board Get the formula i…

[azmat]

we can create subitem colmn by API??

[AlexSavchuk]

@azmat

Thanks for asking! At this time, you will not be able to create sub-item columns via the API, just like with Connect Board columns.

I would recommend raising this question as a separate topic in the future, as your query doesn’t quite seem to be related to the main topic of the discussion here. I hope that makes sense

-Alex