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.

By: CreatorScripts | January 25, 2017

To build a robust Order form in Zoho Creator you need to be able to automatically "fetch" the information about a product and let the system pre-populates the subform with pre-existing data in the Products Table.


First, you need to have a Products form with all the relevant information about the Product. Price, Description, etc.


Second, you  need to fetch the Product information-based "On user input" inside the items Subform and add the below deluge scripting.


prodct  =  Products  [ID == row.Product];
row.Description = prodct.Description;
row.Price = prodct.Price;
row.Qty = 1;
if ((row.Price  !=  null)  &&  (row.Qty  !=  null))
{
    row.SubTotal = (row.Price ...

By: FMRR | May 22, 2013




The objective of this blog/video is to provide a complete example on how to fetch data from one table into another in Zoho Creator. The first thing that we're going to do is create a new table. So just for the sake of an example, we're going to have "visitors" in our data, and then we're going to create a new menu tab about the visitor.

You want to know its "name" and then, let's do an "email" field, a quick "email" field there and a "phone number". Then we're going to create an additional form and let's call this appointments. And I'll just create it under the tab "visitors" so that both tables are within the same place.

For appointments, we want to pick a visitor so we drag a look-up field. Notice how I chose the look-up field? then, we're ...

Category: Zoho 

Tags: Deluge Scripts 

By: FMRR | May 14, 2013



The sequence to execute the logic you are looking to accomplish is exactly as adding a script on a regular form.  On Add, On Delete, On User Input, but there is a subtle difference in the code and there is also a different way to embed the script into a subform, so lets tackle the way we embed the script.
On a regular form we have several options: Script Builder, Free Flow and Form Definition; where you can actually write the code manually if you know what you are doing. Inside a subform there is NO Script Builder that would guide you through the options of data you can access and a user is left with writing the code manually on a Free Flow approach style. The solution is to write the code using the Script Builder on a regular form save...

Category: Zoho 

Tags: Deluge Scripts 

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

candidate onboarding

Employee Onboarding Software