How to access and use TrackVia's API or Application Scripts?

Finding records within a certain time interval

Is there a way to find records in a table via scripting that have a date column value greater than a value (as opposed to just equal to it as the method seems to work now)?

1 vote
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Alexandru Palade shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Alex commented  ·   ·  Flag as inappropriate

        Hi Alexandru,

        Depending on the use case, you can find records in a given interval using a filter or even a calculation. App scripting may not be the best use case as they only run when records are edited and not based on the passage of time as where a filter or calculated field will.

        For example, the filter would look at the date as After or Equal to AND Before or Equal to...the date field. A Calculation would look something like this:

        if( and( {Date} > "YYYY-DD-MM" , {Date} < "YYYY-DD-MM",1,0) You can then filter the records where "1" is present to see the records within the given time frame. You can hard code in a date, "YYYY-DD-MM", or insert a different date field from your table.

        Hope this helps.

        Regards,

        Alex

      Feedback and Knowledge Base