Working with Subforms

[@SentinelleInfo]

Thanks for this video. Clear and to the point.

[@Aorborc]

Thanks for your support. Keep watching our videos and give us feedback

[@SentinelleInfo]

I will. Now I'm just waiting for the Advanced Reports creation. ;-)

[@Aorborc]

Here you go!
ua-cam.com/video/o4J2KoAqnlE/v-deo.html

[@SentinelleInfo]

Thanks a lot !:-)

[@kmac1504]

how do you create the row_rec variable for the total

[@hamidiology5872]

Kindly make a video how to create sales order in zoho crm using zoho creator application like we have sales order form on zoho creator whenever we enter a data it will be shown in zoho crm

[@akshatsaxena1999]

I have a Question. Can we Autopopulate Upload files field from one subform to another.
If yes. How can we do that, as I have tried autopopulating it didn't worked

[@rumaanabegum6877]

How to make the quantity column go back to zero when another item is selected from drop list?

[@Aorborc]

in the on user input of drop list, set row.Quantity=0

[@rodellacuesta1329]

Thanks for the video... i have question regarding the subform.. it is possible that once i select the value from the original form then sub form will display/available to fill up.

[@Aorborc]

Yes, we can write the workflow on the user input to hide and show fields in the subform. let us illustrate the Hiding subform or showing the subform.

[@Gauravsingh-lk5gc]

How to integrate Zoho creator with zoho workdrive

[@henrydelosreyes8035]

what if I deleted a row? the total is still the last one

[@Aorborc]

You need to handle the script on "On Delete row"

[@agusrupendi]

how if we want to more responsif, the total can change autobmaticly as soon as row.total is changed?

[@kutubemuggeridge]

you can perform automatic calculations by creating a Workflow (While using the form | Select the form | Select Created or Edited), then Add New Action, select Deluge Script and select On user input. Select the control that you want to store the automated calculation within... Search online for script examples to do the calculations.
TIP: Try adding new Forms with an existing template. I added a sales order template Form and it already included all the design of adding rows of data and calculating. Use the template Form as a way for you to understand how it was created and get all the Deluge Workflow Scripts that have been created already. I've learnt so much from using existing Templates, and you can even install new Applications that have similar functionality that you need. For me, i found every answer i was after after installing the Quotation Management Application.
Good Luck and remember that just about every possible solution already exists across all the free Templates and Applications that are on offer.

[@saikatmukherjee3304]

Thanks A lot

[@RajKumarsreenivasan]

row.Total_Cost=row.Head_Count * row.Wage_Cost;
// For each record
temp_total=0.0;
for each row_rec in input.Labor_Details.Manpower[ temp_total = temp_total + row_rec.total ];
input.Manpower.Total_Cost=temp_total;
Can somebody help me with an error on line 4.
P.s - Thanks in advance

[@Aorborc]

replace the square bracket with set bracket. Also, get rid of the semicolon - they don't apply for loops.
for each row_rec in input.Labor_Details.Manpower
{
temp_total = temp_total + row_rec.total;
}