Scheduler Scripting Question

Scheduler Scripting Question

Hi I have a Daycare application and I want to charge tuition dues every Monday for Cash paying parents.

I know how to set the scheduler but I need help creating a script that does the following:

  • Find the kids who pay "cash" from the payment_type field in the add_kids _form
  • For each kid who pays "cash", select the child's name (ID) and weekly_tuition_amount from that kids record

  • Then create a new entry in add_bill_form with the child's name (ID from add_kids_form) and weekly_tuition_amount amount from the add_kids_form
  • Repeat for all of the records that have cash paying students