AUTO UPDATE REAL COLUMN WHICH IS REFERENCED TO A VIRTUAL COLUMN

[KathB27]

Hi All,

I have this "Progress" column which is referenced to "Status" Virtual column.

Is there a way to auto update the values in "Progress" when the values in "Status" changes?

The reason i wanted this real column is because i need to link it to data studio. Virtual columns does not appear in data studio (or is there way to see it in data studio?)

[SkrOYC]

Quick Update System - How to update records in you... - Google Cloud Community

[KathB27]

hi @SkrOYC , yes i have done this as well…. the “Status” and “Progress” column lives on my Parent table…. The “Status” column changes based on a formula related to its child tables…. The [Update]+1 in the video seems to only work if the child table is updated and “saved”…however my child tables are updated through an action button only and users don’t need to press the save button…so maybe that’s why it doesn’t work….

Could you advise if the Data Change Bot works…im not sure how its done…

[SkrOYC]

Actions: The Essentials - AppSheet Help

---

You can have an action on the child table that updates the parent

---

@KathB27 wrote:

Could you advise if the Data Change Bot works…im not sure how its done…

---

Avoid it