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",$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?
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.
