I have two tables in my app, toolboxes and trainees. Toolboxes are assigned to trainees via a ref (in the toolbox record, you choose which trainee is associated with that box). I need a way so that when a trainee leaves the company (their “status” field changes) it automatically causes the status field of their associated toolbox to change as well (to “needs pickup”… we pick up and re-assign the boxes). Right now, users have to remember to edit the toolbox record if a trainee leaves, but everybody forgets to do it. Until I get “better” co-workers (ha ha!), does Appsheet have a way to automate this? Thanks!
LinkedIn
Twitter
