Page 1 of 1

updating general table calculations that has hidden columns

Posted: Thu Jun 13, 2024 12:46 pm
by colt
My end goal is to create a rebuildable note that contains formatted assembly mass and cg dimension values.

I have successfully created this note using a general table.
works.jpg

I just hide all the unused rows and columns and end up with this tidy result
good.jpg

Where I am having trouble is with the rebuildable functionality of the note. I have found that the note is not updated until I manually unhide the hidden cells. Sigh...
ANNOYING.jpg

Anyone know another way to do this? Ideally all calcs should be done drawing side without having to add any new equations or properties to the model.

I have a macro that runs when I save the pdf. Maybe I can leave the table visible by default so the data is updated live, then hide cells right before pdf export, and finish up by restoring their visibility after export.

Re: updating general table calculations that has hidden columns

Posted: Thu Jun 20, 2024 4:55 pm
by mgibeault
In the assembly BOM table, when you show the column with the mass, you can have it add a row with the calculated total.
If I recall correctly... I am not there yet at my new job...

Re: updating general table calculations that has hidden columns

Posted: Thu Jun 20, 2024 4:59 pm
by mp3-250
If tables are a problem, try to make a block out of some notes linked to the properties you want to show and draw some lines around it.
we have a similar block, for weight only.

Re: updating general table calculations that has hidden columns

Posted: Sat Jun 22, 2024 7:39 pm
by colt
Thanks for suggestions. The table method has been working, I setup autohide code in my pdf export macro if the tablename = massTable.
@mgibeault Using the bom looked promising, I was able to do the same calculations and precision changes, then I linked my note to the bom cells using the 'link table cell' button. Unfortunately, when I hid the calculation column on the bom the referenced fields in the note went blank. I guess I could have an always visible off sheet bom to do calcs in.

@mp3-250 Do you know a way to change precision / multiply the custom property by value directly in note? I went through all this table rigamarole because I couldn't find a way.