Search the Community

Hi,I am trying to perform a simple calculation in Virtual2 (a calculated field) using a value selected in a multi select dropdown. However, the calculation is failing.Step 1 - I set up a multi select dropdown - List_StringStep 2 - the multi select dropdown field ID cannot be used in a CASE statement therefore I set up [@Virtual1] to capture the selection in the List_String using JavaScriptStep 3 - I then tried some CASE statements in [@Virtual2] to perform a simple calculation based on the List_String selection copied to [@Virtual1]. However, this part isn’t working. I have tried this formula: CASE WHEN '[@cbParamVirtual1]' LIKE '%'+'Car'+'%' THEN 300 END The above formula works with any other field (dropdown, radio buttons, etc) but it will not work with [@cbParamVirtual1]. I wonder if it is because of the data type (when copied from the multi select dropdown) and whether my formula needs to CAST [@cbParamVirtual1] as something that Caspio will recognise as text. Would anyone have any recommendation? Many thanks JayMany thanksJana

In my search form in Reports DataPage, I want to select all the items in a multi-select listbox when my checkbox is checked. Also, when it is unchecked, all the items should be deselected. Any ideas?

How can I use Multiselect listbox to perform a search with OR logic? I have separate search and report as described in the video: https://howto.caspio.com/getting-started/display-results-on-a-separate-web-page/ Does anybody have ideas?

The main goal is to have a pre-defined on-load multi-selected listbox. The listbox element uses Cascading dropDown virtual element. It should hide some sections if 1 element selected and hide others if 2 elements are selected. Can anybody help me with the Caspio or maybe JS solution? Thanks.

How can I show the values that are selected on a listbox in submission page in a virtual field?

Ok so I have a search function that runs as a multi-select. The search options look like this: Project Status: Awarded In Planning In Design Under Construction Project Completed Project Canceled There's a lot more than that but that's the general idea. What I want is to have a checkbox that says "Search Completed/Canceled projects?" and only when that checkbox is marked yes should Completed & Canceled projects be included in the search. If they run the search without that box checked I want all Completed & Canceled project to be omitted from the Search Results. What is the best way to go about this? Virtual Fields? Triggers? Thanks in advance for your help!

I just watched the video How to Create Multiselect Dropdowns in Caspio. The video introduces several new data types: List - String List - Number List - Data I've created a new table to try these new types out but do not see any of them as data type options. Should I be seeing these new data types now, or is this scheduled to be included in an upcoming release perhaps?

So this is something that has been addressed a couple of different times but not of the Javascript solutions work for me. I have an update page that has 3 listboxes with multi-select enabled. I need the update page to display the multiple selections in the listbox separately and not in one long sentence separated by commas. Here are two of the different scripts I have tried to use, neither has worked. First: <script> // Function for selecting corresponding elements from the list box. function select_ (){ // get listbox element var o_els = new Array("EditRecordStatus","EditRecordMarket_Sector","EditRecordDivisions"); for (var k=0; k< o_els.length; k++ ) { var o_el = document.getElementById(o_els[k]); // Enable multiselect for listbox o_el.multiple="multiple"; // get listbox length var len = o_el.options.length; // get selected element var selected = o_el.options[len-1].value; // verify if selected element contains comas, if yes, do the following if (selected.indexOf(",") != -1 ){ // Split selected option into array var m_array = new Array();m_array=selected.split (","); // Delete last option from the listbox o_el.options.remove(len-1); // Go through listbox and select each option, if it is present in array for( var i=0; i< m_array.length; i++ ){for( var j=0; j< len-1; j++ ){ // Trim spaces while comparing elements from array and listbox if( m_array.replace(/^s+|s+$/g, '') == o_el.options[j].value ){ o_el.options[j].selected = "selected"; } } } } } } // call select_ funtion when details page is loaded window.onload = select_; </script> Second (On this one the 3rd Listbox works but the other two do not): <script type="text/javascript"> var v_state = "[@field:Status]" ; var o_state = document.getElementById("EditRecordStatus") ; o_state.multiple = true ; function f_listbox() { if ( v_state.indexOf(",") > 0 ) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_state.value == v_state) { o_state.remove(i); break ; } } var o_st = v_state.split(", ") ; for (var j=0 ; j < o_st.length; j++) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_st[j]== o_state.options.value){ o_state.options.selected = true ; break ; } } } } } window.onload = f_listbox ; </script> <script type="text/javascript"> var v_state = "[@field:Market_Sector]" ; var o_state = document.getElementById("EditRecordMarket_Sector") ; o_state.multiple = true ; function f_listbox2() { if ( v_state.indexOf(",") > 0 ) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_state.value == v_state) { o_state.remove(i); break ; } } var o_st = v_state.split(", ") ; for (var j=0 ; j < o_st.length; j++) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_st[j]== o_state.options.value){ o_state.options.selected = true ; break ; } } } } } window.onload = f_listbox2 ; </script> <script type="text/javascript"> var v_state = "[@field:Divisions]" ; var o_state = document.getElementById("EditRecordDivisions") ; o_state.multiple = true ; function f_listbox3() { if ( v_state.indexOf(",") > 0 ) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_state.value == v_state) { o_state.remove(i); break ; } } var o_st = v_state.split(", ") ; for (var j=0 ; j < o_st.length; j++) { for (var i=0 ; i < o_state.options.length; i++ ) { if(o_st[j]== o_state.options.value){ o_state.options.selected = true ; break ; } } } } } window.onload = f_listbox3 ; </script> Thank you for your help!

How can I enable multi select for multiple lust box on search form I created using submission page?