Empty portal row at top row for new data entry

[rkass068]

Hello I am just wondering if there is way to make the last empty portal row to create a new record at the top row. I have sorted the portal by a date field with the most recent date at the top. I would like the empty portal row at the top so that the data collector wont have to scroll through a bunch of records to get the the empty row at the bottom.

 

Thanks 

[Raybaudi]

Try this file:

DataEntryPortalRow.zip

 

[TKnTexas]

Simplest technique I have seen.  Thanks for sharing it.

[Capt JB]

I was to post the same subject, let see what's in the DataEntryPortalRow file… Grazie ciao.!!

[Capt JB]

Hi,

 

Very good solution, I tried it and it works great. 

I added automated timestamp field in the related base and change portal sorting to this field and to descending parameter.

The result is the records are sorted from the latest to the oldest … of course!!.

With many records created during the same day I have always the last one in the first line of the portal

[Zerojojo]

That's really great! I tried to recreate your setup, but my text field from OnePortalRow does not clear after data entry to show the next new empty record. I can only modify the first one created. I don't see any scripting in your file. What am I doing wrong that my edit box doesn't jump to the next new record in the related table? My relationships are identical, including creation of new records.

 

Thanks!

Here's my try. I just can't figure out what I'm missing.

My try.fmp12

[Zerojojo]

Ok, I got it. There's a second portal with a filtering option. Very clever.

 

Question solved.

[Aihela]

Hello,

DataEntryPortalRow says it is not modifiable to me so I am not able to check how the portals are set.

What filtering option is being used for the second portal?

This is exactly something that I have been trying to solve as well so would love to get this to work.

Thank you!

[Steve Martino]

Did you unzip the file first (extract all).  Open directly from the zipped folder is the usual reason why you cant modify a file.

 

On a side note...Where have you been Daniele.  I have not seen you on the forums in many months...hope all is well.

Edited March 15, 2016 by Steve Martino

[Aihela]

Thanks Steve!

That was it.