0
On an SBM form, how can I get additional information on possible choices in a Multi-Relational field so that I can organize them better for the user (such as putting them in a collapsible tree view of checkboxes)?

The possible choices will number in the hundreds which will not work well at all for a simple list. I want to use tab views and tree views to organize but for that to work I need to get some other data than just the title of the relational items.
Responses (5)
  • Accepted Answer

    Jeff Malin
    Jeff Malin
    Offline
    Tuesday, October 18 2011, 06:26 AM - #Permalink
    0
    If you don't mind it showing up anywhere you look at these relational items, you could change the value display format of the Aux table that you're relating to, to show additional items in each item's name - you can add delimeters to enable parsing of these values as well.

    Otherwise, you could look at embedding a report with Query-At-Runtime parameters that accepts a list of items selected in your field (this functionality is pretty new and I haven't played with it to know if it works for multi-relational fields). Or build a custom lookup API using SBM Script or Web Services, and attach it to the form using JavaScript on the change event of the multi-relational field.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, June 26 2012, 12:12 PM - #Permalink
    0
    That's what I did eventually... I just wanted some way around doing that.

    This is what I achieved... the image shows the Proposed Levels field (normally hidden) that displays the multi-relational field in checkbox form. I skim through that to get the titles which contain 4 pieces of info and use that to construct the tab view/tree view combination on the main screen.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, June 26 2012, 10:07 PM - #Permalink
    0
    Hello, is this an embedded report on a form? are users selecting items from this? If so, this is what we are trying to do, but struggling! How have you managed to return the items selected from the report, even support are struggling to know how to get a handle on the items selected on an embedded report.

    Any help appreciated. Many thanks
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, June 27 2012, 03:47 AM - #Permalink
    0
    This is not a report. The lower section that includes the Proposed Levels field is a panel that I usually hide with a HideSection( ) call (in javascript). I use the HTML DOM to scan the the elements that make up the field and the checkboxes to get the titles of each option (which represent other relational tickets). The title of each ticket is controlled by me and I parse out the 4 pieces of information which I used to construct the tab view at the top.

    The construction of the tab view is also in javascript. I have a simple tab panel with one fixed tab that says "no content available". I dynamically add tabs for each distinct General Category (the first piece of info from the title). In each tab, I construct a tree control (found some code on the web, didn't properly donate or cite, not comfortable in showing this part) with the other pieces.

    The checkboxes in the tree are totally constructed and do not correspond to SBM controls. I trap the clicks on the tree items and make sure to correspondingly check the true items in the actual Proposed Levels field so that the workflow gets the input.

    I have similar code to display the selected stuff in an abbreviated tab/tree panel once OK is pressed.
    The reply is currently minimized Show
  • Accepted Answer

    Wednesday, June 27 2012, 10:19 PM - #Permalink
    0
    Thanks for the clarification, thats certainly a very clever solution. I think I need to learn javascript!
    The reply is currently minimized Show
Your Reply

Recent Tweets