Insert to From not working
Hello everyone,
So I wrote this code below. However, it is not inserting the date into my new form.
I have four forms with customer data, and I need to insert specific data from each form into my new form.
Thank you in advance;
Annette
void AuditBillingsheet.createUpdateSheet(string billingOption, date visitDate, Therapists thRecord)
{
//fetch mece Billing Week
mFBweek = MECA_FIT_Billing_Weeks[Week_Start_Date <= input.visitDate && Week_End_Date >= input.visitDate];
//get dates
weekStarDate = mFBweek.Week_Start_Date;
weekEndDate = mFBweek.Week_End_Date;
weekNumber = input.visitDate.getWeekOfYear();
//Fetch All Sooper Records
sopRecord = SSOOPPRR_FORM[Added_User.Email.equalsignorecase(thRecord.EMAIL) && Date_of_Visit >= weekStarDate && Date_of_Visit <= weekEndDate && Billing_Options.equalsignorecase(input.billingOption) && Total_Billable_Units != null] sort by Visit_Start asc;
//Fetch all TTA Records
ttaRecord = COVID_TTA_form[Added_User.Email.equalsignorecase(thRecord.EMAIL) && Billing_Option.equalsignorecase(input.billingOption) && Date_of_TTA_Contact >= weekStarDate && Date_of_TTA_Contact <= weekEndDate && Total_Billable_Units != null] sort by Visit_Start_Time asc;
//fetch FSC Recrods
fscRecords = Family_Service_Coordinator_Contact_Log[Added_User.Email.equalsignorecase(thRecord.EMAIL) && Billing_Options.equalsignorecase(input.billingOption) && Visit_Date >= weekStarDate && Visit_Date <= weekEndDate && Total_Billable_Units != null] sort by Time_In asc;
//Fetch Cancellations
canRecord = Early_Childhood_Cancellation_Contact_Form[Added_User.Email.equalsignorecase(thRecord.EMAIL) && Billing_Option.equalsignorecase(input.billingOption) && Date_field1 >= weekStarDate && Date_field1 <= weekEndDate] sort by Date_field1 asc;
//initialies list
loopList = {0,1,2,3,4,5,6};
dateList = list:date();
//itarte
for each ll in loopList
{
if(weekStarDate.addDay(ll) <= weekEndDate)
{
dateList.add(weekStarDate.addDay(ll));
}
}
dateList.sort();
wbbsString = "<div style='width: 100%;'>";
wbbsString = wbbsString + "<table style='width: 100%;'><tbody>";
wbbsString = wbbsString + "<tr><td style='width: 70%; font-weight: 600; font-size: 150%;'>MECA Therapies, LLC EI SERVICES</td><td style='width: 30%; font-weight: 600; font-size: 125%;'>Reviewed August 2020</td></tr>";
wbbsString = wbbsString + "<tr><td style=' font-weight: 600; font-size: 150%;'>BILLING SUMMARY SHEET</td><td style=' font-weight: 600; font-size: 110%;'>Audited by:</td></tr>";
wbbsString = wbbsString + "</tbody></table>";
wbbsString = wbbsString + "<div> </div>";
wbbsString = "<div style='width: 100%;'>";
wbbsString = wbbsString + "<table style='width: 100%;'><tbody>";
wbbsString = wbbsString + "<table style='width: 100%; border-collapse: collapse;'><tbody>";
wbbsString = wbbsString + "<tr><td style='width: 20%; border-bottom: thin solid grey;'>FUND</td><td style='width: 20%; border-bottom: thin solid grey;'>" + input.billingOption.toUpperCase() + "</td><td style='width:60%; border-bottom: none !important;'> </td></tr>";
wbbsString = wbbsString + "<tr><td colspan='3'> </td></tr>";
wbbsString = wbbsString + "<tr><td style='border-bottom: thin solid grey;'>WEEK NUMBER</td><td style='border-bottom: thin solid grey;'>" + mFBweek.Week_Label + "</td><td style=' border-bottom: none !important;'> </td></tr>";
wbbsString = wbbsString + "<tr><td colspan='3'> </td></tr>";
wbbsString = wbbsString + ("<tr><td style='border-bottom: thin solid grey;'>THERAPIST NAME</td><td style='border-bottom: thin solid grey;'>" + thRecord.NAME) + "</td><td style=' border-bottom: none !important;'> </td></tr>";
wbbsString = wbbsString + "<tr><td colspan='3'> </td></tr>";
wbbsString = wbbsString + "<tr><td style='border-bottom: thin solid grey;'>SERVICE PROVIDED</td><td style='border-bottom: thin solid grey;'>" + thRecord.TITLE + "</td><td style=' border-bottom: none !important;'> </td></tr>";
wbbsString = wbbsString + "<tr><td colspan='3'> </td></tr>";
wbbsString = wbbsString + "</tbody></table>";
wbbsString = wbbsString + "<h6 style='width: 100%; text-align: center;'># OF UNITS PROVIDED</h6>";
wbbsString = wbbsString + "<table style='width: 100%; border-collapse: collapse;'><thead>";
wbbsString = wbbsString + "<tr><td style='border: thin solid grey; text-align: center; padding: 5px;'>CLIENT NAME</th><td style='border: thin solid grey; text-align: center; padding: 5px;'>SERVICE<br>DATE</td><td style='border: thin solid grey; text-align: center; padding: 5px;'>TELEHEALTH<br>INDIV.</td><td style='border: thin solid grey; text-align: center; padding: 5px;'>HOME<BR>INDIV.</td><td style='border: thin solid grey; text-align: center; padding: 5px;'>COMM.<BR>INDIV.</td><td style='border: thin solid grey; text-align: center; padding: 5px;'>CENTER<BR>INDIV.</td><td style='border: thin solid grey; text-align: center; padding: 5px;'>CENTER<BR>GROUP</td><td style='border: thin solid grey; text-align: center; padding: 5px;'>HOME<BR>GROUP</td><td style='border: thin solid grey; text-align: center; padding: 5px;'>COMM.<BR>GROUP</td><td style='border: thin solid grey; text-align: center; padding: 5px;'>CONSULT<BR>COLLABORATIVE</td><td style='border: thin solid grey; text-align: center; padding: 5px;'>CONSULT<BR>TTA</td><td style='border: thin solid grey; text-align: center; padding: 5px;'>CONSULT<BR>FOLLOW UP</td><td style='border: thin solid grey; text-align: center; padding: 5px;'>E & A</td><td style='border: thin solid grey; text-align: center; padding: 5px;'>NS, PC,<BR>SC, OH</td></tr>";
wbbsString = wbbsString + "</thead><tbody>";
//fileStr=fileStr +
for each dl in dateList
{
//get sf id recrod
sfRecord = SSOOPPRR_FORM[ID in sopRecord.ID.getall() && Date_of_Visit = dl] sort by Visit_Start asc;
// get tta id recrod
ttRecord = COVID_TTA_form[ID in ttaRecord.ID.getall() && Date_of_TTA_Contact = dl] sort by Visit_Start_Time asc;
//Family Service Coordinator ID
famSCRecord = Family_Service_Coordinator_Contact_Log[ID in fscRecords.ID.getall() && Visit_Date = dl] sort by Time_In asc;
//get early childhood id cancelletion
echRecord = Early_Childhood_Cancellation_Contact_Form[ID in canRecord.ID.getall() && Date_field1 == dl];
//get Client Record ID
clientRecord = Client_Form[ID in sfRecord.Client_Name.getall() || ID in ttRecord.Client_Name.getall() || ID in famSCRecord.Client_Name.getall()] sort by Client_Last_Name asc;
//iratare
for each clientR in clientRecord
{
//Fetch ssoop from record //* Why from CF?
sfcRecord = SSOOPPRR_FORM[ID in sopRecord.ID.getall() && Date_of_Visit = dl && Client_Name == clientR.ID] sort by Visit_Start asc;
ttCRecord = COVID_TTA_form[ID in ttRecord.ID.getall() && Date_of_TTA_Contact = dl && Client_Name == clientR.ID] sort by Visit_Start_Time asc;
famCRecord = Family_Service_Coordinator_Contact_Log[ID in famSCRecord.ID.getall() && Client_Name == clientR.ID] sort by Time_In asc;
for each sfcr in sfcRecord
{
//
wbbsString = wbbsString + "<tr>";
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'>" + sfcr.Client_Name.Client_Last_Name + ", " + sfcr.Client_Name.Client_First_Name + "</td>";
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'>" + sfcr.Date_of_Visit.tostring("MM/dd/yyyy") + "</td>";
//telehealth
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(sfcr.Description.contains("Telehealth Code:T1027"),sfcr.Total_Billable_Units,"") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(sfcr.Description.contains("Home-Individual Code:T1027"),if(sfcr.Description.contains("Collaborative Consultation Code:T1027"),"X",sfcr.Total_Billable_Units),"") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(sfcr.Description.contains("Community-Individual Code:T1027"),if(sfcr.Description.contains("Collaborative Consultation Code:T1027"),"X",sfcr.Total_Billable_Units),"") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(sfcr.Description.contains("Center-Individual Code:T1027"),if(sfcr.Description.contains("Collaborative Consultation Code:T1027"),"X",sfcr.Total_Billable_Units),"") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(sfcr.Description.contains("Center-Group Code:T1027"),if(sfcr.Description.contains("Collaborative Consultation Code:T1027"),"X",sfcr.Total_Billable_Units),"") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(sfcr.Description.contains("Home-Group Code:T1027"),if(sfcr.Description.contains("Collaborative Consultation Code:T1027"),"X",sfcr.Total_Billable_Units),"") + "</td>";
//community group
cgTot = 0;
cgTot = cgTot + if(sfcr.Description.contains("Community-Group Code:T1027"),sfcr.Total_Billable_Units.toNumber(),0);
cgTot = cgTot + if(sfcr.Description.contains("Over the phone Collaborative Consultation Code:T1027"),sfcr.Total_Billable_Units.toNumber(),0);
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(sfcr.Description.contains("Community-Group Code:T1027") || sfcr.Description.contains("Over the phone Collaborative Consultation Code:T1027"),if(sfcr.Description.contains("Collaborative Consultation Code:T1027"),"X",if(cgTot > 0,cgTot.tostring(),"")),"") + "</td>";
//consult collaborative
ccTot = 0;
ccTot = ccTot + if(sfcr.Description.contains("Collaborative Consultation Code:T1027"),sfcr.Total_Billable_Units.toNumber(),0);
ccTot = ccTot + if(sfcr.Description.contains("Comprehensive Multidisciplinary Evaluation Code: H2000"),sfcr.Total_Billable_Units.toNumber(),0);
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(ccTot > 0,ccTot.tostring(),"") + "</td>";
//consult tta
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'> </td>";
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(sfcr.Description.contains("Transition Follow Up Consult Code:T1027"),sfcr.Total_Billable_Units,"") + "</td>";
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(sfcr.Description.contains("Evaluation & Assesment Code:T1027"),sfcr.Total_Billable_Units,"") + "</td>";
//ns, pc, sh, oh
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'> </td>";
wbbsString = wbbsString + "</tr>";
}
//itarate
for each ttC in ttCRecord
{
//
wbbsString = wbbsString + "<tr>";
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'>" + ttC.Client_Name.Client_Last_Name + ", " + ttC.Client_Name.Client_First_Name + "</td>";
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'>" + ttC.Date_of_TTA_Contact.tostring("MM/dd/yyyy") + "</td>";
//telehealth indiv.
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//home indiv.
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//commm. indiv.
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//center indiv.
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//center group
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//home group
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//comm. group
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//consult collabrative
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//consult tta
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(ttC.Total_Billable_Units != null,ttC.Total_Billable_Units.tostring(),"") + "</td>";
//consult follow up
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//e & a
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//ns, pc, sh, oh
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
wbbsString = wbbsString + "</tr>";
}
//itarte famCRecord
for each famc in famCRecord
{
//
wbbsString = wbbsString + "<tr>";
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'>" + famc.Client_Name.Client_Last_Name + ", " + famc.Client_Name.Client_First_Name + "</td>";
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'>" + famc.Visit_Date.tostring("MM/dd/yyyy") + "</td>";
//telehealth indiv.
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//home indiv.
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//commm. indiv.
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//center indiv.
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//center group
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//home group
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//comm. group
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//consult collabrative
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//consult tta
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//consult follow up
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//e & a
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
//ns, pc, sh, oh
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'> </td>";
wbbsString = wbbsString + "</tr>";
}
}
//iterate for echRecord
for each echr in echRecord
{
//check if
if(!echr.Staff_Cancellation.isEmpty() || !echr.Parent_Cancel.isEmpty() || !echr.No_Show.isEmpty() || !echr.On_Hold.isEmpty())
{
//
wbbsString = wbbsString + "<tr>";
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'>" + echr.Client_First_Name.Client_Last_Name + ", " + echr.Client_First_Name.Client_First_Name + "</td>";
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'>" + echr.Date_field1.tostring("MM/dd/yyyy") + "</td>";
//telehealth
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(echr.Description.contains("Telehealth"),"0","") + "</td>";
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(echr.Description.contains("Home-Individual"),if(echr.Description.contains("Collaborative Consultation Code:T1027"),"X","0"),"") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(echr.Description.contains("Community-Individual"),"0","") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(echr.Description.contains("Center-Individual"),"0","") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(echr.Description.contains("Center-Group"),"0","") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(echr.Description.contains("Home-Group"),"0","") + "</td>";
//check if
if(echr.Description.contains("Community-Group") || echr.Description.contains("Over the phone Collaborative Consultation"))
{
//
cgTotal = "0";
}
else
{
//
cgTotal = "";
}
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + cgTotal + "</td>";
//check if
if(echr.Description.contains("Collaborative Consultation") || echr.Description.contains("Comprehensive Multidisciplinary Evaluation"))
{
//
ccTotal = "0";
}
else
{
//
ccTotal = "";
}
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + ccTotal + "</td>";
//consult tta
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'> </td>";
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(echr.Description.contains("Transition Follow Up Consult"),"0","") + "</td>";
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(echr.Description.contains("Evaluation & Assesment"),"0","") + "</td>";
//check if
if(!echr.Staff_Cancellation.isEmpty())
{
//
nspcshoh = "SC";
}
else if(!echr.Parent_Cancel.isEmpty())
{
//
nspcshoh = "PC";
}
else if(!echr.No_Show.isEmpty())
{
//
nspcshoh = "NS";
}
else if(!echr.On_Hold.isEmpty())
{
//
nspcshoh = "OH";
}
else
{
//
nspcshoh = "N/A";
}
//ns, pc, sh, oh
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + nspcshoh + "</td>";
wbbsString = wbbsString + "</tr>";
}
}
//
wbbsString = wbbsString + "<tr><td style='' colspan='14'> </td></tr>";
}
//ecccfAllRecord
//iterate canRecord fetch all ealry childhood cancellation
for each canr in canRecord
{
//check if
if(canr.Staff_Cancellation.isEmpty() && canr.Parent_Cancel.isEmpty() && canr.No_Show.isEmpty() && canr.On_Hold.isEmpty())
{
//
wbbsString = wbbsString + "<tr>";
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'>" + canr.Client_First_Name.Client_Last_Name + ", " + canr.Client_First_Name.Client_First_Name + "</td>";
wbbsString = wbbsString + "<td style='border: thin solid grey; padding: 5px;'>" + canr.Date_field1.tostring("MM/dd/yyyy") + "</td>";
//telehealth
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(canr.Description.contains("Telehealth"),"0","") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(canr.Description.contains("Home-Individual"),if(canr.Description.contains("Collaborative Consultation Code:T1027"),"X","0"),"") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(canr.Description.contains("Community-Individual"),"0","") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(canr.Description.contains("Center-Individual"),"0","") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(canr.Description.contains("Center-Group"),"0","") + "</td>";
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(canr.Description.contains("Home-Group"),"0","") + "</td>";
//check if
if(canr.Description.contains("Community-Group") || canr.Description.contains("Over the phone Collaborative Consultation"))
{
//
cgTotal = "0";
}
else
{
//
cgTotal = "";
}
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + cgTotal + "</td>";
//check if
if(canr.Description.contains("Collaborative Consultation") || canr.Description.contains("Comprehensive Multidisciplinary Evaluation"))
{
//
ccTotal = "0";
}
else
{
//
ccTotal = "";
}
//
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + ccTotal + "</td>";
//consult tta
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'> </td>";
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(canr.Description.contains("Transition Follow Up Consult"),"0","") + "</td>";
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + if(canr.Description.contains("Evaluation & Assesment"),"0","") + "</td>";
//check if
if(!canr.Staff_Cancellation.isEmpty())
{
//
nspcshoh = "SC";
}
else if(!canr.Parent_Cancel.isEmpty())
{
//
nspcshoh = "PC";
}
else if(!canr.No_Show.isEmpty())
{
//
nspcshoh = "NS";
}
else if(!canr.On_Hold.isEmpty())
{
//
nspcshoh = "OH";
}
else
{
//
nspcshoh = "N/A";
}
//ns, pc, sh, oh
wbbsString = wbbsString + "<td style='border: thin solid grey; text-align: center; padding: 5px;'>" + nspcshoh + "</td>";
wbbsString = wbbsString + "</tr>";
}
}
//
wbbsString = wbbsString + "</tbody></table>";
//
wbbsString = wbbsString + "</div>";
//fetch audit weekl bill sumary record
wauditRecord = Weekly_Audit_BSS[Billing_Option.equalsignorecase(input.billingOption) && Clovis_Therapists_Lookup == thRecord.ID && Week_Number == weekNumber && Year_Number == visitDate.getYear() && MECA_FIT_Billing_Weeks_Lookup == mFBweek.ID];
//check if
if(sopRecord.count() > 0 || ttaRecord.count() > 0 || fscRecords.count() > 0 || canRecord.count() > 0)
{
//check if
if(wauditRecord.count() = 0)
{
//create new record
wauditNewRecordID = insert into Weekly_Audit_BSS
[
Billing_Option=input.billingOption
Week_Number=weekNumber
Clovis_Therapists_Lookup=thRecord.ID
Year_Number=visitDate.getYear()
Added_User=zoho.loginuser
Start_Of_Week=weekStarDate
SSOOPPRR_FORM_Lookup=sopRecord.ID.getall()
COVID_TTA_form_Lookup=ttaRecord.ID.getall()
Family_Service_Coordinator_Contact_Log_Lookup=fscRecords.ID.getall()
Early_Childhood_Cancellation_Contact_Form_Lookup=canRecord.ID.getall()
Billing_Summary_Sheet=wbbsString
MECA_FIT_Billing_Weeks_Lookup=mFBweek.ID
];
}
else
{
//update existing record
wauditRecord.SSOOPPRR_FORM_Lookup=sopRecord.ID.getall();
wauditRecord.COVID_TTA_form_Lookup=ttaRecord.ID.getall();
wauditRecord.Family_Service_Coordinator_Contact_Log_Lookup=fscRecords.ID.getall();
wauditRecord.Early_Childhood_Cancellation_Contact_Form_Lookup=canRecord.ID.getall();
}
}
else if(wauditRecord.count() > 0)
{
delete from Weekly_Audit_BSS[ID = wauditRecord.ID];
}
}