How do you get specific value from responseContent?

Respected Seniors,

I have these blocks

The blocks display following data
I want to get value show in red box
Need this value in variable to display an other textbox

There are total 7 columns in used in TableViewer as

 SELECT
    ddate,
    vou_no,
    acc_name,
    cr_amount,
    dr_amount,
    closing,
    CASE WHEN closing < 0 THEN 'DR' ELSE 'CR' END AS a

Regards

We need to see where data list came from.

Show us it's raw form.

Respected sir,
I want to get -5706 in variable to display in textbox.

This figure may be different in different dates.
But its location always be the in second last cell in last row.

Please

Use length of list to get the index of the last row.

Sir I used this block to determine number of rows

It displays this result

Total rows are 3

Now how to get 6th cell value of 3rd row.

Please

Init a global variable, call it last_row.

When you have your table,
set last_row to select item (length of list(table) of table
set Label.Text to select item 6 of global last_row

Can you please daraw block, I am still confuse.

1 Like

Sir there are 3 rows in datalist then your block works fine.
But if there are records are not equal to 3 then your block does not work

Suppose I have this data


Now the codes do not work.

I think we should use length of list, but I do not know how to.
Please

lists_length

Sir I used these blocks

Now everything is ok.
Thanks

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.