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

(Etwo Cargo) #1

Dear team,

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

(Aleksi Alkio) #2

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

(Etwo Cargo) #3

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

(Etwo Cargo) #4

App name is e2FOPS Account IS is 266065

(Aleksi Alkio) #5

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

(Etwo Cargo) #6

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) #7

Any news?

(Aleksi Alkio) #8

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

(Aleksi Alkio) #9

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

(Etwo Cargo) #10

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

(Aleksi Alkio) #11

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) #12

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) #13


column is ATA by the way

(Aleksi Alkio) #14

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) #15

Not a problem. You are the best, i am the new :slight_smile: 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) #16

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