I have one table filled with dorms. The dorms have other fields like “Building” and “Floor.”
I have another table with assignments to clean specific dorms. If I create a cleaning assignment but instead of a specific dorm number, I enter just a building, I want a “Find Records” automation to find all the dorms assigned to that building (that part I know how to do) and then I want the automation to turn around and create a separate cleaning assignment record in Table B for each Dorm record found in Table A.
How can I do this? I bangin` my head against the wall trying to figure it out. I think I would prefer a script but I don’t even know how to begin with that.