Hi
I'm new to app sheet and hoping someone can help.
I have a table that is used for basic stock counting. The user has access to a field to update the stock count. they then repeat this process for as many of the items they can (some might not need to be updated and there may not be time to do a complete check)
I would then like some sort of submit action that would write a "true" to a second file that only has one entry (the default case would be "false"). I would then use another application to periodically scan that file to see if the entry is "true" as that will initiate another set of functions
Any suggestions as to how I might do this or a better approach I'm a bit lost at the moment
Create an action of type Data: set the value of some columns in this row.
thanks for the reply.
can this be done for a spreadsheet that only has 1 entry e.g. A1 = "false"
And what is the best ui view?
@reelbigfish wrote:can this be done for a spreadsheet that only has 1 entry e.g. A1 = "false"
You can create an action for any table in your app.
@reelbigfish wrote:And what is the best ui view?
I don't know what you mean. Ideally, whichever view your users are already using.
@reelbigfish wrote:a better approach
There are certainly ways to accomplish the overall process that you describe wholly within an AppSheet app--i.e., not depend on "another application to periodically scan that file to see if the entry is "true" as that will initiate another set of functions"--as long as the "other set of functions" can be invoked from AppSheet, Apps Script, or another available integration.
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |