Generating new records with specific dates and days of the week for a date range

[daparker]

I need a script to be able to create a new set of records with dates for specific days of the week. Like:

Generate 9 records starting with April 5th that fall into the following sequential pattern:

April 5

April 5

April 8

April 12

April 12

April 15

April 19

April 19

April 22

and so on

this is to facilitate creating service order records for church services (Two services on Sunday and one on Wednesday) Right now I have to create all the service/date records manually.

[comment]

Perhaps you could use something like the attached. There's no script - just create as many records as required.

Services.fp7.zip

[Brent Durland]

You could build a script that loops through a list of dates in a field. Use GetValue and a variable that increments with each loop. Something like this:

Set Variable [$values; Value:ValueCount ( Services::gDateList )]

Set Variable [$counter; Value:1]

Loop

Exit Loop If [$counter > $values]

New Record/Request

Set Field [ Services::Date; GetValue ( Services::gDateList ; $counter )]

Set Field [// Set other fields as appropriate]

Set Variable [$counter; Value:$counter + 1]

End Loop