Jump to content


  • Posts

  • Joined

  • Last visited

CDiez's Achievements


Apprentice (3/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. By the way... I don't have much experience with global fields, so I have to ask: In using global fields this way to collect users' search criteria, is there a problem with multiple users searching at the same time? I mean, how can I select one set of choices and someone else select a different set simultaneously, if it's a global field?
  2. Thanks! This builds on a method you suggested to me some months back when I was looking at this the first time (this is a part time project for me, so I work on it in pieces, and sometimes forget where I've been.. not ideal I know). I will go back to that and integrate your suggestion here, and I will keep in mind your suggestion to keep things simple. I have begun to appreciate that that is very good advice. Regards, C
  3. Hi, I am looking for a way to display to users their search parameters as they enter them in a number of FIND layouts. In my solution, users will perform searches by entering a number of search criteria (on different layouts) and "extending" the found set possibly multiple times (as they switch layouts, and as they "extend" the find criteria within a layout). But they won't go to a browse layout to view the search results until they are done "building" their search. I have scripted buttons to let them "extend" their search or "complete" the search and go to a browse results layout. I would like to display to them the criteria they are searching on as they are building their find, in a window somewhere on the find layout. It would go away once they complete their search and go to a browse layout to see their found set. Does what I describe seem feasible, or would it be way too complex to implement? I would love some opinions from you experts, and appreciate any tips to point me in the right direction. Thanks in advance... Carlos
  4. yes this is it! I have to step out now so I will have to study it later, but it looks like a very elegant solution. much obliged!! cheers, Carlos
  5. This sounds right.. but I can't seem to get it to work. Not sure I understand the relationship between this global text field and the records being searched. I added this global field to the table that holds all the records, and formatted it to show the checkbox set for the same value list that I use to select the value for each record, and in the "display data from" window I selected the field that contains those values for each record. Does that sound right?
  6. bcooney, Your last suggestion is exactly where I'm headed (I think). I appreciate your advice about keeping Find simple. But I'd like to give this a shot and see where it takes me. The only hangup is capturing just the values that the user selects when the value list is presented to them in a checkbox. What I need is a function sort of like ValueListItems, that returns selected values instead of all the values in the list. Would it make sense to reproduce the values from the list individually in separate fields, present each field as a 1-value checkbox (in browse), and then use your technique to determine if the user has selected it? I could then string together the selections to construct a find. If this seems really stupid, please let me know. I'm still a novice banging my head around a lot. Thanks again!! Carlos
  7. I like the idea of using tabs, but based on the previous post it would appear my whole approach is wrong, since doing a find on multiple values in checkboxes will search for records that have all the selected values (e.g., all records that have both FL "AND" NY for the state). Since what I want is all records with FL "OR" NY, my approach won't work. This means I'd have to string together a sequence of finds (extending each time). Is there a function to capture (in browse mode) all the the values selected in a checkbox field in which multiple values may be selected? If so, I may be able to script the sequence of finds. Thanks, Carlos
  8. You know.. I was so intrigued by the possibility of a solution from Stephen's suggestion that I didn't really think about what you meant. But based on what you say, my whole approach is wrong. So would it be possible to set up an interface allowing the user to select multiple checkboxes and then run the multiple find requests via a script? If so, how could I "collect" the user's choices for retrieval by the script? The values in the checkboxes come from a set of conditional value lists which are used to assign each record to a particular set of categories and subcategories. Thanks, Carlos
  9. Stephen, I stumped. First, I noticed in your solution that selecting multiple values in your checkbox 1 gives me all the relevant subchoices in box 2 (both browse and find modes). Not sure if this is the intended behavior. This is actually what is happening to me by default (with no script triggers or global fields), and what I need to change. What I'd like to do is have a script trigger that switches between layouts in FIND mode. The various layouts either show or don't show the 2nd and 3rd checkboxes. If the user selects 1 value in the 1st checkbox, I want them to see the 2nd box (and if 1 value in 2nd, to see the 3rd). But if 0 or >1 values are selected in box 1, I want to go to the layout that does NOT show box 2, etc. In my scenario, it does not make sense to show the subchoices if >1 top level choice is made. Also, this way I get rid of the "" message when there are no subchoices. Following your suggestion, I added a new global field and tried using a script variable to populate it with a number that points to the appropriate layout (layout 1, 2, etc.), and then a set of if statements that take the user to the layout based on the number in the global field. I put this in a script trigger (on modify) in the appropriate checkboxes. Again, it works in browse mode but not find. Any idea what I might be doing wrong that it does not work in find? Or is what I'm after simply not possible? Any additional pointers would be great... Thanks, Carlos
  10. Thanks! I haven't had time to look at it yet but from your description it sounds like your method will do the trick or take me a good way towards what I want. Carlos
  11. Hi, My solution includes a set of conditional value lists for selecting a type and subtype for each record. Some of you have been a great help before with these value lists, but now I have a problem in find mode. For searches, I need to show the type and subtype values as checkboxes, because a search may include multiple types. However, if my search is for multiple types, I want to mask the subtype choices from the user. As an example, if the types are types of food, I might select fruit as the type and then strawberries and mangoes under subtypes. But if I select fruit and vegetables, then I do NOT want to show all the subtypes of both food types. This would be a broad search and the subtype level of granularity would not make sense. Also, in my solution I have many types and subtypes and showing all would make for a cluttered interface. The default FM behavior in FIND mode is that if the user selects >1 type, all the subtypes corresponding to the top level checkboxes selected are shown. I would like to show NO subtypes when >1 or 0 types are chosen (though I could live with the default "" message in the subtypes field when 0 types are chosen). SO... I created different search layouts to show or not show the subtype fields, and wrote a script that selects the layout (using valuecounts) based on which checkboxes are selected in the type fields. I invoke the script using an "on object modify" script trigger on the type field (I'm using FM10). Now for the frustrating part... it works perfectly in BROWSE mode, but NOT in FIND mode. If someone would point me in the right direction on how to achieve what I discuss above, I would be most grateful... Carlos
  12. comment, I stumbled upon the solution, and thought I would post it here, in case anyone else has the same difficulty I had. I believe I had the wrong syntax in the auto-calc field for the 3rd level: it was pointing to the wrong TO. Now your "condVL2+clear2" solution seems to work exactly the way I need it to, so if you don't mind, I will borrow it for my properties project. Initially, I will use it to allow users to select the appropriate zoning district, based on the governing municipality, which is selected from a list based on the county selected. Also for property categories, types and subtypes (a few of which are shown in the attached). Many thanks for sharing your solution!! Cheers, Carlos condVL2_clear2_REVISED.fp7.zip
  13. comment: I feel bad that I had not realized you had already suggested a solution some months back when I first started wrestling with this. Sorry! I had to put the project aside and now I'm on it again, and I've been looking at the solution you shared then ("condVL2+clear2"). As I mentioned, my solution requires 3-level value lists, and I've been having difficulty modifying your solution to add the 3rd level. I was hoping you would be kind enough to take a look at what I've done (attached). I've been at it for hours with no success, but I'm sure you'll spot the problem in a minute. I'd be MOST grateful. Notice the problem when selecting the "subtype" (3rd level) in the table layout: it shows all the subtypes associated with the top level ("category"), instead of only the ones associated with the combination of "category" and "type" (my 2nd level). Not sure if the snag is in the relationship or in the auto-calc field. You need to look at the "retail" category to see what I mean. Also, when "retail" is selected (but NOT when other category values are selected), the subtype field is cleared as soon as I select a subtype value. Can't figure out why that is happening! I feel this is THE solution if I could just get past these two snags... THANKS AGAIN!!.... Carlos condVL2_clear2_REVISED.fp7.zip
  14. Thanks. I had already looked at that some months back and it didn't fully address the problem. Can't remember why (and I'm no longer subscribed so I can't view it again). I think I almost have it though. Just working through one last snag. I appreciate the reply...
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.