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
(thinking…)
Password icon
Signed in as (Sign out)
You have left! (?) (thinking…)
Alexandru Palade shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

1 comment

Sign in
(thinking…)
Password icon
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