Skip to main content
Solved

Automations - multiple actions

  • December 23, 2025
  • 4 replies
  • 33 views
H
Forum|alt.badge.img+11

I’m trying to work out if I can create an automation to do multiple tasks or if they all have to be separate (which might max out my allowance)…

I have a table which tracks my book contracts. Each contract may have up to 5 titles on it and each title could be produced in up to 6 editions.

 

 

I’d like an automation that creates a record in my edition table for each planned edition…

So,

Test title 1 Hardback

Test tile 1 Paperback

etc

I can get this to work if each automation is separate but feel like there should be a way to group it somehow. However, at the moment when I try to create a chain it comes up as ‘otherwise’ so it doesn’t run the paperback if there is a hardback. What am I missing? 

Best answer by TheTimeSavingCo

Hm, without scripting, the minimum you’d need would be 5 automations (one per title) and I’ve set it up here for you to check out

 

If you were to do it with scripting you could handle it within one automation, but that might be more work than it’s worth, really.  If this is really something you’d like to explore I’d suggest trying to use ChatGPT to help with this and if you hit a wall let me know and I’ll see what I can do to help!

    4 replies

    TheTimeSavingCo
    Forum|alt.badge.img+31

    Hm, without scripting, the minimum you’d need would be 5 automations (one per title) and I’ve set it up here for you to check out

     

    If you were to do it with scripting you could handle it within one automation, but that might be more work than it’s worth, really.  If this is really something you’d like to explore I’d suggest trying to use ChatGPT to help with this and if you hit a wall let me know and I’ll see what I can do to help!

    Adam, Airtable Consultant - thetimesaving.company
    H
    Forum|alt.badge.img+11
    • HannahS
    • Author
    • Known Participant
    • December 24, 2025

    Fab, thanks so much!

      felipe-saucedo
      Forum|alt.badge.img+10

      Hi Hanna this would be a simple scripting, you can ask GPT, i find it to be good on making these simple scripts and then with a keen eye you can always fix it or amend it. 

      Mike_AutomaticN
      Forum|alt.badge.img+28

      Hey ​@HannahS,

      If I may suggest an additional update to your setup:
      You cound split you current Contracts table into the following two tables:
      Contracts
      Titles

      You should link your Editions table to your Titles table rather than to your Contracts table.

      In this case, Contracts would be linked to one or multiple (5) titles. Each title will be its own record in the Titles table. Fruthermore, each title will have its corresponding Planned Editions (which by the way I would suggest having Edition Types as a completely different table and have a linked record field to Edition Types rather than having a multiple select for Planned Editions).

      You can now create a new field at the Contract Level -checkbox for exmaple- called Create Planned Editions.
      You can have a lookup of Planned Editions field at the Titles level.
      For last you can set the trigger on the automation to run when Planned Editions (from Titles) lookup field is not empty at the Titles level.
      In this way, and using repeating groups as shown by Adam above, you (a) woud have a more robust and scalable database architecture, and (b) you would only need one unique automation to get the job done.

      Hope this helps!

      Mike, Consultant @ Automatic Nation 
      YouTube Channel

      Terms & ConditionsAccessibility statement