I have a fixed form project with a table object that extracts line items on an order form. This includes a mixture of check marks and ICR field values. My challenge is that many of the row values do not contain any data and the client would like for those not to be exported with empty rows in the line item detail. For example, a customer completes an order form and lists two rows of data. The form contains a total of 20 rows of data. When they process the form and export we get two rows of data that we desire along with 18 empty rows. Since the data is going into Excel we can create a simple macro to delete the excess row data and go that route. But ideally the export of the blank data would not happen in the first place.
Does anyone have an idea on how to proceed with this?
Does anyone have an idea on how to proceed with this?
Comments
3 comments
Usually I use script to make it happen
Evaluate the first cell not empty - send to files.
If isnothing(document.field("TableName").cell("ColumnName",0).value) = false then
' script to write to row data
end if
Hope this will help
Hi,
There is a Isvalid checkmark in lineitem section. When I click on Isvalid checkmark and it is selected , only that row should be exported and remaining should not be. Can anyone tell how to do this?
Please sign in to leave a comment.