Hi, all.
I have a procedural question, and probably a very easy one.
My app has actions set up for field inspections. After a month or so, someone will return to the same item and inspect it again. If the results are the same, and they select the same option as the last time, it wonโt register as an action or change anythingโฆI understand this to be because the Google Sheet cell would technically see it as the same status.
What has been everyoneโs workaround or โbest practicesโ for logging a repeat action with the same result?
I am not always the best at describing what Iโm after in AppSheet lingo, so I hope that is not the problem hereโฆ
I can try and rephrase the question if needed.
I need the new timestamp and user info for an action when the action is the same as the previous (e.g. two inspections with the same result/using the same action button.) Right now, if someone marks an item as โdryโ and goes back a month later to mark it โdryโ again, the app doesnโt recognize any change and wonโt log anything.
Like I said, Iโm sure Iโm missing an obvious solution, but I would love a smarter forum memberโs help.
I would keep your โactionโ record as child records in another Table, so you can record an exact history.
Thanks for the reply.
Right now, I do have a child table for โactivity,โ but the problem is choosing the same action as before doesnโt register on that tableโฆI hope I am describing the problem the right way.
I took a quick video of what I mean. The item Iโm clicking was โdryโ the last time it was inspected, and when I try to use that button again to give it a new timestamp indicating the status has not changed - but it was inspected again - it doesnโt registerโฆApologies if my meaning is unclear.
I mean that youโd create a brand new record for every activity, not edit an existing record.
Right. I have that working fine at the moment. The parent table rows are edited, and a new row is added to a child table. But if I pick the same action like I tried to show above, nothing is changedโฆ
Thanks for sticking it out with my post.
I donโt understand what the issue is then. Is something not working correctly? What do you mean by โnothing is changedโ? If there is a new record being created, that is most definitely a โchangeโ.
I mean a new record is not added, nor is the parent table edit showing up when it is the same action as the previous oneโฆIf I were to click a different action, that does work - the row edit and the new row in the child table. So right now, if an item is marked โdry,โ the only way I can see to indicate that it is dry again the next time someone clicks it is to pick a different action, and then click โdry.โ I would try to capture that on video, but I didnโt want to bounce from the app to the Google Sheet and make it confusingโฆ
But it sounds like itโs already confusing.
Show how your Actions buttons are configured.
Here is the action Iโve been using as an example:
And hereโs how Iโve been adding a new row to the other table:
I am a beginner, so I assume I made some kind of misstepโฆ
Hopefully those images are what you had in mind. I can screenshot something else if neededโฆ
So how is the 2nd Action being triggered, in any case?
Iโve been using a bot to do that.
Ahhh, that makes way more sense now.
You should change your โDryโ Action to be a Grouped Action, that triggers your old โDryโ Action, as well as the 2nd Action.
Perfect! I knew there was something fundamental I was missing. I will get to work on that. I may revisit here with a follow-up question, so bear with me. At least now I know where to start. Thanks!
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |