Automation to create multiple records based on a multi-select text field
Hi everyone! I have a tricky question for you. I have a parent table (jobs) with a child table (schedule) with its own child table (crew assignments), which in turn has its own parent table (crew) which is just a master list of the staff. The way I have my app designed, users add schedule items in a grid edit within the main Job form. Then within each schedule item in the grid edit, there's a multi-select text field set up to assign crew members to each schedule item. It's fine, but it's just a multi-select text field that pulls crew names from the master crew table, it's not actually associating crew assignment child records with that schedule item. Having users click a report link from each schedule item and add crew assignments in grid edit mode would be adding too many steps. What I think I need is to be able to do is keep my multi-select text field, but create an automation that separates that list and then creates a child record in the crew assignments table for each name on the list. I haven't done much with list fields in automations so I'm not sure where to start. Or of course, if I'm missing something blindingly obvious about being able to create multiple grandchild records within a grandparent form let me know. Any help would be awesome! ------------------------------ Elena Larrabee ------------------------------33Views0likes2CommentsHow to set up a child record to automatically select its parent?
Hi everyone! I've just started playing with a connected Quickbooks table. I'm trying to find a way to have the records in the Books table automatically select a parent record in my Jobs table. Each Books record has a Job Number field that should associate it with the proper Job record (each Job record has a unique Job Number), but I can't figure out how to create an automation that tells the Books record to "select the job with the matching 'Job Number' as the related Job for this record". I've tried to have it automatically write the Job Number to the Related Job field, but it just inputs some numbers and doesn't select the correct job. Any ideas? Thank you in advance! - Elena ------------------------------ Elena Larrabee ------------------------------36Views0likes6Comments