All Activity

This stream auto-updates     

  1. Yesterday
  2. Last week
  3. Validate Date and Time

    Also unsuccessfully tried this: <div id="datefix"> <script> function DateCheck() { var dateout = document.getElementById('InsertRecordDefined_Time_Out').value; var datein = document.getElementById('InsertRecordDefined_Time_In').value; var zero = "00/00/0000" if (dateout <= datein) alert("Please enter a date and time OUT after date and time IN "); document.getElementById("InsertRecordDefined_Time_Out").value = "zero"; return false; } document.getElementById('InsertRecordDefined_Time_Out').onChange = DateCheck; </script> </div> Any suggestions would be greatly appreciated. Thanks in Advance. !
  4. I was wondering if you could conditionally display deploy code based on a passed parameter. If the parameter = X, then show the deploy code, if not, then hide it. thanks
  5. Vitalikssssss Thank you so much for taking the time to help. The "s" was the problem. Thanks again !
  6. Hi Accountability, I have noticed a syntax error in your code where you trying to reference Cascading Elements. Here is an example of the correct syntax for referencing Cascading Elements: Hope this helps.
  7. Triggered Actions on Timestamp field

    Hi MyNameIsSean, That is very odd behavior which I believe will be resolved in an upcoming Caspio Bridge release. In the interim, you can try to build the Triggered action as per below as a temporary workaround. Hope this helps.
  8. Remove Special Characters

    Hi jrodriguez88, I would suggest combining your functions within a single function. Here is a code: <script> function check() { var x = document.getElementById("EditRecordPHONE_NUMBER").value; var y = document.getElementById("EditRecordMOBILE_NUMBER").value; document.getElementById("EditRecordPHONE_NUMBER").value=x.replace(/[^0-9 ]/g, ""); document.getElementById("EditRecordMOBILE_NUMBER").value=z.replace(/[^0-9 ]/g, ""); } document.getElementById("caspioform").onsubmit = check; </script> Hope this helps.
  9. Remove Special Characters

    Thanks! It works using one field but I have multiple. I have tried this but it does not strip special characters when I am trying to use it for multiple fields. Any advice. <script> function check() { var x = document.getElementById("EditRecordPHONE_NUMBER").value; document.getElementById("EditRecordPHONE_NUMBER").value=x.replace(/[^0-9 ]/g, ""); } document.getElementById("caspioform").onsubmit = check; function checkB() { var y = document.getElementById("EditRecordMOBILE_NUMBER").value; document.getElementById("EditRecordMOBILE_NUMBER").value=z.replace(/[^0-9 ]/g, ""); } document.getElementById("caspioform").onsubmit = check; </script>
  10. Hi dspolygot, I have some jQuery code which can achieve this, just put the below code in the header of your DataPage(in Configure Results Page Fields): <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script> <script> $(document).ready(function(){ $("td:nth-child(2)").each(function () { if($(this).html() === 'Final') $(this).css('color','red'); }); }); </script> Please note td:nth-child(2) is for second column if you want it for some other columns just replace 2 by the number of that column. Cheers,
  11. Please see the attached Screen Shot. This is the same working code in: https://forums.caspio.com/topic/7022-time-sheet-date-and-time-in-and-out/ Only changes made were, Dropdowns were changed to Cascading Dropdowns. The following is not working. Anything obvious ? Please advise... Thanks for helping <div id="con1"> <script> function concatenate1() { var One = document.getElementById("cbParamVirtual1").value; var Two = document.getElementByName("cbParamVirtual2")[0].value; var Three = document.getElementByName("cbParamVirtual3")[0].value; var Four = document.getElementById("cbParamVirtual4").value; var Five = document.getElementByName("cbParamVirtual5")[0].value; var link = One + " " + Two +":" + Three + ":"+Four + " "+Five; document.getElementById("InsertRecordDefined_Time_In").value = link; } document.getElementByName("cbParamVirtual5")[0].onchange = concatenate1; document.getElementById("cbParamVirtual1").onchange = concatenate1; document.getElementByName("cbParamVirtual2")[0].onchange = concatenate1; document.getElementById("cbParamVirtual3").onchange = concatenate1; document.getElementByName("cbParamVirtual4")[0].onchange = concatenate1; </script> </div> <div id="con2"> <script> function concatenate2() { var Six = document.getElementById("cbParamVirtual6").value; var Seven = document.getElementByByName("cbParamVirtual7")[0].value; var Eight = document.getElementByByName("cbParamVirtual8")[0].value; var Nine = document.getElementById("cbParamVirtual9").value; var Ten = document.getElementByByName("cbParamVirtual10")[0].value; var linkout = Six + " " + Seven +":" + Eight + ":"+Nine + " "+Ten; document.getElementById("InsertRecordDefined_Time_Out").value = linkout; } document.getElementByName("cbParamVirtual10")[0].onchange = concatenate2; document.getElementById("cbParamVirtual6").onchange = concatenate2; document.getElementByName("cbParamVirtual7")[0].onchange = concatenate2; document.getElementByName("cbParamVirtual8")[0].onchange = concatenate2; document.getElementById("cbParamVirtual9").onchange = concatenate2; </script> </div>
  12. Hello everyone, Does someone know how to dynamically change the font color of a text column in a tabular report? For instance, I have a field named Indicator and it is the second column in the report. If the text value is equal to "Final", the font color must be set to red. Thanks in advance. -dspolyglot
  13. Thats fine. All that info is helpful. I kind of like the frustration I think ;^) After searching online and seeing many others trying to accomplish this seemingly easy function made me headstrong. In excel this is just a COUNTIF= function - count occurences of X and put tally here. I thought the code was close. Think its missing something obviously as its not counting. Was hoping it was just me incorrectly calling the field entries. The example online I got this from was essentially doing the same thing but from an HTML forms input fields.
  14. It does now, so you are trying to count how many values you have in the table. I dont think you are going the correct way. What would happen if this table is 3 pages long? How would you track the amounts in the div. The way I see it you have these three options: Getting a custom JS function to add 1 to a JSON object for every single line and then do the counting to place the results in the div (now sure how it will work in large reports) API calls from a view to count records (You have a limitation of 1000 rows max per call so if your report is greater than 1000, multiple calls are needed) Use two datapages. One for the table and the other one should be tabular too with grouping to show results in the way you want to see it. This datapage should be deployed as an iFrame in the main Table footer. In all ways, you may need to get external help in case you feel stuck, again it can be done but I dont want you to get fustrated. Please also take into consideration that this is how I see it, I am sure there may be other people that can suggest something different and it would be ok as soon as it works. Sorry for not being able to help you with a final coding but a further review is needed.
  15. No problem. Appreciate any help. Im trying to count from the field CME_category. Grouping and Aggregate doesn't do the best job of counting individual entries or placing them in an easy to see stacked view like Im trying to achieve. As these categories grow and the number entries get huge grouping and aggregate numbers will get spread out and some off screen as the entries grow. A simple report tally in one spot will be helpful and more useful and easily digestible to me users. The one above should read. I only included 3 categories for test. summarycardiology = 3 critical care = 2 EM = 2 Medicine = 1 stroke = 1 trauma = 1 I dont have editable turned on as I want it to be just a visual summary report, non editable. Hope that makes sense.
  16. Sorry, I got lost. Where is the field you want to count from? I see only a table with no edittable fields. By the way, have you tried to use the Grouping function and Aggregate field on this table to display counting results?
  17. Yes for the libraries. Called them in from the Header. https://c3ebv137.caspio.com/dp.asp?AppKey=3f2d400026716a8f79ee4d37942f
  18. Could you please share the datapage? Also, did you include the jQuery Library in your datapage/webpage already?
  19. Hello All, I have a Details datapage that filters to show multiple records (one record per page but all accessible with the Next/Previous buttons). I'd like to be able to, from the browser, click Print and print to pdf ALL of the records in the results into a single PDF doc. Instead it only will print the current record. Does anyone know how to do this? I would put the records in a tabular, list, or gallery datapage to do this but the problem is forcing page breaks in the right place so images and/or text don't get split in the pdf. I was hoping to be able to utilize a Details page to avoid this issue...
  20. Validate Date and Time

    Thank you so much for responding. Unfortunately it didn't work. I don't know if this makes a difference but there are two other working scripts right above it https://forums.caspio.com/topic/7022-time-sheet-date-and-time-in-and-out/ Any more advise would be greatly appreciated.
  21. Can you hide an HTML block with a rule?

    Wow. Both work well. Thank you! The script version was very educational - I can see why it works and where mine was off. The rule for hding the section is very elegant. And proof that I tend to over think things. I think this topic and solution will help other. Thanks again.
  22. Validate Date and Time

    Hello Accountability, I would suggest using following code if you prefer to restrict form submission if the condition "dateout <= datein" is met: <div id="datefix"> <script> function DateCheck() { var dateout = document.getElementById('InsertRecordDefined_Time_Out').value; var datein = document.getElementById('InsertRecordDefined_Time_In').value; if (dateout <= datein) alert("Please enter a date and time OUT after date and time IN "); document.getElementById("InsertRecordDefined_Time_Out").value = null; return false; } document.getElementById('InsertRecordDefined_Time_Out').onChange = DateCheck; </script> </div> Hope this helps.
  23. Only regular drop-down form element can receive a parameter on a submission form. What is the purpose of assigning a parameter to a cascading element? First, you may need to submit a parameter to your lookup table. Have a look at this post.
  24. Time Sheet Date and Time in and Out

    Please See Above attachment. In attempting to integrate drop-down values so I could use both the working code (Above) and the drop-down. I unsuccessfully tried the following. If I can find a way for this code to work I will apply the same for every Work Schedule in the drop-down). Any advise would be appreciated. Code Snippet var shift = document.getElementById("Defined_Work_Schedule").value; var One = document.getElementById("cbParamVirtual1").value; var Two = document.getElementById("cbParamVirtual2").value; if (shift == "7:00 AM to 7:00 PM") var Two="07"; var Three = document.getElementById("cbParamVirtual3").value; if (shift == "7:00 AM to 7:00 PM") var Three="00"; etc.....
  25. I am trying to make sure the time in entered is less than the time out entered. I was determined to figure this out on my own but just can get go any further without help. Here is my code. Since Defined_Date_Out is required, I thought replacing the users erroneous entry with null would prevent the submission from being initiated. Thanks for any advise ? <div id="datefix"> <script> function DateCheck() { var dateout = document.getElementById('Defined_Time_Out').value; var datein = document.getElementById('Defined_Time_In').value; if (dateout <= datein) alert("Please enter a date and time OUT after date and time IN "); document.getElementById("InsertRecordDefined_Time_Out").value = null; } document.getElementById('InsertRecordDefined_Time_Out').onChange = DateCheck; </script> </div>
  26. Clearing Values in A Search Form

    No such luck. It reloads the page but the values in search form persist as well as the filtered data.
  27. @douvega The impacted Data element is a CASCADING dropdown menu. I don't see an option for it to receive the parameter within the Caspio bridge. I am assuming that this will need a custom JS on windows. onload() to set the Dropdown value to the parameter.
  1. Load more activity