Hi. I am trying to build an app to record my watch's battery consumption. This contains 4 columns of the data: Key ID, Date, Recharge(a Yes/No data), Battery.
I like to enter the data daily; normally, there is only one entry each day. But when I have to recharge my watch, I need to input the [Current Battery](eg. 5%) and the [New Battery] (ie. 100%) after recharge. I would like to only input the [Current Battery]. Then a [New Battery] record could automatically be added to the app.
I tried to use Actions to achieve this feature. I chose:
[Effect: Data: add a new row to another table using values from this row]
[Set these columns] Key ID = Unqiueid(), Date = Today(), Recharge = No, Battery = 100%
[Position] Hide
[Behavior] Only if this condition is true: Recharge = Yes
And my trouble is, I cannot trigger this action when the Recharge = Yes. Am I misunderstanding the usage of [Action]? Or is there another method to achieve it?
Solved! Go to Solution.
Action take place based on some user driven event or when specifically invoked by the user.
So if you are using a form to set the column [Recharge]="Yes", you could have your action that you have described as a 'Form Save" event action.
Run actions based on view events - AppSheet Help
You need to include the action in the "Event Actions" Setting of the form view as the example screenshot shows below.
User | Count |
---|---|
18 | |
11 | |
11 | |
8 | |
4 |