I want to write a script to create a new record and confine the last record created how would I do this? GetNthRecord?
If you want to create a new record and immediately constrain the found set to that new record, the easiest way is:
Find Matching Record [ Replace ; Table::primaryKey ]
which of course presumes that you have a primary key, which you should anyway
you could also (after new record creation) show all records, omit record, show omitted only.
Peter, the idea behind recommending Find Matching Record[ ] is to have shorter code that does less work (ie no loading of all records with all that might entail in a given context).
You're right in that Show All - Omit - Show Omitted would be a workaround for when you don't have a primary key; but then I'd remedy that state, rather than employing the workaround.
In a hosted database with multiple users creating records in this table, Show All - Omit - Show Omitted can fail to isolate just the current record. The Show Omitted step can pull in a record created by another user if they created it at just the wrong instant of time.
Retrieving data ...