Skip to main content
Solved

Sequential #'s

  • December 31, 2025
  • 0 replies
  • 72 views
Forum|alt.badge.img+5

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? 

Best answer by hueyal

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.

Forum|alt.badge.img+9
  • hueyal
  • Registered
  • Answer
  • December 31, 2025

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.

    Terms & ConditionsAccessibility statement