Skip to main content
Question

Determining Next Item Number

  • July 16, 2019
  • 0 replies
  • 34 views
Forum|alt.badge.img+11
I have attached a screenshot showing a dynamic form rule to determine my next item number for my meeting minutes.  Basically what I am doing is taking a summary field of the # of meeting minute items related to the meeting minute.  So I get a total count of the items in each category.

I did a lookup to the summary field.

Now that I enter this I can assign the item number to the "last" item.  My 7th entry is 6 because I cannot figure out where to place a "+1" as a formula.  I thought maybe a formula field but it is continuously updating ,not just once.  So not sure how to either lock that, or I need to use this method.

Only other thing I can think of is to create another set of fields that are formula fields and increment the number.  Just seems ridiculous to have to create (5) additional fields to add (1).

    • XavierFan
    • Registered
    • July 16, 2019
    If I understand you correctly - you already have:

    1)  Summary of # of Meeting Minute Items (related to the Meeting Minute)
    2)  Lookup to the summary field - call it [Current # of Meeting Minute Items]

    My suggestion would be:

    - Create a Formula Numeric field called [Next Item Number]- in the Meeting Minute Item table.

    Formula would be:

    [Current # of Meeting Minute Items} + 1

    e.g. If you have [Current # of Meeting Minute Items] is 6, then [Next Item Number] would be 7

    So say you have a Numeric [Item Number] field in your Meeting Minute Item table.

    Then in your form rule - you can say:

    If [Item Number] is blank

    change [Item Number] to the value in the field [Next Item Number]

    And uncheck the box that says "Fire "change" actions only when a condition changes from false to trueonly change this when this becomes true".

    Then this form rule would always apply when the [Item Number] is blank.


    This will work as long as you're only adding Meeting Minute Items, and not deleting items in the middle, etc.  But you can always Grid Edit the Meeting Minute Items and update the [Item Number] if you need to re-order the items.

    Let me know if this helps.
    Terms & ConditionsAccessibility statement