How To Update A Database Field With The Results From A Calculated Field.

[wvantongeren]

I'm checking ID's an expiration days.

 

In the calculated field I have this (and works perfecly):

 

Datediff(day,GetUTCDate() ,[@field:Expiratiedatum])

 

The results are: left days to expire the ID.

 

Now I want to automaticly update the database field "Days_Left" with the results from the calulated field, is that possible? 

[MayMusic]

If this calculated field is in details page you can make the field hidden and receive the calculated value as parameter. upon update value will get to the table.

[cheonsa]

Hello, 

You can create an Application Tasks to automatically update the Table and run it everyday. 

Tasks are operations that you can create in your application and run them manually or automatically based on a predefined schedule. They can be very useful for automating repetitive actions, like data modifications or sending email and SMS notifications.

 

Check this link for more details: https://howto.caspio.com/tasks/

[cheonsa]

Here's the sample Tasks that you can create

This will update every record in the Table and it will run every day.

 

As best practice, you can try this first in a Test Table or have a back up of your Tables.