Smart Software For Maverick Entrepreneurs

By: CreatorScripts | February 17, 2017

The first step is to have the Subtotal or Total field value in the Order Form. Normally this would be a currency field or decimal field if you need to consider 1 or more decimals into your calculations. If not you can also set it the field as a Numeric value field. Our example uses a currency field.


Second, you need to think about the places where the script to aggregate the rows needs to occur. In our case, there are several places. On Add Row, On Selecting a new Product, On Changing the Qty amount or the pricing. It is important that all scenarios are considered otherwise your calculations may not be properly aggregated if it encounters a scenario that you have not considered in your scripting yet.

Last but not least, the script below is ready for you to copy and paste into your application. Assuming of course that the field names of your Order Form are named exactly as our test application.



if ((row.Price != null)  &&  (row.Qty  !=  null))

{
    row.SubTotal = (row.Price  *  row.Qty);
}
t = 0.0;
if ((row.Price  !=  null)  &&  (row.Qty  !=  null))
{
    for each rec in Item_Details
    {
        t = (rec.SubTotal  +  t);
    }
}
input.Subtotal = t;

Do not hesitate to contact me if you have any questions. I would be more than glad to help you build an amazing online database application with Zoho Creator. Or check out our full Master Zoho Creator Subforms Course to learn more.

Category: Zoho Creator 

Tags: Deluge Scripts, Subforms 

Comments:

John Bellingshausen

Posted on : January 26, 2018

From the help of this blog and this video you will learn how you can
change the amount and value of currency. By using this <a href="https://www.essayuniverse.net/">essayuniverse</a>
you will have the ability to comprehend easily.


Francisco

Posted on : February 19, 2017

Sure. Will include details on Taxing and Total update on the next video.


Giorgio

Posted on : February 18, 2017

Hi thanks for a video is it possible to create another video to complete
this for a field VAT DISCOUNT and TOTAL ?<br />
thanks so much for help<br />


Post a Comment

Tags

Entrepreneur

HTML

PDF

Word

API

Geolocation

IP Address

Rapleaf API

Email

Pages

Deluge Scripts

Google API

Custom Functions

Gapps

Developer

Webmerge

Creator Scripts

Online Database

Online Tools

Email Marketing

Key Benefits

Sales and Marketing

SaaS

LTV

Barcodes

Hacks

Ted Talks

Quickbase

Spreadsheets

Integrations

Apps

Remote Support

How To Videos

Business Intelligence

Security

Mobile

Zapier

Presentations

Mileage Tracking

LastPass

LogMeIn

Google Analytics

Google Chrome

Expense Receipts

Pivot Table

Reminders

Printing

MS Access

Zoho Creator

GrowthHacking

Productivity

Macros

zohodevs

QR Code

Inventory

Send Email

Fetch Records

digitalnomad

startuplife

hustle

Loyalty

NPS Survey

onlinemarketing

socialmediamarketing

contentmarketing

ladyboss

Gamescope

twitter

HR

Monster

Dice

Zip Recruiter

Zoho Invoice

Wepay

Cashflow

startup

GameofThrones

BI

bigdata

peterdiamandis

online survey

olympic games

Email Receipts

success

Email reminders

business email

zoho mail

Scheduled Emailing

Applicant Tracking

AT

online quizes

online quizzes

Ladyboss

Subforms

G Suite

Invoicing

Image Management

Iterations

Pricing

Price Books

ImagesAPI

GettyImages

iStock

Thinkstock

Ash Maurya

Nick Smith

Jonathan Taylor

Dashboards

randomness

Colombia

Hosting Email

zohomail

Phone Format

Gmail

ZohoCRM

viralloop

ifttt

northstar

metric

fax com

optimization

reducecosts

Cloud Software

Zoho One

Spectre

Meltdown

chatbots

Adwords

Tradeshow

Live chat

Zia

AI

Phone Validation

Zoho CRM

Data Backup

Dropbox

SEO

Shopify

Facebook

Checkr

Human Resources

People

Recruiters

Website

CSS

HubSpot

ZohoAnalytics

Zoho Social

digitaltransformation

Recruiting software

Streamline hiring

Zoho

Zoho recruit

Zoho Books

accounting software

gst filing

Automation

Customer Engagement

custumer journeys

Digital marketing

collaboration

Online Meeting

Zoho Marketplace

applicant tracking system

hiring

HRMS

recruitment

zoho recruit

CRM Award

CRM Software

PCMag Business Choice Award 2019