Smart Software For Maverick Entrepreneurs

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 going to name it "visitor" and we're going to select it from the table visitor. And we are going to bring the name of that particular visitor. We can actually add visitors from within this form by selecting the option within that form, we can also sort the visitors on alphabetical order and for now this should be enough.

But let's say that in addition to the visitor, obviously we will want to have a "date" for the appointment but we also need the email of this particular visitor, so that we're able to send him a note or something when we request the appointment. So, for the purpose of this example we're going to limit for the email option only.

And now you have two alternatives. You can either type the email of the visitor every time you create an appointment or we can automatically pull that information from the other table every time you select a visitor. So let's create some examples here. Let's go to visitor form. Then I'm going to input a few examples here. So let's do Joe Blow, email, joeblow@hotmail.com. This actually might be a real email so don't send to anybody, okay. We got Joe Blow, then Sue Blow email, sueblow@gmail.com. And we have a phone number there.Great!!!

Now if we go to the visitor's view there are two records that we just captured. Next we're going to link the information. And this is the objective of this blog/video. So you're going to go to visitor, and you want the system to create an action on your input, so you go to actions on user input, and then you are going to go to script builder form format and the first thing that we need to know &  to do is actually fetch the records. 

And we're going to call those visitors because we are pulling the visitor data from the visitor table into the appointment table....then we're going to select them from visitor's form and we want the name of the visitor to be equal to the visitor input field that you just selected. This is the key to link the information.

This process will pull the information about the visitor that you just selected on form view, and then all we need to do is set a variable name which in this case is going to be the email of the visitor, and we are going to go to collections to get the information about the visitors that we just fetched and assign the email to it.

Visitors email will be our new email name for it. And that's it, we just click "save." Go to the appointments table and every time you select a new visitor the system will automatically populate the email for you. If you go to Sue Blow now, Sue Blow email address appears on there. So I hope this exemplifies the way how you can fetch records from one table to another in Zoho Creator, good luck!

Category: Zoho 

Tags: Deluge Scripts 

Comments:

Be the first to comment ...

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