Community

Taking dropdown values from database

Hi
I want to create country dropdown field, i have 240 countries in my database table, i want to add that countries in dropdown field. How to do it? (i am using group of checkboxes as dropdown in document definition). I have added all countries manually but i want to add dynamically from database. Please check attached screenshot. I have gone through help file as -  program settings -> Document Definitions -> Field properties -> Text Input Fields -> Data types. But there is no description of how to add field value from database. Please give all description in details how to add values.

1

Comments

5 comments

  • Avatar
    Ekaterina

    Hello,

    You may extract your values from the database by SQL queries (the .Net methods should be used). Then you may add the values to the dropdown list by IField::Suggest() method (See the “Using scripts in ABBYY FlexiCapture > Scripts for customizing processing stages > Objects > IField” article in the Developer’s Help).

    1
  • Avatar
    Shreedhark

    Hi
    i tried your solution but it only work for textfield not for checkbox group (Dropdown). IField.Suggest() this method suggests what we want, but it has some drawbacks like -(1) textfield suggests all texts from invoice like if i press m then it shows all words starting from m. (2) Suppose i have suggested 3 values as follows - India, Indonesia, Iran. Now when i type i in that textbox it gives 1 values by alphabetically i.e. - India - It dosent shows all 3 values starting from i. (3) Another problem is for that textbox arrow keys not working like when i press down arrow on dropdown field , in dropdown next value comes, but in textbox this scenario not working

    1
  • Avatar
    Ekaterina

    Hello,

    Sorry, the project customization you want to implement requires the amount of work too big to handle on this forum. 

    Please contact the professional service of your regional support to get help in this task.

    0
  • Avatar
    ABBYY_User0707

    I have seen that we can create checkmarks and after grouping it, we are getting as dropdown list. Can I do the same for text oriented fields? If I trying to capture country or state name, verifier can easily do the changes. Is this possible ?

    0
  • Avatar
    Ekaterina

    Hello,

    Answered in the http://www.capturedocs.com/thread/flexicapture-questiona/ topic.

    Sorry for the long delay

    0

Please sign in to leave a comment.