Forum Discussion

TylerFoy81's avatar
TylerFoy81
Qrew Member
5 months ago

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",$sequencenumber,0)

I had this working but when the status expires I want it to auto take it out of the sequence when it refreshes. is there anyway to so this the way I had it above I though worked but now it has skipped the numbers when it expires 

I would like the 2 active ones to reflect 1,2 ect. to each related profile is this possible? 

formula query

1 Reply

  • hueyal's avatar
    hueyal
    Qrew Cadet
    5 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.