PeterWindle

Numbering related records via portals

Discussion created by PeterWindle on Jan 10, 2016
Latest reply on Jan 10, 2016 by jormond

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.

Outcomes