Source: https://oguzerol.com/en/product-customer-autofill-form/ [ View full size](https://oguzerol.com/gorseller/senaryo/product-customer-autofill-form-senaryo-en.webp) # Product and Customer Autofill Form [Oğuz Erol](https://oguzerol.com/en/about-me/) | 2 min read Choosing a customer can bring the current address and payment details into a new quote, while choosing a product can bring its description and approved price. ## How the Product and Customer Autofill Form can work A submitted quote can retain the values used at that time even if the master price list changes later. I can make this distinction visible so routine updates do not silently rewrite past documents. Excel lookups and Google Sheets references can bring details into a form. In an app, separating master customer data from historical quote values becomes a more visible business rule. As Oğuz Erol, I develop custom web apps for this workflow. Once customer and product sources are clear, I aim to prepare an initial autofill screen quickly; historical-document rules shape the scope. ## Frequently Asked Questions ### What happens to an old quote after a price-list change? A saved quote can retain its original price and description while new forms use the current source. ### Who updates the master customer record? A designated role can maintain the master record while the quote retains its point-in-time details. ## Discuss your workflow [Discuss your workflow](https://oguzerol.com/en/contact/) [Explore custom web apps for your team](https://oguzerol.com/en/custom-web-apps-for-your-team/) ## Related services - [Dependent Dropdown Custom Forms](https://oguzerol.com/en/dependent-dropdown-custom-forms/) - [Price and Cost Calculation Screen](https://oguzerol.com/en/price-cost-calculation-screen/) [Back to top ↑](https://oguzerol.com/en/product-customer-autofill-form/#icerik) ## You may also find these useful [Searchable Form Records SystemA custom web app that turns form submissions into records searchable by customer, date and other relevant details. Built for Excel and Google Sheets workflows.](https://oguzerol.com/en/searchable-form-records-system/)[Rules-Based Data Entry FormA bespoke form that flags missing, required or incompatible information before a record is completed. Built for Excel and Google Sheets workflows.](https://oguzerol.com/en/rules-based-data-entry-form/)[PDF Documents from Form RecordsA bespoke workflow that creates consistent PDF delivery notes, reports or similar documents from form records. Built for Excel and Google Sheets workflows.](https://oguzerol.com/en/pdf-documents-from-form-records/) [Browse all articles →](https://oguzerol.com/en/articles/) WHAT YOU CAN ASK FOR ## How do I work? Work-hour packages Tell me about your business and what you need on WhatsApp or by phone; we agree on **a work block of somewhere between 5 and 40 hours** and I start doing what is needed. What you get is not a calendar window — it is net working hours spent directly on your business. I can use 40 hours working three days straight, or deliberately spread it out and finish it over a year — whatever the work calls for. I do not spend my time estimating how long something will take, I spend it doing the work; every hour I spend leaves a lasting result in your business. We keep going for as long as you find it useful. WORK BLOCKS ## Why not monthly? Is 40 hours a week? On a fixed monthly fee both sides are watching the wrong thing: you watch a fixed cost, the other side watches how many more contracts like this they can line up. Working by the hour puts us both in front of the same thing — the real value of the work that got done. I know not having an upfront answer to "how much will this cost in total?" is the natural cost of this model. But instead of paying a fixed fee for months to a setup that is not producing results, you only pay for the qualified time spent on your work — and you see exactly where that time went, start to finish. That is why my clients keep coming back. 5hours300€ + VAT60€ per hour[Choose this block](https://wa.me/905496546489?text=Hi%2C%20I%27d%20like%20info%20about%20the%205-hour%20work%20block.) 10hours500€ + VAT50€ per hour[Choose this block](https://wa.me/905496546489?text=Hi%2C%20I%27d%20like%20info%20about%20the%2010-hour%20work%20block.) 20hours800€ + VAT40€ per hour[Choose this block](https://wa.me/905496546489?text=Hi%2C%20I%27d%20like%20info%20about%20the%2020-hour%20work%20block.) 40hours1,400€ + VAT35€ per hour[Choose this block](https://wa.me/905496546489?text=Hi%2C%20I%27d%20like%20info%20about%20the%2040-hour%20work%20block.)