Insert multiple rows with creator...
Hi, the below code inserts only 1 row from the fetched data. Can anyone help with code to make sure it inserts all records fetched? Thanks for the help...
Pdtxpagar = Alumnas1[Status_Alumnas_os == "Alumna(o)"] sort by Fecha_de_Inscripcion desc;
Pdtxpagar2 = Academia[Servicio == "Mensualidad" && Status_Pago == "Pendiente x pagar"];
insert into Academia
[
Added_User = zoho.loginuser
Alumna = Pdtxpagar.Nombre_Alumna
Fecha = zoho.currentdate
Forma_de_Pago = Pdtxpagar2.Forma_de_Pago
Mes_a_cubrir = "Junio"
Notas = "El Status de esta Alumna es Pdt x Pagar"
Servicio = Pdtxpagar2.Servicio
Status_Pago = Pdtxpagar2.Status_Pago
]