Walter
Caspio Ninja-
Posts
38 -
Joined
-
Last visited
-
Days Won
2
Walter last won the day on March 30 2016
Walter had the most liked content!
Walter's Achievements
-
2 Questions About Authentication and Website Load
Walter replied to JoellaLoge's question in Security, Authentications, Roles, SAML
Hello JoellaLoge, As far as I know, in the body of the request should be the following text: grant_type=client_credentials&client_id=Client ID&client_secret=Client Secret You can see details in the article: https://howto.caspio.com/integration/web-services-api/rest-api/authenticating-rest/ When you say about maps, do you mean map mashup? -
Walter reacted to a post in a topic: How to have a url in a calculated field
-
peterhanse reacted to a post in a topic: Disable The Confirmation Popup By Deleting
-
Hello zalipresents, You cannot select more than one radio button, it's limit of the HTML code. But. You can change the size of your listbox. I've used the code to display all items in the listbox and do not display empty items: <SCRIPT LANGUAGE="JavaScript"> /* "fieldName" is the variable name for the listbox type form element field. */ var fieldName = "InsertRecordFIELDNAME"; var x=document.getElementsByName(fieldName); x[0].multiple=true; x[0].size=x[0].options.length; </SCRIPT>
-
Disable The Confirmation Popup By Deleting
Walter replied to peterhanse's topic in User JavaScript and CSS Discussions
Hello Peter, I have used a JavaScript that "confirmed" pop up. I know, it is not the best code, but it worked: <script type="text/javascript"> function to_confirm() { var alertWindow = document.getElementsByClassName("Alert")[0]; alertWindow.getElementsByTagName("input")[2].click(); } function to_delete() { document.getElementById("Mod0DeleteRecord").click(); setTimeout(to_confirm,1000); } if(document.getElementById("caspioform")) { setTimeout(to_delete,1000); } </script> You can change "1000" to "100", if your DataPage is fast enough. -
Hi Shelley, I have used the pre-defined DataPage to filter View with parameters. Does it work for you?
-
Hello, Welcome to the forum. Try disabling AJAX on the DataPage, it's "Results Page Options" screen, "Enable AJAX" checkbox. AJAX and JavaScript in the Footer work incorrectly.
-
Hi Heyjimi, On your Search page, select the field with dates, add New Criteria (the same was as you add Header&Footer elements or HTML Blocks), select "And" option in the "Logical operator between criteria". Now set the "Greater Than or Equal" comparison type for the Criteria 1 and "Less Than or Equal" for the Criteria 2. It should work. Or select "Dropdown" or "Listbox" Form Element and "Range" comparison type, if it works for you.
-
Hi Skauntey, If you send me the URL of your page, that is not assigned with any Authentication and does not use a Search page, I will send you the link to PDF for pdfcrowd. The PDF Generator generates a PDF version of tabular reports and it's a paid feature if your account is not Corporate. Probably, you better to contact your account manager for details.
-
Conditional Count Of Columns Sql
Walter replied to Elena's question in Calculations and aggregations
Hi, I have used an aggregation field and a formula like: (CASE WHEN SUM(one)>0 THEN 1 ELSE 0 END)+(CASE WHEN SUM(two)>0 THEN 1 ELSE 0 END)+(CASE WHEN SUM(three)>0 THEN 1 ELSE 0 END)+(CASE WHEN SUM(four)>0 THEN 1 ELSE 0 END)+(CASE WHEN SUM(five)>0 THEN 1 ELSE 0 END) I know, it's not a brilliant solution, but it works. -
Hi, I believe, the "Resource Scheduling" RMA does something like your goal: http://www.caspio.com/resource-scheduling/
- 7 replies
-
- calendar
- color code
-
(and 1 more)
Tagged with:
-
Hello Steve, It seems, it's the answer: http://forums.caspio.com/index.php/topic/5432-geo-coordinates-from-phone/#entry17099?
-
Hi Shelly, I believe, a pivot table report can help. The article about pivots: http://howto.caspio.com/datapages/reports/pivot-table/ Also you can use your Users table as the DataSource, then all users will be displayed only once.
-
Image Link Displayed Depending On Field Value
Walter replied to Hearnie's question in Styles and Localizations
Hi Steve, I've created an HTML Block, added a section before and a section after this Block, and then used the Rule: if the checkbox is not checked, hide the section with the HTML Block. The article about rules: http://howto.caspio.com/datapages/forms/conditional-forms/ -
Hello Hearnie, I believe, this article can help.
-
Hello bwe, If you clear a style assigned with a DataPage, then embed the DataPage to your index.HTML, styles of your site will be applied to the DataPage. How to embed a DatPage is written in the article, it's embed Deployment method. I believe, you can find instructions in the video too. But I'm not sure that I understand your question correctly.
-
Calculation In Submission Form
Walter replied to Parma2015's topic in User JavaScript and CSS Discussions
Hi Jan, Have you alerted every value? I mean, <SCRIPT LANGUAGE="JavaScript"> function calcHours() { var startH = document.getElementById("InsertRecordStartHr").value; alert(startH); var startM = document.getElementById("InsertRecordStartMin").value; alert(startM); var lunchM = document.getElementById("InsertRecordLunch").value; alert(lunchM); var stopH = document.getElementById("InsertRecordStopHr").value; alert(stopH); var stopM = document.getElementById("InsertRecordStopMin").value; alert(stopM); var hrs = (stopH-startH)- (lunchM/60) + (stopM-startM)/60; alert(hrs); document.getElementById("InsertRecordHours").value= hrs; } document.getElementById("caspioform").onchange=calcHours; </SCRIPT> It seems, you get "NA" on one of steps.