Return to FileMaker.com
The requirement is that the records present in the table has to be exported in the form of excel.
The script step Save Records as Excel can be used to fulfill this. However, I could able to generate only in a static path:
For example : filewin:/D:/test/Users.xlsx
Is it is possible to generate in dynamic path based on the user input so that folder structure can be created dynamically.
Yes, you can do this. Start here: Get Directory. Then use the resulting variable as your path (maybe with some additional stuff, like the filename).
Retrieving data ...