Dear team, How can i have a button which wil...

[Etwo_Cargo]

Dear team,

How can i have a button which will change time stamp after press on it?

[Aleksi_Alkio]

Do you need to do it only once when you add a new entry or later when modifying it?

[Etwo_Cargo]

Dear Alikio I need it when want to modify records. Thanks for your support.

[Etwo_Cargo]

App name is e2FOPS Account IS is 266065

[Aleksi_Alkio]

What column should be that “button” column? And to where should you write the DateTime value?

[Etwo_Cargo]

There will be 3 column which will have time info. user will press first on Ata, then Cls and final PushBack. Ata means arrival, Cls is close and PushBack will be moving time after operation done. I do not want to have regular time entering process. Buttons will be much useful. Am i right? I need only Time for now. Maybe Date column can bee as button as well.

[Etwo_Cargo]

Any news?

[Aleksi_Alkio]

You can find a sample from appsheet.com - - portfolio of mobile apps created with AppSheet - portfolio of mobile apps created with AppSheet appsheet.com

[Aleksi_Alkio]

One option is an action button (set a value of a column) with an expression NOW(). Is this possible for you?

[Etwo_Cargo]

Thats great. What if i want to use when entry new data?

[Aleksi_Alkio]

Then you could add an enum button “Read Datetime” and if you add an expression like IFS(ISNOTBLANK([Read DateTime]),NOW()) into the initial value, it will read the value when you press the button.

[Etwo_Cargo]

Dear Aleksi, Sorry but i am new on that. Got an error as shown down below.

Column Name ‘Ata’ in Schema ‘e2FOPS_Schema’ of Column Type ‘Enum’ has an invalid ‘Initial Value’ of ‘=IFS(ISNOTBLANK([ATA]),TIMENOW())’. The type of the Initial Value does not match the column type. Consider using ‘’ instead.MORE INFOGO TO THE PROBLEM

[Etwo_Cargo]

My

column is ATA by the way

[Aleksi_Alkio]

Sorry… I explained it badly. The Enum column is just an button, nothing more. The other column is a DateTime and you should add that formula there.

[Etwo_Cargo]

Not a problem. You are the best, i am the new I found my mistake. Now is ok. But i am getting another error after press save button. There need to be 3 time stamp after press on them. System shows as “invalid date” and there is no any record in my spreadsheet. Sync is not working because of this error. What i need to do? # it is one small operational app.

[Aleksi_Alkio]

What is the app name and your account ID. Easier to check than guessing