Jump to content


Caspio Rockstar
  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by kpcollier

  1. Here is a CodePen example of the code above working on simple input elements. Just trying to get this to work on my datapage. I get no errors, just nothing happening. I have a feeling it is because every input element is wrapped in a div. I might just have to write a script for every step, i.e. if cbParamVirtual1 length = 2, go to cbParamVirtual2, and so on.
  2. I have a few virtual text fields on my submission form. I am trying to find a script that will automatically go to the next field when the previous one is filled. I wasn't too sure where to start with this, so I started with a stackoverflow article. $('*[class*="cbParamVirtual"]').keyup(function () { if (this.value.length == this.maxLength) { var $next = $(this).next('*[class*="cbParamVirtual"]'); if ($next.length) $(this).next('*[class*="cbParamVirtual"]').focus(); } }); Obviously it is a bit different because not all of my inputs share the same cla
  3. Hello. I have a trigger that is taking the difference of two dates (Date_Start and Date_End) and creating a new record for each one. In Example, if Date_Start is 5/10/2021 and Date_End is 5/12/2021, three new records should be inserted into the table, one for 5/10, 5/11, and 5/12. My problem is that my trigger is creating extra records in the table. Taking a look at the table and the trigger below may help understand the problem I am having. Here is the trigger. Var daycount is getting the difference in days. This number should be the amount of records that will be cre
  4. Sorry @TellMeWhy, you may have missed the 'Edited' remark on my last response. I had found the solution myself and posted it there. It is working as intended. Thanks for the help!
  5. You could separate your search and results page into two different pages, like found in this article. Maybe create a new table, Search Log Table, with some of the same fields used in the search form (whatever fields you want to log). This would be for saving the search log results. Instead of using virtual fields like in the article mentioned, you would use these fields from the new table. Have these new search fields have the same lookup sources as the search form you have now so the data is the same. Then, like in the article, pass the parameters to the results page on submit
  6. I had this problem with my date and text area fields. I had to use the '>' operator in my CSS rules, in my own media query to make it work. @media only screen and (max-width: 1025px) { .cbFormFieldCell > #EditRecordTech_Schedule_Table_2_Date{ width:30% !important; } .cbFormFieldCell > #EditRecordTech_Schedule_Table_2_Notes{ width:99% !important; } .timeClass{ width: 96%; } }
  7. I have tried inserting an IF statement - if (ampm !== null) - but it is updating it to the default '12:00:00' regardless. **Here is the script if anyone is looking for the answer to this problem. document.getElementsByName('Mod0EditRecord')[0].onmouseover = function(){ var date = document.getElementById('EditRecordTech_Schedule_Table_2_Date').value; if(date == "") { date = "1/1/2011"; } var ampm = document.getElementById('timepicker1').value; var ampm2 = document.getElementById('timepicker2').value; if (ampm !== null && ampm !== ''){ document.getElementById('Edit
  8. I have a datapage with 2 date fields and I am using the timepicker to set the Time for them. The script I have is working, however I'd like to make some minor changes and it seems to be difficult for me. document.getElementsByName('Mod0EditRecord')[0].onmouseover = function(){ var date = document.getElementById('EditRecordTech_Schedule_Table_2_Date').value; if(date == "") { date = "1/1/2011"; } var ampm = document.getElementById('timepicker1').value; var ampm2 = document.getElementById('timepicker2').value; document.getElementById('EditRecordTech_Schedule_Table_2_Time_From').value = d
  9. Is there a way to automatically 'search' if the search form receives a parameter? I would like the search form to act normally most of the time, but, if the search form receives a parameter, I would like it to automatically go to the results page. I was thinking of modifying the Auto Submit script with an if/then clause that would check to see if the fields already have a value upon load, and submit if so. But,then I thought it would cause a problem going back to the search form from the results page because the old values are still present when you do that. Sounds like it would create a
  10. What do you mean by 'more secure'? Are you using authentications?
  11. @DesiLogiDid you ever find a solution to this problem?
  12. Does anyone know if there is a workaround to make the display value of a field show on the results section of a tabular report? I have multiple fields that store an amount of time in days, but I'd like to display those values in weeks. I.e., the report will show '14' and '70' when I would like it to display "2 Weeks" and "10 Weeks" respectively. The fields already use a lookup table that has both display and actual values saved. When setting a lookup table for an editable field, you can select the Display Value, but this only shows when editing a record in the results section.
  13. @Darryl, I ran into the same problem. Fixed it using the code below. Replace TableName with your table name. select[id^="InlineEditTableName"]{ width: auto !important; } Also, to fix it for fields/columns that are not editable, you can use the below code. However, I am not too sure how to drill this down more. 'Data' class name seems a bit ambiguous and may cause changes elsewhere. However, for my report, it did not. div[class^="Data"] { width: auto !important; }
  14. @Mahmood, one of the best things you could do for just starting out is to head over to the Ready Made Apps and ask to get one downloaded to your account. I suggest one of the more simple ones. It doesn't necessarily have to match your workflow above, but it is a nice way to understand how different forms/reports/pages are built and give you ideas you can use for your own. Also, search for Caspio on YouTube, as there are a ton of nice videos that can help get you started.
  15. Never really found a proper way to do this. But, I did find a workaround that seems to be functioning fine. You'll need to give the Month header bar the following to give room for your header: nav.cbResultSetCalendarStickyHeader { top: 100px; } Then, you'll need to make your Datapage Header come in front of the events/records, and give it a white background to hide the events that overlap. .container { position: fixed; z-index: 999; background-color: white; } The body tag from the Caspio stylesheet has 8px of margin on the top, which lets 8px of the overlapping eve
  16. Some things I have tried: Adding a sticky class - this is being ignored, or I'm just not doing it correctly. div.sticky { position: -webkit-sticky; position: sticky; top: 0; } Making the key/legend position: fixed - this one is keeping it sticky, and I am able to give the 'Month Header' the top css rule to be placed below the key when scrolling. But, I cannot figure out how to do the same to the actual events/results. The events are overlapping the legend at the top of the page when scrolled. .container { position: fixed; } @media only screen and (max-width: 576px) na
  17. Anyone know if it is possible to make the header of a calendar datapage sticky? I have a color key/legend for the events on my calendar datapage in the header and would like to keep it at the top at all times when scrolling down the calendar. This will be used for mobile devices, so I need to have the Responsive feature on. On a mobile calendar datapage, the events/records are displayed one by one and you scroll down to see the later dates. The top 'header' that displays the Month is sticky and scrolls with the page. I am trying to make it so my header is sticky as well.
  18. Thanks @IamNatoyThatLovesYou. I have some formulas in the blank cells that were causing the issue. I appreciate your help.
  19. On the Caspio HowTo article on Importing Data, they mention you can import an entire worksheet excel file. However, I am running in to a problem with importing an excel file that has multiple sheets. The first sheet goes through the import process just fine with all datatypes and columns matching up perfectly. However, the next sheets in the excel file do not bring the formatted datatypes. So, I am getting an 'Incompatible Data' warning because it shows that all of the data being imported is set to Text(255). I am sure I have these values formatted correctly in the Excel sheets, but they do no
  20. Here is a solution to this. You can put the values selected in the List String into a text field, that you can then use for a lot of features that List String was lacking.
  21. Correct! I was trying with either way. Every post on this forum I have been able to find about List Sting fields have said this is impossible, so I was trying with both ways. First I was trying with dropdown and couldn't get only one value to show up. Then when I tried the listbox I saw the label elements. I guess devtools was making it more confusing for me than it was. Your workflow is what I am trying to do - get the selected values of a list string into a text field so that they can be used in triggers/lookups and such. I am guessing the 'Type on this after making selections' field i
  22. $('[id^="InsertRecordJob_Type"]').change(function() { alert("hi"); $("#InsertRecordJobTypeString").val($(this).closest('div').find('label').text()); }); This one is successfully copying the labels into the text field. However, it is copying all of the labels from the list string box. Not sure how I can limit this to only options that are checked, but it seems I am getting closer. I am novice with jQuery and JS and learning about .closest() and .next(). The label elements are directly beneath the input elements. I believe I need to use .next(), but can't quite seem to get the value
  23. Still having trouble with this. When options are selected in a List String box, the values are shown comma delimited on the value box. I feel like I should be able to copy the contents of that to another text field on change. I believe the List Box actually is basically two elements - a select element with the options to choose from, and then an input element to store the values. The input element seems to be the one I need to target. The problem I am having is it is sending an integer value instead of the text value, which I am guessing is which index position each value is? Not sure. An
  • Create New...