Integrated BIM tools, including Revit, AutoCAD, and Civil 3D
Professional CAD/CAM tools built on Inventor and AutoCAD
Explore calculated parameters and bidirectional associativity.
Type:
Tutorial
Length:
7 min.
Transcript
00:03
As we scroll down the schedule here,
00:05
it can sometimes be difficult to remember
00:08
which parameter is actually in which column.
00:11
So for example, it would be easy to get the width and height columns here mixed up.
00:16
So to help with this,
00:18
we'll go back to the modify schedules and quantities ribbon here
00:22
and on the titles and headers panel, we can click the freeze header button
00:27
and then we can see the headers of the schedule come back into the top and
00:30
as we scroll,
00:31
they will stay there to help remind us which column represents which parameter.
00:38
Now looking at the width and height columns here,
00:40
they're currently reading in feet and inches
00:43
and we'd like them to display in inches only.
00:46
So to do this, I'll select one of the entries here
00:49
and then from the modified schedules and quantities ribbon.
00:52
We'll go over to the parameters panel here and then click format unit
00:58
in here. We'll unselected the used project settings option.
01:02
Now we can change the unit to be inches
01:06
and that will assign the unit symbol
01:09
and now click. Ok.
01:10
And we can see now that all of the entries in that width column display in inches.
01:15
So I choose an entry on the height column
01:18
and we'll go back and click the format unit button.
01:21
And again, we'll uncheck the project settings and change the units to inches
01:25
and assign the unit symbol
01:28
and then click. Ok.
01:29
And we can see both of those columns now are displayed in inches.
01:36
So we'd like to add a column in that calculates the area of the window opening
01:42
and to do this, we'll need to add in a calculated parameter.
01:48
So we'll go back to the modified schedule and quantities ribbon here
01:52
and from the columns panel here, we'll click insert
01:58
and now in between the two fields here,
02:00
we have some buttons and one of these is to add a calculated parameter.
02:05
So we'll click on this.
02:07
Now we said its name to be opening area,
02:13
it's going to be a formula
02:14
and we're going to calculate an area. So we'll change the type two area.
02:19
And now for the formula here,
02:21
we'll click the ellipsis button here to open up the fields
02:24
and we can only use fields that have been added to the schedule.
02:27
So I'll select the width field first and then click. OK.
02:30
And now we can add the multiply symbol from the keyboard here
02:35
and then click the button again and we can select the height field and click,
02:38
OK to add that into the formula.
02:40
So now we have that formula created of width multiplied by
02:42
height and it knows to calculate an area we'll click.
02:45
OK?
02:46
And we can see that's now been placed at the bottom of the scheduled fields.
02:51
So we usually move up arrow here and move
02:54
it up so that it sits beneath the height parameter
02:58
and now it will click. OK.
02:60
And we can see that new column added into the schedule here
03:03
and it's calculating the opening area of the window.
03:08
We also want to add in the comments field.
03:11
So we'll go back to the ribbon and click on the insert button once more.
03:15
And now we can select the comments from the
03:17
available fields and add it to the scheduled fields.
03:21
We can see that's added it in beneath the height. So we'll move it down.
03:24
So it's after the seal height
03:26
and then we'll click. Ok?
03:28
And we can see we have that comments column added into the schedule now.
03:32
And as we scroll down,
03:33
we can see any comments that have been added onto the individual objects.
03:38
And now to show the bidirectional associativity
03:40
between the schedule and the objects here,
03:44
we can see that we have on floor three here,
03:46
two windows that have a comment added that, that say tin in film is required.
03:50
Actually,
03:51
if I select window 29 here and then we'll start to add in the
03:55
same comment tinted and we can then pick that from the list here.
03:60
And we've now added that comment to window 29.
04:04
So with it selected,
04:05
we'll go up to the modified schedules and quantities ribbon here
04:09
from the elements panel. We'll click highlighting model.
04:13
Now we can see that swapped us to the 3D view we had open
04:17
and in the background, the window is highlighted,
04:19
but we want to see this in a plan view. So,
04:22
so we'll click the show button here for it to search through other available views.
04:26
And that's just letting us know that we don't have an open view that shows it.
04:30
So it'll need to search through the project browser. So we'll click. Ok.
04:36
And now we can see that we have that view open in the background. So I'll click close.
04:40
That's now looking at the floor three floor plan view.
04:44
We can see we have window 29 selected
04:47
and looking in the properties palette here,
04:49
we can see with the comments parameter
04:51
and we have that comment of tintin film required.
04:55
If I select window 28 just beneath this
04:58
and looking at the properties here, we can see the comments is actually blank.
05:02
So I'll start to type in tint in film required and then select it from the list here.
05:08
And then we applied it to window 28. I'll swap back to the window schedule
05:13
and we can see next to window 28
05:15
we've got the comment Tinton film required in the schedule too.
05:19
So we can see that this schedule is live looking at the model
05:22
and I, I'll swap back to the floor three plan view
05:26
and we'll add another window into the conference room here.
05:30
So to do this, I'll select the window here in the room below.
05:34
And now on the modify windows ribbon tab on the create panel, we'll click,
05:38
create similar
05:40
and from the place windows ribbon or select the tag on placement option.
05:45
And now we just place the window approximately in the middle of the conference room.
05:50
I click, modify to finish that tool.
05:52
And we can see now that that's window a
05:55
so now I'll swap back to the window schedule view
05:59
and at the bottom of the floor three group here,
06:01
we can see window 80 it's been added in
06:05
and that shows that the schedule is live and updated as the model is edited.
06:10
So now with it selected,
06:11
if I go back up to the modified schedules and quantities ribbon
06:15
from the rows panel here, click the delete button,
06:19
we'll get a message here that lets us know
06:21
we're going to delete that row from the schedule,
06:23
but also delete the associated element.
06:26
So we'll click. Ok. And we can see that row has been deleted
06:30
if I swap back to the floor three view
06:32
and we can see that that window has been deleted from the model.
Video transcript
00:03
As we scroll down the schedule here,
00:05
it can sometimes be difficult to remember
00:08
which parameter is actually in which column.
00:11
So for example, it would be easy to get the width and height columns here mixed up.
00:16
So to help with this,
00:18
we'll go back to the modify schedules and quantities ribbon here
00:22
and on the titles and headers panel, we can click the freeze header button
00:27
and then we can see the headers of the schedule come back into the top and
00:30
as we scroll,
00:31
they will stay there to help remind us which column represents which parameter.
00:38
Now looking at the width and height columns here,
00:40
they're currently reading in feet and inches
00:43
and we'd like them to display in inches only.
00:46
So to do this, I'll select one of the entries here
00:49
and then from the modified schedules and quantities ribbon.
00:52
We'll go over to the parameters panel here and then click format unit
00:58
in here. We'll unselected the used project settings option.
01:02
Now we can change the unit to be inches
01:06
and that will assign the unit symbol
01:09
and now click. Ok.
01:10
And we can see now that all of the entries in that width column display in inches.
01:15
So I choose an entry on the height column
01:18
and we'll go back and click the format unit button.
01:21
And again, we'll uncheck the project settings and change the units to inches
01:25
and assign the unit symbol
01:28
and then click. Ok.
01:29
And we can see both of those columns now are displayed in inches.
01:36
So we'd like to add a column in that calculates the area of the window opening
01:42
and to do this, we'll need to add in a calculated parameter.
01:48
So we'll go back to the modified schedule and quantities ribbon here
01:52
and from the columns panel here, we'll click insert
01:58
and now in between the two fields here,
02:00
we have some buttons and one of these is to add a calculated parameter.
02:05
So we'll click on this.
02:07
Now we said its name to be opening area,
02:13
it's going to be a formula
02:14
and we're going to calculate an area. So we'll change the type two area.
02:19
And now for the formula here,
02:21
we'll click the ellipsis button here to open up the fields
02:24
and we can only use fields that have been added to the schedule.
02:27
So I'll select the width field first and then click. OK.
02:30
And now we can add the multiply symbol from the keyboard here
02:35
and then click the button again and we can select the height field and click,
02:38
OK to add that into the formula.
02:40
So now we have that formula created of width multiplied by
02:42
height and it knows to calculate an area we'll click.
02:45
OK?
02:46
And we can see that's now been placed at the bottom of the scheduled fields.
02:51
So we usually move up arrow here and move
02:54
it up so that it sits beneath the height parameter
02:58
and now it will click. OK.
02:60
And we can see that new column added into the schedule here
03:03
and it's calculating the opening area of the window.
03:08
We also want to add in the comments field.
03:11
So we'll go back to the ribbon and click on the insert button once more.
03:15
And now we can select the comments from the
03:17
available fields and add it to the scheduled fields.
03:21
We can see that's added it in beneath the height. So we'll move it down.
03:24
So it's after the seal height
03:26
and then we'll click. Ok?
03:28
And we can see we have that comments column added into the schedule now.
03:32
And as we scroll down,
03:33
we can see any comments that have been added onto the individual objects.
03:38
And now to show the bidirectional associativity
03:40
between the schedule and the objects here,
03:44
we can see that we have on floor three here,
03:46
two windows that have a comment added that, that say tin in film is required.
03:50
Actually,
03:51
if I select window 29 here and then we'll start to add in the
03:55
same comment tinted and we can then pick that from the list here.
03:60
And we've now added that comment to window 29.
04:04
So with it selected,
04:05
we'll go up to the modified schedules and quantities ribbon here
04:09
from the elements panel. We'll click highlighting model.
04:13
Now we can see that swapped us to the 3D view we had open
04:17
and in the background, the window is highlighted,
04:19
but we want to see this in a plan view. So,
04:22
so we'll click the show button here for it to search through other available views.
04:26
And that's just letting us know that we don't have an open view that shows it.
04:30
So it'll need to search through the project browser. So we'll click. Ok.
04:36
And now we can see that we have that view open in the background. So I'll click close.
04:40
That's now looking at the floor three floor plan view.
04:44
We can see we have window 29 selected
04:47
and looking in the properties palette here,
04:49
we can see with the comments parameter
04:51
and we have that comment of tintin film required.
04:55
If I select window 28 just beneath this
04:58
and looking at the properties here, we can see the comments is actually blank.
05:02
So I'll start to type in tint in film required and then select it from the list here.
05:08
And then we applied it to window 28. I'll swap back to the window schedule
05:13
and we can see next to window 28
05:15
we've got the comment Tinton film required in the schedule too.
05:19
So we can see that this schedule is live looking at the model
05:22
and I, I'll swap back to the floor three plan view
05:26
and we'll add another window into the conference room here.
05:30
So to do this, I'll select the window here in the room below.
05:34
And now on the modify windows ribbon tab on the create panel, we'll click,
05:38
create similar
05:40
and from the place windows ribbon or select the tag on placement option.
05:45
And now we just place the window approximately in the middle of the conference room.
05:50
I click, modify to finish that tool.
05:52
And we can see now that that's window a
05:55
so now I'll swap back to the window schedule view
05:59
and at the bottom of the floor three group here,
06:01
we can see window 80 it's been added in
06:05
and that shows that the schedule is live and updated as the model is edited.
06:10
So now with it selected,
06:11
if I go back up to the modified schedules and quantities ribbon
06:15
from the rows panel here, click the delete button,
06:19
we'll get a message here that lets us know
06:21
we're going to delete that row from the schedule,
06:23
but also delete the associated element.
06:26
So we'll click. Ok. And we can see that row has been deleted
06:30
if I swap back to the floor three view
06:32
and we can see that that window has been deleted from the model.
How to buy
Privacy | Do not sell or share my personal information | Cookie preferences | Report noncompliance | Terms of use | Legal | © 2025 Autodesk Inc. All rights reserved
Sign in for the best experience
Save your progress
Get access to courses
Receive personalized recommendations
May we collect and use your data?
Learn more about the Third Party Services we use and our Privacy Statement. May we collect and use your data to tailor your experience?
Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.