Skip to main content
allenp0001
Known Participant
July 1, 2021
Question

Auto numbering

  • July 1, 2021
  • 10 replies
  • 0 views

I have an interface where a supervisor can prioritize orders.  Is there a way that when one order ships that the numbers will automatically change to a lower number?

    10 replies

    mikes0011
    Brainy
    July 1, 2021

    Can you clarify your use case a bit?  I'm unclear

    1. what user interaction on the form seen in your screenshot is intended to cause your desired change
    2. what the 2nd and 3rd columns are actually showing / doing
    3. which item(s) in the list you would expect to be affected after such user interaction takes place
    4. what logic would be used to address duplicates and/or gaps in the list of numbers
    The Expression Guru
    allenp0001
    Known Participant
    July 1, 2021

    So the interface is written so that the user can assign a priority number to an order.  The second column is where they enter in the number and the third is what the current number is.  Duplicate numbers only happen if an order has 2 or more line items as shown with number 4.  I am hoping to figure out a way where when order is shipped and is no longer on the report as for what was number 5, that 6 would become 5.

    mikes0011
    Brainy
    July 1, 2021
    I am hoping to figure out a way where when order is shipped and is no longer on the report as for what was number 5, that 6 would become 5.

    This brings me back to the question from my first bullet point - what is the actual user interaction that precipitates this?  Is it something they do on-form?  Is it something that happens in an unrelated process model?

    The Expression Guru