About kevin_merakjing

kevin_merakjing · 05-25-2021

From the example in Date and Time Expressions : Examples that compute duration in days, months and years help.appsheet.com Date and Time Expressions Incorporate dates and times into the behavior of your app. FLOOR(((HOUR([EndDate] - [StartDate])) - (...

kevin_merakjing · 05-15-2021

What is the difference between Linktoform vs Action : copy this row and edit the copy? Correct me if I’m wrong, I found that : We can choose which column we want to copy to the new row using Linktoform, while “Action : copy this row and edit the copy...

kevin_merakjing · 03-29-2021

Hi, I have a table with description as below : Table name : Transaction Table Fields : Trx Date ; Transaction ; Verification Date There are several Transactions with the same Trx Date. I would like to have such action automatically : when the Verific...

kevin_merakjing · 03-16-2021

Hi All, Need your help. I have a table with columns : Transaction date [Trx date] type date Verification date [Verification date] type datetime Verified by [Verified by] type useremail Supposing : Transaction date can be input from the range of the l...

kevin_merakjing · 03-07-2021

Hello I’m just starting to create apps using Appsheet. I have : [Column 1] using Enum type with 2 fixed values (Value 1 and Value 2) and other values are allowed to be added by users. [Column 2] Yes / No type. For Value 1 in [Column 1] should always ...

kevin_merakjing · 05-25-2021

I need to compute the number of days between the startdate and the enddate. (how many days between two dates input in apps aka the duration of using a spare part) At first, I was wrongly using an expression : DAY([EndDate]) - DAY([StartDate]) , retur...

kevin_merakjing · 03-19-2021

One thing that I forgot to write it in my first post. I can input the verification date manually via Edit. Is there any bugs with the Action?

kevin_merakjing · 03-19-2021

Lynn: Hi @kevin_merakjingga Is the use of both date time and date columns causing the problems? @Steve Hi @Lynn , I don’t think so, because I have added date() to pick up only the date value of the datetime.

kevin_merakjing · 03-17-2021

Steve: The problem is with this expression. The column value is only valid if [Trx date] is now or in the past AND [Trx date] is strictly greater than EVERY Trx date value of existing rows that have a Verification date . The purpose of this expressio...

kevin_merakjing · 03-17-2021

kevin_merakjingga: Thanks, Steve. I have tried [Verification Date]>=[Trx date], still the same error message. Thanks, Steve. I have tried [Verification Date]>=[Trx date], still the same error message.

My Stats

Marcin_Milewski's Bio

Badges kevin_merakjing Earned

Recent Activity

Compute duration in days

Linktoform vs Action : copy this row and edit the copy

Automatically update field of several rows based on input from another row in the same table workflow

Action : set the value of some columns in this row, but error encountered from other column

How to autofill yes for one specifically option in dropdown menu of other column, but for other options users can choose either yes or no

Re: Compute duration in days

Re: Action : set the value of some columns in this row, but error encountered from other column

Re: Action : set the value of some columns in this row, but error encountered from other column

Re: Action : set the value of some columns in this row, but error encountered from other column

Re: Action : set the value of some columns in this row, but error encountered from other column