Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 list boxes - Status and Type.
Status
Active
Inactive
Type
Rent
Non-Rent
When I click on the text object I want everything to be selected from Status and Type except Inactive.Is this doable ?
Thank you much.
go to action tab of text object, add two actions like below
1) To select status
Add action-> Select in Field ->
field : Status
value : '(' & concat(DISTINCT chr(39) & if(Status<>'Inactive',Status) & chr(39),',') &')'
2) To select Type
Add action-> Select in Field ->
field : Type
value : '(' & concat(DISTINCT chr(39) & Type & chr(39),',') &')'