How to create actions for

[#1]

Hi Experts,

I have vendor table with Vendor,vendor status,Vendor status having values active and null values.i want dispaly any sheet object with yes,no.if we click on no i need to get only Active vendors,if clik on yes i need to get all values of vendor.

Thanks,

Siva

[varshavig12]

Use list box with expression

[beck_bakytbek]

hi siva,

do you want the tabrows with your objects, any tabrows contain Information of vendor(active) and another tabrows with vendors (with null)

if select vendor (active), then you have only Sheets with active vendors, and if you select no then you have vendors with nulls.

did i understand right?

beck

[varshavig12]

if(vendor_status='active','no','yes')

[#5]

If i clik No Button i have to show all Active sattus vendor,if clik Yes i want see all the Vendors.

Thanks

siva

[#6]

If i clik No Button i have to show all Active sattus vendor,if clik Yes i want see all the Vendors.

[beck_bakytbek]

sive,

can you give your example-data, so i can create for you an example.

beck

[susovan]

Hi Siva,

Try this attachment,

[#9]

Vendor	Vendor_Status
1	A
2
3
4
5
6
7	A
8
9
10
11
12	A
13
14
15
16
17
18
19
20	A
21
22
23
24
25
26
27
28
29
30	A
31
32
33
34
35
36
37
38
39
40	A
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72	A
73
74
75
76
77
78
79	A
80
81
82
83
84
85
86	A
87
88
89
90
91	A
92
93
94
95
96
97
98
99
100	A
101
102
103
104
105

[#10]

Hi Beck,

I want to create 2 buttons YES and NO,If Clik on NO i have to show all the active items,if i clik the YES i have to show all the vendors.

Thanks

siva