topic Editing Calculated Value Formula in Revit API Forum

Editing Calculated Value Formula

Anonymous — Fri, 07 Jun 2019 19:49:03 GMT

Is it possible to edit the formula of a Calculated Value in a schedule using the Revit API?

I'm using Python, and I can get the Calculated Value as a ScheduleField using the code below, but I can't figure out a way to access the Formula. Perhaps this isn't possible in the API at the moment? If it is, any help would be appreciated!

view = doc.ActiveView

nFields = view.Definition.GetFieldCount()

for i in range(0, nFields):
    field = view.Definition.GetField(i)

    if field.IsCalculatedField:
    
        fieldType = field.FieldType

This code gets the FieldType which is Formula, and according to this: https://www.revitapidocs.com/2017/8ea6756f-aa39-2a10-792a-c22eae32db55.htm it is a Get and Set property. But I don't understand how to Set it or if it is even possible

Re: Editing Calculated Value Formula

jeremytammik — Tue, 11 Jun 2019 06:57:45 GMT

Dear Dan,

Thank you for your query.

As you say, the FieldType property is a get and set property, so it can apparently be modified.

However, as far as I understand your query, you are interested in setting the formula value itself, not the field type, so that will not help.

You say you can retrieve the Calculated Value as a ScheduleField. Interestingly, the remarks on that class say:

The SchedulableField class represents a non-calculated field...

Anyway, regardless of all that, I cannot imagine that you can edit whatever is displayed by the calculated field, since, as its name implies, the value is calculated.

I hope this helps.

Best regards,

Jeremy

Re: Editing Calculated Value Formula

Anonymous — Tue, 11 Jun 2019 17:34:53 GMT

I think the ScheduleField is different than the SchedulableField, where ScheduleField includes the Calculated Values, correct me if I'm wrong.

I'm not interested in editing the value, but rather the formula. It seems like it's not possible, however, unless there's something else I'm missing.

Thanks for the reply, Jeremy.

Re: Editing Calculated Value Formula

jeremytammik — Wed, 12 Jun 2019 06:45:32 GMT

Can you edit it manually in the user interface? If not, the API will probably not support this either. If yes, there might be a way somehow. To discover how, perform the manual operation and research what exactly changed where, e.g., using RevitLookup:

https://thebuildingcoder.typepad.com/blog/2017/01/virtues-of-reproduction-research-mep-settings-ontology.html#3

Re: Editing Calculated Value Formula

Anonymous — Wed, 12 Jun 2019 14:32:11 GMT

Yes, it is possible to edit the formula of a calculated value as such:

1. Create the calculated Value

2. Add the formula in the Formula Field

3. After the value is created, you can select it in the Fields and click the pencil button to edit it. You can then edit the formula as needed in the Formula Field.

I have tried to use the Revit Lookup tool on the schedule, but I couldn't find anything of use. The farthest I can get is to get the Calculated Value, but I don't know how to access the Formula in the calculated value to be able to edit it.