Generate records

Generate records

Hello,
Can anyone assist with the following,


I want to generate records based on input field value on Input Form 

Eg input field = 8

Therefore Generate 8 records

 

I can insert 1 record ok but need to perform routine below (8 times in this instance)

 

insert into Input_Results

    [

        Added_User = zoho.loginuser

        Competition_Event = input.Competition_Event

        Event_Year = input.Event_Year

        Month = input.Month

        Result = "Pending"

        Start_Date = input.Start_Date

        Time = input.Time

        Venue = input.Venue

    ]

 

 

Thanks