Fetching value from a table

Fetching value from a table

miyeDP27D
Contributor Contributor
80 Views
1 Reply
Message 1 of 2

Fetching value from a table

miyeDP27D
Contributor
Contributor

Hello, I am trying to fetch the SKU value from my table according to my product Type. I have a label in my token called Product_Type. and the name is exactly the same as the value in the Product_Type Column. I want to assign a new label called SKU and retrieve the SKU value of the product type from the table. 

miyeDP27D_1-1748595644502.png

what Would it be in the???  Table("Products_PrepTime")[???][3]

0 Likes
81 Views
1 Reply
Reply (1)
Message 2 of 2

joerg_vogel_HsH
Mentor
Mentor
Table("Products_PrepTime").getRowByKey(token.Product_Type,1) // just for ???

but more efficiently replace the line completely by

Table("Products_PrepTime").getValueByKey(token.Product_Type,3,1)

Api Table Class properties, methods 

0 Likes