records in table Box as per input value

[#1]

I want to display records in table Box as per input value in Input Box. How to do it ?

[vishsaggi]

You cannot use the inputbox in table box. You have to use a straight table. Table box can take only fields variables are not possible. However, i assume you are trying to add different values into a field ? Correct me? If Yes, you might want to use an InputField where you can change and add the values in each cell.

For eg:

INPUTFIELD Value;

Table:

LOAD * INLINE [

ID, Value

2,

3,

4,

5,

];

Once you load this add these fields in your table box then you can manually enter your own values in individual cells accordingly. So when you hover over your mouse on these individual cells you will get a small button to edit the cell.

Hope this helps.

[passionate]

Hi Nitesh,

Please specify your requirement in detail

Regards,

Pankaj

[passionate]

This can be tried using variable trigger.

Assign variable to input box and then try to reduce field based on this.

[#5]

I  want to filter my data by giving input to input box.

for Example -

I have 2 records in database table as below-

eid    ename    dept

1         A              10

2         B               20

3         C               10

i use one input box for using as deptno, when i enter 10 then all the record who has only dept=10 must display.

How to achieve it.

[vishsaggi]

You have to use a trigger to do this.

Click ctrl+Alt+D - Triggers Tab - > Variable Event Trigger -> Onchange Edit button -> Add Select in Field trigger -> use Dept as your field and in search string use your variable name like = vDeptValue.

[Colin-Albert]

Why not just add a listbox to your sheet on the dept field. There is no need to use an input box to filter your data.