I have a form that I have some record rules on. However I've run into a problem with the way record rules work... Here's what I'd like to do, and I'm looking for suggestions..
When the submit button is pressed, I want the Record Rule to do two things..
Insert a connected Record, based on the fact that the field Approved is YES, and that the "Invoice Sent" field is set to NO
Update the "Invoice Sent" field to YES, so that I don't accidentally do this again..
However, Update rules run first, so the "Invoice Sent" is getting set to YES, which means my connected Insert is not firing..
How are people getting around this type of issue?