Hello, Iโd like to do โReceive Dateโ and โApprove Dateโ when I receive and approve Goods.
Step of my app
I added โVirtual Columnโ for [Receive Date] = โToday()โ in โAPP FORMULAโ for Use in the real column to show on the system [Receive Date 1] but the Formatting of date is not appropriate in my country
so I used CONCATENATE and SWITCH Formatting of the date on [Receive Date 1] in โInitial valueโ
CONCATENATE(
DAY([Receive Date]),
" ",
SWITCH(MONTH([Receive Date]),โ1โ,โเธก.เธ.โ,โ2โ,โเธ.เธ.โ,โ3โ,โเธกเธต.เธ.โ,โ4โ,โเนเธก.เธข.โ,โ5โ,โเธ.เธ.โ,โ6โ,โเธกเธด.เธข.โ,โ7โ,โเธ.เธ.โ,โ8โ,โเธช.เธ.โ,โ9โ,โเธ.เธข.โ,โ10โ,โเธ.เธ.โ,โ11โ,โเธ.เธข.โ,โ12โ,โเธ.เธ.โ,0),
" ",
YEAR([Receive Date])+543,
" ",
TIMENOW()
)
Reset on Edit : [Status]=โReceiveโ
Virtual Column [Approve Date] = โToday()โ in โAPP FORMULAโ
[Receive Date 1] in โInitial valueโ
CONCATENATE(
DAY([Approve Date]),
" ",
SWITCH(MONTH([Approve Date]),โ1โ,โเธก.เธ.โ,โ2โ,โเธ.เธ.โ,โ3โ,โเธกเธต.เธ.โ,โ4โ,โเนเธก.เธข.โ,โ5โ,โเธ.เธ.โ,โ6โ,โเธกเธด.เธข.โ,โ7โ,โเธ.เธ.โ,โ8โ,โเธช.เธ.โ,โ9โ,โเธ.เธข.โ,โ10โ,โเธ.เธ.โ,โ11โ,โเธ.เธข.โ,โ12โ,โเธ.เธ.โ,0),
" ",
YEAR([Approve Date])+543,
" ",
TIMENOW()
)
Reset on Edit : [Status]=โApproveโ
But The result after I accepted data to approve. Appsheet reset both of Receive and Approve Date. Thatโs wrong.
Maybe Iโm wrong with Value in Virtual Column?
Cloud you tell me how to fix that, please?
Could you elaborate on any specific reason you are not using function TODAY() directly in the real column initial value expressions? One thing you may wish to try is you could use function TODAY() directly in the real column initial value expressions instead of using VCs.
Something like below
CONCATENATE(
DAY(TODAY()),
" ",
SWITCH(MONTH(TODAY()),โ1โ,โเธก.เธ.โ,โ2โ,โเธ.เธ.โ,โ3โ,โเธกเธต.เธ.โ,โ4โ,โเนเธก.เธข.โ,โ5โ,โเธ.เธ.โ,โ6โ,โเธกเธด.เธข.โ,โ7โ,โเธ.เธ.โ,โ8โ,โเธช.เธ.โ,โ9โ,โเธ.เธข.โ,โ10โ,โเธ.เธ.โ,โ11โ,โเธ.เธข.โ,โ12โ,โเธ.เธ.โ,0),
" ",
YEAR(TODAY())+543,
" ",
TIMENOW()
)
Thank you for you reply
I learnt from Youtube and they taught me to use VC to get date Today()
After that change format in the real column with CONCATENATE in initial
My propose is Change Formatting of Date on AppSheet and I would like to stamp data on google sheet as well.
Thank you. Could you try as suggested to use TODAY() function in real column?
Could I show you on my picture.
Have you explored using ChangeTimeStamp columns? I believe for such a requirement those will be more useful. You could have two ChangeTimestamp columns ( one each for Receive and Approve status) that change on those respective specific [Status] column values.
Thereafter you could have another two column to format those ChangeTimeStamp columns in the local date format you need.
Sample app as below
https://www.appsheet.com/samples/Keep-track-of-when-columns-change?appGuidString=8a1572da-c548-418c-...
Thank you for your kindness and helping me ^^
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |