Skip to main content
Question

Form time counter

  • March 7, 2017
  • 0 replies
  • 50 views
Hi

I would like to send a notification after 48 hours based on date created field in the form. At the same time i want to run some javascript code. is that possible ? 
Another requirement is, when a user change a value in a listbox and save the record, that time the counter needs to put on hold. Then the notification should not be sent.

The same counter should start again after the listbox field change to another value. Again notification should go when 48 hours is met.

Thanks
      This topic has been closed for replies.

      • MCFNeil
      • Registered
      • March 7, 2017
      Making these type of requirements is not a native solution.  And would need a bit of work around to get exactly what you are asking.  

      Can you describe your problem you are trying to solve?  This might present us with many different options or angles in which to solve the problem, and not solve the proposed solution.
      • MCFNeil
      • Registered
      • March 8, 2017
      One option to take care of the status changes and keep track of the time it is 'on the clock' would be to create a "Status Change" table.  

      You will use native API_AddRecord calls to make status updates, it will create a record, with a specific status.

      After the relationship is made you'd need to add a few summary fields to bring the most recent record ID, so when you later push the next "Status Change" button option, it will close out the old record with API_Edit then create another status via API_Add.

      There will be several summaries and lookups going back and forth to help total your time, but this will be the cleanest way to do it, and things can get updated with just ONE click, rather than several or relying on messy form rules to start and stop timers.
      • MCFNeil
      • Registered
      • March 13, 2017
      Did you guys get this sorted out in time for your client? 
      Terms & ConditionsAccessibility statement