Full Customer Form Schema
Back to form
Customer Form Field Information
Full field overview, section by section, with UI format, selectable input values, and SQL storage type.
1
SQL Mapping
1. Basic Information
20 fields
| Question | UI Answer Format | UI Answer Input | SQL Storage Format |
|---|---|---|---|
| Your position/title | Text | Free text | VARCHAR(255) |
| Mobile | Phone number | International phone input | VARCHAR(50) |
| Telephone | Phone number | International phone input / optional | VARCHAR(50) |
| I confirm that I am authorized to claim this company and manage its information. | Checkbox | True / false | BOOLEAN |
| Company name | Text | Free text | VARCHAR(255) |
| Organization number | Text / Number | Registration number | VARCHAR(100) |
| Company website URL | URL | Valid URL input / optional | VARCHAR(500) |
| Company email | Valid email input | VARCHAR(255) | |
| Visiting address | Text | Free text | TEXT |
| Postal code / Zip code | Text | Postal / ZIP code | VARCHAR(50) |
| Postal city / City | Text | Free text | VARCHAR(255) |
| County | Single choice | Oslo, Østfold, Akershus, Buskerud, Innlandet, Vestfold, Telemark, Agder, Rogaland, Vestland, Møre og Romsdal, Trøndelag, Nordland, Troms, None / Not applicable | VARCHAR(100) |
| Upload company logo | File upload | Image upload | TEXT |
| Number of employees | Single choice | 1-4 employees, 5-9 employees, 10-24 employees, 25-49 employees, 50-99 employees, 100-249 employees, 250+ employees, None / Not applicable | VARCHAR(50) |
| Year established | Number | 4-digit year | INT |
| Annual revenue in EUR | Single choice | Under EUR 100,000, EUR 100,000-499,999, EUR 500,000-999,999, EUR 1-4.9 million, EUR 5-9.9 million, EUR 10-19.9 million, EUR 20-49.9 million, EUR 50 million or more, None / Prefer not to say | VARCHAR(100) |
| Which industry/industries do you mostly operate in? | Single choice | Food industry, Mechanical industry / machine building, Plastic and composite production, Electronics and electromechanical industry, Metal industry / steel and welding, Furniture industry and woodworking, Aquaculture and fish processing, Pharmaceutical industry, Process industry, Logistics and packaging solutions, Building automation / ventilation / electrical, Energy and hydropower / renewable energy, Recycling and waste management, Laboratories / R&D / test environment, Public sector and health technology, Automation for small and medium-sized companies (SMB), Other, None / Not applicable | VARCHAR(255) |
| If other, describe | Textarea | Free text / optional | TEXT |
| What products and services do you offer? | Text | Free text / optional | TEXT |
| Who are your customers? | Textarea | Free text / optional | TEXT |
2
SQL Mapping
2. Production process & the task to be automated
12 fields
| Question | UI Answer Format | UI Answer Input | SQL Storage Format |
|---|---|---|---|
| What do you want to automate - or which part of production should be automated? | Textarea | Free text | TEXT |
| What type of automation are you considering? | Single choice | Sorting, Dismantling / picking, Battery handling, Internal logistics / moving, Reuse-triage, Quality control / identification, Other (describe), None / Unsure yet | VARCHAR(255) |
| Describe other | Textarea | Free text / optional | TEXT |
| What is the product that the automation should handle/interact with? | Textarea | Free text | TEXT |
| What type of EE-waste or fraction does this apply to? | Single choice | Small electrical, White goods, Circuit boards / electronics, Batteries (loose), Batteries embedded in products, Cables, Plastic fractions, Metal fractions (aluminum/steel), Other (describe), None / Not applicable | VARCHAR(255) |
| Describe other | Textarea | Free text / optional | TEXT |
| What does today's workflow look like? | Textarea | Free text | TEXT |
| Are there HSE or safety risks in today's process? | Single choice | Fire risk, e.g. batteries, Cut/injury risk, Heavy lifting / ergonomics, Chemicals, Dust/particles, Electrical risk, Other (describe), None | VARCHAR(255) |
| Describe other | Textarea | Free text / optional | TEXT |
| Does the company have several locations that this need applies to? | Textarea | Free text | TEXT |
| Keywords (tags) you want to be shown on RoboConnect.no | Textarea / Tags | Free text / hashtag list | TEXT |
| Do you have questions, challenges, or are you unsure about anything? | Textarea | Free text | TEXT |
3
SQL Mapping
3. Production, volume & flexibility
9 fields
| Question | UI Answer Format | UI Answer Input | SQL Storage Format |
|---|---|---|---|
| Production volume today? | Textarea | Free text / optional | TEXT |
| Approximately how long do you currently use to produce one unit, e.g. one product, one coil, or one part? | Textarea | Free text | TEXT |
| Is the production serial production or many small variants (high-mix-small-volume, many changeovers in a day)? | Textarea | Free text | TEXT |
| How much variation is there in incoming waste/products? | Single choice | Low (same type of objects, little variation), Moderate (some variation in size/shape/material), High (chaotic flow - many different types), Unsure (describe), None / Not applicable | VARCHAR(255) |
| Describe | Textarea | Free text | TEXT |
| How often does the product change? (high vs. low product variation) | Textarea | Free text | TEXT |
| What quality requirements apply to the final product | Textarea | Free text | TEXT |
| Product specifications | Textarea | Free text | TEXT |
| Upload images, sketches, or video of the products | File upload | File list | JSON |
4
SQL Mapping
4. Technical & physical framework
12 fields
| Question | UI Answer Format | UI Answer Input | SQL Storage Format |
|---|---|---|---|
| What is the working environment like where automation will be implemented? | Textarea | Free text | TEXT |
| Food production or another type? | Textarea | Free text | TEXT |
| How much space is available for a robot cell? | Single choice | Small <10 m2, Medium 10-30 m2, Large >30 m2, None / Unknown | VARCHAR(100) |
| Requirements for availability and downtime? | Textarea | Free text | TEXT |
| Which systems do you use today? | Single choice | Visma, Tripletex, SAP, Microsoft Dynamics, Monitor ERP, RamBase, PowerOffice, Omega 365, SCADA system, MES system, Other production or control system, We do not use such systems, Other/others, None / Unsure | VARCHAR(255) |
| If other/others, specify | Text | Free text / optional | TEXT |
| Which communication protocols do you have today? | Single choice | PROFINET, EtherCAT, Ethernet/IP, Modbus (TCP/RTU), CAN/CANopen, OPC UA, IO-Link, Other/others, We do not have communication protocols | VARCHAR(255) |
| If other/others, specify | Textarea | Free text / optional | TEXT |
| Which suppliers or makes do you use today? | Single choice | Siemens, Rockwell Automation / Allen-Bradley, Omron, Mitsubishi Electric, Schneider Electric, ABB, Beckhoff, Festo, Bosch Rexroth, Weidmuller, No known suppliers, Others, None / Unsure | VARCHAR(255) |
| If others, specify | Textarea | Free text / optional | TEXT |
| Do you have existing PLC or control systems? | Textarea | Free text | TEXT |
| Is there equipment that must be retained or connected to a new system? | Textarea | Free text | TEXT |
5
SQL Mapping
5. Goals, scope & financial framework
11 fields
| Question | UI Answer Format | UI Answer Input | SQL Storage Format |
|---|---|---|---|
| What is your most important goal with the automation | Single choice | Reduce costs, Increase capacity, Improve quality, Better HSE, Other, None / Unsure | VARCHAR(100) |
| Other, describe | Textarea | Free text / optional | TEXT |
| What is your upper budget (EUR) for the automation solution? | Textarea | Free text / amount | TEXT |
| What is the expected return time (ROI) | Single choice | Within 1 year, Within 2 years, Within 3 years, > 3 years, None / Unsure | VARCHAR(100) |
| Do you have financing in place? | Textarea | Free text | TEXT |
| Are you looking for a gradual start-up (proof-of-concept/pilot) or a full-scale solution | Textarea | Free text | TEXT |
| When do you want to start up? | Single choice | As soon as possible, Within 1/2 year, Within 1 year, Within 2 years, >2 years, None / Unsure | VARCHAR(100) |
| Do you need help with financing? | Textarea | Free text | TEXT |
| Which payment model do you prefer? | Single choice | One-time amount, Split payment, Pilot first, Leasing, Other, None / Unsure | VARCHAR(100) |
| Other, describe | Textarea | Free text / optional | TEXT |
| Do you have growth ambitions you want to realize? | Textarea | Free text | TEXT |
6
SQL Mapping
6. Experience & readiness
2 fields
| Question | UI Answer Format | UI Answer Input | SQL Storage Format |
|---|---|---|---|
| Do you have previous experience with automation? (Yes/No - briefly describe) | Textarea | Free text | TEXT |
| Do you have in-house competence in programming, robotics, or anything else relevant? | Textarea | Free text | TEXT |
7
SQL Mapping
7. Summary, attachments & consent
11 fields
| Question | UI Answer Format | UI Answer Input | SQL Storage Format |
|---|---|---|---|
| Do you want to specify guarantees, delivery conditions, or expectations? | Textarea | Free text | TEXT |
| I want RoboConnect to assess whether free, independent prequalification is relevant for the project. | Checkbox | True / false | BOOLEAN |
| Upload documentation that is relevant for the customer project | File upload | File list / optional | JSON |
| Have we overlooked anything that is important for RoboConnect to know? | Textarea | Free text / optional | TEXT |
| Do you have other comments and input for RoboConnect? | Textarea | Free text / optional | TEXT |
| I consent that my data can be used for matching and display for the RoboConnect service | Checkbox | True / false | BOOLEAN |
| I want to be visible on the platform and in search | Checkbox | True / false | BOOLEAN |
| I consent to RoboConnect's terms of use | Checkbox | True / false | BOOLEAN |
| I understand that further cooperation with an integrator via RoboConnect must also go through the platform | Checkbox | True / false | BOOLEAN |
| Yes, I want to receive newsletters from RoboConnect | Checkbox | True / false | BOOLEAN |
| I would like to contribute as a test user. | Checkbox | True / false | BOOLEAN |