Add New record from top of portal?

[johnnyreno]

I haven't found this question yet, but let me apologize if I missed it. Is there anyway to get a portal to add new records from the top of the portal instead of having to scroll down through all of the existing records to the blank "entry" row?

[Ugo DI LUCA]

AFAIK, you can't do this....

But you can sort your relationship in descending order.

What I find handy is a little square just at the intersection from the portal header and the scrowl bar. Draw a small "+" into it , and attach a script.

Perform External (the related file - create new record)

Refresh.

You then will have a empty row in the higher part of the portal.

[Mike D.]

Ugo,

To add upon your method, use a field in the related file that is the Creation Date and Time of that record. Then sort the portal based on the date/time field in descending order and the latest record, even if blank, is always at the top of the portal.

Mike

[ibiubu]

How would you have a field with both the creation date and the creation time? I only know how to create a field that automatically inputs the date or the time, but not both.

LR

[-Queue-]

I believe he means to use a concatenated calculation field that consists of a Creation Date field, a space, and a Creation Time field.

[Mike D.]

Queue, You are correct. A calculation field concatenating the date and time fields is what I meant.

Thanks, Mike

[mse]

Here you are (from John Osborne's site; not available at the moment)

[Helpful Harry]

By a strange coinky-dink, I've just posted an example solution in the Smaple Files area for using the top row of a portal for entering new records. My method doesn't use any buttons or scripts, but instead uses a second portal to do the data enty. If you want you can read the message and download the example solution HERE

[johnnyreno]

Thanks for all of your suggestions; Harry's was particularly Helpful.

[RicRicho]

This only works if you paste or set the related record id into the new record which is a little more complicated.

[RicRicho]

You can also use the date created and time created and sort by the two fields together... you have to create the two fields anyway to do the concatinated calc field so this is simpler.

[MoonShadow]

How would you have a field with both the creation date and the creation time?

Maybe I'm missing something here... you have vs. 7. Why not just use a Timestamp instead of concatenating date/time?

[-Queue-]

This thread is from two years ago, sans RicRicho's latest additions.

That is probably why you feel you are missing something.

[MoonShadow]

Errr. I knew that. Yeah, that's right. I knew that ...

I was making the point that vs. 7 removes the need to concatenate date/time. Yeah. Well then ... use Timestamps now.