Check Box filter..

Shonatina · 2010-06-21

hi All..

i have an checkbox to which i have assigned an table...now what i want to know is that, how i will filter this table so that the user see only certain fields....i tried using RunformView :? ..but dunno how well to use it i guess :x .

for eg :- i have an table with students mark,roll,name,chemistry,biology,phys.

so how do i use runFormview ,so that it shows only chemistry values along with the others (mark,roll,name)...

hope i made my query understandable....

thanks

alok_dida · 2010-06-21

I dont know i am right or not .. But this might be solution . Create one form in which you can define your limited fields . In runobject set that form and try to call that Page when checkbox is checked.

Shonatina · 2010-06-21

thanks for the reply dear

but thats not what i want.....see i will attach my snap here

in methodylogy there are serveral, but i hav kept only 1 here, so when i click the methodology and the resource! only the resurces i selected should appear in the form....

can you understand dear?

alok_dida · 2010-06-21

From your point i get this thing if you select Long Term in methodology so based on that selection you have to set visibility for the CheckBoxes in resources... am i right dear?

Shonatina · 2010-06-21

perfect so far....

Zephyr · 2010-06-21

Use this ::
Here Choise is text & UrChoise is int.

//

Form - OnInit()
Choise := 'All,City,Reg.';

Form - OnOpenForm()
UrChoise := STRMENU(Choise,1,Text001);

IF UrChoise = 1 THEN BEGIN
CurrForm.Contact.VISIBLE := TRUE;
CurrForm."Currency Code".VISIBLE := TRUE;
CurrForm.City.VISIBLE := TRUE;
CurrForm."Country/Region Code".VISIBLE := TRUE;
END
ELSE IF UrChoise = 2 THEN BEGIN
CurrForm.Contact.VISIBLE := FALSE;
CurrForm."Currency Code".VISIBLE := FALSE;
CurrForm."Country/Region Code".VISIBLE := FALSE
END
ELSE IF UrChoise = 3 THEN BEGIN
CurrForm.Contact.VISIBLE := FALSE;
CurrForm."Currency Code".VISIBLE := FALSE;
CurrForm.City.VISIBLE := FALSE;
CurrForm."Country/Region Code".VISIBLE := TRUE;
END;

Shonatina · 2010-06-21

i dont get you clearly Zephyr....the codes, should i place it in longTerm? And why do i have so many else as false?
Should it be like....case 1
Pm : visible
case 2
Pl : visible....

sorry to ask, but how do i get that from your codes....its a bit confusing to me.
thanks

alok_dida · 2010-06-21

yeah..
One question for this ... I know that if we define a Boolean Variable in Global Variables (set IncludeInDatabase property to true) and i can give this variable name in value for property Visible. when form loads or some another trigger i can set this value and based on this that control's visibility set. check this link http://dynamicsuser.net/blogs/mark_brum ... perty.aspx

But i now suppose i want to set that control visibility using this functionality on some checkbox activate and deactivate . You can consider above scenario. How can i do that?

AdrianAkers · 2010-06-21

Do your tick boxes correspond to fields in a table?

If so then have a button to run the form on your screenshot shown. On the OnPush trigger of your button then on a local variable of table SETRANGE on your various tick options. Then SETTABLEVIEW to your record and call FORM.RUN.

Simple right? Unless I misunderstand what you are trying to do? ](*,)

Shonatina · 2010-06-21

AdrianAkers wrote:

Do your tick boxes correspond to fields in a table?

If so then have a button to run the form on your screenshot shown. On the OnPush trigger of your button then on a local variable of table SETRANGE on your various tick options. Then SETTABLEVIEW to your record and call FORM.RUN.

Simple right? Unless I misunderstand what you are trying to do? ](*,)

no thats the design screen i have! as shown user will select the methodology and resouces...culmination of both will open an form with as the prescribed metholody and resources....

i totally have 6 phases.....And all are shown in Long team.

say i have another methodology called short team....in this only 3 phase are shown...and the corresponding resources are selected! so this should result in only 3 phases visible in the form with the resources field selected!....

'm i making it clear or confusing?

Shonatina · 2010-06-22

hi ...

i will explain more clearly....

in a company we have more than 1 dept's right ?

So lets call them as practise here...but a person(say myself) is working on NAV! so i can access only NAV details. but the company has all the details of all the practise!
clear till now?

now...when i select NAV in the Practise...All the method & resources opening will be of NAV details....

But Not all person can access all datas even in NAV....I am an Technical person, so i can access only technical details! thats is where Methodology cames...then i want to view only particular datas in the methodology! so comes the Resouces!

so i will open a form with filters like this

Prac : NAV

Method : long Team

Resources : PM PL SE

clear?

alok_dida · 2010-06-22

on what time it will open up a window?

I didnt find any command or else?

Because if you are open up form on activation of checkboxes than at which checkbox you will open up form.Take your example there are three resources so on which resource click i ll pop up a form . I think there should be some command or something else logic behind it.

Shonatina · 2010-06-22

alok_dida wrote:

on what time it will open up a window?

I didnt find any command or else?

Because if you are open up form on activation of checkboxes than at which checkbox you will open up form.Take your example there are three resources so on which resource click i ll pop up a form . I think there should be some command or something else logic behind it.

Hmmm...What i though is when you select the practice, the other checkboxs regarding NAV will be activated...then on that you select the Methodology....then the checkbox for resource should be selected.....finally the form opens....
clear?

alok_dida · 2010-06-22

Shonatina wrote:

Hmmm...What i though is when you select the practice, the other checkboxs regarding NAV will be activated...then on that you select the Methodology....then the checkbox for resource should be selected.....finally the form opens....
clear?

But dear on which checkbox of resource i will open up a form?
We do not have any idea how many checkboxes in Resource item is going to select by user. So on which resource item i ll open up form?

Hope you got my point.

Shonatina · 2010-06-22

alok_dida wrote:

But dear on which checkbox of resource i will open up a form?
We do not have any idea how many checkboxes in Resource item is going to select by user. So on which resource item i ll open up form?
Hope you got my point.

i have....see as i said...every checkbox must codes to operate on! i just dunno what codes that must be!

as i said i will i will select NAV in the prac, Long team in Method..then when i finally select my resources..the form should open on the basis of my selection !

got?

alok_dida · 2010-06-22

Shonatina wrote:

Prac : NAV

Method : long Team

Resources : PM PL SE

I have checked NAV... Methodology ll become visible and in there there will be two option Long Tearm and Short Tearm ... Now i am selecting Long Tearm and based on that Resources are avilable. Resources are there like PM PL SE TL ... First i have select PM and is it open up a form?

If it is not than after selecting all PM SL SE it will open up a form? Now if it is like this than dear how can we know that user has done with his/her choices ? How can i know that he is done with changes because still TL is left.... getting me what i am trying to say..

Or Other possible case is like we have to open up a form on each selection chexboxes in Resources.First i am selecting PM and it will popup screen.. than i am selecting PL and it will popup another screen.. is it true?

Shonatina · 2010-06-22

alok_dida wrote:

I have checked NAV... Methodology ll become visible and in there there will be two option Long Tearm and Short Tearm ... Now i am selecting Long Tearm and based on that Resources are avilable. Resources are there like PM PL SE TL ... First i have select PM and is it open up a form?

If it is not than after selecting all PM SL SE it will open up a form? Now if it is like this than dear how can we know that user has done with his/her choices ? How can i know that he is done with changes because still TL is left.... getting me what i am trying to say..

Or Other possible case is like we have to open up a form on each selection chexboxes in Resources.First i am selecting PM and it will popup screen.. than i am selecting PL and it will popup another screen.. is it true?

hmmmmm #-o sorry to say but i have not thought about that :oops: ! thanks

so what do you suggest i do dear ?

alok_dida · 2010-06-22

hasshh...

add button on a form that will open up a form and all. now form which is going to be open on that what you want to display.. ??? are some controls or just only text..

Shonatina · 2010-06-22

alok_dida wrote:

hasshh...

add button on a form that will open up a form and all. now form which is going to be open on that what you want to display.. ??? are some controls or just only text..

oh just thought the same....sorry for late reply....went for a conference...
i have added a button called SHOW...now i suppose i need to write all my codes in this.

alok_dida · 2010-06-22

Yeah.. true...can you tell me what you want to display on your form which is going to open on button click?

Shonatina · 2010-06-22

alok_dida wrote:

Yeah.. true...can you tell me what you want to display on your form which is going to open on button click?

oh i thought you knew that....
see i hav a unitwise Estimation form....it has 6 phases....

the methodology is based on the how many phases you need to show!
And i hav 8 resources.....so depending on that the user wil select the resources he/she needs!

finally when show is clicked..the form opens with all the selected filters...some thing like this..

alok_dida · 2010-06-22

Shonatina wrote:

alok_dida wrote:

Yeah.. true...can you tell me what you want to display on your form which is going to open on button click?

oh i thought you knew that....
see i hav a unitwise Estimation form....it has 6 phases....

the methodology is based on the how many phases you need to show!
And i hav 8 resources.....so depending on that the user wil select the resources he/she needs!

finally when show is clicked..the form opens with all the selected filters...some thing like this..

I understand that you have to display Entry form again on on show button click? right...

Shonatina · 2010-06-22

alok_dida wrote:

I understand that you have to display Entry form again on on show button click? right...

hey this the output screen you will see....in that you operate! got it dear?

alok_dida · 2010-06-22

still not dear.... still confused.. please show me input screen , then your selection and based on that your output screen.

Shonatina · 2010-06-23

alok_dida wrote:

still not dear.... still confused.. please show me input screen , then your selection and based on that your output screen.

hi...
the only possible way to achieve the solution for this is to code it manually i guess...so 'm working on it now...got to jolt down all possible scenario's....
its gonna be something like this

if a = FALSE then
BEGIN
CurrForm.B.ENABLED := FALSE;
CurrForm.C.ENABLED := FALSE;
END
ELSE
if a = TRUE then
CurrForm.B.ENABLED := TRUE;

(Small letter 'a' is the SourceExpression and 'B' and 'C' are the values in the NAME field)

Thanks...

Howdy, Stranger!

Quick Links

Categories

Check Box filter..

Comments