Jump to content


Caspio Ninja
  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by peterhanse

  1. Good morning , I have a Pivot Table Report . I'm looking for a solution to replace the "13". For the count of all records with kostentest_cat = 1 (that are 13 records). can someone help. CASE WHEN [@field:kostentest_cat] = 1 THEN [@field:kostentest_hoeveelheid]-([@voorraad_ruw]/13) ELSE [@field:kostentest_hoeveelheid] END regards Peter .
  2. already solved: <script> var myTotalcont = parseFloat(myCells[column_number].innerHTML); if (myTotalcont>="[@field:GEBRUIKERS_Aantal_paarden]") { window.location = "[@app:Overzicht_paarden_klanten_accounts]?cont="+myTotalcont; } </script>
  3. <input id="klant" class="cbSubmitButton" type="button" value="klant" name="klant" onClick="window.location.href='[@app:your app page]'"> maybe this will help , regards peter
  4. HI, I want to use a var. (variable) as a parameter value. Something like this: <script> var myTotalcont = parseFloat(myCells[column_number].innerHTML); if (myTotalcont>="[@field:GEBRUIKERS_Aantal_paarden]") { window.location = "[@app:Overzicht_paarden_klanten_accounts]?cont=myTotalcont"; } </script> How to work a round. in the window.location.
  5. I have a Single Record Update data page, whit a autosubmit. Depending on the value I want the destination after record update to a specific page. Something like this. <script> var machtiging = "[@authfield:GEBRUIKERS_Machtiging]"; if(machtiging=="Yes") if(document.getElementById("caspioform")) { document.getElementById("caspioform").style.display = 'none'; setTimeout('document.forms["caspioform"].submit()',1000); window.location="[@app:logout]"; } else if(document.getElementById("caspioform")) { document.getElementById("caspioform").style.display = 'none'; setTimeout('document.forms["caspioform"].submit()',1000); } window.location="[@app:horseplanner_home]"; } </script> This is not good ,i now. but for the idea. does anyone have an idea
  6. A little bit late but I workaround as follow: Styles> go to your Style> Edit> tab: Source >User-defined Styles> insert this code in : #CalendarToolBox { z-index: 1000 !important; left: 10px!important; top: 256px; width: 300px!important; height: 300px!important; } #CalendarToolBox .BodyTable tr { height: 35px!important; } The calendar is now larger . works for me. thanks everyone.
  7. I would like in the "Destination after record submit:" something like this: function goBack() { window.history.back() }
  8. hi jaymont yes then i go back to the same data page. but i want back to the data page where link is for this submit form .
  9. hi roattw move the field glucose and the section between hospital and age and insert a second section below glucose . now the field glucose between the two sections wil be hide
  10. Hi I have a submit form that I use on several pages, Now i want as "Destination after record submit:" , Go Back. how kan fix that. Because it is not always the same page.
  11. hi ,aam82, Thanks for your answer , but this is too complicated for me . I think I 'm going to fix it just with a submit button. Thank you, P.s. Do they know at Caspio that all the " link" texts are not visible in this forum, just as you mouse over role.
  12. Hi Is there a way to make a "Create Date-Specific New Record Links in Calendar DataPages" if we use the wordpress deploy methode. I tried this code below but it only works in the preview. <script> var month = ""; var allSpanTags = document.getElementsByTagName("span"); for (i=0; i<allSpanTags.length; i++) { if (allSpanTags[i].className == "cbResultSetCalendarCaption"){ month = allSpanTags[i].innerHTML; } } month = month.replace(/January /gi,"1/Day/"); month = month.replace(/February /gi,"2/Day/"); month = month.replace(/March /gi,"3/Day/"); month = month.replace(/April /gi,"4/Day/"); month = month.replace(/May /gi,"5/Day/"); month = month.replace(/June /gi,"6/Day/"); month = month.replace(/July /gi,"7/Day/"); month = month.replace(/augustus /gi,"8/Day/"); month = month.replace(/September /gi,"9/Day/"); month = month.replace(/October /gi,"10/Day/"); month = month.replace(/November /gi,"11/Day/"); month = month.replace(/December /gi,"12/Day/"); var allHTMLTags = new Array(); //Create Array of All HTML Tags var allHTMLTags = document.getElementsByTagName("div"); //Loop through all tags using a for loop for (i=0; i<allHTMLTags.length; i++) { //Get all tags with the specified class name. if (allHTMLTags[i].className == "cbResultSetCalendarField") { var transfer = month.replace(/Day/gi,allHTMLTags[i].innerHTML); /*Begin Add New Link Section*/ allHTMLTags[i].innerHTML = allHTMLTags[i].innerHTML +'<br><a style="text-decoration:none;" href="https://horseplanner.nl/app/apl140/?datum='+transfer+'">Add New</a>'; /*End of Add New Link Section*/ } } </script>
  13. I have workt it around whit: CASE WHEN (Datediff(Day,'[@field:begin_date_item]','[@beginyear]')) < 0 THEN '[@field:begin_date_item]' ELSE '[@beginyear]' END
  14. I have chance the localization to english (us) so all date are now the same and format are al the same, is it possible that there is a issue that the the date from the tabels and from the popup calendar not the same notation have . Because when i have my app localization on Dutch. the date's are different. But that now solved for the time being with chance the localization to english (us). The scrip is still not working, despite the fact that the parameters are now well , and the date is the same note
  15. It's strange when i test whit Datediff everything works correct, so the parameters are correct.
  16. I have a tabular report with search page . In the search page, I send a parameter with a start date on which I seek ( [ @beginyear ] ) to the resulting page . In the Calculated Field in the resultpage i like to have: search date ( [ @ beginning year ] = 1-1-2016 Record: Start date item item [ @field : begin_date_item ] = 5-5-2016 result: Calculated Field = 5-5-2016 [@field: begin_date_item ] Or Record: Start date item item [@field: begin_date_item ] = 12-4-2015 result: Calculted Field = 1-1-2016 ( [ @ beginning year ] Unfortunately, this does not works. It seems that the parameter of the search page is not working with the proper date format , somebody ideas CASE WHEN [@field:begin_date_item]<[@beginyear] THEN [@beginyear] ELSE [@field:begin_date_item] END
  17. Hi all, I have a detail update page in tabular report , I would uncheck the checkbox when a date field is not empty. I 've been trying the script below but it does not work . what am I doing wrong <script> document.getElementById('Mod0EditRecord').onmouseover = function(){ if (document.getElementById("EditRecordSTALLING_eind_stalling_datum").value =="") { document.getElementById('EditRecordSTALLING_actief').checked = true; } else { document.getElementById('EditRecordSTALLING_actief').checked = false; } </script>
  18. I have test it but only the submit type works , I have solved it now whit a menu link.
  19. Hi Daniel Why do you not make applicatie in Caspio and deploy it in your wp_site . http://howto.caspio.com/deployment/deploying-into-wordpress/
  20. Tanks MayMusic, This has become the solution <script> var pksoork='[@field:PAARD_KOPPELINGEN_soort_koppeling]'; var gbrvnaam='[@field:GEBRUIKERS_volledige_naam]'; var pkusid='[@field:PAARD_KOPPELINGEN_user_id_koppeling]'; var userid='[@authfield:GEBRUIKERS_user_id]'; var peid='[@field:PAARDEN_eigenaar_id]'; var sgstnaam='[@field:STAL_GEGEVENS_stalnaam]'; if(pksoork==1) { document.write('<IMG SRC="https://horseplanner.nl/wp-content/uploads/2016/06/paard-icon.png" ALT="logboek" WIDTH="30" HEIGHT="24" ALIGN="center"></A><br />[@field:GEBRUIKERS_volledige_naam]'); } else if(pksoork==2&&pkusid==userid) { document.write('<IMG SRC="https://horseplanner.nl/wp-content/uploads/2016/06/stal-icon-e1466102511312.png" ALT="logboek" WIDTH="30" HEIGHT="24" ALIGN="center"></A><br />[@field:GEBRUIKERS_volledige_naam]'); } else if(pksoork==3&&peid==userid) { document.write('<IMG SRC="https://horseplanner.nl/wp-content/uploads/2016/06/ruiter_icon.png" ALT="logboek" WIDTH="30" HEIGHT="24" ALIGN="center"></A><br />'); } else { document.write('<IMG SRC="https://horseplanner.nl/wp-content/uploads/2016/06/stalmedewerker-icon-e1466255481754.png" ALT="logboek" WIDTH="40" HEIGHT="24" ALIGN="center"></A><br />[@field:STAL_GEGEVENS_stalnaam]'); } </script>
  21. Thank you kRv, it works perfectly , I use the data page only 1 time a user to " Transfer" the account to the new user . That's what I meant by I do not want to use a "Require current password validation" .because the user does not know the current password. And if you use "Require current password validation" the fields new and confirm password are blank but you have to know the old password. regards, peter
  22. I have a single record update data page . (See example) The user must change his password here . My problem is that automatically already ******** appears in the fields . ( By creating in the submitForm I do not use the password field , so the password field is blank !! or not?? ) . And I don't want to use a " Require current password validation" . Is there a way to clear the new password field and Confirmation password field in the single record update data page. If do that manually it works fine . the way how it is now. as it should be:
  23. Hi MayMusic I had something like this, but I 'm probably not quite through the logic of the buttons . . And if I put this in the footer , the buttons come below the delete button instead of next to it. <input id="Mod0CancelRecord" class="Mod0CancelRecord" type="button" onmouseout="cbButtonHover(this,'Mod0CancelRecord');" onmouseover="cbButtonHover(this,'Mod0CancelRecord');" value="Back" name="Mod0CancelRecord" onClick="window.location.href='[@app:logboekmenu]
  • Create New...