Wire sheet columns to inputs — gull system handbook
Wiring an Excel source's columns to a configurator's inputs: dragging an input onto a column, unlinking, what unsaved and saved wiring mean, when a wire drops.
Wire sheet columns to inputs
Every sheet column fills at most one input. Until you save the wiring it is only a suggestion by matching names; after saving only what is saved counts.
Procedure
- Every column is a row with its heading and position (`A:A`, or `1:1` in the by-column layout). An empty one says Drag an input here.
- From the Unassigned inputs list below drag an input onto a column. A wired column shows the input as a blue chip; the cross on it unlinks the input. The input can also be picked under Properties → Input.
- Save with the header's Save. Only then does the wiring count.
What saved wiring means
- State: never saved - What happens on an order: the column heading finds the input of the same name — regardless of case and spaces, diacritics included. The app shows this as a suggestion.
- State: saved - What happens on an order: only the saved wiring counts. A column you left empty sends nothing.
- State: saved and cleared - What happens on an order: the column sends nothing and nothing is guessed again
The status column cannot carry a value — it serves the order status only.
When a wire drops
- When you rename the heading in Excel.
- When you delete the input.
- When the heading disappears from the sheet.
The Home screen reports it as "A loose heading in Excel — orders will not start". Open the source, drag the input again and save.
Ribbon buttons
- Open in Excel (or Open folder).
- Reload reads the saved sheet again, for example after adding a column. Not before the first save: "Save the file changes first".
The values a column carries
In the selected column's Properties is Values in the sheet — a preview of what is really in the column. A value must satisfy the form field collecting the input: MIN and MAX, list items, a table row. A row with a value out of range is refused just as in a form — see Field types and their properties.