Formula not working while using Appsheet Data base

[madhukarb]

I am trying to build app using https://www.appsheet.com/dbs/database/ as backend, however when i try updating data using formula it works fine with google sheet but not with dbs. 

Below is the formula is using to update approved data, but it does not work

IF(([Approved by Reporting Manager]<> ""), "", Today())

[SkrOYC]

Please report this on AppSheet Databases thread since this is a preview feature.

Introducing new AppSheet database feature in publi... - Google Cloud Community

[Marc_Dillon]

---

@madhukarb wrote:

when i try updating data using formula

---

What exactly do you mean by this? An Action, an App Formula, something else?

[madhukarb]

Hi Dillon

I am in process of building an for our team where we collect ideas from diffrent teams , if any one submits an idea it has to be approved by their reporting manager so that we can further take action.

https://screenshot.googleplex.com/6EzRXPC8X2oGTiC

I have 2 columns "Approved by Reporting Manager" and "Approved Date". I used this formula in data tab "IF(([Approved by Reporting Manager]<> ""), "", Today())" as shown in the below screen shot so that once a manager approves or reject the idea the date will auto capture in "Approved Date" column. It work well while used google sheet , however it not working on database.

https://screenshot.googleplex.com/9EJn46xGzPbcGHd

https://screenshot.googleplex.com/BJwFqjiwZ2JaTnS

[Marc_Dillon · Accepted solution]

Your screenshots require login, so I can't see them.

I would not use a formula in such a case. I would create an "Approve" action that sets both the [Approved by...] column as well as the [Approved Date] column.