topic Re: Schedule - calculated value / field in Revit API Forum

Schedule - calculated value / field

Anonymous — Thu, 21 Feb 2013 22:14:46 GMT

hi,

Using the ScheduleDefinition.GetSchedulableFields it is possible to iterate through the available (shared) parameters and add or insert (addfield or insertfield) them to the created schedule.

However I wish to add a calculated value / calculated field to the schedule. This field does not show up in GetSchedulableFields because this field has to be added 'on the fly'. In the API there is a schedulefieldtype.formula member which suggest it may be possible to add a calculated field. Does anyone know how to add a calculated field because I am running out of ideas

regards,

Raymond

Re: Schedule - calculated value / field

jeremytammik — Thu, 14 Mar 2013 11:22:27 GMT

Dear Raymond,

Yes, sorry, currently not possible. Revit 2013 provided a first stab at a schedule API, to be fledged out in future, e.g. to access individual values.

Cheers, Jeremy.

Re: Schedule - calculated value / field

YarUnderoaker — Sat, 01 Jun 2013 22:27:45 GMT

Hi.

Is this possible in Revit 2014? I can find how to add calculated fields.

Re: Schedule - calculated value / field

jeremytammik — Sun, 02 Jun 2013 00:00:56 GMT

Sure. Look at the new SDK samples:

ScheduleAutomaticFormatter
ScheduleCreation
ScheduleToHTML

Best regards,

Jeremy

Re: Schedule - calculated value / field

YarUnderoaker — Sun, 02 Jun 2013 07:45:33 GMT

Exactly, thank you. I habitually use the SDK 2013 and was looking for methods in documentation and forgot that there is already a new one

Re: Schedule - calculated value / field

YarUnderoaker — Sun, 02 Jun 2013 08:59:49 GMT

Unfortunately I still can't see what to do for creating calculated fields 😞

Re: Schedule - calculated value / field

kmiller — Thu, 09 Apr 2015 19:26:28 GMT

Anyone ever find the syntax and/or method for this? I have been searching for hours and haven't found it yet. Not on the forums or examples. Basically I want to create a new field called "Height" and set it equal to an existing field called "Thickness". Then going to hide the thickness columns/fields. Common discipline of Length type if that matters at all.

Running 2015.

Re: Schedule - calculated value / field

jeremytammik — Thu, 09 Apr 2015 21:54:14 GMT

Dear Kmiller,

I searched the help for 'formula' and 'calculated' and could not find it.

All the field methods in the ScheduleDefinition class 'regular' fields that are apparently explicitly non-calculated.

I'll check with the development team, though.

Cheers,

Jeremy

Re: Schedule - calculated value / field

kmiller — Fri, 10 Apr 2015 16:21:13 GMT

Thank you - I also did a search of some items in the object model, or think I did it correctly and didn't come up with a whole lot. Was hoping maybe it was named something different.

If this isn't available, is there any other options to get the same results?

Re: Schedule - calculated value / field

Anonymous — Sat, 11 Apr 2015 08:44:54 GMT

Hello, i have been searching on this as well. Is this possible in Revit 2015 API? What i would like to achieve is to add a calculated value with formula into the schedule.

Re: Schedule - calculated value / field

kmiller — Mon, 04 May 2015 15:33:21 GMT

Hey Jeremy -

Did you get anywhere with checking with the development team on this?

Re: Schedule - calculated value / field

jeremytammik — Mon, 04 May 2015 20:26:32 GMT

Dear Kmiller,

I have not heard back from them yet.

I re-prompted for an answer now.

Cheers,

Jeremy

Re: Schedule - calculated value / field

Aaron.Lu — Wed, 10 Jun 2015 06:11:59 GMT

Dear,

Currently both Revit 2015 and Revit 2016 cannot support adding formula fields and percentage fields.

Re: Schedule - calculated value / field

Anonymous — Wed, 02 Aug 2017 11:02:40 GMT

Hi Aaron,

Any change in this for 2018? We really need to add calculated fields via the API.

An alternative option for us would be the ability to perform type conversions in the formula column of parameters for a family, eg text to weight.

Or even access to custom routines in the formula.

Best regards

Paul

Re: Schedule - calculated value / field

Anonymous — Fri, 04 Aug 2017 06:49:38 GMT

Hi Jeremy,

Is there any change on this issue for 2018.1? (please see my last post to Aaron Lu).

Best regards

Paul

Re: Schedule - calculated value / field

Anonymous — Mon, 14 May 2018 09:00:30 GMT

Hi All,

Would really love to hear that it's been added in the Revit 2019? Any updates?

Best Regards,

Khaled

Re: Schedule - calculated value / field

jeremytammik — Mon, 14 May 2018 09:13:11 GMT

All the most important enhancements are listed here and in the SDK documentation:

http://thebuildingcoder.typepad.com/blog/2018/04/whats-new-in-the-revit-2019-api.html

Re: Schedule - calculated value / field

Anonymous — Tue, 12 Jun 2018 07:40:02 GMT

I guess that's a no then?

Best regards.

Paul

Re: Schedule - calculated value / field

jeremytammik — Tue, 12 Jun 2018 07:50:44 GMT

Dear Paul,

Is the functionality you are after provided by the Revit user interface?

If so, you have a good chance that it is available programmatically as well.

If you don't know, you might want ask about it in one of the user interface related forums instead:

https://forums.autodesk.com/t5/revit-api-forum/this-forum-is-for-revit-api-programming-questions-not-for/td-p/5607765

The people there are much better equipped to answer your question than us programming nerds.

I hope this clarifies.

Best regards,

Jeremy

Re: Schedule - calculated value / field

Anonymous — Tue, 12 Jun 2018 08:13:46 GMT

Hi Jeremy,

Thanks for the quick reply. In answer to your question, you can set up a calculated field via the UI, but up till now (as far as I know), not via the API.

Best regards

Paul