Is there any possibility to import first 100 records in the layout without using Perform find.
No... export always works with the current found set.
If you are worried about destroying the current found set, just open a new window, do the find there and export from there. Then close the window and the user will still be on their original found set.
Or use ExecuteSQL, dump the data in a scratch table and export from there.
Thanks for your update.
I have to export first 10 records present in the layout.Please refer the attached script where the exporting is happening every time and the data is getting overridden.
Can you suggest me how to export 10 records at a single shot.
Your script is exporting each record one at a time, and overwriting the prior export, rather than exporting all 10 records into one file. Try this:
Go to Record by calculation [ min ( get ( foundcount ) ; 11 ) ]
Omit multiple records [ get ( foundcount ) - 10 ]
Show all records
Omit multiple records [ 10 ]
Show omitted only
However, what is the deal with omit 10 or 5 when the title of the thread here is about the first 100?
Thanks so much That works!
The omitting count is given as example ( which is not the accurate one).
Retrieving data ...