Solved: Actions to update other tables. Why not how - Page 2

Joseph_Seddik · 01-15-2022 02:05 PM

Hello,

I would like to know please whether there is a reason for which we can “Add rows to another table using values from this row”, but we can NOT "Update rows of another table … "

Instead of having to use complex (and in some cases non-reliable) lookup operations, I was wondering why is AppSheet missing such action?

Personally, I use a personal method based on custom keys to locate values, I’ve read several older topics regarding the subject so I’m not facing an issue and thanks to the community I know how it can typically be done. I just couldn’t find the reason for making this feature unavailable and I’m really interested in knowing why.

Thank you!

MultiTech

Sorry for the many reply’s but there’s a lot in this thread

One way you might go about this…

There could be a virtual field on the Parent, that’s watching the child data, waiting to change a status value
- I typically call these [Something_Auto_Status]
This column watched all the related columns, and depending on the data there - changes it’s value from one status to another.

From this status change, you can then trigger off all sort of automations.

But what I would do in this scenario:

Have an [Auto_Status] column watching the [Status] field of the child data
- The idea being, there will be a bunch of statuses from the tasks - but eventually they will all say “Complete”
- So if I generate a list of all the status values from the children, then Unique() that list…eventually it will reduce to a single “Complete” value
  - At which point the project is complete

and(
  count(UNIQUE([Related Whatevers][Status]) - list("") = 1,
  in("Complete", UNIQUE([Related Whatevers][Status]) - list(""))
)

The fields for the [Project_Completion_Time] could then be a “ChangeTimestamp” column type
- Watching the [Auto_Status] column
- Triggering off the “Complete” value

View solution in original post