Hi, is it possible to automatically generate several new records at once AND give them names according to some kind of a formula? 😮
What I have:
A “Projects” table & a “Sprints” table
What I want:
Whenever I create a new project, automatically create 10 new Sprints that are auto-named “S1: [project name]”, S2: [project name]", S3: [project name], etcetera.
Trigger: new record in “Projects”: “Buy the Empire State Building”
Action: create 10 new records in “Sprints”:
Any help would be hugely appreciated!
If the number of records to be created is always fixed (and less than 25) this can be done with automations. Use the create record action and set the spring name to be a combination of static text and text pulled from the record. If the number is not fixed, but can be otherwise determined, this can be done with a script.
You could use any of the following Automation setups, all of which assume you have a trigger that is “when record is created in the Projects table”:
S1: Name, S2: Name, S3: Name, S4: Name, S5: Name, S6: Name, S7: Name, S8: Name, S9: Name, S10: Name
Use a script to generate new linked records
Hello Kamille, thanks for your answer!
I’ll go for option 2 (“update record”) because it seems easiest.
Your explanation was still a bit cryptical though :winking_face: , but with the help of this post explaining the difference between the RECORD ID, the FIELD to update and the VALUE to update it with, I think I got it…
It should look like this, right?
Anyway, I’ll test it out tomorrow and see if it works!
Thanks for your help! Tim