Community

Delete table rows if a field is null

Hello,

I have a Table with 9 columns of fields, I need to delete the rows where one of these fields is null, is there a way to do this using a script?

Thank you very much.

0

Comments

2 comments

  • Avatar
    ElliotG

    From my experience you can't delete rows from a table, only clear the fields in it.

    https://help.abbyy.com/en-us/flexicapture/12/developer/ifield

    Under "Rows":

    Read-only A set of table rows. Unavailable for non-table fields.
    0
    Comment actions Permalink
  • Avatar
    Scott Chau

    Yes its possible but it has to be done at the Workflow Stage level.  Basically create a document processing script.  I dont' have an exact script but it should call to delete your particular line item based on your null condition.

    Document.Field("Invoice Layout\\LineItems").Items.Delete 

    0
    Comment actions Permalink

Please sign in to leave a comment.