コミュニティ

Database Check Rule with Duplicates

How is Flexicapture suppossed to behave for a Database Rule when more than one record match the lookup conditions? - I have a DB rule that performs as expected, fills correctly other form's fields, but when having duplicates it blanks all fields, instead of filling them with the correct values.
Thanks for any support you can provide.

この記事は役に立ちましたか?

0人中0人がこの記事が役に立ったと言っています

コメント

5件のコメント

  • Avatar
    Anastasiya Nechaeva
    Hello atorino,


    When program meet more than one matching record it allows user to choose the proper one. Did you see any warning like "Too many records found"?

    In case duplicates it would be better to use a script rule where you can handle such issue.
    1
  • Avatar
    Alberto Torino
    Thanks for your answer, Anastasiya. No warning message was received. I'm trying a workaround to this problem. Let you know how it goes. Thanks again
    0
  • Avatar
    Permanently deleted user

    I have the same problem, but when i choose the proper one and click on checking rules, i get still the same warning like "Too many records Found"

    0
  • Avatar
    Veerish Uppin

    Anastasiya Nechaeva  -  I am getting the same error as "Shipping address must be found: Too many records found.

    The customer / vendor is getting matched from the purchase orders and the record is getting pulled from the dataset, but it is not ablet pull the record for Shipping address as there might be multiple address (Shipping IDs) in the dataset. Where to add the script and what should be condition like ??  

    0
  • Avatar
    Anton Vakhtel

    @... Hi,

    More details and the project are needed to come up with the workaround for it, so I have created a ticket based on your comment. The ABBYY Customer Support Team will contact you via the ticket as soon as possible.

    Best regards,

    Anton

    0

サインインしてコメントを残してください。