get average of test results for each item from another table
i set up a database to help me organize battery cells and figure out which are good and bad. i have a table for each make & model’s rated specs, a table with the results for the each battery cell’s capacity test (each test is a record and a battery cell can have multiple tests/records) and a table f…
you will need to manually link each battery record to all of its battery test records (using a linked record field).

then you can create a rollup field to give you the average of all its battery tests.
hi [@jitse\_b](/u/jitse_b)

welcome to the community !

yes you can, there are various ways to do so.

the simplest:

you may want to create a table with 3 columns,

key\_column, type text, value “k000” (or whatever you want, it doesn’t matter if you stick to only one comparison)

“material1”, type ref, source tabl… g = findgroups(yourtable.name);
output = splitapply(@(varargin) {table(varargin{:}, 'variablenames', yourtable.properties.variablenames)}, yourtable, g);
this should give a cell array of tables. You need to iterate over the resource...

 
```
while ($row = mysql_fetch_object($tariff_query)) {
    echo $row->somefield;
    echo $row->someotherfield;
}

```
 So you now get all the records not just the first one.

 BTW, if you want to use an object, why not use PDO or mysqli? mysql is dead - or as good as. hey, so after some minor improvements i finally found the time to make this into a doc that everyone can use, adopt and copy. let me know what you think and if you have any improvements.

[image]

[life dashboard - the all in one tracker](https://coda.io/@heuschkelsimon/life-dashboard-all-in-one-tracker)

track your personal habits, finances, tasks and time … here is an example notebook

<https://gist.github.com/volkerh/465925d24accc940f7a0a0b1f5f40f7a#file-map_array_example-ipynb>

map\_array\_example.ipynb

{

"cells": [

{

"cell\_type": "code",

"execution\_count": 1,

"id": "satellite-momentum",

"metadata": {},

"outputs": [],

"source… *any examples are for illustrative purposes only.*  
  
the standards do not require a log sheet to be maintained for waived tests. the organization is required to be able to correlate the quality control results with the individual test results. examples of typical correlated information would include the following:
* client identifier
* date of testing
* test kit lot number
* test result, qc lot numbers
* qc results
* testing personnel identifier


logs are useful for compiling this information in one comprehensive document. alternatively, the organization may choose to document this information in the client chart or utilize a combination of document sources to correlate the information. for example, an organization performing occult blood testing elects to document the date of testing, client result, qc result and testing personnel initials in the client chart. a separate inventory log is maintained to track the lot of reagents and test cards in use at the time of testing. performance of initial qc for the lot, when required by the organization's policy, could also be documented on the inventory log prior to releasing the kit for general use. you might be able to use synchronize. if you have more than 2 tables, you will need to use it multiple times. hi paul,

i believe the financial reporting covers in quite a lot of detail exactly what you are looking for.

from what i can tell you aren’t using templates in your tables…

[[image]](https://forum.enterprisedna.co/uploads/db7134/original/2x/5/559a333f85c159c8d9bec9235ca5c45997d08858.png "image")

if you want to get a certain order and custom table then you really need to use the template approach covered in t… I just posted an example of this over in a similar thread about JTable [here](/software-development/java/threads/373078/1605358#post1605358). Perhaps it will help. Hi Djhenry,
  

  
When you right-click a sheets tab, you can select all sheets. When you have done that, you can insert a row and enter all the information and all sheets wil contain that information.
  

  
Best regards,
  
Trowa