first of all, let me say that even though this question might be basic and "searchable" I have no idea what to search for and therefore I'm stuck. I apologize if this is to basic/has already been answered.
Here's my situation. I've had a friend of a friend code up a skeleton for an app in Django so I have a base to stand on. I want to create a form with several fields but 3 of those should interact the following way:
When I enter a string of 1234567891234(12 numbers) in formfield 1 I want the app to search through column A in database. If it finds an identical match to the first 8 numbers I want it to fill formfield 2 with contents from DB column B and fill formfield 3 with the contents of DB column C. If it doesn't find anything I want it to do nothing with formfield 2 and 3.
I was wondering if you might provide me with some kind of terms/functions of which I could find more information about this. I can't code python just yet so I really don't know what to look for.
Any assistance would be greatly appreciated.
best regards Andreas