upside-down portals?

[kev100]

Hi, is there any way to make portals display the most recent entries at the top, rather than at the bottom? It's a real pain to have to scroll to the bottom of a portal just to enter a new record.

 

Sorry if this has been covered already, I couldn't find anything related to this.

 

Cheers,

 

Kev.

[Ender]

Putting the most recent entries at the top, and putting the data-entry row at the top are two separate things. The first can be done by changing the portal Sort option in the portal definition. But the built-in data entry row is always at the bottom.

 

What you would need to do to put the data-entry row at the top would be to make your own data-entry row out of globally stored fields and arrange them above the portal, then have a script actually create the new related record from those global values, and clear the globals when done. In this case, the "allow creation of related records..." option in the relationship would be turned off.

 

If you need an example of this technique, upgrade your membership and I'll dig up a demo.

[Maarten Witberg]

for instance, create an auto-enter creation timestamp field in the lineitems

table and sort the portal (and/or the relationship) by this timestamp field descending.

"allow creation of related records" is still possible but you'll still find them at the bottom.... so best to script creation so the user sees a new empty portal row at the top to fill in.

[kev100]

Thanks guys for the quick reply. That's brilliant (and yes, I am trying to get the data entry row at the top). Perhaps this is something that Filemaker can implement in a future release. It seems really counter-intuitive to have to scroll to the bottom to enter new data, or work around the issue with scripts.

 

Thanks again, though. That's really helpful.

 

All the best,

 

Kev.