Forum Discussion

TylerFoy81's avatar
TylerFoy81
Qrew Trainee
7 months ago
Solved

Sequential #'s

im using a Var query var number sequencenumber =  Size( GetRecords( "{53.ex.'"&[Related Profile]&"'}"&If(not IsNull([Record ID#]),"AND{3.LTE.'"&[Record ID#]&"'}"))); If([Status]="Active",$sequen...
  • hueyal's avatar
    7 months ago

    Try adding another condition to your formula query for sequencenumber to include the status field equal to 'Active' as well.  The size in the current formula query includes Expired records.