New Portal Row at the Top

[Ukyo]

Dear Professionals,

New row for entering portal data is defaulted to be at the very bottom of the list.

Is there a way to keep it at the very top?

[IdealData]

This is the way that portals behave for data entry, however, depending on the sorting for the relationship or the portal the new record will finally display in the correct place.

A technique to maintain data entry at the top of the portal is to have a "parallel" set of GLOBAL fields above the portal and use a script to write the new record (in the related table) once the globals have been entered. Use a button to fire the script.

Edited October 4, 2009 by Guest

[Ukyo]

So you mean to place the global fields above the portal frame and make it look as if it's the empty top most portal row.

Enter data in the global fields then script to set the actual empty fields in the portal?

In this case, is there a way to not show that empty portal row at the bottom?

[IdealData]

Yes.

You must change the relationship settings to NOT ALLOW CREATION via the relationship - then the empty bottom row will disappear.

Your script to write the new record must, therefore, go to another layout based on the target table of the relationship, and use the SET FIELD script command to write the fields, roughly like this..

Go To Layout (target table)

New record

Set field (first data field, using first global field)

Set field (second data field, using second global field)

.

.

Go to layout (original layout)

Global fields have a nice "property" about them - they are accessible from all tables without a relationship!

HTH

[Ukyo]

Hi IdealData,

Thanks so much for your help.

It's working fine and my staffs are all happy with it.

I can head home now...

Thanks again!