Thanks in advance.
If you want to specify the file path in the script it has to run from a "privileged context", ie a .js file that's installed on the user's local machine.
Is there any alternative to this? we are at a university and I don’t think we have access to the folders where the .js file would have to be installed. (If you could confirm the folders I can check)
Not without a lot of effort. You can use a button to open the file selection dialog, and then the row selection dialog, though.
How would this be done?
Using this code:
In this case, no. Use it as I provided it.
And it should go as the Mouse Up event of your button.
Yes, but what you are asking about is creating an Automation tool, not a form feature. As Try67 has already stated, this type of activity requires privilege.
You can read more about automation and data handling here:
The last tool listed on this page displays a popup menu of options from a CSV (comma separated), for auto-filling fields on a form, which sounds a lot like what you need.