ChangeTimeStamp watching date column?

[anonymous]

Hi.
I have a ChangeTimeStamp column (not virtual) that watches a list of columns in my main table, and assigns a DateTime upon changes.

This then takes a slice where users have not updated an entry in more than 30 days and flags for their update.
If the information in this row entry is still valid, the user won’t have to update the fields, but can confirm all fields are up to date, so I added an action which I was hoping would update the ChangeTimeStamp to now(). But, my understanding is you can’t override this formula with an action update??

As a workaround, I added a Date column [Last verified] where the same action records the date the user last verified the data was correct in that row.

I went to link the ChangeTimeStamp column to watch for changes in the [Last verified] column, but don’t see the column available in the dropdown options, assuming it can’t watch a date field?

Any suggestions would be really appreciated.
Thanks

[Suvrutt_Gurjar]

Could you try with having that final action that conforms “all fields are up to date” can update a number type column with initial value as 0 and action to update this very number column from 0 to 1.

This number column in turn could be watched by the original ChangeTimeStamp column that is watching other columns so that the ChangeTime Stamp column updates with the latest timestamp?

Edit: Minor change in description

[anonymous]

Hey @Suvrutt_Gurjar.
Been able to do all that up to the point where I want to add the column to the watch list for the ChangeTimeStamp.

The column does not appear in the dropdown list.

[Suvrutt_Gurjar]

Hi @Colin_Lough,

Could you please share how you have implemented it? I of course tested it before sharing. I will share screenshots of the configuration if it helps.

[anonymous]

1. Added number column, intial value as 0.

   

2. Have action that when clicked updates [last verified] column to 1.

   

3. Go to add [last verified] column to watchlist, but not available

   

[Suvrutt_Gurjar]

Thank you.

I am afraid, your action configuration is incorrect. I am unable to know from the screenshots why you cannot see the column in change timestamp change column list.

Ok, I will share my configuration. Hope that helps.

Table where number and Changetimestamp Columns are there

Number column configuration associated with “All is well” action

ChangeTimestamp Column configuration that includes number column to track as well

“All is Well” action settings ( Same as “I confirm NLO Info is uptodate” you have named)

Detail view containing action

**

**

Table backend view with timestamp updated when action is invoked

[anonymous]

Thanks, I updated my action to be [last verified]+1.

I even added a new column to my data set, regenerated the column structure, and that is not being picked up under the dropdown options

[Suvrutt_Gurjar]

Could you please share the screenshots of the table where you have added that column and timestamp column?

Equivalent to my first 3 screenshots?

Could you please add which dropdowns you are trying as well?

[anonymous]

I did not have ‘Show’ selected for the [last verified] column therefore it wasn’t populating the available columns to pick from.
This has now fixed it.
Is there a reason as to why this must be shown @Suvrutt_Gurjar?

Thank you for your help.

[Suvrutt_Gurjar]

Thank you @Colin_Lough for the update.

Great to know the solution works per your requirement.

As for show_if column constraint, I believe it is set to on by default. I tested it on a new test column by adding it just now. It sounds that while setting other settings of the column, it could have inadvertently got set to off in your case.