LabPP_Automat Guide for ARCHICAD

Adding a row with summation in numeric columns with a row that has the same key column value.

It is easiest to explain with a real example.

There are "Board" objects. These objects have the field "standard size" ("100x40", "50x40", etc.), "unit" ("linm", "sq.m", "cub.m") and "quantity" .

We want to get a summary table, where all the objects of the "Board" type in the project are summed up as follows:

To do this, we create a table with one key column and columns for regular data.

ts_table(TableDescr1,"add_column",0,"string","object name + type + unit");

ts_table("TableDescr, "set_first_key",0);

ts_table(TableDescr1,"add_column", 1,"string","objectname");

ts_table(TableDescr1,"add_column", 2,"string","tiposize");

ts_table(TableDescr1,"add_column", 3,"string","edizm");

ts_table(TableDescr1,"add_column", 4,"double","kolvo");

ts_table(TableDescr1,"set_columns_to_add_sum", "kolvo");

To add a row to a table, simply use the following entry:

ts_table(TableDescr1,"add_row_sum",0,objectname+tiporazmer+edizm, 1,objectname, 2, tiposize, 3, edizm, 4, kolvo);

As a result, all objects in the table with the same value name+type+unit. will be reduced to single records, and the column "quantity" will contain the amount количеств.