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())
Solved! Go to 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.
Please report this on AppSheet Databases thread since this is a preview feature.
@madhukarb wrote:when i try updating data using formula
What exactly do you mean by this? An Action, an App Formula, something else?
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
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.
User | Count |
---|---|
35 | |
30 | |
30 | |
20 | |
18 |