Hi, I need a solution when a particular column or columns has a null value in 4-5 rows, so another field will export value as 'false'. Say, column Qty has values 1,5, null,2,7... So if it has a null value , another field Issue should export as ' Yes'.
Null value in line items
この記事は役に立ちましたか？
0人中0人がこの記事が役に立ったと言っています
コメント
1件のコメント
Hello,
Please try to use script which 1) counts null values in the corresponding columns; 2) sets the field value to true or false based on null value cells counted. The script like this can be used in rules, event handlers or project or stage tools, whichever you find more convenient in your situation.
Please try to use the following constructions :
Document.Field("FullTableName").Items[<row number>].Field("FieldName").Value == null
or
Document.Field("FullTableName").Cell(“<Column Name>”, <row number>
.Value == null
Please note that IField method Cell( columnName : string, rowNum : int ) : IField is not allowed in Rule scripts, in case if you choose to use it. The same is true for IField Children property if it is addressed to table cells.
サインインしてコメントを残してください。