I’m looking to extend an existing MachForm installation with two focused upgrades: 1. Smart field validation • When a user submits the form, the script should query an external MySQL table in real-time, match a specific value, and automatically populate or adjust target fields with the returned data. • If the lookup fails or returns an invalid result, the form must show a clear, custom error message and block submission. • The solution needs to be coded cleanly in the MachForm PHP framework so future version updates remain straightforward. 2. Tailored data processing & reporting • After submission, store the additional lookup data alongside the normal entry so it appears in the admin panel, CSV exports, and email notifications. • Add one concise summary report (or tweak an existing one) that filters entries by the looked-up value and outputs totals. I’ll provide direct server access to a staging copy, the database schema for the lookup, and a short test plan. Deliver a fully working module, commented code, and brief install notes so I can replicate the change on production.