Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Skip Form data when field matches specific value

Avatar

Avatar
Validate 1
Level 1
tarad4225910
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
tarad4225910
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
tarad4225910
Level 1

03-01-2020

My current form with a table which displays all the Item/Product data for every line, even when an item it deleted giving it an ActionCode of 3. We'd like to only display the Item Data if the Action != 3.

 

Here is the partial XML Data

<Item>
<ID>1</ID>
<ActionCode>03</ActionCode>
<ActionCodeName/>
<Product>
<StandardID schemeAgencyID=" ">614099641183</StandardID>
<StandardID schemeAgencyID="9">614099641183</StandardID>
<BuyerID>ASH10066-AC</BuyerID>
<BillToID>ASH10066-AC</BillToID>
<TypeCode>1</TypeCode>
<TypeName languageCode="EN">Material</TypeName>
</Product>
<ProductCategory>
<BuyerID>11500</BuyerID>
<BillToID>11500</BillToID>
<Description languageCode="EN">HOME ACCESSORIES</Description>
</ProductCategory>
<Price>
<GrossAmount currencyCode="USD">122.70</GrossAmount>
<NetAmount currencyCode="USD">122.70</NetAmount>
<TaxAmount currencyCode="USD">0.00</TaxAmount>
<NetUnitPrice>
<Amount currencyCode="USD">20.45</Amount>
<BaseQuantity unitCode="EA">1.0</BaseQuantity>
<BaseQuantityTypeCode>EA</BaseQuantityTypeCode>
<BaseQuantityMeasureUnitName languageCode="EN">ea</BaseQuantityMeasureUnitName>
</NetUnitPrice>
</Price>

 

 

And Here is the current Data binding for the table 

$.PurchaseOrder.Item[*]

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Boost 50
MVP
_Bruce_Robertson
MVP

Likes

269 likes

Total Posts

1,782 posts

Correct Reply

372 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile

Avatar
Boost 50
MVP
_Bruce_Robertson
MVP

Likes

269 likes

Total Posts

1,782 posts

Correct Reply

372 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 250
Boost 25
View profile
_Bruce_Robertson
MVP

07-01-2020

Hi,

 

You can use an expression in the binding, so try

 

$.PurchaseOrder.Item.[ActionCode <> "03"]

 

Note the full stop should be before the opening square bracket.

 

Regards

 

Bruce