Change A Field When A Date Is Added

[james1234]

hello I am new to Caspio and really need a little help.

 

I need to have my field Response updated when a date is added or changed to the field ServiceDate. 

 

The Response should be "New Date", "Updated Date" or null (if the value was not changed).

 

ANy assistance would be greatly appreciated!!

[Jan]

Hello james1234,

 

Can I ask, whether  it is Update form or Details page of a Report?

[james1234]

I intend on having it in both an update form as well as a detail page

[Jan]

Hello James,

 

I think, you can add Header&Footer element and add the following code:

<SCRIPT LANGUAGE="JavaScript">
var beforeDate = document.getElementById("EditRecordmyDate").value;

function checkStart()
{
   var afterDate = document.getElementById("EditRecordmyDate").value;
   if (afterDate==beforeDate) { }
     else
       {
          var status_update = document.getElementById("EditRecordupdated").value;
          if (status_update == "") {status_update = "New Date"}
             else {if (status_update == "New Date") {status_update = "Updated Date"} }
         document.getElementById("EditRecordupdated").value = status_update;
       }
}   
document.getElementById("caspioform").onsubmit=checkStart;
</SCRIPT>

Please, enter names of your fields instead of "myDate" and "updated".

I tried with field with name "updated" that is Hidden and myDate that is text field.

 

I hope it helps.

[Kurumi]

You could try using Calculated value on it.  Caspio introduced new features which you can find here: https://howto.caspio.com/release-notes/caspio-bridge-17-0/

This release includes the Calculated Value form element to Update Forms and Details Pages to generate dynamic calculations as users interact with your forms. I hope this helps!

 

[cheonsa]

Hi @james1234,

Just to add from the previous comments above, you can also use Triggered Action. Triggered Actions allow data manipulation, calculations and sending notifications by constructing application logic with a visual interface. They will be executed on specified events to perform actions on data in your tables. Changes in one table can affect data in other tables.

Kindly check this link for more information: https://howto.caspio.com/tables-and-views/triggered-actions/

 

-kristina