Community

Database lookup

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.

Was this article helpful?

0 out of 0 found this helpful

Comments

8 comments

  • Avatar
    Sushi
    Richard,

    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.

    0
  • Avatar
    Richard Sandve
    Thank's :-)
    This works perfect.
    0
  • Avatar
    Sushi
    Just in case anyone else needs it. Here is the promised video on how to setup the DB lookup

    https://anonfiles.com/file/7b40070a841f9aec5ded7924fe2224ee
    0
  • Avatar
    Artūras Vonsevičius
    In my project i could not use "exact" option for index field, only "fuzzy" option and filled from DB table. Recognized values are not verified manually because is used FC Engine. How fill other fields from DB table by index field. Link above with video not work, could be renewed link?
    0
  • Avatar
    Ludatic
    Not sure if I understand you completely, but it seems like you want to know how to perform a DB lookup when manually entering a value into an index field. Is that correct?

    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.



    0
  • Avatar
    Sushi


    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.
    0
  • Avatar
    franco.padilla
    Dear Sushi, could you upload the video again?
    0
  • Avatar
    franco.padilla
    Sushi, could you upload the video again??
    0

Please sign in to leave a comment.