Copy data from one Address Field to another
Requirement
Copy one Address field to another automatically while filling out a form.
Use Case
An online e-commerce application generally would ask every customer to enter separate billing and shipping addresses. Sometimes, people have both the addresses same. We need to ensure that if the user says both are same, we
copy
the
shipping address to
the
billing address.
Steps to follow
|
Form
|
Form Link Name
|
Field Type
|
Field Name
|
Field Link Name
|
|
Delivery
|
Delivery
|
Name
|
Name
|
Name
|
|
Email
|
Email
|
Email
|
||
|
Address
|
Shipping Address
|
Shipping_Address
|
||
|
Decision Box
|
The billing Address is the same as the Shipping Address
|
The_billing_Address_is_the_same_as_the_Shipping_Address
|
||
|
Address
|
Billing Address
|
Billing_Address
|
2. Create a workflow to execute on the
user input of the Decision Box
to toggle the display of the
Billing Address
field when the box is checked, and to copy the
Shipping Address
field to the
Billing Address.
3. Click
Add New Action
and add the below script:
- if(input.The_billing_Address_is_the_same_as_the_Shipping_Address)
- {
- //Hide the Billing Address field when both are same
- hide Billing_Address;
- //Assign the Shipping Address value to Billing Address
- input.Billing_Address = input.Shipping_Address;
- }
- else
- {
- //Display the Billing Address during the toggle of the Decision Box
- show Billing_Address;
- }
4. We shall create another workflow to execute during the
successful form submission
to copy the
Shipping Address
to
Billing Address.
5. Click
Add New Action
and click
Deluge Script. Add the below
Deluge script for copying the addresses.
- //If the Decision Box is true and the Business Address is empty, copy the Shipping Address to Billing Address
- if(input.The_billing_Address_is_the_same_as_the_Shipping_Address && input.Billing_Address.trim() == "")
- {
- input.Billing_Address = input.Shipping_Address;
- }
See how it works
Points to Note
-
We can only specify the link name of the "Address" field when assigning it a value copied from another "Address" field. In all other cases, we have to give values for its sub-fields separately, as explained in this table.
-
The working of the composite Name field is the same.
Related
Links
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Zoho DataPrep Resources
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
Capture data using NFC
Requirement Capture data from NFC supported tags. Use Case An organization wants a mechanism where its employees can submit feedback about its cafeteria and restrooms by tapping their NFC- enabled ID cards against the feedback collecting ...Autopopulate Zoho Creator field with Zoho People data
Requirement Autopopulate Zoho Creator field with employee information stored in Zoho People. Use case Let's assume an organization named Zylker has a private library. The regular users must purchase a membership in order to access the library, ...Show or Hide field on checkbox input
Requirement Show or hide a field based on the checkbox value. Use Case An ice-cream parlour is accepting orders online. The patrons can choose from a list of available flavours, toppings etc. See how it works Steps to follow 1. Create the form with ...Understand Address Field
The address field enables your users to enter the address of a physical location. It's a composite field consisting of the following subfields: Address Line 1, Address Line 2, City/District, State/Province, Postal Code, and Country. Below is how the ...Understand fields
Note: Ensure to not enter sensitive terms while naming your form fields or collect confidential information in them. A field is the basic unit or building block of a form. In your Zoho Creator app, you collect and store data using forms and each ...
New to Zoho LandingPage?
Zoho LandingPage Resources