Job Queue Number

Hi there, I am wondering if it is possible to assign records a queue number? I have created a view that would be great if all records in this view are numbered >1 and all other records 0 or something similar.

This is so customers can log in and see their order is number xxx in the queue.

Thanks!

It’s not possible to directly check a record’s view assignment. However, you could use the same criteria that put those records into the view to drive something else.

First, add an autonumber field to your table; I’ll refer to this as {Autonumber} below. Next, add a formula field. You didn’t mention what puts those records into that view, but let’s say that it’s a single select field named {Status} set to “In Queue”. In that case, the formula would look like this:

IF(Status = "In Queue", Autonumber, 0)

Assuming that records are set to “In Queue” (or however you’re marking them) in the same order that they’re created, this will output the record’s automatic number if it matches that status. Once you change the status to something else, it will drop out of that view, and the number returned by the formula will be 0.

This isn’t a perfect solution—the first record in the view wouldn’t start at 1 if you’ve got some records that have already fallen out of that view through previous processing—but it would get the job done without scripting. If you’d like something more precise, an automation-executed script could help clean up the numbering as records are updated, and also eliminate the need for the autonumber field. Message me directly if you’d like to explore that possibility.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.