Changing a status field based upon field content in a separate table

You could do this one of two ways, both involve using Automations.
1. Create a scheduled Automation to check the Purchase Value field daily. For any records where it is null, change the status on related record. Might need to use the Copy Record(s) action for this one. (A little bit more complex)
2. In the table where status is, set the default value of status to "Awaiting Purchase Value" (Or whatever your planned status is) and then set up an automation that triggers when Purchase Value field is changed, and the action for the automation should change the status to whatever you want after that happens.

Let me know if that makes sense

Hi Dirk, 

What 'type' is the status field?

I'd start by bringing the 'invoice purchase value' into the table with the 'Status' field via a table-to-table connection.

If the 'Status' field is a formula field,   Then you can update the formula with an 'If-Statement' like: 

If([IsNull(Invoice Value),Old Status,New Status)   

For the 'Old Status' argument in the formula you can paste in whatever formula you were previously using in the 'Status' field

If your Status field is a multiple-choice field will depend on your workflow, but you could use a form rule to prevent users updating the status to whatever status allows an invoice to be sent if the purchase value is null.

Let me know if you have any questions.

Jake Rattner | Solutions Architect
(847) 927-1427 | jrattner@quandarycg.com
Quandary Knowledge Base