Skip to main content
Question

Pipelines Advanced Query

  • August 30, 2021
  • 0 replies
  • 393 views
Hi All,

Does anyone know if I can use the '$' in the advanced query function to ask for the previous value of a field as a condition? I've tried:

{$prev.10 .EX. 'Value'}
{'$prev.10' .EX. 'Value'}
{$prev10 .EX. 'Value'}
{'$prev10' .EX. 'Value'}

And none worked. I was assuming that since you could use it in the outputs that it could have been used in the advanced query step. Has anyone gotten this to work?

(Updated at 10:47 AM EST to include missing 'prev' after '$'. Still not working.)

Thanks,

------------------------------
Daniel Johnson
------------------------------
This topic has been closed for replies.

  • DanielJohnson2
  • Author
  • Quickbase Alumni
  • August 30, 2021
Got some help from customer service on this one. Let's say field 10 is a text field called Status, then the correct syntax in the trigger query would be:

{'{{a.$prev.status}}' .EX. 'Value'}

I was told you have to use the written form of the field and not the field ID number.

------------------------------
Daniel Johnson
------------------------------
Terms & ConditionsAccessibility statement