Jump to content

guardmetrics

Members
 View Profile  See their activity

  • Content Count

    11

  • Joined

  • Last visited

Community Reputation

1 Neutral

See reputation activity

About guardmetrics

  • Rank
    Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. guardmetrics
    @Hastur @Vitalikssssssany ideas?
  2. guardmetrics
    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
  3. guardmetrics started following COUNT CASE statement in Formula field in table, Distance between 2 sets of coordinates Haversine Function, Display aggregate of total time as HH:MM and 2 others
  4. guardmetrics
    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;
  5. guardmetrics
    @HasturThanks so much! How do you make this work in the aggregate?
  6.    guardmetrics reacted to an answer to a question: Display aggregate of total time as HH:MM
  7. guardmetrics
    @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?
  8. guardmetrics
    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
  9. guardmetrics
    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!
  10.    Alison reacted to an answer to a question: Move submit button to right of field instead of below form
  11. guardmetrics
    Nevermind! I figured it out. Will post for reference for others: <style> .cbSearchButtonContainer { display: none !important; } </style>
  12. guardmetrics
    Thank you! How do I hide the container?
  13. guardmetrics
    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.
  14. guardmetrics
    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!!
×
×
  • Create New...