Triggered Actions on Timestamp field

[MyNameIsSean]

I am loving the new triggered actions feature, but I have the following issue:

 

I have a parent table containing 2 timestamp fields, one for the creation and one for the update.

 

I am trying to create a triggered action that inserts a new record in the child table, for each update in the parent table.

 

In the child table, the field that is created to keep the creation and update dates are set as date/time.

 

I followed the video tutorial, and encountered error "2088: Mismatched data types." on the above mentioned fields.

 

I tried changing the field type in the child table to "Text" but it didn't work. 

 

Changing the triggered action data field to timestamp only timestamped the date and time the action was triggered.

 

Here is a screenshot of the trigger, if it helps:

 

 

Does anyone know a fix for this?

[Vitalikssssss]

Hi MyNameIsSean,

 

That is very odd behavior which I believe will be resolved in an upcoming Caspio Bridge release.

In the interim, you can try to build the Triggered action as per below as a temporary workaround.

Hope this helps.

[MyNameIsSean]

Hi Vitalikssssss

 

Thanks for your workaround solution to this issue. I hope this bug will be fixed soon.

Cheers

[Vitalikssssss]

Hi MyNameIsSean,

It looks like the issue has been fixed.

I have been able to create a Trigger which inserts the Timestamp value from parent table into Date&Time field.

 

Regards,

vitalikssssss

[MyNameIsSean]

Hi Vitalikssssss,

 

Thanks for the update! You have been most helpful

 

Cheers

[RuisiHansamu]

Hi there, I believe this would be helpful for guidelines and steps https://howto.caspio.com/tech-tips-and-articles/common-customizations/stamp-the-time-url-or-ip-address-to-new-and-updated-records/ and