Accessing a specific cell of a table without a model via script in SAC

[FxGk]

Hey,

it is possible to create a table without a model and to enter numbers and text manually. So far so good. You can even use formulas like in Excel and the result will be displayed.

Just a test:

But i cant find any way to access the cells or to manipulate the values of this table by using a script. And because there is no data source for this table i cant use Table_1.getDataSource().

Does anyone have an idea?

Best regards

Felix

Edit:

You can even reference to a specific cell like in Excel:

Now i wonder if and how i can use scriptvariables in this table calculation?

[N1kh1l · Accepted solution]

fx.gk

I think that's a grid page ? Unfortunately scripting does not work on that page at all. Or if its table without a model then again scripting wont work without a data source binding.

Br

Nikhil

[FxGk · Accepted solution]

It is a table without a model

What a shame i cant use scripting here 😄

I cant use script variables either?

Thanks for the fast response.

[eeddggaarr]

Hi Felix,
a workaround if you only need a few table fields:

• use the table to create needed structure
• put input or text fields into the table cells
• now you can use scripting with values retrieved from input fields (var userInput1 = InputField1.getValue();) create a new variable with your calculation (var result = userInput1 + userInput2;) and display them in text fields (Text_1.applyText(result.toString());

br
edgar

[FxGk]

Hi edgar,

I tryed this first but it seems like you cant put input fields into a table cell. The only option i found is to overlay the table with an input field. But this is a very dirty solution.

[eeddggaarr]

Hi Felix,
'put xyz into the tabel cells' was poorly worded => I meant on top of the table cells. And I agree: this is not a very efficient solution.
another idea: you could try integrated R environment to create a table more suited to your needs. This should allow you to use variables and calculations.

br
edgar