13 Replies Latest reply on Jan 10, 2016 8:00 PM by jormond

    Numbering related records via portals

    PeterWindle

      Ok, it's simple, but it's one of those things that you can easily get trapped by. I've been trying to find a neat solution to this, but so far, I have not found it.

       

      I have a parent record with a portal showing children records.

      I wish to be able to number the child record in relation to the parent:

       

      eg: a contact may have multiple addresses in the portal,

       

      each address will have the numbering:

       

      Contact A:

      Address 1

      Address 2

      Address 3

       

       

      which is simple enough, however, the records can be created via the portal AND deleted via the portal.

      With creation, I wish to have the next highest number automatically put on the record.

      With deletion, I don't want the preceeding numbers to change, they should remain the same.

       

      eg: Deleting number 3 should allow the next address entered to be 3. Deleting number 2 will mean the next number is 4.

       

      There is a problem with timing when creating more than one related address at a time (record commit)

      Is there a simple way to make this happen?

      remember, address 1,2 and 3 could all be created via the portal at the same time.