Insert row in a portal

[garrys]

Hi,

Is it possible to insert a row (record) within two existing rows in a portal?

Regards,

Garu

[Vaughan]

Unless specified otherwise, new portal records appear at the bottom (last) row of the portal.

The trick is to specify a sort order for the portal (or the relationship the portal is based on). This could be a numeric "sort" field, and insert the appropriate value for the new record.

Say the portal records have values in their sort field:

3

6

12

13

14

18

To insert a record between records 6 and 12, create a new related record and give it a sort value between 7 and 11 inclusive:

3

6

7 <-- new record

12

13

14

18

Part of the challenge for this is creating an interface that makes it easy for the user to insert the record in the right place. This could be as simple as buttons in each portal row that say "insert record above" or "insert record below" which runs a script that works out the correct value for the sort field, creates the new related record and sets the value.

[garrys]

I had that idea beforehand. It seems that it's the only way to go... Thanks.

Thanks,

Garu