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 581
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