Is it possible to do a Database Lookup?
The value entered in one index field should trigger a database search to fill the other fields automatically.
The value entered in one index field should trigger a database search to fill the other fields automatically.
Comments
8 comments
Yes is it possible to do a Database lookup. I will create a video to show you later but for now, look in the FlexiCapture Help file under "Database check rule". Basically you will have two or more fields. The index field will be setup to be "exact" to the database field. The values you want to bring into FlexiCapture from the DB will need to be setup as "Do not compare" "Copy field from Database". So if the value from the index field match, it will pull in the additional database value.
This works perfect.
https://anonfiles.com/file/7b40070a841f9aec5ded7924fe2224ee
What I've done is setup a Verification Stage tool Event for "On Field Control Deactivate". When that event fires it runs my script which connects to a DB and executes a query. Just simply put in an if statement if you only want it to run for a specified fieldcontrol. My DB lookup script is all being handled in my custom .dll I imported into the project.
Arturasv,
Please clarify as Ludatic mention. In any case, the DB lookup can be done the same way. Basically rules generally get run all the time. So it doesn't matter if the field gets capture or they type the value in. It will match the value in the DB and then pull the other values in. I no longer have the video. I generally make it once and delete it from my computer. Let me know what version of FlexiCapture you're on and I can create it again.
Please sign in to leave a comment.