wimtracking2

@CoopperBackpack Is there anyway to search with these preselected cities but also return results IF another field is a certain value? So if the default city field is set to "Bozeman", "Belgrade", "Livingston", but the search returns results for records in any city IF the Type of the record is "Option 2", "Option 3".

Hi have a non-authenticated app that is deployed on 7 websites. I would like to track how many searches are completed in the app and even better know what website is hosting the app the searches are coming from. I know that I can create a submission page and pass these parameters into a table and build a second app to display the results (Separate Search Page and Results Page into Two Different Web Pages - Caspio Online Help). However, using this does not work for me since the same app is on 7 websites and the second app (results) is hosted on a different page and requires sending the user to a URL specific to the website they are currently on. Has anyone built something like this or know a work around?

@CoopperBackpack Just had to change the value ID as you laid out and it works perfectly! Thank you

In a search datapage, with a list of cities available in a multi-select list box, how can I "pre-select" or set multiple values as the default search. Users want to see cities Bozeman, Belgrade, and Livingston as the default records returned in the default search results below the search form. The will then have the ability to change the selection using the multi select city field. The values stored in the city field are a text field. Thanks for your ideas!

This worked on the radio buttons. Thank you

I have a search datapage that displays results in a tabular report. When I search, based on what I see in the results, I want to select certain records to be included in my export or download to excel. Does anyone know a way to add a custom selection box to only download certain records from the tabular report?

I have a search and report datapage that when deployed on most Wordpress websites functions properly. On one wordpress website that uses (Theme X) the radio buttons are not displaying on the same line. In the datapage it is set to display "multiple options per line". The hint images are also displaying on the line under the label. I believe I need to enter custom css into the style in order to make the radio buttons display multiple options per line and the hint images to stay on the same line. What css can be used? Here is the app functioning with the issues when deployed: https://www.mtpca.org/behavioral-health-directory/ Here is the app functioning properly when deployed: https://wimtracking.com/thebrightapp/

Hi @NiceDuck Yes, the data pulls from one View. It's a limit on the total count of all records downloaded over one year. So download one, they download a .csv file of 500 records, download two, they download a .csv file of 3,000 records. Now they have downloaded 3,500 records and can only download another 2,000. Once they download the last 2,000 records, the download option should be disabled. So they can download as many .csv files as needed, until the total count of all the records from each download reaches 5,500. Thanks so taking a look!

I have a Report Datapage that displays Tabular results. I have enabled users to download their search results into a .csv file. I would like to limit the number of records (5,500) that each user can download over the course of 365 days. I would like to continue to allow them to download as many records each time they search until they have dowloaded 5,500. At that time I would like the download option to be disabled. Has anyone done this? Thanks

I was able to get this figured out. I needed to move my code to my footer. I have deployed an update datapage on Wordpress and the javascript below works fine. However, I deployed it on a Weebly website and it is not working. I have pasted the javascript below and then also the deployment code I put on Weebly. I have other custom javascript that is working on the same datapage, so wondering if the iMask might be the problem? Javascript in the Datapage: <script src="[@app:iMask/]"></script> <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var phoneMask = IMask( document.getElementById('EditRecordFax'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordOffice_Phone'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordOther_Phones'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordPrimary_Phone_Number'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordCell_Phone'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordHome_Phone'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordBeeper'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordOther_Phone'), {mask: '(000) 000-0000'}); }); </script> Datapage embed deployment code: <script type="text/javascript" src="https://c2axa376.caspio.com/dp/3c194000bfe6c015b6ac4d52b0e2/emb"></script> <div class="cxkg"><a href="https://c2axa376.caspio.com/dp/3c194000bfe6c015b6ac4d52b0e2">Click here</a> to load this Caspio <a href="http://www.caspio.com" target="_blank" title="Cloud Database">Cloud Database</a></div> <div id="cb3c194000bfe6c015b6ac4d52b0e2"></div>

Hi @DesiLogi Is there anyway to use this same solution, but for the user to multi-select from checkboxes rather than the listbox?

Hi @Andrew I implemented your iMask framework to format my phone number fields and it worked great. I deployed my datapage into a wordpress site without a hitch. However, when deployed into a Weebly website, it did not work. Other custom javascript is working in the same datapage on the Weebly site. Curious if you have run into this before, know what would cause the issue and if you have suggestions on what I might try to get it to work? Below is the code I implemented and it works when deployed on a wordpress site. <script src="[@app:iMask/]"></script> <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var phoneMask = IMask( document.getElementById('EditRecordFax'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordOffice_Phone'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordOther_Phones'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordPrimary_Phone_Number'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordCell_Phone'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordHome_Phone'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordBeeper'), {mask: '(000) 000-0000'}); var phoneMask = IMask( document.getElementById('EditRecordOther_Phone'), {mask: '(000) 000-0000'}); }); </script> I answered my problem - it was a browser update issue. Oi

I did get this answered through another post: https://forums.caspio.com/messenger/465/?tab=comments#comment-831

Thank you @douvega, your code worked perfectly. I was able to implement it for 8 fields needing to function the same way. <script type="text/javascript"> //JS code created by douglas.vega1989@gmail.com function f_listbox(fieldObj) { //Set field to multi-select fieldObj.multiple = true; //Get field values var values = fieldObj.value; if (values.indexOf(",") > 0) { for (var i=0 ; i < fieldObj.options.length; i++) { if(fieldObj.value == values) { fieldObj.remove(i); break ; } } var arr = values.split(", "); for (var j=0 ; j < arr.length; j++) { for (var i=0 ; i < fieldObj.options.length; i++ ) { if(arr[j]== fieldObj.options.value){ fieldObj.options.selected = true; break ; } } } } } setTimeout(f_listbox(document.getElementById("EditRecordCertifications")), 20); setTimeout(f_listbox(document.getElementById("EditRecordTreatment")), 20); setTimeout(f_listbox(document.getElementById("EditRecordAges")), 20); setTimeout(f_listbox(document.getElementById("EditRecordTherapy")), 20); setTimeout(f_listbox(document.getElementById("EditRecordAgency_Services")), 20); setTimeout(f_listbox(document.getElementById("EditRecordInsurance")), 20); setTimeout(f_listbox(document.getElementById("EditRecordAccept")), 20); setTimeout(f_listbox(document.getElementById("EditRecordAreas")), 20); </script>

@douvega I modified the code per this post This is what I have: <script type="text/javascript"> function f_listbox(v_state) { if ( v_state.indexOf(",") > 0 ) { for (let i=0 ; i < o_state.options.length; i++ ) { if(o_state.value == v_state) { o_state.remove(i); break ; } } let o_st = v_state.split(", ") ; for (let j=0 ; j < o_st.length; j++) { for (let i=0 ; i < o_state.options.length; i++ ) { if(o_st[j]== o_state.options.value){ o_state.options.selected = true ; break ; } } } } } document.addEventListener('DataPageReady', function (event) { let v_state = ["Certifications", "Therapy", "Ages", "Agency_Services", "Insurance", "Accept", "Areas", "Treatment"]; //Field names goes here let o_state = []; v_state.forEach(function(el) { if (el !== null) { o_state.push(document.getElementById("EditRecord"+el)); } }); o_state.forEach(function(el){ if (el !== null) { el.multiple = true; } }); f_listbox(v_state); }); </script>