Download only last record in table

[doughemi]

I am building a solution in which users can edit club information. For security purposes, the data is first copied into a holding table by a FileMaker script triggered by a newPerformScript command. The record just created is the last record, so that is the only one I want to download to the user's browser. I had hoped that making the script create the correct found set would do the job. It didn't.

There is not necessarily anything unique about the data in the desired record, so I can't figure out a way to create a php find request to get just that record.

--Doug

[Quartekoen]

One of the things that I generally do "just because" is add a field to every table I created called UID. This is a Number field, Auto-Enter Serial, Unique. This way, whenever a record is created, there is always something unique about it.

If you use this, and you can capture the ID of the record you create, you can easily do a find for this record to make it the only one in your found set.

[doughemi]

Thanks for the hint, but I don't understand how the php script learns the uid to perform the search.

--Doug