peterhanse
Caspio Ninja-
Posts
62 -
Joined
-
Last visited
-
Days Won
2
peterhanse last won the day on November 26 2016
peterhanse had the most liked content!
Recent Profile Visitors
peterhanse's Achievements
-
TWIRED reacted to a post in a topic: Create a button to go to another Datapage
-
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 .
- 1 reply
-
- calculation
- pivot table
-
(and 1 more)
Tagged with:
-
peterhanse reacted to a post in a topic: Create a button to go to another Datapage
-
var as parameter value in a string
peterhanse replied to peterhanse's topic in User JavaScript and CSS Discussions
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> -
Create a button to go to another Datapage
peterhanse replied to satch's topic in User JavaScript and CSS Discussions
<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 -
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.
-
peterhanse reacted to a post in a topic: autosubmit destination after record update to a specific page ,depending on a value
-
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
-
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.
-
Destination after record submit: Go Back
peterhanse replied to peterhanse's topic in User JavaScript and CSS Discussions
I would like in the "Destination after record submit:" something like this: function goBack() { window.history.back() } -
Destination after record submit: Go Back
peterhanse replied to peterhanse's topic in User JavaScript and CSS Discussions
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 . -
roattw reacted to an answer to a question: Define several actions / rules for the same field - issue
-
Define several actions / rules for the same field - issue
peterhanse replied to roattw's question in DataPages
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 -
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>
-
peterhanse reacted to an answer to a question: parameter (date) from searchpage to result page
-
parameter (date) from searchpage to result page
peterhanse replied to peterhanse's question in Parameters
I have workt it around whit: CASE WHEN (Datediff(Day,'[@field:begin_date_item]','[@beginyear]')) < 0 THEN '[@field:begin_date_item]' ELSE '[@beginyear]' END -
parameter (date) from searchpage to result page
peterhanse replied to peterhanse's question in Parameters
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