How to fetch data from Zoho Creator on user input | Creator database
This video provides an example of how to fetch information from one table into another on user input. #digitaltransformation #zohocreator
00:00 - Introduction
Brief introduction explaining the purpose of the video: Fetching data from one table to another in Zoho Creator.
00:15 - Creating a New Table
Starting with the creation of a new table for visitors, including name, email, and phone number fields.
00:45 - Setting Up a Form for Appointments
Creating an additional form named 'Appointments' and placing it under the 'Visitors' tab.
01:10 - Adding Lookup Field to Appointments
Demonstrating how to add a lookup field in the 'Appointments' form to select visitors from the 'Visitors' table.
01:35 - Sorting and Adding Additional Fields
Sorting visitors in alphabetical order and discussing the need for an email field in appointments for notification purposes.
02:00 - Automating Email Fetching
Explaining options for adding visitor's email: manual input versus automatic fetching from the 'Visitors' table.
02:25 - Inputting Visitor Examples
Entering example data into the 'Visitors' form with names, emails, and phone numbers.
02:50 - Linking Visitor Data to Appointments
Illustrating how to link visitor information from the 'Visitors' table to the 'Appointments' form.
03:15 - Setting Up Actions for User Input
Navigating to 'Actions' in the visitor form and using the script builder for automating data fetching.
03:40 - Fetching Visitor Records
Detailing the process of fetching visitor records and linking them to the 'Appointments' form.
04:05 - Assigning Email Variables
Explaining how to set a variable for the visitor's email and assign it within the form.
04:30 - Demonstrating Automatic Email Population
Showing how the system automatically populates the email field in 'Appointments' when a visitor is selected.
04:55 - Conclusion and Final Thoughts
Wrapping up the tutorial with a summary and encouraging viewers to try it out in their Zoho Creator setups.
Already familiar with Zoho Creator? Get access to our Deluge Scripts Library to help you build an application and launch it within minutes. https://zoholibrary.creatorscripts.co...
Sign up for free: https://www.creatorscripts.com/zohocr...
Connect with us on Twitter: / creatorscripts