API - create a calculated value field in schedule

[adam.krug]

Revit API should enable creating a calculated value field in a schedule and also provide means to access and modify it (e.g. read and change the formula, name etc.). Simple as that.

[adam.krug]

Below are Revit API forum discussions on this, for reference.

https://forums.autodesk.com/t5/revit-api-forum/how-to-create-a-calculated-field-with-a-formula-in-re...

https://forums.autodesk.com/t5/revit-api-forum/schedule-calculated-value-field/m-p/8061967

[Anonymous]

Да, действительно данная возможность очень важна

Google translated by Community manager:
Yes, indeed, this feature is very important.

[PRP_MikeRichardson]

I vote for this.

It's relatively fundamental if you want to create schedules programatically.

Thanks

[scott.a.michaud]

Okay so hear me out. With new categories in Revit 2021-2023 there are a ton of Schedules that need to be converted to the new categories. (MEP specifically) This is a massive task. I've written code to handle other FeildsTypes but without this API method I'm kind of stuck with we gained a feature (ex: Plumbing Equipment Category) but now have a large manual task (rebuild schedules that may calculate many values for engineering use cases) in front of us to utilize it. Shiny new car that I can only look at... 😐😓

[vitalij.marcukov2BP2F]

I know I'm not the only one who's complained about how unbelievably long it takes to get these ideas implemented, but just out of interest, how many votes we need to achieve so this idea becomes a reality? 

[UP860073]

People, do something about it or make it an open source so revit users could do it.

[ali_and_bahar_71]

We are still waiting for it...

[reylorente1]

Algun progreso?

[taaviSWPX2]

How come there has been no progress on this in 7 years!? Please implement this function!

[a_sedlenieks]

We need this functionallity!

[kaiZQHQ4]

I agree, this is a crucial feature

[ankofl]

Since we don't have the ability to do this through the API, what if we get a pointer to the window where we create it manually, and try to do it through low-level interaction with the window?

[scott.a.michaud]

So at this time I have hit my "solution" its an interesting one but its still a work around.  We built-in the Calculated Parameters in to the Schedules and uploaded them to Content Catalog.  We then use the Combined and Calculated Parameters in a grouping of columns grouped as Hide For Plot. Then have users hide and unhide as needed. 

This give us the ability to have "✔" or "NA" or "-" in cells based on yes/no or other parameters. 

This is not ideal as its still work around and converting 200 Mechanical Schedules to Plumbing Equipment Schedules means recreating 200 x the number of adjustments via calculated parameters manually.  (Used API to recreate all Parameters and Formatting outside of the Combined and Calculated parameters) 

We hit the point where we are recreating tools or building tools to optimizer the work around with the API but it would still be nicer to be able to just generate calculated parameters.