Creation of individual forms based on numerical input
creator.zoho.com/kwasserman/copy-of-tracking/
In the "NEW_JOB" form I have a field named "STARTING_VOLUME_NAME". I also have a form named "IMAGING_VOLUMES". In the "NEW_JOB" form I would like to create a numerical field just after the "STARTING_VOLUME_NAME" field that asks the user who is inputting the data into the form to identify how many volumes should be created. Once the form is submitted I would like that data to update in my "VOLUMES" view.
In other words if I were to enter into the "STARTING_VOLUME_NAME" field "ABC" and I were to designate that I would like 3 volumes created, I wish to have three individual records created in the "VOLUMES" data set, whilst carrying over certain pertinent information (Master project number, primary contact, job number). I have created a field in the "IMAGING_VOLUMES" form labeled "VOLUME_NAME". I would like the volume name to be the combination of the input from (NEW_JOB.STARTING_VOLUME_NAME) an underscore, followed by a padded three digit number depending on how many volumes were selected to be created.
For example, if I entered ABC into (NEW_JOB.STARTING_VOLUME_NAME) and entered 3 into the field asking for the amount of volumes, I would like to be able to switch to the VIEW for the "IMAGING_VOLUMES" form and see three records created named ABC_001, ABC_002, and ABC_003.
In the IMAGING_VOLUMES form I do have certain fields that are required, which may or may not present a problem when creating new records dynamically through other forms. I am more concerned regarding the "JOB_NUMBER" field in the IMAGING_VOLUMES form. This field is currently set up as a picklist that looks up data from information entered into the "NEW_JOB" form. I would need this information to be carried over as well as it is my link to other dependent information in other forms.
Can someone please break down what I would have to change in order to make all this happen.
Sincerely,