topic Re: File selection input box in JMP Application builder in Discussions

File selection input box in JMP Application builder

dileepkr — Mon, 20 May 2019 17:42:28 GMT

Hi,

I am creating a JMP application which would open a xlsx workbook, load individual sheets into datatables in background and link the datatables to Graph building JSL script buttons in JMP app.

Is there a way to create a file selection input box in JMP Application builder, where in user can browse and select the xlsx workbook from the app?

Re: File selection input box in JMP Application builder

cwillden — Mon, 20 May 2019 18:44:53 GMT

Definitely. Just create a button box and give it a script that does a pick file. Here, I just have a button box and an empty text box named "file_path_text". For the button box script, I just type in "On Select".

Then in the script window, I define On Select like so:

On Select = expr(
	file_path = Pick File(
		"Select Excel File",
		"$DOCUMENTS",
		{"Excel|xls;xlsx"}
	);
	
	file_path_text << Set Text(file_path)
);

When you run it, you should see your selected file printed in the previously empty text box showing the path of your previously selected file. Use "dt = open(file_path)" to open the selected file when you're script is ready to start working with the selected file.

Re: File selection input box in JMP Application builder

dileepkr — Mon, 20 May 2019 18:47:59 GMT

Thank you so much for the solution!