Showing posts with label Zoho Creator. Show all posts
Showing posts with label Zoho Creator. Show all posts

Thursday, July 13, 2017

Iron-clad Zoho Creator Dashboards

In today's data-driven world it has never been easier to collect, to aggregate and to present terabytes of information in a well-structured chart or table. However, it's not the amount of data you can process what will drive your business forward, but all the actionable steps that can be drawn from the dashboard metrics.

We spent some time on the www looking for the best dashboards out there and we found a plethora of graphics and software applications eager to feed your aggregated data cravings, but few stand out and are worth considering. 

For example.-  How to build your dashboard metrics by Ash Maurya. You can check his Youtube video below or buy his Running Lean: Iterate from Plan A to a Plan That Works (Lean (O'Reilly)) book.
You should also consider reading the post What makes a good lead generation dashboard?by Jonathan Taylor and 6 Golden Rules to Successful Dashboard Design by Nick Smith, these are golden gems worth your time. Once you inform yourself with the endless suggestions google has to offer. You will probably come to the conclusion that less is more and a simple yet useful dashboard is always the way forward.

Zoho Creator allows you to be creative and code your own dashboard metrics or if you prefer you can also embed some of the automatically created dashboards Zoho Reports has to offer. Below you can review a few options you can implement in your Zoho Creator application.

Simple Header

Simple header with room for up to 6 metrics to track. The source code for this particular dashboard is available in our Zoho Library

Chart Type

More robust dashboard with room for several layers of charts or tables stacks one below the other. The source code to implement this dashboard is also available in our Zoho Library

Note: If you purchase access to our Deluge Script Library we will assist you with the script setup in your application. Send us an email with subject line: less=more

Sunday, July 9, 2017

20 Epic Ways to Automate Documentation with Zapier

As consumer demands become more unique and varied, in order to keep up with big businesses, small businesses must change their back-end operations. With the accessibility and affordability of automated software solutions, this demand is not only possible, but it also saves time and money for small business owners.
Where do you start? That’s easy! Zapier and WebMerge.
Zapier provides businesses with the ability to sync any application they want. Based on the uniqueness of your operations, you could use Zapier to share new Tweets on Slack, send RSS feeds to Buffer, and more. With Zapier and WebMerge’s powers combined, you can automate your documentation process and eventually… rule the world!
Here are 20 ways you can use Zapier and WebMerge to automate your business:
  1. Create and Sign Real Estate Contracts with CudaSign
    Real Estate agents are always on the go.  From meeting with new clients, running around town showing homes, to closings, real estate agents are rarely in the office. Here’s how you can create quick contracts and save some energy.
  2. Create Contracts and Agreements from Nutshell CRM
    Managing your contacts, leads, and opportunities can be a daunting task, but with choosing the right CRM can be a life saver.  Nutshell is a great CRM and in combination with WebMerge you can save your sales team countless hours.  In this example we’re going to show you how you can create a contract from a lead in Nutshell and automatically send it to your customer.
  3. Generate Contracts from Opportunities in TrackVia
    Managing your workflow can be a daunting task, but with tools like TrackVia, you can keep track of everything from start to finish – all within a single platform.  From managing a projects to collecting data in the field, TrackVia is a great solution.
  4. Send a Letter of Engagement from Clio
    Document generation in the legal world is a must-have.  By auto-populating letters, contracts, and other types of legal documents, attorneys and paralegals can save countless hours.  Another way lawyers can save time (and their sanity) is by using a practice management system like Clio.
  5. Populate a PDF Receipt from a Formidable Order Form
    Formidable is a popular Wordpress form plugin for creating contact forms, order forms, registration forms and many more types of web forms.  But what if you want to take that information collected on the form and populate a Word document or PDF?  Your options are very limited.  Unless you haveWebMerge, of course!
  6. Send an Order Invoice from Smartsheet
    Smartsheet is a pretty cool tool that allows you to easily collect data from customers and team members, plus offering an easy platform to manage that information.  It’s like Excel, but on steroids.  In this example, we’re going to show you how to send an invoice created with WebMerge directly from Smartsheet as a new order is entered into our sheet.
  7. Create and Send an NDA from Zoho CRM
    Keeping track of all your customer information can be difficult, but getting data out of your CRM can be an even bigger hassle.  Most often you end up re-typing information into other systems, documents, etc.  With Zoho CRM you can easily capture your leads, plus manage your customers, partners, and opportunities.
  8. Send Customized Invoices for Magento Orders
    Let’s face it – e-commerce is here to stay and is an important part of any business.  Today there are many services out there that can help you build and maintain an online store front without the need of expensive coding or customization.  One of the most popular services is called Magento and they offer a product that can fit your every need.
  9. Send Welcome Letters to Hubspot Form Leads
    You’ve jumped into the world of HubSpot marketing and sales tools, collecting all of this data on your website visitors, leads, and customers.  But, you don’t have an easy way to populate documents (letters, contracts, offers, etc) from that customer data.  Until now!  With the help of WebMerge (via Zapier) you can take your HubSpot data and populate documents on the fly.
  10. Create PDFs and Reports from Knack
    If you’re looking for an easy way to build an online database application without the need for programming, you need to check out Knack.  With Knack you can get rid of those clunky spreadsheets and build easy to use web applications such as a custom CRM, proposal tracker, order management, and more.  Knack allows you to build some pretty powerful apps and we’re going to show you how you can easily generate documents directly from Knack using WebMerge.
  11. Create Service Contracts from Batchbook
    If you’re looking for a great CRM to help you with organization and productivity, then we suggest you take a close look at Batchbook.  With Batchbook you can track your contacts, manage your deals, maintain your communication with customers, and more.  Let's take it one step further and generate documents from Batchbook using WebMerge.
  12. Create and Send Contracts from Solve CRM
    In today’s competitive landscape for the CRM space, it’s tough for services to stick out from the rest.  You have to fit the needs of specific verticals or use-cases and do that really well.  In the case of Solve CRM, they have wisely picked a deep integration with Google for Work and all the apps that come along with it.  From Calendar syncing, to Gmail integration, to managing Google Drive files, Solve integrates seamlessly.
  13. Create and Manage HR Documents from ZOHO Creator
    Managing your HR processes can be a daunting task.  From collecting new employee information, tracking time off, and handling payroll, there is a lot to keep track of and a lot of documentation to go along with it.  No sweat!  There’s a great tool called ZOHO Creator and you can build a customized HR app that allows you to manage all of your HR data across your entire business.  Then, combined with WebMerge you can generate employee contracts, insurance applications, state forms, and more.
  14. Create Custom Invoices and Letters from Harvest
    Managing projects, finances, timesheets, and deliverables can be a job in itself, but with Harvest you can make life a whole lot easier.  Harvest can track all your expenses throughout a project and make it easy to bill your customers when the project is complete.  Sounds great, right?  Well, we agree, but what if you want to customize the invoices or send letters to your new customers?  Your options are limited.
  15. Create and Send a Custom Payment Receipt from Freshbooks
    Freshbooks is one of the leading accounting solutions on the market and they do a great job of helping your manage your invoices, time, and expenses.  You can keep track of all of your customers and send invoices in minutes.  But what if you want to create a customized invoice or send a receipt to your customer when you receive payment?  Your options are very limited.
  16. Send Customized Payment Receipts from PayPal
    PayPal is a great way to get paid for things online without the hassle of gateway fees, setup charges, or merchant accounts.  You can easily integrate PayPal into your shopping cart, website, or registration processes.  However, your options are limited if you want to customize the receipt that a customer receives when they pay your through PayPal.
  17. Create Customized Invoices from Xero
    Managing your small business has never been easier than with Xero accounting software.  From your billing to payroll to contact management, Xero has got you covered and will save you hours upon hours every month.  Xero has a built in feature to send invoices to your customers and it will show you when they have viewed the invoice, but customization is limited.
  18. Create Customer Receipts from Stripe Charges
    Let’s face it, Stripe is awesome at making payments easy.  You can integrate with their API in a matter of minutes and collecting money instantly.  The best part is that you don’t have any monthly fees to worry about.  You only pay when you get paid.  The only downside to Stripe is that it is hard to send customized notifications to your customer about their payment.  Unless you’re the developer behind the Stripe integration, your options are limited.
  19. Email Personalized Receipts for Braintree Payments
    Accepting payments online is a great way to streamline your business and offer your customers an easy way to pay you. With Braintree you can easily integrate your payment process into your website, app, or shopping carts.  With just a few lines of code you can start accepting payments.  Unfortunately, sending customized receipts is not quite that easy.  Your hands are pretty tied if you want to customize the receipt.
  20. Upload a TypeForm Medical Patient Intake Form to Box
    Have you ever thought filling out forms is a pain in the neck? TypeForm makes the experience of filling out forms fluid and fun. At the doctor’s office, filling out an intake form is often the first experience the patient has upon arriving for his or her appointment. If you have a medical practice, then you might be interested in improving your intake process. With TypeForm, in conjunction with WebMerge, you can merge the form submissions with a template document and automatically file them in your digital document storage system and/or as easily print them out as hard copies.

Tuesday, July 4, 2017

Integrate GETTY Images API to Zoho Creator

Getty Images is among the world’s leading creators and distributors of award-winning still imageryvideomusic and multimedia products, as well as other forms of premium digital content, available through its trusted house of brands, including iStock© and Thinkstock©.
With its advanced search and image recognition technology, Getty Images serves business customers in more than 100 countries and is the first place creative and media professionals turn to discover, purchase and manage images and other digital content. Its best-in-class photographers and imagery help customers produce inspiring work which appears every day in the world’s most influential newspapers, magazines, advertising campaigns, films, television programs, books and online media.
With its search image engine you can call via API any kind of images GETTY has access in its database and store them inside your Zoho Creator application to enhance the user experience.

    imageURI = "";
    if (yoursearchword.length()  >  0)
        //yoursearchword =
        imageURI = thisapp.API.gettyImage(yoursearchword);

You can now get all the API script needed to integrate GETTY Images and Zoho Creator from our Zoho Library. If you are still not a Zoho guru we can set it up for you if you prefer.

Please, visit our Zoho Services page for more details.

Saturday, June 3, 2017

Compress Your Zoho Images 33% or more with Cloudinary API

Cloudinary is the image back-end for web and mobile developers. An end-to-end solution for all your image-related needs.

Use Cloudinary's image service instead. With simple integration to Zoho Creator you'll get immediate access to cutting-edge image capabilities. Save R&D time, get to market faster, reduce your IT costs and improve your viewers experience.

What makes Cloudinary stand out?

  • Securely upload images or any other file, at any scale from any source. API for fast upload directly from your users' browsers or mobile apps.
  • Store as many images as needed. Our image hosting service stores images privately and safely with automatic backup and historical revisions.
  • Manage your media library interactively with our Digital Asset Management solution or via APIs. Gain insights using advanced analytics.
  • Manipulate your images dynamically to fit any graphics design. Apply effects, resizing, cropping, face detection, watermarks and tons of image processing capabilities.
  • Get your images delivered lightning-fast, responsive and highly optimized for any device in any location. Images are served via Akamai’s worldwide CDN.
Interested on integrating this API to your zoho creator application?

Integration has been developed and its readily available as a one time Add-On purchase or inside our Leverage Zoho Library to all its members.

Wednesday, February 8, 2017

How to properly set subforms in Zoho Creator Part 2

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 populate 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  *  row.Qty);

Check How to properly set subforms in Zoho Creator Part 1

Tuesday, January 3, 2017

6 of the Most Popular Zoho Creator posts of 2016

Zoho speeds up Innovation with mobile App CreatorZoho Creator, Online Database
Fetch Email Id Associated with a UsernameZoho Creator, onlinedatabase
How QR code and barcode scanning with Zoho Creator works?Zoho Creator, Barcode, QRCode
Zoho Creator Hack: Specify "OR"  or "AND" operators when setting criteria for displaying a viewZoho Creator, Views criteria
Why Zoho Creator is winning the database war against MS AccessZoho Creator, MS Access
How to properly set Subforms in Zoho Creator Part 1Zoho Creator, Subforms

Friday, December 2, 2016

Create and Manage HR Documents from ZOHO Creator

Managing your HR processes can be a daunting task.  From collecting new employee information, tracking time off, and handling payroll, there is a lot to keep track of and a lot of documentation to go along with it.  No sweat!  There’s a great tool called ZOHO Creator and you can build a customized HR app that allows you to manage all of your HR data across your entire business.  Then, combined with WebMerge you can generate employee contracts, insurance applications, state forms, and more.

In this example we’re going to show you how you can generate new employee intake documents with WebMerge when an employee is added to your ZOHO Creator app.  We’ll be generating a new employee contract automatically with a little added help from Zapier.

To get started, we are going to create a new document in WebMerge and upload our Employee Contract template (a Microsoft Word document).  This template is already setup with merge fields like {$FirstName}, {$LastName}, etc and that tells WebMerge where to put the employee information throughout the contract.

Next, we’re going to integrate the delivery of the document with SignNow so that we can get the employee’s signature on the contract.  Go to the Delivery tab for your document setup, then click New Delivery.  Select the SignNow option and then authenticate your SignNow account.  Complete the rest of the settings and indicate the signer info, then save the delivery.

Now, it’s time to setup the Zap so that your ZOHO Creator information automatically to WebMerge.  Login to Zapier and create a new Zap with ZOHO Creator as the Trigger and WebMerge as the action. 

Once you authenticate your accounts with Zapier, you’ll need to pick your WebMerge document that you want to merge and then map the merge fields with the corresponding ZOHO Creator fields.  This tells Zapier how to send the data to WebMerge to make sure it is put into your merged document correctly.

After you have mapped the fields, go ahead and jump down to the Test section.  This allows you to send test information from ZOHO to WebMerge using your settings and you will see how the process works.  If you need to make any changes, do so now.  Here’s what our contract looks like:

Congrats, you’re done!  Now you can run your entire HR department through ZOHO and automatically create any documents you need with WebMerge.  What other ways can you use WebMerge in your business?

Create Personalized Documents from Zoho Creator with WebMerge
powered by Zapier

Tuesday, November 29, 2016

How to properly set Subforms in Zoho Creator Part 1

This is the most important step in the process of setting up your zoho creator database. A properly linked setup will enable your information to run smoothly and avoid waisting space ( MB )

First, you need to create at least 2 Forms. For example.- Orders and Items. An Order can have multiple items and 1 item can be part of many Orders. Creating a many to many relationship.

Second, you need to add the Subform Items inside the Form Orders and name it. Then you have to add a Lookup field in the Items Form and click on Existing Relations. 

Do NOT forget this part. This is the key. You must have a lookup field linking the original Form to each record on the subform you are creating. Makes Sense?

If it does not or need any help do not hesitate to contact us. We can guide you through the process to set your Subform for success.

Thursday, July 25, 2013

How to calculate the elapsed time between two Date-Time fields

I have found several functions, scripts and blogs providing different methods to calculate the elapsed time between two date-time fields. However, most of them are hard to understand or involve a higher coding of deluge scripting to obtain the desired result.

Below you will find a solution in 3 lines of code if the Dates belong to the same day

Hr=(input.End_Time.getHour()  -  input.Start_Time.getHour());
Min=(input.End_Time.getMinutes()  /  60  -  input.Start_Time.getMinutes()  /  60);
Elapsed=(Hr  +  Min);

Or 7 lines of code If the Dates vary in Days ...

if(input.Start_Time.getDayOfWeek()  ==  input.End_Time.getDayOfWeek())
Hr=(input.End_Time.getHour()  -  input.Start_Time.getHour());
Min=(input.End_Time.getMinutes()  /  60  -  input.Start_Time.getMinutes()  /  60);
Elapsed=(Hr  +  Min);
else if(input.Start_Time.getDayOfWeek()  <  input.End_Time.getDayOfWeek())
Hr=(input.End_Time.getHour()  -  input.Start_Time.getHour());
Min=(input.End_Time.getMinutes()  /  60  -  input.Start_Time.getMinutes()  /  60);
Day=((input.End_Time.getDayOfYear()  -  input.Start_Time.getDayOfYear())  *  24);
Elapsed=(Day  +  Hr  +  Min);

In the following link you will be able to test the script on a live and free application. Elapsed Time

You may locate the following code in the following places: On user input, On Add On Success, or On Edit On Success

Hope it helps....enjoy.

Friday, July 19, 2013

How to add an image to an HTML View ( page ) in Zoho Creator

If you are already exploring Zoho Creator ability to develop Html Views  ( now known as pages )
you are stepping into a powerful section of your application that will yield great results overtime.

With this in mind you will also need to understand how to incorporate Logos, Images into your pages so the "visual" effect of the application has a more human touch and assist the user to understand what the task in hand is.

Below you will see a sample on how to add a Logo into an HTML View using "Notes" Field. Go to the Form you would like to incorporate the Logo. In this example our "Page" hosts 2 views. View No.1 is Summary Invoice and View No. 2 Product View. Open your Summary Invoice Form and drag the "Add Note" field into the form.

Click Edit on the Note field & look for the Image icon on the top menu bar to upload your image.

Copy & paste the Image URL. 

In order to have a URL you must have uploaded your image to the company server or to a free service such as Flicker or Google  Drive. Click ok and Listo!!!

Thursday, June 27, 2013

How to decide if syncing Zoho Creator to GAPPS is a good business move?

Sometimes if you have built your basic communications operation around Google Interface it seems like a natural blend to incorporate you Zoho Creator application right into the heart of GAPPS. Think again!!!

There are 3 major points of interaction between Zoho Creator & GAPPS. The access, the data & the sharing. After living the frustration of a client of mine first hand and a month long of testing its functionality and performance we can confidently conclude the following.

First, there is no problem visible to the human eye that suggests there is something wrong with "accessing" Zoho Creator via GAPPS. Once installed in your GAPPS account you will see a link to Zoho Creator under the if you click will open the application smoothly and everyone is happy.

Second in line is: the "Data" that you can access inside Zoho Creator from GAPPS. There seems to be intermittent issues. For example.- if you have a field inside your forms to select users from GAPPS the options may magically disappear temporarily and after reloading & reloading they may reappear back.  If you are not a hard core user of your application you may be able to live with reloading and waiting every time this occurs, but if you run your daily operations in Zoho Creator this is an annoying losing time = money nightmare.

And last but not least the "Sharing". This is the most important of all!! Within Creator you have the ability to share your Forms and Views with individual GAPPS users or with Groups. If you select nothing but individual users everything seems to perform as expected, however if you select a Group within GAPPS the performance on your Zoho Creator application will slowdown 5 fold average. 

So unless Zoho or Google comes with a solution around Sharing Groups of users within an application resist the temptation to simplify sharing or suffer  a loss of 5x fold in performance. Your call.

For more details review this Zoho Forum note with more information regarding this possible performance issue related to GAPPS integration.

Saturday, May 25, 2013

How to decide when to use a Lookup field in Zoho Creator?

To make the optimal decision about the type of fields to incorporate into your application you only need to consider one concept; "Always use Lookup fields" A Lookup field can be displayed into nearly any other field form: Radio Button, Checkbox, etc & you are 1000% better by incorporating Lookup fields right from the get go. Let me explain why.When you build an application there are 2 main aspects you need to evaluate:  the size of the application & the usability or user experience for both developers & endusers.

For the size of an application its better to have Lookup fields because it will save you time as you incorporate the field into multiple forms and screens across you application. I had to learn the hard way after a client requested to have the same field across more than +20 screens and had to manually enter the field options , which were a "gazillion"by the way, into each and one of them. We changed course and start adding Lookup fields instead and now we only need to drag the Lookup field and call it up as needed. Also if the Client changes his mind, which mine does regularly due to a dynamic business process, can go into the Lookup field that requires a new option and added or modified it himself.

Regarding the user experience, Lookup field  used to be a problem considering that not all field options were available for a Lookup field. Initially that is why I was apprensive about using Lookup field across the application and settle for a drop down when i was really in need of a checkbox or something else. However, you can now select any field alternative from within a Lookup field therefore the argument above is no longer valid and you are way better of incorporating a Lookup field everywhere you go. As for developer usability, your only concern is the type of field you use & you should consider that Checkboxes will be the most difficult to code around when triggering actions upon selection of multiple checkboxes, but other that is field option selection process not an issue with the Lookup field itself.

Dont make the same mistake I made, save time and start using lookup fields across your application. create a New Tab, name it lookup tables and store everything in there, move it to the end of the list and hide the tab menu. On sharing specs make sure you are the only admin ( or any developers you may have ) with access to this tables and listo!!!

Image for the old Zoho Creator Interface

Wednesday, May 22, 2013

How to fetch records from one table into another in Zoho Creator

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, This actually might be a real email so don't send to anybody, okay. We got Joe Blow, then Sue Blow email, 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!

Thursday, May 16, 2013

How to give access to a developer in Zoho Creator

This is probably one of the top 20 most asked questions i seem to be answering all the time.when you are trying to share your work with a developer most of us believe its a 1 step process and we do know how to update / change the user status. However, there is an additional step  you need to consider to fully provide access to a developer to your Zoho Creator account. Please, review the slides for the 2 step process below and let me know if you have any questions.



Tuesday, May 14, 2013

How to update Unit Price into a subform based on Product selection

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 it from a free flow screen and take it into the subform corresponding action.
In the image below you will see an Order Management Form displaying regular fields about a Product and its Unit Price along with a subform that aggregates products in the same way. For the purpose of this example, we have created the script to update the Unit Price based on Product selection.
Now, notice how subtle the difference in the code is once we compare the lines of code that would update the fields on the right ( regular form ) to the ones on the left ( subform ) and you will see that they are nearly identical which provides us with a great opportunity to quickly incorporate scripts int any subform. Write the script on a regular form then paste it into the subform and correct the subtle difference.
//Fetches the information from the "Products" table
selected_Product = Products [Code = input.Order_Items];
//Updates the value of Unit Price using the stored value from "Products" table
input.Unit_Price = selected_Product.Price;
//Fetches the information from the "Products" table
selected_Product = Products [Code = row.Order_Items];
//Updates the value of Unit Price using the stored value from "Products" table
row.Unit_Price = selected_Product.Price;
Notice that the only difference between the 2 is the word row. before the field value of the subform. With this knowledge you can now write the script you need on a regular form by simulating the subform fields, import the code and modify with the word row. as needed.