Hi, I have created an action to add a value t...

(Nick Parsons) #1

Hi, I have created an action to add a value to a column.

The value needs to be my date column plus 7 days.

Therefore I have added this formula.

[Date Raised] + 7

It seems to work, however the result is incorrect.

The date returned from the original date of 13/08/2018 13:16 is exactly the same.13/08/2018 13:16 no change, no 7 days added?

Any ideas welcome…

Thinking about it, is this because the formula works at the same time the record is created, basically the same time the original date is set?

(Levent KULAÇOĞLU) #2

@Nick_Parsons1

If your column type in the app is DateTime, the expression should work really: [Date Raised] + 7

If your column type is Date then try with

DATE([Date Raised]) + 7

(Nick Parsons) #3

@Levent_KULACOGLU yes column type is DateTime?

I have also tried the formula you suggest and the same result applies?

No change to the date.

(Nick Parsons) #4

I have just noticed that what I am doing maybe wrong…My aim was to have a response date (Date raised)+7 days added automatically as a timestamp to my google sheet.

Instead, for this to work it requires me to press the action button?

Looks like I have misunderstood the use of the actions…

If this is the case, would I have to apply the time stamp within gsheets instead?

I would prefer it to be sent from appsheet but maybe thats not the best way…

(Levent KULAÇOĞLU) #5

@Nick_Parsons1 at what condition you want to parse that expression to the sheet from the app? Can you elaborate a bit more?

(Nick Parsons) #6

@Levent_KULACOGLU When a new record is submitted, and my column (severity) = 1 - Minimal Risk for example, a particular amount of time will be added to the date raised column to produce a response date (new column).

Basically, for each of my 5 severity levels there will be an amount of time suggested to respond to the concern.

A severity 1 for example may allow for a 7 day response.

Severity 3 may require a response within 3 days, Severity 5 will require an immediate response.

So, there will be two dates, date raised and response time.

Depending on the severity, an amount of days will be added to the date raised to produce the response time.

(Levent KULAÇOĞLU) #7

@Nick_Parsons1 you can set below AppFormula for your [Response Date] column:

=IFS( [Severity]=“1”,[Raised Date] + 7, [Severity]=“2”,[Raised Date] + 5, [Severity]=“3”,[Raised Date] + 3, [Severity]=“4”,[Raised Date] + 1, [Severity]=“5”,[Raised Date] )

(Nick Parsons) #8

@Levent_KULACOGLU I had to edit some of the context which has been accepted by appsheet, however the time is exactly the same still as the date raised?

=IFS([Severity]=“1 - Minimal Risk”,[Date Raised] + 7,[Severity]=“2 - Low Risk”,[Date Raised] + 5,[Severity]=“3 - Med Risk”,[Date Raised] + 3,[Severity]=“4 - High Risk”,[Date Raised] + 1,[Severity]=“5 - Highly Likely”,[Date Raised])

(Levent KULAÇOĞLU) #9

@Nick_Parsons1

If [Raised Date] value is 8/12/2018 14:30:00, for [Severity]=“1 - Minimal Risk”, the extension will yield to 8/19/2018 14:30:00

(Nick Parsons) #10

@Levent_KULACOGLU You are correct…I made a very simple mistake!!!

Works perfectly, I tried many different ways, not realising it can be done in the app formula!! thank you.