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];
}
}
Topic Participants
Annette
Karunakaran G
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Zoho Orchestly Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー