Here are my cheat notes on that
{{a.
$prev.est_start_date}}
take the regular version and insert the $prev
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'}
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MessageKey=657fdac9-9fd0-4a73-9a40-05c46e8fab09&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer{{a.$prev.est_start_date}}
But then this thread says that you cannot use prev in a query expression.
https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=b2947263-9f0c-4fe9-a2b5-095725d3aceb&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer#bmb2947263-9f0c-4fe9-a2b5-095725d3aceb------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
