Forum Discussion
DonLarson
3 years agoQrew Elite
Sean,
Assuming that your User field is FID 8
And you have a Check Box FID9
Set your Advanced Query to
{8.XTV.''}AND{9.EX.0}
When 8 is changed and 9 is false, the Pipeline will fire. Have two steps
Update the QB Record FID9 to True
Update the other system
Now if they change the User in FID 8 or clear the User and set it again later, the Pipeline will not fire because FID 9 is true from the first time that the Pipeline fired.
Obviously hide FID 9, do not put it on forms or let anybody edit it except the role of the User that built the Pipeline.
------------------------------
Don Larson
------------------------------
Assuming that your User field is FID 8
And you have a Check Box FID9
Set your Advanced Query to
{8.XTV.''}AND{9.EX.0}
When 8 is changed and 9 is false, the Pipeline will fire. Have two steps
Update the QB Record FID9 to True
Update the other system
Now if they change the User in FID 8 or clear the User and set it again later, the Pipeline will not fire because FID 9 is true from the first time that the Pipeline fired.
Obviously hide FID 9, do not put it on forms or let anybody edit it except the role of the User that built the Pipeline.
------------------------------
Don Larson
------------------------------