Hello AppSheet Community,
I have now a bigger project going on.
And Iโm struggeling with a kind of log / history book I wanna create.
What I want is that I have a task with different โStatusโ like New, Accepted, On hold, Finished, etc.
Everytime someone changes this Status I want the App to write a Row into a referenced table with the chosen State, Time and User who did this.
So that everytime I can go into the task and see whatโs the history of this task.
Is this possible to create in AppSheet?
Thanks in advance. Adrian
Yes, itโs just sightly complex. The way I handle it is to basically write an entire new record every timeโฆ But I have a security filter that only take every records newest time. So I do this with various actionsโฆ The user doesnโt even know theyโre looking at an entirely new recordโฆ In SQL this is accomplished much easierโฆ
So, I change the edit action, from edit to link to form that populated all the existing recordsโฆ You could also do the copy action I think, but thereโs always other things I want to manually change programmatically, so I always link to formโฆ
Also, an action can still link to form and change status automatically, they would just need to hit save, I treat this like a confirmationโฆ
You can show the system actions, and then modify then
The user should see every entrie, like a history.
Iโve found out that my function works, but it doesnโt trigger correctly I think.
Is it possible to trigger an action every 5 minutes?
Thank you Grant for this response.
I have trouble to grasp your idea correctly.
Iโll know try to do this over the weekend and I would be really happy, if I could contact you maybe when I have some questions.
Thank you really much for the information.
@Adrian_Enz Feel free to simply reply to this post, good luck!
Already got one question.
When I set a State and do a Workflow / Action to the form. How can I auto populate the form with the state that was chosen previously?
@Adrian_Enz I think Iโm hazy on what you mean by set a stateโฆ But this article is awesome! https://help.appsheet.com/data/columns/column-type-app-deep-links
Iโm sorry, I mean Status.
I
couldnโt figure out how I can go to his FormView when a Row is Updated.
So when a User presses Save it should go to the FormView and the user is required to fill out this form.
Hope that explains it good enough.
I probably have found an answer to my earlier question.
I know do it as follow: I trigger an action on a Table where I have my โBuildingsโ saved. It then opens a form view of a table that is referenced to โBuildingsโ where a user can input updates to a specific building and set e โStatusโ.
The action that was triggered, triggers a second action that should put in the โStatusโ field in the โBuildingsโ table the most recent โStatusโ from the โUpdateโ table.
The function of the second action looks like this: ANY(SELECT(DB_Workinfo_AVOR[AVOR Status],[Datum / Zeit]=MAX( SELECT(DB_Workinfo_AVOR[Datum / Zeit],[Adresse]=[_THISROW].[Adresse]))))
The first action works perfect and really accomplishes what I want. But the second action just doesnโt work, I canโt get the most recent โStatusโ value into the other table.
You need to have a security filter or a slice filter that is always showing the most recent itemโฆ So once they add that new item, the old item is gone, out of their viewโฆ
I basically replace all of my edit actions to copy and edit actions.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |