Teresa Sampaio Posted March 7, 2006 Posted March 7, 2006 Hi, I have 2 categories of clients - “banks” and “others” – and for “banks” I have two sub-categories. I would like to mark one of these two sub-categories and “banks” should be auto-marked. I have succeeded to do this, but then I can’t mark only “banks” if there is no need to mark sub-categories… What am I doing wrong? Or this is not possible? Thanks in advance.
Sanjai Posted March 15, 2006 Posted March 15, 2006 When you talk about categories, do you mean you have used check boxes or radio buttons to represent the categories? You could simply write a script to uncheck/unmark the sub categories if a certain condition is true and mark only the top banks category. Some more details would be helpful.
alphanitrate Posted April 3, 2006 Posted April 3, 2006 If i understand you correctly, if you have a field with certain contents ( Field 1 Yes) I can a have a check box automatically checked? Also can I use larger group (Category 200) to have these fields automatically checked? ( IF items have a category of 200, then these Field 1 will automatically be checked)?
LaRetta Posted April 3, 2006 Posted April 3, 2006 Hi alphanitrate, You would use an Auto-Enter on Field 1 (be sure to UNCHECK 'Do Not Replace Existing Value' with: If ( Category = 200 ; "yourCheckboxValue" ) ... where yourCheckboxValue is whatever is specified in that checkbox value list. But does that Value List contain other values as well? If so, change the calc to: If ( Category = 200 ; "yourCheckboxValue" ; Field 1 ) It helps to have specific examples. The first example assumes only one value - it becomes a toggle and will only allow a one value or blank. The second example allows multiple values. LaRetta
Lee Smith Posted April 3, 2006 Posted April 3, 2006 Hi alphanitrate, LaRetta has provide a similar answer as I was going to post, but she beat me to the punch because she is a faster typist then me. However, I was going to ask a question to clarify the answer a bit: is the Category = 200 the only number you want this fore, or were you talking about the range of 200...300, i.e. 200, 201, 202, ... 299? HTH Lee
Teresa Sampaio Posted April 4, 2006 Author Posted April 4, 2006 I think the main problem remains unsolved… If need to check the first “category” only (and none of the second and third), it seems that, as I turned it into an “auto-enter calc”, it wont be possible and that’s my problem. I want that first category to be both “auto-checked” and free to check. Is it possible? (I don’t know if I made my self clear, as my English is not as good as I’d like.)
Lee Smith Posted April 4, 2006 Posted April 4, 2006 Hi Teresa, Sorry for answering alphanitrate's question, and while you were still needing help. You sound like you have set up, or are wanting to have a Conditional Value List for Banks. But, your file structure is a little fuzzy to me, can you attach a sample of your file? Lee
Teresa Sampaio Posted April 4, 2006 Author Posted April 4, 2006 Hi, Lee Here goes the sample. Thanks. Contactos_.zip
alphanitrate Posted June 19, 2007 Posted June 19, 2007 4-03-06 02:10 PM - Post#200710 In response to alphanitrate Hi alphanitrate, You would use an Auto-Enter on Field 1 (be sure to UNCHECK 'Do Not Replace Existing Value' with: If ( Category = 200 ; "yourCheckboxValue" ) ... where yourCheckboxValue is whatever is specified in that checkbox value list. But does that Value List contain other values as well? If so, change the calc to: If ( Category = 200 ; "yourCheckboxValue" ; Field 1 ) It helps to have specific examples. The first example assumes only one value - it becomes a toggle and will only allow a one value or blank. The second example allows multiple values. LaRetta Hi alphanitrate, LaRetta has provide a similar answer as I was going to post, but she beat me to the punch because she is a faster typist then me. However, I was going to ask a question to clarify the answer a bit: is the Category = 200 the only number you want this fore, or were you talking about the range of 200...300, i.e. 200, 201, 202, ... 299? HTH Lee I thank you both for providing me help before - and i am looking for it again. Here's the scenario - I have a list of product catagories ( 200, 300, 400 etc) i would like these catagories to activate check boxes that correspond to safety warnings. ( IE. 200 = don't eat) Now some catagories may have multiple warnings. ( 300= don't eat, keep out of light, explosive.) So in my layout the items would be have check boxes for all the possible warnings, but would have some prepopulated based on catagory. I would also like to have the new checked off warnings attached to this record, but not the whole class. Here's what i've done so far: Set up a Checkbox set linking the catagory number from another file and the field (:BYRNUM). Displaying values from " Warnings" value list, I tried to use LaRetta's example and have done this: Use values from field ::BYRNUM and also tried a custom ( If BYRNUM=200;"do not eat"; Field 1) in the field it self i get a check box I've never used value lists before, so i'm not even sure what i did correctly .
Recommended Posts
This topic is 6425 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now