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
Access your files securely from anywhere
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:
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
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
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?
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
FAQs: Basic Fields
This page covers everything you need to know about customizing and managing data fields in Zoho Creator forms, from setting initial values to ensuring data accuracy and enhancing user experience. What fields are categorized under the Basic Fields? ...How to copy subform data to another subform using a report action
The values in a subform of a record can be copied to another form's subform using Deluge within the report actions. This allows seamless transfer of subform data between forms, ensuring consistency. For example, consider a Zoho Creator resource ...Import data to reports
Zoho Creator allows you to import data from into the reports in your Creator application. Creator supports importing data from .xls, .xlsx, .xlsm, .csv, .tsv, .ods, .accdb, .mdb, .json and numbers file formats. The required file can either be stored ...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 ...Understanding emailing data to form
A form is the component of your app (that you’ve built using Zoho Creator), through which your users can submit data. In addition to the default method of data entry where users access your form, enter data in the fields and submit the form, you can ...
New to Zoho LandingPage?
Zoho LandingPage Resources