separate cell data extraction in combination

[Giuno85]

Good evening to all,
I am trying to use the separate table of materials created together by making additions and multiplications to have a cost count.
My intent is to, after doing a mathematical operation in a separate cell, I would like to write the result inside the custom properties of the axieme, or even as a global variable. .
Unfortunately, I haven't been able to get over it, thank you very much for the help

 

[MassiVonWeizen]

with distinct materials I see it difficult if not impossible. Perhaps it could be feasible with a data table dedicated to that purpose. the reading of the drawing by the side or together I never faced it

 

[MassiVonWeizen]

I did some tests and it is possible to do it on the parts.
the method is as follows
insert into the parts all items including those that must be read by the drawing
once inserted the distinct in the drawing click on the cell to read and insert the equation
made this double click on the same cell and the notice will appear if you want to maintain the link, give confirmation and the property is transferred

explanatory video allego. (the voice of the property weight tot does not correspond to that of the part because I modified it later, but it is only text while the property of the column is correct. )
View attachment 20170923_1600_53.zip

 

[Giuno85]

thank you so much from the answer, the method you illustrated is to write inside the files of the parts, the properties customized from the cell of the distinct components.
I meant to write inside the custom properties of the set a value contained within the cell of the distinct components resulting from an operation performed.. such as a total of a sum of more cells. . .
I have attached pictures... in image 1 there is my distinct components inside a set where I circled red the value of the cell I would like to transcribe in the custom properties of the axieme where it is contained (picture 2)

 

[MassiVonWeizen]

the distinct materials do not report data of the main set, but only of its components.
Can you insert in the custom table of the set?

 

[Giuno85]

In fact, I would like to do the opposite, write a separate material in the personal property of the axieme... .
- - - updated - - - -then make a count to the distinct material.... and then write the result into a cell of custom properties of the assieme

 

[MassiVonWeizen]

I understand that, I'm asking if you can enter any property together in the table. this because the distinct materials read the secondary parts and assemblies and not the main one. If you can then it can be feasible otherwise I'm not very convinced

 

[Giuno85]

I tried to connect a property together in tabela and it worked... image 3 -4.. properties test... and I put random numbers.. And I tried to connect her... and it worked.... the beautiful now is to do the opposite...
take the result "1428" and put it inside the weighted property

 

[MassiVonWeizen]

Since it is a table that you manipulated a lot, at a quick look, attach the file so you work on the same line

 

[MassiVonWeizen]

the principle should be the same as post #3.
if you connect to a property (try in the example) of the axieme with a double click should tell you that the cell is connected and if you want to keep the link or not.
then create a property that will be called sub total painted (or what you call back in the column) and handle it as I explained in post #3

 

[MassiVonWeizen]

I did some tests and with the method I used, which could be different from yours, it doesn't work.
in practice the cells referred to the properties of the axieme are cells added ex novo and not native to the distinct materials and the row to which they refer (the lines are normally the individual details) is not linked to the axieme.
therefore it is true that the cell reads the properties of the assieme, but in a forced way as seen from the first image of the post #8

Maybe you've made the difference and need your file to understand the possibility of management

 

[Giuno85]

exact is exactly so I go to enter the value of the custom property of the assieme into a table cell that is not tied to the parts... in post #8.... but the goal is the opposite... go to write the value of the forced cell, not connected to any part, used to perform arithmetic operations, in the custom property of the axieme (post #4 image 2)

 

[MassiVonWeizen]

You know what your goal is.
put so according to me it is not possible because the cell is not linked to the property like those of the parts.
or better, it is not possible through separate materials

 

[MassiVonWeizen]

a possible solution to trick the system would be to insert an empty, perhaps virtual part, with the same name as the axieme.
in this way in the distinct the siege with the properties linked and therefore transferable from the separate to thetogether.
keeping the virtual part there is no possibility to lose the file and therefore part and together always go hand in hand and being empty will not affect either the weight or other details.
in this way also the possibility of transferring that cursed property from the side to the aid could be possible; I have no idea how, but if I have a lighting like today's, I'll make some evidence.
Maybe there's some discussion about it, try to do some research.