Feb 26, 2023 06:27 PM - edited Feb 26, 2023 07:37 PM
I'm trying to create an automation whereby, when a user checks the green "flag" checkbox for a given "Adjustment" in the "All Adjustments" table, it triggers the creation of what you see under the "Analysis by Division" field in the Analysis Table.
That is, for a given checkboxed "Adjustment" (listed in All Adjustments Table) like "Seat Molding," "Touch ID Seat Adjustment," "Heated Massage," "Meal Reheater/Composter" or "Retractable Covid Seat Screen," I'd like Airtable to automate the concatenated formula (as shown under "Analysis by Division,") pairing every one of the 17 "Team Divisions" that I have posted in the list of Team Divisions (which I have rolled up into the "Analysis" table) with the "Item Being Analyzed," which is basically a roll-up of the same checkboxed "Adjustment" from the All Adjustments Table.
I was trying to automate this from the click of the checkbox in "All Adjustments" and spit out 17 concatenated records in the "Analysis" table, but I think I'm doing something wrong. Any feedback? Thanks.
Feb 26, 2023 06:52 PM
Not really sure I'm following. I think you're looking to create one record per Team Division? If so, I recommend checking out the repeating group functionality
The automation would do a "Find Records" action to get all the records in "Team Division", then you'd put a "Create Record" action inside the repeating group to create one record per Team Division
Feb 26, 2023 07:44 PM
Yes, sorry that was so wordy. Yes, let's say I check the green checkbox button for a given "adjustment" and it's (for example) the "Seat Molding" record. I want to then make that selected checkbox trigger 17 concatenated formulas as I've written them:
Spinning out "Telecommunications's Analysis of Seat Molding" "Sales's Analysis of Seat Molding," etc. to align with the 17 different team divisions I've included in that table.
Feb 27, 2023 08:57 PM
And the output of each formula field would need to be created as a new record in the "Analysis" table?
If the divisions don't change I think I'd just manually create one "Create Record" action as needed.
Really sorry, at this point I still don't think I fully follow you. Do you think you could create a really simplified version of this issue with an example base and I could help you with it?
Alternatively if we could get on a quick call I think that'd help massively too
Feb 28, 2023 03:20 PM
No, I think you've got it!
The content of the Team Divisions table would stay the same, and those 17 team divisions be pulled into the "Analysis" table, and paired with the "Adjustment" selected by the checkbox in the "All Adjustments" table.
So in essence, I'm trying to automate it so that, say the "Name" of the "Adjustment" were "Cosmetic Seat Improvements" and I clicked that record's checkbox button in the "Generate Impact Analysis" field in the "All Adjustments" table. The result I'd want is that in the "Analysis" table under "Analysis by Division," 17 new records would immediately be created as such:
Mar 01, 2023 05:09 AM
Oh hm, wait, so you've looked into the repeating group functionality? Because that would do exactly what you needed I think
You'd have an automation that would trigger when the user checks the green "Flag" checkbox in "Adjustment", with the following actions:
1. Find Records action which would find all the records in the "List of Team Divisions" table
2. A repeating group function with a "Create Record" action that would create one record per division record in the list from the previous step
What problems did you face when attempting this?