Hi all, I was wondering how to achieve the ...

(吳承甫(Louis)) #1

Hi all,

I was wondering how to achieve the following:

column A(text) and B(date), how to work that when A be changed, than set

B date(TODAY)

Is there a way to achieve this?

Thanks in advance.

(Praveen Seshadri (AppSheet)) #2

if this is the only use of B, then the simplest way would be to make B a Change Timestamp column.

(Suvrutt Gurjar) #3

Hi @praveen, Sorry , I saw your post after posting my

comment that I was typing in, so did not realise you had already posted.

(吳承甫(Louis)) #4

@Suvrutt_Gurjar @praveen thanks you guys it’s worked!

(Suvrutt Gurjar) #5

Hi From

your description and my understanding, I request you to try following ,

  1. Please add another

Column

C with column type as “ChangeTimestamp”

and please set change column to “Column A”

in Column C’s definition. You can also hide this column C

2)Please insert expression =LEFT(TEXT([Column C]),10) in Column B

and please define column B as Text type.

When there is a change in Column A , you will see that Column B shows today’s date.

However,in this scheme, once the date has changed with first change for the day in Column A

, it will remain same till next day, in spite of any number of changes in Column A.

Hope this helps.