Hi, I have a status in one table and when it changes, I need it to change a status in another table. Is this possible? I cant seem to find a way to see other tables when I set the action in the Quickbase pipeline.
How are you looking up the record in the other table to perform your action? Your Pipeline high level should look something like:
Step A: Trigger when record is updated and status changes
Step B: Lookup or search for record in other table
Step C: Update Step B or Loop through Search Results to update Step B
When you say you're not seeing the status options - does that mean that it's not available as a field when you're picking the fields to include or is it there and the options aren't showing? The search records is fine as long as you're also using the loop and querying properly.
