topic Updating existing Table Box Row in Discussions

Updating existing Table Box Row

m4mazzotti — Sat, 10 Jun 2023 23:13:41 GMT

Hello JMP Community,

I currently have on my interface a Table Box loading data from a JMP dt.

Is there a way to "update" Table Box row? Or do I need to refresh the whole Table box? I was trying to update a row for the sake of performance.

Thanks!

Re: Upading Table Box Row

gzmorgan0 — Mon, 30 Apr 2018 08:01:44 GMT

A TableBox is comprised of mutiple StringColEditBox and NumberColEditBox display boxes. You can add and remove elemets to these column display boxes.

However, it might be easier to insert and delete rows. This is a modification of Scripting Index scripts.

Names Default To Here( 1 );
New Window( "test",
	tb = Table Box(
		scb1 = String Col Edit Box( "string col", {"a", "c", "d", "d", "e"} ),
		ncb1 = Number Col Edit Box( "number col", {1,2,3,4,5} )
	)
);
wait(2);
tb << delete row(2);
tb << insert row( 2, {"b", 2} );

tb<<delete row(3);
tb << insert row(3, {"c", 3});

Re: Upading Table Box Row

m4mazzotti — Mon, 30 Apr 2018 12:35:45 GMT

That is already a step forward. Much better thank reloading the whole table. Thanks!

To build on top of your example, this is what I was trying to do. Lets say i wanted to update that first "a" with a "z": But it just didnt work.

Names Default To Here( 1 );
New Window( "test",
	tb = Table Box(
		scb1 = String Col Edit Box( "string col", {"a", "c", "d", "d", "e"} ),
		ncb1 = Number Col Edit Box( "number col", {1,2,3,4,5} )
	)
);
wait(2);
scb1[1] = "a";

Re: Upading Table Box Row

gzmorgan0 — Mon, 30 Apr 2018 12:47:10 GMT

I don't see any other way than setting the entire row or using get and set the column values.

Names Default To Here( 1 );
New Window( "test",
	tb = Table Box(
		scb1 = String Col Edit Box( "string col", {"a", "c", "d", "d", "e"} ),
		ncb1 = Number Col Edit Box( "number col", {1,2,3,4,5} )
	)
);
wait(2);
_xx = scb1<<get;
_xx[1] ="z";
scb1 << set( _xx);

Re: Upading Table Box Row

gzmorgan0 — Mon, 30 Apr 2018 12:56:43 GMT

There is also the option of createing a data table from the columns you want using the Data Table Col Box(). When you update the table the display is updated.

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
nw = New Window( "Example",
	Table Box( Data Table Col Box( :name ), Data Table Col Box( :height ) )
);
nw[Table Box( 1 )] << set scrollable( 10, 0 );
wait(2);
:height[1]=60;

Re: Upading Table Box Row

m4mazzotti — Fri, 04 May 2018 18:13:16 GMT

The problem i was having using Data Table Col Box is that i was not able to hide rows that i didnt want to show.

I got one big data with data from multiple customers and I only want to show for 1 customer, and I was trying to avoid subsets because I am updating the table as the user edit a Numeric Col Box.