Help

Create multiple linked records with a button

Topic Labels: Scripting extentions
Solved
Jump to Solution
11104 11
cancel
Showing results for 
Search instead for 
Did you mean: 
Mathias_Elmose
7 - App Architect
7 - App Architect

Hi

I would like to be able to create multiple linked records in one “run”.

I do a lot of videos for lectures and have a base has with a “productions” table and a “projects” table.

I want to be able to

  • add a button in the “projects” table that runs a script
  • the script should ask me how many new records to create in the “productions” table.
  • and then create the records linked to the project

This would help me when 1 projects has 30 productions.

And because a higher demand for remote learning I get many request for many videoes - so time saved on place it time used in another:)

Thanks!

11 Replies 11

Hi Mike - thanks for this script works perfectly! How would you approach automatically triggering this script based on the changed state of a field? Julia

Hi, I’d also like to know this. If I have a number mentioned in the parent record, can the scripting block create that number of records automatically?

My use case is like this:
I have a “project” record with number fields for “videos” and “images”. So basically that project will have X videos and Y images. With a button field, can it create records in another table linked to this project, and create X number of records having a single select value of “videos”, and Y number of images with a single select value of “images”?