
guardmetrics
Members-
Content Count
12 -
Joined
-
Last visited
About guardmetrics
-
Rank
Member
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
Passing field values with ampersand (&) over query String
guardmetrics replied to TroubleShooter's question in Parameters
How would this be done in a link from a details page? -
Still struggling with this, here is where I am now: <script type="text/javascript"> document.addEventListener('DataPageReady', function (event) { var lat1 = document.getElementById("InsertRecordLat").value; var lon1 = document.getElementById("InsertRecordLng").value; var lat2 = document.getElementsByName("cbParamVirtual6”)[0].value; var lon2 = document.getElementsByName("cbParamVirtual7”)[0].value; var R = 6371; // km var dLat = (lat2-lat1)*Math.PI/180; var dLon = (lon2-lon1)*Math.PI/180; var a = Math.sin(dLat/2) * Math.sin(dLat/2) + Math.cos(lat1*Math.PI/180) * M
-
Does anyone have a Haversine Function that works? I'm having trouble, and this is where i'm at: <script type="text/javascript"> document.addEventListener('BeforeFormSubmit', function(event) { function f_Haversine_Roving(){ var lat1 = document.getElementById("InsertRecordLat").value; var lon1 = document.getElementById("InsertRecordLng").value; var lat2 = document.getElementsByName("cbParamVirtual6”)[0].value; var lon2 = document.getElementsByName("cbParamVirtual7”)[0].value; var R = 6371; // km var dLat = (lat2-lat1)*Math.PI/180; var dLon = (lon2-lon1)*Math.PI/180;
-
Display aggregate of total time as HH:MM
guardmetrics replied to guardmetrics's question in Calculations and aggregations
@HasturThanks so much! How do you make this work in the aggregate?- 4 replies
-
- aggregate
- totals aggregation groups
- (and 6 more)
-
guardmetrics reacted to an answer to a question: Display aggregate of total time as HH:MM
-
Display aggregate of total time as HH:MM
guardmetrics replied to guardmetrics's question in Calculations and aggregations
@Hastur This is working great. The only thing is that it is showing time like this " 8:0" instead of "8:00". Any idea on how to get it to show 2 digits to the right of the colon?- 4 replies
-
- aggregate
- totals aggregation groups
- (and 6 more)
-
Display aggregate of total time as HH:MM
guardmetrics posted a question in Calculations and aggregations
I have a table which includes a timestamp and a type field (among others) I've created triggers and a view that combines this table into itself and displays a clock-in time, clock-out time, and a total time difference between them in HH:MM format. The formula in the calculated field is below: CONVERT(varchar(5), DATEADD(minute, DATEDIFF(minute, [@field:Patrol_Activity_Database_Date], [@field:Patrol_Activity_Database_1_Date]), 0), 114) My issue is that I need to have a total/aggregate for this field, but it gives an invalid error if I just do sum, and I've been unable to figure out- 4 replies
-
- aggregate
- totals aggregation groups
- (and 6 more)
-
Caspio Authentication as an ID service
guardmetrics posted a question in Security, Authentications, Roles, SAML
I'm working on a mobile app that will be using APIs to submit data into Caspio. My main obstacle is authentication. I have found the article regarding "Caspio Authentication as an ID service", my question is regarding this is the solution to allowing my native app Authenticate with Caspio as the authentication source. Any thoughts/experience/etc. appreciated! -
Alison reacted to an answer to a question: Move submit button to right of field instead of below form
-
Move submit button to right of field instead of below form
guardmetrics replied to guardmetrics's question in Styles and Localizations
Nevermind! I figured it out. Will post for reference for others: <style> .cbSearchButtonContainer { display: none !important; } </style> -
Move submit button to right of field instead of below form
guardmetrics replied to guardmetrics's question in Styles and Localizations
Thank you! How do I hide the container? -
I am using a search field that is above the results, and the button being below the form takes up precious vertical space on the page. It would look SO much better having the button to the right of the search field. I've included a screenshot showing where button is, and where I'd like it to be. I've got the button in the form on the right by putting the button code in an HTML block, but if I hide the submit button it hides both.
-
COUNT CASE statement in Formula field in table
guardmetrics posted a question in Tables, Views and Relationships
I'm working on putting a formula field in my table that will count all records in a separate view. (i.e. Subscribed Users = # of records in a filtered view If someone could point me in the right direction for this CASE statement, that would be amazing!!