Creator: How to add subform row to main form with deluge
We have a stateless form named "Bulk Schedule Jobs". When this form is submitted, it loops through existing account records that match the selection made in the stateless form, then it creates a new record in the system via the "Add_Job_Form".
Essentially, when someone submits the form it bulk creates jobs in the system for each account that is assigned to the program.
PROBLEM
I can successfully bulk create the jobs via the code below, but I cannot figure out how to populate the subform within the "Add_Job_Form".
When adding a new record into the system via deluge, how can I also create a new row in the subform?
- for each record in Add_Account_Form [ Programs.Program_Name == Program_Name ]
- {
- if ( record.Programs.Program_Name == input.Program_Name )
- {
- insert into Add_Job_Form
- [
- Added_User = zoho.loginuser
- Status = "Pending"
- Account_Name= record.ID
- Customer_Name = record.ID
- Account_Number = record.Account_Number
- Job_Address.address_line_1 = record.Service_Address.address_line_11
- Job_Address.address_line_2 = record.Service_Address.address_line_21
- Job_Address.district_city = record.Service_Address.district_city1
- Job_Address.state_province = record.Service_Address.state_province1
- Job_Address.postal_Code = record.Service_Address.postal_Code1
- Job_Address.country = record.Service_Address.country1
- Job_Address.latitude = record.Service_Address.latitude1
- Job_Address.longitude = record.Service_Address.longitude1
-
- ]
- }
- }
Access your files securely from anywhere
Zoho Developer Community
Deliver unforgettable customer experiences
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
Zoho Desk Resources
-
Desk Community Learning Series
-
-
-
-
-
-
-
-
-
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho Campaigns Resources
Zoho CRM Resources
Zoho Show Resources
Writer Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.