Fill Each Page from Its Own Tab
Copies each workbook tab's cells into the fields of its own page, with nothing inferred and nothing invented.
Overview
Readings are not prose. A thickness figure sits in a known cell of a known tab, and the form has a field waiting for exactly that cell. So this step is a copy, not a reading: the form's template carries the cell each field is fed from, and the values move across as they stand.
That is the point of the whole workflow. No model reads your measurements, nothing is inferred from them, and a cell you left blank arrives blank rather than guessed.
What It Does
| Capability | What it means for you |
|---|---|
| Cell to field, one for one | Each field takes the value of the cell its form names, and no other cell feeds it |
| A blank cell stays blank | A cell the inspector left empty leaves its field empty instead of inviting a guess |
| A tick only where the cell says so | A checkbox is marked only when its cell reads what the form expects there, and left clear otherwise |
| Every page at once, each on its own | All the named tabs fill together, and each comes back with its own result and its count of fields |
| Partly filled is reported as partly filled | A page whose mapped cells were not all filled comes back marked as partial rather than as done |
| A tab that held nothing says so | An empty tab, or one matched to the wrong appendix, comes back naming that rather than as a fill that broke |
| The workbook is recorded as the source | Each page it fills is stamped with the workbook it came from, which is what carries it into the finished document |
When the Agent Chooses This Tool
Available in the Coating QA workflow. The Fill Any Form, appraisal-report and pre-bid workflows do not have it.
The instructions call it once, after the pages exist, naming the workbook and the tabs whose pages were created.
- A page has to exist first. A tab with no page yet comes back saying so, and nothing is filled for it.
- Partial is not a problem to solve. The instructions say so outright, so the agent reports it and does not retry.
- A tab that errored is named in the summary and retried at most once.
Inputs and Outputs
Takes: the workbook and the tabs to fill.
Returns: one result per tab: how many fields the page received, how many cells its form maps, and whether the page came out complete or partial.
Example
Five pages are waiting, one per inspection tab.
One call fills them all. Four come back complete. The fifth reads partial, because the inspector left two readings for the next shift, and the agent says so in its summary instead of filling them with anything.
Limits
- A formula cell reads as what your spreadsheet last saved. Excel stores the result of a formula with the file, so a workbook last written by another program can hand over an empty cell where you see a number.
- A number reaches the field at two decimal places. A reading carried to more than that is rounded on the way in, and a date is written as MM/DD/YYYY whatever format the tab shows it in.
- Only the cells the form maps are read. A value you put somewhere the template does not name is not picked up, and no field outside that mapping is touched.
- A page whose mapped cells are all empty is marked failed, because a page filled with nothing is not an inspection. The run says which tab it was, and does not fill it again.
- A field with no cell behind it is never filled here. The signature fields are the ones that have none, so they reach you blank whatever the workbook holds, and they count towards neither the filled fields nor the missing ones.
- A form with no cell mapping cannot be filled here and comes back saying so.
- A tab with no page yet, or a page that cannot be filled, is reported per tab while the others go ahead.
- An attachment that is not this package's workbook is refused for the whole call, before any page is touched.
FAQ
Does the AI read my measurements?
No. The form's template names the cell behind each field, and the value is copied from that cell. Nothing about a reading is inferred or rewritten. It is written the way a form field takes it: a number to two decimal places, a date as MM/DD/YYYY.
My page says partial. What did I do wrong?
Nothing, most likely. Partial means some of the cells the form maps had no value when the workbook was read. Fill them in and run the package again, or leave them as they are. The signature fields are not part of that count: they have no cell behind them and are always left for a person.
My formulas show numbers in the sheet but arrive empty. Why?
A spreadsheet file stores both the formula and the last result it was saved with, and only some programs write that result. When the workbook was last saved by something that did not, the cell arrives empty. Opening it in Excel and saving it again fixes that file.