Am I missing something here, or is this field just...
# general
d
Am I missing something here, or is this field just not supported. I have a saved search that I want an alert for certain Fulfillments. However, I only want it to send the alert, on update, when the status goes from Picked to Shipped. Below is a screenshot of the "Updated Fields" section for this. This does not work at all. I have tried multiple variations for the Status field and nothing works. If I do another simple example, for the memo field. Old Value = "Hello", New Value = "Goodbye" it works just fine. Is the actual Value of the status field something else behind the scenes? I have tried A -> C (ship status value), that doesn't work either.
j
This is the transaction status field? When I pull up the selections in a saved search they look like this:
d
Ahh, Brilliant. I will try those right now.
j
yeah, no guarantees that that'll work for you, but worth a shot for sure. The other spot I often look at for what the values might be would be system notes.
d
Ya, System Notes just shows it as "Picked" and "Shipped", he XML also just shows it that way. I just tried your suggestion and that still doesn't work. I'm stumped on this one.
Even the results just show "Picked" and "Shipped" for that field. Odd stuff
j
what happens if you pull those into a transaction saved search using a formula field of {status}
sometimes the actual output in the field will give you slightly different results
d
Same thing. Shows as "Picked" and "Shipped". I've even tried '|' || {status} || '|' to see if there is a leading or trailing space and there are none.
j
🤔 maybe this would help
d
That worked! Thanks for the find!
j
np. glad it worked