Hello AppSheet Community,
I have a parent table ‘incidents’ that has a one:many relationship with the child table ‘actions.’ The incidents table has a status field. The actions table has a actType field. I want the status field to be “Closed” if any related actType field has the value “yes” and “Open” otherwise.
I use this formula for the status field in the incidents table:
IF(IN(“Yes”,[Related actions][actType]),“Closed”,“Open”)
If I create a closing action WHILE I’m creating a new incident this formula seems to work. However, if I create a new incident, save it, and then later add a closing action then the status column does not update.
LinkedIn
Twitter
