I have 3 tables: "Employees", "People Changes" and "FP&A". I have 2 Automations to add a record to FP&A when a record is added to Employees or a record is added to People Changes.
Now I am trying to set up Automations to modify the associated FP&A record when an Employee record or People Change record is modified. Currently when I modify an Employee record with the modify automation set up the way i have it, it changes ALL FP&A records. It makes sense that the automation doesn't know WHICH record to modify - but i can't understand where i'm inputting an indicator/relationship.
The key field in Employees is Employee Number and the Key Field in People Changes and FP&A are Record ID#.
What am I missing?
Question
Need to use Automations to modify records in a table that were created with Automations.
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.