Quick Edit doesn't allow to edit columns type data Time, any solution?

Hi all, tried to use the Quick Edit table feature but there is something wrong in that features. After entry data and then i quick edit again, column with type data Time (column Time Actual) reset again to 00:00. But if I saved again, the value return to the same data as before. Is there a way to fix this issue? Please advise me.
Pls see the below screenshot before and after saved for your reference and consideration:

1. Before i edit (using quick edit)

as.png

 

 


2. When i quick edit is on

asd.png

 

 

3.  When i saved again, the value is return to 00:00, though value data in google sheet is still no change.

asdf.png

 

 

4. Database from google sheet

asdfg.png

 

 

5. Column Time Actual
asw.png


 

 

 

 

 

 

Solved Solved
0 3 76
1 ACCEPTED SOLUTION

Then check your gSheet so that column's type is correct.

View solution in original post

3 REPLIES 3

Few things to check.. is the "Reset on edit" set as ON? Is the column type set properly in your gSheet?

Yes sir "Reset on edit" i set as OFF. 

asq.png

Then check your gSheet so that column's type is correct.

Top Labels in this Space