Know if adding or updating record

I want to know if exist any way to know if iโ€™m adding or updating a record.
I need it to control when a column value must to be saved.

Thanks

0 3 587
3 REPLIES 3

You could do that for example with IN([KeyColumn],TableName[KeyColumn])

Thanks Aleksi but donโ€™t see how i can do it

I explain my problem

I have two colums in a table TIME IN and TIME OUT
When the user creates the record the time in is with formula TIMENOW()
When the user enter to edit the record , how can i do for save Time out colum with TIMENOW() , but not changing Time In column

Maybe i need to do it with with an Action

Thanks and regards

When you create that record, use TIMENOW() as an initial value for the TIME IN field. Then it wonโ€™t change if you open that record. I would probably create an action for the TIME OUT so you would not need to open that record.

Top Labels in this Space