Hi,
We have been trying to use formulas for cases with the following criterias:
* If string name contains "Product A", set field product to "Product A"
* If string name contains "Product B", set field product to "Product B"
* If string name contains "Product C", set field product to "Product C"
* If string name contains "Product D", set field product to "Product D"
We have been testing A LOT of formulas but haven't been able to work it. We have the following for the first two criterias using wild cards:
ifThenElse(
string\substring(name, 1) = '*Product A*',
product = 'Product A'
ifThen(
string\substring(name, 1) = '*Product B*',
product = 'Product B')
);
Are we in the right track? What are we missing?
Thanks a lot and hope to hear from you.
We have been trying to use formulas for cases with the following criterias:
* If string name contains "Product A", set field product to "Product A"
* If string name contains "Product B", set field product to "Product B"
* If string name contains "Product C", set field product to "Product C"
* If string name contains "Product D", set field product to "Product D"
We have been testing A LOT of formulas but haven't been able to work it. We have the following for the first two criterias using wild cards:
ifThenElse(
string\substring(name, 1) = '*Product A*',
product = 'Product A'
ifThen(
string\substring(name, 1) = '*Product B*',
product = 'Product B')
);
Are we in the right track? What are we missing?
Thanks a lot and hope to hear from you.
Comment