I am using FC12 and table blocks for my flexilayout. 95% of my tables are fine on supplier invoices but I have a few instances where the table is very messy and tough to pickup just the rows I need. In this specific instance there is two lots of text above and below my table row that I need to remove or ignore. what are my options here?
I believe I cannot link a repeating group element to my table block and I do not want to complicate the FL or use repeating groups if possible.
I only want to pick up the middle row in the table above. Bare minimum I only need the QTY shipped and Unit cost values.
It seems I have two options. somehow ignore the data in flexilayout or remove them in project setup via scripting.
for option 1 I cannot find anyway in FL to ignore these rows above and below my data. best I can do is pickup all rows and the verification officer will need to remove the unwanted rows manually. Is there any option in my table element I can use to ignore these rows? I have tried just about every setting in the table element.
for option 2 I suppose I would add a event handler to run a script 'after document state changed' - this script would remove any rows without a column value in it for example? BUT, I would only want this to happen on specific supplier alts - do I have access to the service field flexilayout at this stage? So I can use it in my scripting.
My script would go: IF flexilayout = 'altname' and QTYShipped = '' then delete row? is this possible?
how would I go about scripting this. does anyone have any examples I could reference?