Cron Job To Update A Calculated Value

[clicknip]

I need to be able to search on an "age" field. To be current, the age field would be calculated using the birth date. How can I periodically update the age field? Can I use some kind of cron job to update the value?

 

(This is related to an earlier post, http://forums.caspio.com/index.php/topic/4039-working-with-calculated-age-from-date-of-birth/. Apparently I can't do what I need to do with a calculated field in a report.)

 

Thanks in advance!

[ShWolf]

Hi, Clicknip

 

As I can see in the Caspio Idea Box (http://ideabox.caspio.com/forums/164206-caspio-bridge/suggestions/2905340-calculated-field-to-be-stored-in-table), table-level calculations and formulas are in the road map for future releases. I think this feature is what you need.

 

Until this feature is released, the only way is to create new column in the table and insert age for each record (or you can do this in Excel via formula and then import this excel table to the Caspio)

[clicknip]

Thanks for you comment and the heads up, ShWolf.

 

Once I got the API setup working (a little tricky, since I'm not a hardcore developer), I was able to do the calculation and update the data that way. I would just need to have a regular cron job of some kind hit the php page. Here's what the code looks like, minus my account details. It follows the code style in the API documentation.

 

function updateAge()

{

global $wsdl,$AccountID,$ProfileName,$Password;

 

    try

    {

//init the SOAP Client

$SoapClient = new SoapClient($wsdl);

 

$affected=$SoapClient->UpdateData($AccountID, $ProfileName, $Password,

"BB_Model", false,

"Age",

"datediff(day,Birth_Date,getdate())/365");

}

catch (SoapFault $fault)

{

//SOAP fault handling

$str = "<h1><b>Fault:</b> faultcode: {$fault->faultcode}, <b>faultstring:</b> {$fault->faultstring}</h1>";

print($str);

}

}

[AtayBalunbalunan]

Hi clicknip,

Caspio Bridge has a new feature which is called Task and is somewhat equivalent to a CRON job. You can now create Tasks to enhance the level of automation in your applications. Tasks can modify data and send email or SMS notifications based on a predefined time schedule. With Tasks, your applications can run operations on a predetermined schedule and automatically do all the steps that you configured in them. You can find more information here. It is included in the release of Caspio Bridge 15.0 last October 16, 2018. 

I hope this information helps.

Cheers!